This is probably related to Lockhart's changes to allow
not null/not deferrable to work (foreign key stuff). I'm
sympathetic, I looked at gram.y for awhile myself trying to
figure a way out of the problem and didn't find a good
donb=# create table bar(i integer unique not null);
ERROR: parser: parse error at or near "not"
donb=# create table bar(i integer not null unique);
ERROR: parser: parse error at or near "unique"
donb=# create table bar(i integer unique);
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'bar_i_key' for
Ouch. Fails on "primary key not null", etc too (though the
not null is redundant in this case).
The data model I'm porting from Oracle fails several hundred
times now because of this little problem...I guess my last
snapshot was just before Thomas' committed those changes,
otherwise I would've caught them before beta.
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2000-02-28 15:20:29|
|Subject: Re: [HACKERS] Re: ALTER TABLE DROP COLUMN |
|Previous:||From: Tom Lane||Date: 2000-02-28 15:14:07|
|Subject: Re: [HACKERS] having and union in v7beta |