Skip site navigation (1) Skip section navigation (2)

Re: Copy/Paste table(s) functions

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Vladimir Kokovic <vladimir(dot)kokovic(at)gmail(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Copy/Paste table(s) functions
Date: 2011-04-17 13:50:43
Message-ID: 4DAAF033.8020605@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
Le 14/04/2011 10:21, Vladimir Kokovic a écrit :
> 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
> 

I don't see how you can have that issue. When I add a primary key (to a
new table or to an existing table), I don't have a COLLATE clause.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

In response to

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2011-04-17 14:02:32
Subject: pgAdmin III commit: Don't show collation if it's the default one
Previous:From: Guillaume LelargeDate: 2011-04-17 13:44:10
Subject: pgAdmin III commit: Fix a crash when adding an index constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group