Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] CREATE TABLE LIKE and SERIAL

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] CREATE TABLE LIKE and SERIAL
Date: 2009-11-01 12:24:10
Message-ID: 937d27e10911010424k6771590ey3e22c2acb9a47aa4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-general
On Fri, Oct 30, 2009 at 11:12 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
> Le vendredi 30 octobre 2009 à 23:48:45, Tom Lane a écrit :
>> Thom Brown <thombrown(at)gmail(dot)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

In response to

Responses

pgadmin-hackers by date

Next:From: mehmetsait vuralDate: 2009-11-01 12:54:52
Subject: postgresql with c#
Previous:From: Dave PageDate: 2009-11-01 12:18:03
Subject: Re: import 2009/10/31

pgsql-general by date

Next:From: Mark Morgan LloydDate: 2009-11-01 13:03:33
Subject: Re: Forms generator ?
Previous:From: Thom BrownDate: 2009-11-01 11:10:03
Subject: Re: Postgres alpha testing docs and general test packs

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