smorrey@xxxxxxxxx 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
