Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f34ItZ877936 for ; Wed, 4 Apr 2001 14:55:36 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f34ItUw08041; Wed, 4 Apr 2001 14:55:30 -0400 (EDT) To: jkakar@expressus.com cc: pgsql-sql@postgresql.org Subject: Re: Need to do an ALTER TABLE. In-reply-to: <20010404105738.A536@expressus.com> References: <20010404105738.A536@expressus.com> Comments: In-reply-to jkakar@expressus.com message dated "Wed, 04 Apr 2001 10:57:38 -0700" Date: Wed, 04 Apr 2001 14:55:30 -0400 Message-ID: <8038.986410530@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/55 X-Sequence-Number: 2394 jkakar@expressus.com writes: > I'm glad I did this as I found out I have > to use 'pg_dump -d' to get a useful backup. =) Why? > The tables I need to modify are referenced by other > tables- will those other tables realise that they should re-establish > foreign key references? If not automatically, will VACUUM ANALYZE do > this for me? No, and no :-(. regards, tom lane