Re: multiple default values specified for column? - Mailing list pgsql-general

smorrey@gmail.com writes:
> ERROR:  multiple default values specified for column "txnid" of table
> "ec_transaction"

> CREATE TABLE ec_transaction (
>     txnid BIGSERIAL NOT NULL DEFAULT
> nextval('public.ec_transaction_txnid_seq') ,

SERIAL/BIGSERIAL implies a default clause.  If you want to attach the
column to a pre-existing sequence, just declare it int or bigint.

            regards, tom lane