Re: [GENERAL] CREATE TABLE LIKE and SERIAL - Mailing list pgadmin-hackers

From Guillaume Lelarge
Subject Re: [GENERAL] CREATE TABLE LIKE and SERIAL
Date
Msg-id 200910310012.09092.guillaume@lelarge.info
Whole thread Raw
Responses Re: [GENERAL] CREATE TABLE LIKE and SERIAL
List pgadmin-hackers
Le vendredi 30 octobre 2009 à 23:48:45, Tom Lane a écrit :
> Thom Brown <thombrown@gmail.com> writes:
> > How is pgAdmin determining the serial type in this case?
>
> Most likely it's looking for the pg_depend entry that shows the sequence
> as being "owned by" the column.  However, that's an oversimplification
> of reality.  I would imagine that pgAdmin will lie to you in exactly
> the same cases that used to break pg_dump (notably, where someone has
> manually adjusted either the default expression or the sequence...)
>

I've just read this. I wasn't aware of this. Should we suppress this behavior
of pgAdmin?


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

pgadmin-hackers by date:

Previous
From: David Lazar
Date:
Subject: Re: [ADMIN] pgAdmin 1.10, OSX 10.6 problem
Next
From: Quan Zongliang
Date:
Subject: import 2009/10/31