Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: CREATE TABLE LIKE and SERIAL
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Thom Brown <thombrown(at)gmail(dot)com>
- Cc: Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
- Subject: Re: CREATE TABLE LIKE and SERIAL
- Date: Fri, 30 Oct 2009 18:48:45 -0400
- Message-id: <24932.1256942925@sss.pgh.pa.us> <text/plain>
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...) regards, tom lane
- References:
- CREATE TABLE LIKE and SERIAL
- From: Mark Morgan Lloyd
- Re: CREATE TABLE LIKE and SERIAL
- From: silly8888
- Re: CREATE TABLE LIKE and SERIAL
- From: Mark Morgan Lloyd
- Re: CREATE TABLE LIKE and SERIAL
- From: Thom Brown
- Re: CREATE TABLE LIKE and SERIAL
- From: Tom Lane
- Re: CREATE TABLE LIKE and SERIAL
- From: Thom Brown
- Re: CREATE TABLE LIKE and SERIAL
- From: Tom Lane
- Re: CREATE TABLE LIKE and SERIAL
- From: Thom Brown
- CREATE TABLE LIKE and SERIAL
- Prev by Date: pg_start_backup question
- Next by Date: Re: pg_start_backup question
- Previous by thread: Re: CREATE TABLE LIKE and SERIAL
- Next by thread: Re: CREATE TABLE LIKE and SERIAL
- Indexes: