Named constraints

Поиск
Список
Период
Сортировка
Искать
От
Francisco Reyes
Тема
Named constraints
Дата
в 23:01:56
Msg-id
20020522225629.M76665-100000@zoraida.natserv.net
Список
Дерево обсуждения
Named constraints Francisco Reyes <lists@natserv.com>
Re: Named constraints Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Named constraints Francisco Reyes <lists@natserv.com>
Re: Named constraints Stephan Szabo <sszabo@megazone23.bigpanda.com>
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
FAQ