X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CEA69529D8 for ; Wed, 20 Jul 2005 05:50:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17769-01 for ; Wed, 20 Jul 2005 08:50:31 +0000 (GMT) Received: from km0908.keymachine.de (unknown [62.141.48.191]) by svr1.postgresql.org (Postfix) with ESMTP id 05041529AD for ; Wed, 20 Jul 2005 05:50:29 -0300 (ADT) Received: from prog-01.polonium.de ([212.91.241.54]) (authenticated) by km0908.keymachine.de (8.11.6/8.11.6) with ESMTP id j6K8oPD11876 for ; Wed, 20 Jul 2005 10:50:25 +0200 Message-Id: <6.2.3.4.0.20050720104139.01e0e370@polonium.de> X-Mailer: QUALCOMM Windows Eudora Version 6.2.3.4 Date: Wed, 20 Jul 2005 10:49:20 +0200 To: pgsql-admin@postgresql.org From: Rafal Kedziorski Subject: Add new column Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.207 tagged_above=0 required=5 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200507/145 X-Sequence-Number: 18201 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