On Fri, 7 Oct 2005 smorrey@gmail.com wrote:
> Hello pgsql is complaining and I can't seem to figure out what the
> error is talking about.
> Basically it's claiming that multiple default vaues are being
> specified, but nowhere in statement below is there one single place
> where I can see an error.
> Please help!
Bigserial implies a default and then you placed a default on the column in
addition.
>
> SQL error:
>
> ERROR: multiple default values specified for column "txnid" of table
> "ec_transaction"
>
> In statement:
>
> CREATE TABLE ec_transaction (
> txnid BIGSERIAL NOT NULL DEFAULT
> nextval('public.ec_transaction_txnid_seq') ,