Re: multi-table unique index - Mailing list pgsql-sql

From Markus Bertheau
Subject Re: multi-table unique index
Date
Msg-id 1056392214.3405.0.camel@saphir
Whole thread Raw
In response to Re: multi-table unique index  (Michael A Nachbaur <mike@nachbaur.com>)
Responses Re: multi-table unique index
List 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.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: TR: Like and =
Next
From: Michael A Nachbaur
Date:
Subject: Re: multi-table unique index