deferred capability for the primary key

From: Merrill Oveson <merrill(at)actarg(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: deferred capability for the primary key
Date: 2000-06-01 16:21:20
Message-ID: 39368D80.4CF4E5FD@actiontarget.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

t

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Lynde 2000-06-01 16:37:10 Re: Postmaster won't -HUP
Previous Message Peter Landis 2000-06-01 16:11:59 ALTERING A TABLE