Serial Data Type
David Hartwig <daveh@insightdist.com>
From: David Hartwig <daveh@insightdist.com>
To: pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 1998-09-11T20:01:57Z
Lists: pgsql-hackers
I have a couple minor issues regarding the 6.4 implementation of the
SERIAL data type. I like the ease of using the serial data type and I
suspect it will be used frequently base on the number of inquiries over
the past months.
1. Should the sequence created by the serial type declaration, be
dropped as a result of dropping the parent table?
2. Can a declared serial column be also a primary key? If so, what
will be the side effected? Specifically, how will the unique index be
named? The ODBC driver uses the {relname}_pkey to identify the primary
key of a table. The driver must be able to identify primary keys.
Comments?