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?