Re: Use of reference table ('look-up-table') and FK constraint

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Charles Hauser <chauser(at)duke(dot)edu>
Cc: <josh(at)agliodbs(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Use of reference table ('look-up-table') and FK constraint
Date: 2002-10-17 15:34:51
Message-ID: 20021017083401.Y9470-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On 17 Oct 2002, Charles Hauser wrote:

> Josh & Stephan,
>
> This helps a lot - thanks!
>
> Any idea what datatype 'Identifier_type IDENTITY' specifies? I don't
> see this in the postgres documentation. I'll see what I can find in
> sybase lingo.

As a rough guess, I'd say probably a serial column,
"phone_id serial primary key" is likely.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-10-17 16:03:57 Re: object oriented vs relational DB
Previous Message Акулов Александр 2002-10-17 14:40:30 Can I create working trigger on view