Re: [GENERAL] CREATE TABLE LIKE and SERIAL

On Fri, Oct 30, 2009 at 11:12 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> 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?

Do you have a proposed fix? I suspect people won't want us to stop
showing columns as 'SERIAL' when they actually were created that way.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PGDay.EU 2009 Conference: http://2009.pgday.eu/start