Named constraints

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Named constraints
Дата
Msg-id 20020522225629.M76665-100000@zoraida.natserv.net
обсуждение исходный текст
Ответы Re: Named constraints  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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?


В списке pgsql-general по дате отправления:

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: Graphical Tool
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Named constraints