From: | Rafal Kedziorski <rafcio(at)polonium(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Add new column |
Date: | 2005-07-20 08:49:20 |
Message-ID: | 6.2.3.4.0.20050720104139.01e0e370@polonium.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I wan't add new column to this table:
CREATE SEQUENCE abo_product_2_user_seq;
CREATE TABLE abo_product_2_user (
abo_product_2_user_id BIGINT NOT NULL DEFAULT
NEXTVAL('abo_product_2_user_seq'),
abo_product_id SMALLINT NOT NULL,
user_id BIGINT NOT NULL,
valid_from TIMESTAMP NOT NULL,
valid_to TIMESTAMP,
debit_entry VARCHAR(12) NOT NULL,
--
PRIMARY KEY (abo_product_2_user_id),
--INDEX (abo_product_id),
--INDEX (user_id),
FOREIGN KEY (abo_product_id)
REFERENCES abo_product (abo_product_id),
FOREIGN KEY (user_id)
REFERENCES users (user_id)
);
But PostgreSQL 8.0.3 adds the new column at the end. I want add this
new column between user_id and valid_from.
Best Regards,
Rafal
From | Date | Subject | |
---|---|---|---|
Next Message | Dawid Kuroczko | 2005-07-20 09:04:15 | Re: Add new column |
Previous Message | Tsirkin Evgeny | 2005-07-20 07:55:50 | Re: can not start the postgresql, i use gentoo |