Comment 1987 added to page ddl-inherit.html of version 7.4

From: nobody <nobody(at)developer(dot)pgadmin(dot)org>
To: pgsql-www(at)postgresql(dot)org
Subject: Comment 1987 added to page ddl-inherit.html of version 7.4
Date: 2005-01-13 12:40:44
Message-ID: 200501131240.j0DCeisu011482@developer.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

Author: Diego Zuccato <diego(at)otello(dot)alma(dot)unibo(dot)it>
----
Replicating PRIMARY KEY in child tables allows only referencing 'em from other tables. It doesn't solve the "duplicated primary key" problem in the parent table. The only way I could find is adding :
CREATE OR REPLACE FUNCTION base_notexists(integer)
RETURNS boolean
STABLE
LANGUAGE 'SQL'
AS 'SELECT NOT EXISTS(SELECT id FROM base WHERE id=$1)';
and the constraint
CHECK (base_notexists(id))

If only it could be possible to reference an already existing index...
----
Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/ddl-inherit.html
Reject: http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1987
Edit: http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1987
Delete: http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1987

Browse pgsql-www by date

  From Date Subject
Next Message Dave Page 2005-01-13 13:02:25 FTP/Mirror selection
Previous Message John Hansen 2005-01-13 08:43:31 Re: Search