On Sun, Jul 25, 1999 at 03:13:39PM +1000, Chris Bitmead wrote:
> Dan Wilson wrote:
>
> > Yes, I am aware that the primary key does not really mean anything except
> > implicitly making it a unique key, but it's supposed to be there for
> > compatibility and it's not even in the dump.
>
> Someone mentioned recently that primary key enforces nulls as unique
> whereas unique index doesn't.
>
Actually, I belive it enforces NOT NULL on primary keys, which it also
dumps in the pg_dump output.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005