| 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: | Whole Thread | Raw Message | 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 |