Re: multi-table unique index

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Michael A Nachbaur <mike(at)nachbaur(dot)com>
Cc: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: multi-table unique index
Date: 2003-06-23 18:16:55
Message-ID: 1056392214.3405.0.camel@saphir
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

В Пнд, 23.06.2003, в 19:32, Michael A Nachbaur пишет:
> Instead of using the "serial" datatype, you can set it to "int4 PRIMARY KEY
> DEFAULT nextval(foo_type_id_seq)" and you can manually create the sequence
> "foo_type_id_seq".
>
> This way all the tables share the same sequence.

Yeah, but I want to force this behaviour. so that it cannot happen by
accident when you insert records without relying on the sequence.

--
Markus Bertheau.
Berlin, Berlin.
Germany.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael A Nachbaur 2003-06-23 18:34:11 Re: multi-table unique index
Previous Message Tom Lane 2003-06-23 17:35:39 Re: TR: Like and =