From: | Francisco Reyes <lists(at)natserv(dot)com> |
---|---|
To: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Named constraints |
Date: | 2002-05-23 03:03:18 |
Message-ID: | 20020522225629.M76665-100000@zoraida.natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am trying to create a named constraint, but it doesn't seem to take the
name.
I got an example from the referential integrity page
http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php
After looking the examples I created SQL script
create table Users
(
UserID serial primary key,
GroupID integer
constraint fkgroup
references Groups,
LocationID integer
constraint fklocations
references Locations,
Password varchar(20) NOT NULL,
Name varchar(16) NOT NULL,
LongName varchar(20) NOT NULL,
Email varchar(50)
);
It creates the table, but lists the triggers
Triggers: RI_ConstraintTrigger_13682386,
RI_ConstraintTrigger_13682392
Is there a different syntax I should be using?
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-05-23 03:29:18 | Re: Named constraints |
Previous Message | Nigel J. Andrews | 2002-05-23 01:39:01 | Re: Graphical Tool |