Postgres Pro
Downloads
Home   >   mailing lists

CREATE TABLE LIKE and SERIAL - Mailing list pgsql-general

From Mark Morgan Lloyd
Subject CREATE TABLE LIKE and SERIAL
Date
Msg-id hcen3g$eqf$1@pye-srv-01.telemetry.co.uk
Whole thread Raw
Responses Re: CREATE TABLE LIKE and SERIAL
List pgsql-general
Tree view 
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]

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: checkpoints/bgwriter tuning verification
Next
From: Guillaume Lelarge
Date:
Subject: Re: checkpoints/bgwriter tuning verification