Postgres Pro
Downloads
Home   >   mailing lists

Re: serial as FK ? - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: serial as FK ?
Date
Msg-id 20050228100844.N97109@megazone.bigpanda.com
Whole thread Raw
In response to serial as FK ?  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: serial as FK ?  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Tree view 
On Mon, 28 Feb 2005, Oleg Bartunov wrote:

> what's wrong to use SERIAL as FK without explicit PRIMARY KEY or UNIQUE ?

Serial isn't enough to guarantee uniqueness as required by foreign keys.

pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [pgsql-hackers-win32] win32 performance - fsync question
Next
From: David Fetter
Date:
Subject: Re: SQL99 Hierarchical queries