Re: serial as FK ?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>, dev(at)archonet(dot)com
Subject: Re: serial as FK ?
Date: 2005-02-28 18:09:55
Message-ID: 20050228100844.N97109@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2005-02-28 18:44:33 Re: SQL99 Hierarchical queries
Previous Message pgsql 2005-02-28 17:54:44 Re: snprintf causes regression tests to fail