deferred primary key

Поиск
Список
Период
Сортировка
От Merrill Oveson
Тема deferred primary key
Дата
Msg-id 393D6EC1.37F192C9@actiontarget.com
обсуждение исходный текст
Список pgsql-general
Fellow postgresers:

According to the web site the following syntax is permitted:

PRIMARY KEY clause

SQL92 specifies some additional capabilities for PRIMARY KEY:

Table Constraint definition:

[ CONSTRAINT name ] PRIMARY KEY ( column [, ...] )
    [ {INITIALLY DEFERRED | INITIALLY IMMEDIATE} ]
    [ [ NOT ] DEFERRABLE ]


My snytax is:

constraint base_pos_pkey primary key (base, pos)
    initially deferred

Postgres complained about the "initially"

Are deferrable primary keys not supported by Postgres?


Thanks!

Merrill




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum Question
Следующее
От: mjp@ornl.gov
Дата:
Сообщение: Composite Types