Re: [GENERAL] Custom Domain; migration from 8.4 to 9.1 and COLLATE

ete script -- including the citext creation statements from the dump, with the patch, with the bugged statements. https://gist.github.com/2656537 I'll reload the database the otherway and try to update the domain with the same update statements. -- Evan Carroll - m...@evancarroll.com

Re: [GENERAL] Custom Domain; migration from 8.4 to 9.1 and COLLATE

ATE EXTENSION. -- Evan Carroll - m...@evancarroll.com System Lord of the Internets web: http://www.evancarroll.com ph: 281.901.0011 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Custom Domain; migration from 8.4 to 9.1 and COLLATE

oo_before CREATE TEMP TABLE trash2 AS SELECT * FROM tablefoo_before ; -- Evan Carroll - m...@evancarroll.com System Lord of the Internets web: http://www.evancarroll.com ph: 281.901.0011 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] Custom Domain; migration from 8.4 to 9.1 and COLLATE

that generates this same error, not exactly sure why it is getting generated though. -- Evan Carroll - m...@evancarroll.com System Lord of the Internets web: http://www.evancarroll.com ph: 281.901.0011 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Custom Domain; migration from 8.4 to 9.1 and COLLATE

in" with collatable type citext HINT: Use the COLLATE clause to set the collation explicitly. v.vin is the column with the custom DOMAIN. -- Evan Carroll - m...@evancarroll.com System Lord of the Internets web: http://www.evancarroll.com ph: 281.901.0011 -- Sent via pgsql-general mailing list (

[GENERAL] Custom Domain; migration from 8.4 to 9.1 and COLLATE

VALUE ) ); How do I best resolve this error? -- Evan Carroll - m...@evancarroll.com System Lord of the Internets web: http://www.evancarroll.com ph: 281.901.0011 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] New COPY command (alternative to pg_loader) and Perl shell

as I write grammars for other SQL statements I'll start to expand it to be more shellish. -- Evan Carroll System Lord of the Internets http://www.evancarroll.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Question about weird COPY syntax

S ] 'quote' ] [ ESCAPE [ AS ] 'escape' ] [ FORCE NOT NULL column [, ...] ] -- Evan Carroll System Lord of the Internets http://www.evancarroll.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Question about weird COPY syntax

[ CSV [ HEADER ] [ QUOTE [ AS ] 'quote' ] [ ESCAPE [ AS ] 'escape' ] [ FORCE NOT NULL column [, ...] ] [ -TCSV_key ] [ -TCSV_