Re: [SQL] Split a string to rows?
Hello Thomas, Thanks a lot! I just noticed that my postgresql is 8.3(unnest function is not there by default). Is there a way that I could download and load only this function from somewhere? Are you aware that 8.3 will be de-suppported as of next month? You should really think about an upgrade *now* http://www.postgresql.org/support/versioning/ Although 8.3 reaches EOL date, it says that Supported=Yes for 8.3. I believe that Supported would be fine, wouldn't it? Emi -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Split a string to rows?
On Tue, Jan 08, 2013 at 09:34:24AM -0500, Emi Lu wrote: Hello Thomas, Thanks a lot! I just noticed that my postgresql is 8.3(unnest function is not there by default). Is there a way that I could download and load only this function from somewhere? Are you aware that 8.3 will be de-suppported as of next month? You should really think about an upgrade *now* http://www.postgresql.org/support/versioning/ Although 8.3 reaches EOL date, it says that Supported=Yes for 8.3. I believe that Supported would be fine, wouldn't it? Emi Hi Emi, It will be supported until February 2013. You have about 1 month left. Regards, Ken -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Split a string to rows?
On Tue, Jan 8, 2013 at 2:34 PM, Emi Lu em...@encs.concordia.ca wrote: Hello Thomas, Thanks a lot! I just noticed that my postgresql is 8.3(unnest function is not there by default). Is there a way that I could download and load only this function from somewhere? Are you aware that 8.3 will be de-suppported as of next month? You should really think about an upgrade *now* http://www.postgresql.org/support/versioning/ Although 8.3 reaches EOL date, it says that Supported=Yes for 8.3. I believe that Supported would be fine, wouldn't it? It is supported until February (or more precisely, until the next point release after then, which will be the final wrapup release). At that point, there will be no more releases or bug fixes. Start thinking about upgrading now, as Thomas suggests. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] copy users/groups
We have a database that was updated from 7.4.1 to 9.1.3. I've gotten everything working, but now it seems that the users and groups weren't restored. Probably because they weren't backed up. Is there a way to dump just the users and groups, plus the passwords and permissions, and restore them without overwriting what's been manually added to the new database? Edward W. Rouse -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] copy users/groups
On 01/08/2013 07:08 AM, Edward W. Rouse wrote: We have a database that was updated from 7.4.1 to 9.1.3. I've gotten everything working, but now it seems that the users and groups weren't restored. Probably because they weren't backed up. Is there a way to dump just the users and groups, plus the passwords and permissions, and restore them without overwriting what's been manually added to the new database? Users/groups i.e roles are global to a cluster, you need to use pg_dumpall: http://www.postgresql.org/docs/9.1/interactive/app-pg-dumpall.html pg_dumpall -g Will dump only the global items. Edward W. Rouse -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] How to generate drop cascade with pg_dump
Hello, May I know how to generate drop table cascade when pg_dump a schema please? E.g., pg_dump -h db_server -E UTF8 -n schema_name -U schema_owner --clean -d db_name ! ~/a.dmp In a.dmp, I'd like to get: drop table t1 cascade; drop table t2 cascade; ... ... Only dropping constraints within a schema is not good enough since there are dependencies on other schema. Thanks a lot! Emi -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql