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: 2009-10-30 12:44:31
Message-ID: hcen3g$eqf$1@pye-srv-01.telemetry.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-general

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]

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message David Lazar 2009-10-30 13:20:53 Re: [ADMIN] pgAdmin 1.10, OSX 10.6 problem
Previous Message Dave Page 2009-10-30 08:59:19 Re: [ADMIN] pgAdmin 1.10, OSX 10.6 problem

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2009-10-30 13:03:11 Re: checkpoints/bgwriter tuning verification
Previous Message Brad Nicholson 2009-10-30 12:25:05 Re: checkpoints/bgwriter tuning verification