> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > We currently only allow the words PRIMARY KEY on a SERIAL column.
>
> Say what? There are ColConstraintElem and ConstraintElem productions
> for PRIMARY KEY ... are they broken?
>
> regards, tom lane
>
Oh, I see it now. The grammer seems to only support it in SERIAL, but I
see it works now. I guess i am surprised SERIAL PRIMARY creates the
index and sequence, while INTEGER PRIMARY only creates the index.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026