From: | Vladimir Kokovic <vladimir(dot)kokovic(at)gmail(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: Copy/Paste table(s) functions |
Date: | 2011-04-14 08:21:32 |
Message-ID: | BANLkTinR603h+Nc+PvWnDNJmoieLX+tY2Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi,
During copy/paste testing I've found that on 9.1 'COLLATE' should be
omitted from table constraints definitions..Look in my PostgreSQL log:
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 LOG:
statement: SELECT relname FROM pg_namespace n LEFT JOIN pg_class c ON
n.oid=c.relnamespace AND relkind='r' WHERE nspname='"".""' AND
relname='edi_razmena'
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 LOG: duration: 7.734 ms
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 LOG: statement: BEGIN
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 LOG: duration: 2.135 ms
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 LOG:
statement: SHOW search_path
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 LOG: duration: 1.804 ms
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 ERROR: syntax
error at or near "COLLATE" at character 1232
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 STATEMENT: SET
search_path=""".""";-- Table: edi_razmena
-- DROP TABLE edi_razmena;
CREATE TABLE edi_razmena
(
godina character varying COLLATE pg_catalog."default" NOT NULL,
razmena_id character varying COLLATE pg_catalog."default" NOT NULL,
char_set character varying COLLATE pg_catalog."default" NOT NULL,
kupac character varying COLLATE pg_catalog."default" NOT NULL,
dobavljac character varying COLLATE pg_catalog."default" NOT NULL,
datum date NOT NULL,
vreme time without time zone NOT NULL,
test character varying COLLATE pg_catalog."default" NOT NULL,
odgovor character varying COLLATE pg_catalog."default" NOT NULL,
ts timestamp without time zone NOT NULL DEFAULT now(),
CONSTRAINT edi_razmena_pkey PRIMARY KEY (godina COLLATE
pg_catalog."default", razmena_id COLLATE pg_catalog."default", kupac
COLLATE pg_catalog."default")
)
WITH (
OIDS=FALSE
);
ALTER TABLE edi_razmena OWNER TO vlada;
GRANT ALL ON TABLE edi_razmena TO vlada;
GRANT ALL ON TABLE edi_razmena TO public;
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 LOG: statement: ROLLBACK
2011-04-14 10:04:28 CEST asoft 127.0.0.1(41254) 5357 0 LOG: duration: 1.383 ms
Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2011-04-14 09:47:15 | pgAdmin III commit: Make style. |
Previous Message | Peter Geoghegan | 2011-04-12 21:39:56 | wxWidgets 2.9 build - new incompatibilities |