Skip site navigation (1)
Skip section navigation (2)
What is the "correct" behavior of a serial column when a table is created with LIKE? The manual is silent on this.
Peripheral Links
Header And Logo
|
Site Navigation
CREATE TABLE LIKE and SERIAL
- From: Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk>
- To: pgsql-general(at)PostgreSQL(dot)org
- Subject: CREATE TABLE LIKE and SERIAL
- Date: Fri, 30 Oct 2009 12:44:31 +0000
- Message-id: <hcen3g$eqf$1@pye-srv-01.telemetry.co.uk> <text/plain>
What is the "correct" behavior of a serial column when a table is created with LIKE? The manual is silent on this.
What appears to be happening with 8.2 is that the column in the new table refers to the original sequence generator.
-- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues]
- Follow-Ups:
- Re: CREATE TABLE LIKE and SERIAL
- From: silly8888
- Re: CREATE TABLE LIKE and SERIAL
- Prev by Date: Re: checkpoints/bgwriter tuning verification
- Next by Date: Re: checkpoints/bgwriter tuning verification
- Previous by thread: Correlated Subquery and calculated column non-functional
- Next by thread: Re: CREATE TABLE LIKE and SERIAL
- Indexes: