Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f076CH752320 for ; Sun, 7 Jan 2001 01:12:18 -0500 (EST) (envelope-from t-ishii@sra.co.jp) Received: from sranhk.sra.co.jp (sranhk [133.137.36.134]) by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id PAA03447 for ; Sun, 7 Jan 2001 15:12:25 +0900 (JST) Received: from localhost (IDENT:t-ishii@portsv3-15 [133.137.84.15]) by sranhk.sra.co.jp (8.9.3/3.7W-srambox) with ESMTP id PAA22609 for ; Sun, 7 Jan 2001 15:12:23 +0900 To: pgsql-hackers@postgresql.org Subject: Re: Re: [SQL] renaming columns... danger? In-Reply-To: References: <20001027050141.76502.qmail@web10004.mail.yahoo.com> X-Mailer: Mew version 1.94.2 on Emacs 20.7 / Mule 4.1 =?ISO-2022-JP?B?KBskQjAqGyhCKQ==?= Message-Id: <20010107151215W.t-ishii@sra.co.jp> Date: Sun, 07 Jan 2001 15:12:15 +0900 From: Tatsuo Ishii X-Dispatcher: imput version 20000228(IM140) Lines: 55 X-Archive-Number: 200101/150 X-Sequence-Number: 2822 As for the latest CVS source, it looks still we have problems regarding alter table rename column and pg_dump as Grant has mentioned. Results of pg_dump is attached. test=# create table a ( aa serial primary key ); NOTICE: CREATE TABLE will create implicit sequence 'a_aa_seq' for SERIAL column 'a.aa' NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for table 'a' CREATE test=# alter TABLE a RENAME aa to new_aa; ALTER test=# \q [t-ishii@srapc1474 current]$ pg_dump test > /tmp/aaa [t-ishii@srapc1474 current]$ dropdb test DROP DATABASE [t-ishii@srapc1474 current]$ createdb test CREATE DATABASE [t-ishii@srapc1474 current]$ psql test < /tmp/aaa Using pager is off. You are now connected as new user t-ishii. CREATE ERROR: CREATE TABLE: column "aa" named in key does not exist UPDATE 53 ERROR: Relation 'a' does not exist invalid command \. BEGIN CREATE INSERT 18819 1 UPDATE 1 DROP COMMIT setval -------- 1 (1 row) [t-ishii@srapc1474 current]$ psql test Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit Using pager is off. test=# \dt No relations found. test=# ------------------------------ attachments ------------------------------ Multipart/Mixed 2/ 1 Text/Plain(guess) CoverPage* B 2 Application/Octet-Stream aaa.gz 3 . --------0-1-2-3-4-5-6-7-8-9----------------------------------------------