multiple default values specified for column?

Поиск
Список
Период
Сортировка
От smorrey@gmail.com
Тема multiple default values specified for column?
Дата
Msg-id 1128689450.387021.232140@g43g2000cwa.googlegroups.com
обсуждение исходный текст
Ответы Re: multiple default values specified for column?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: multiple default values specified for column?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-general
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!

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') ,
    uid integer DEFAULT 0 NOT NULL,
    mail character varying(64) DEFAULT ''::character varying NOT NULL,
    shipping_firstname character varying(32) DEFAULT ''::character
varying NOT NULL,
    shipping_lastname character varying(32) DEFAULT ''::character
varying NOT NULL,
    shipping_street1 character varying(64) DEFAULT ''::character
varying NOT NULL,
    shipping_street2 character varying(64) DEFAULT ''::character
varying NOT NULL,
    shipping_zip character varying(11) DEFAULT ''::character varying
NOT NULL,
    shipping_city character varying(32) DEFAULT ''::character varying
NOT NULL,
    shipping_state character varying(32) DEFAULT ''::character varying
NOT NULL,
    shipping_cost numeric(11,2) DEFAULT 0.00 NOT NULL,
    shipping_country character varying(2) DEFAULT ''::character varying
NOT NULL,
    billing_firstname character varying(32) DEFAULT ''::character
varying NOT NULL,
    billing_lastname character varying(32) DEFAULT ''::character
varying NOT NULL,
    billing_street1 character varying(64) DEFAULT ''::character varying
NOT NULL,
    billing_street2 character varying(64) DEFAULT ''::character varying
NOT NULL,
    billing_zip character varying(11) DEFAULT ''::character varying NOT
NULL,
    billing_city character varying(32) DEFAULT ''::character varying
NOT NULL,
    billing_state character varying(32) DEFAULT ''::character varying
NOT NULL,
    billing_country character varying(2) DEFAULT ''::character varying
NOT NULL,
    payment_method character varying(32) DEFAULT ''::character varying
NOT NULL,
    payment_status character varying(32) DEFAULT '1'::character varying
NOT NULL,
    coupon integer DEFAULT 0 NOT NULL,
    workflow integer DEFAULT 1 NOT NULL,
    gross numeric(11,2) DEFAULT 0.00 NOT NULL,
    expires integer DEFAULT 0 NOT NULL,
    created integer DEFAULT 0 NOT NULL,
    changed integer DEFAULT 0 NOT NULL,
    CONSTRAINT ec_transaction_coupon_check CHECK ((coupon >= 0)),
    CONSTRAINT ec_transaction_uid_check CHECK ((uid >= 0)),
    CONSTRAINT ec_transaction_workflow_check CHECK ((workflow >= 0))
)


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to inject knowledge into a Postgres database
Следующее
От: Dan Armbrust
Дата:
Сообщение: Re: What Front-End you suggest ?