Received: from orbits.com (mail@sdsl-64-7-11-116.dsl.iad.megapath.net [64.7.11.116]) by hub.org (8.10.1/8.11.0) with ESMTP id e9S6nbZ14880 for ; Sat, 28 Oct 2000 02:49:37 -0400 (EDT) (envelope-from root@orbits.com) Received: from root by orbits.com with local (Exim 3.12 #1 (Debian)) id 13pPtV-00075D-00; Sat, 28 Oct 2000 02:55:09 -0400 To: pgsql@orbits.com Received: from hub.org.org (localhost [127.0.0.1]) by hub.org (8.10.1/8.11.0) with SMTP id e9R9mjq55684; Fri, 27 Oct 2000 05:48:45 -0400 (EDT) (envelope-from pgsql-sql-owner+M1922@hub.org) Received: from home.grafton.lv (dns.grafton.lv [159.148.192.252]) by hub.org (8.10.1/8.11.0) with ESMTP id e9R90cq29575 for ; Fri, 27 Oct 2000 05:00:40 -0400 (EDT) (envelope-from emils@grafton.lv) Received: from mortyr (mortyr.grafton.lv [159.148.192.196]) by home.grafton.lv (8.9.3/8.8.7) with ESMTP id KAA23162; Fri, 27 Oct 2000 10:59:36 -0200 From: "Emils Klotins" Date: Fri, 27 Oct 2000 11:00:27 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: renaming columns... danger? CC: pgsql-sql@hub.org In-reply-to: <20001027050141.76502.qmail@web10004.mail.yahoo.com> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Mailing-List: pgsql-sql@postgresql.org Precedence: bulk Message-Id: X-Archive-Number: 200010/264 X-Sequence-Number: 1931 Subject: [SQL] renaming columns... danger? > I just discovered that doing an alter table ... alter > column (to rename a column) does not do a complete > rename throughout the database. > shouldn't rename update any index and key definitions? > I'm very frightened right now, because I'm rather > dependent upon my database right now. I don't like > the thought that my database is corrupt at the schema > level. > Yes, I believe the same is true about trigger definitions and suchlike. In short - to do a rename on column I do a pg_dumpall and change all references of the name by hand :*((( Btw, is there a way to see what triggers are defined for particular field? Or how to drop triggers, which (by default) are unnamed?