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 <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 (view raw or flat)
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

In response to

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2011-04-18 19:51:18
Subject: pgAdmin III commit: Fix the display options
Previous:From: Guillaume LelargeDate: 2011-04-18 19:28:06
Subject: pgAdmin III commit: Fix an issue with collate and index constraint

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