From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Vladimir Kokovic <vladimir(dot)kokovic(at)gmail(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Copy/Paste table(s) functions |
Date: | 2011-04-18 19:28:41 |
Message-ID: | 4DAC90E9.2000206@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Le 18/04/2011 11:04, Vladimir Kokovic a écrit :
> Hi,
>
> 1.Select server
> 2.Select database
> 3.select schema
> 4.select table with primary key which contains character varying.field
> 5.look in SQL pane line for the primary key definition
> If your selected server is PostgreSQL 9.1, primary key looks like:
> CONSTRAINT edi_razmena_pkey PRIMARY KEY (godina COLLATE
> pg_catalog."default", razmena_id COLLATE pg_catalog."default", kupac
> COLLATE pg_catalog."default")
> 6.If you apply patch, primary key looks like:
> CONSTRAINT edi_razmena_pkey PRIMARY KEY (godina, razmena_id, kupac)
>
OK, I reproduce it now. The patch I wrote fixed also the index in the
browser.
Thanks for your report.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-04-18 19:51:18 | pgAdmin III commit: Fix the display options |
Previous Message | Guillaume Lelarge | 2011-04-18 19:28:06 | pgAdmin III commit: Fix an issue with collate and index constraint |