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: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
Le 18/04/2011 11:04, Vladimir Kokovic a écrit :
> Hi,
> 1.Select server
> 2.Select database
> schema
> 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

Thanks for your report.


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-2017 The PostgreSQL Global Development Group