Re: Need to do an ALTER TABLE.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jkakar(at)expressus(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Need to do an ALTER TABLE.
Date: 2001-04-04 18:55:30
Message-ID: 8038.986410530@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

jkakar(at)expressus(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-04-04 19:17:17 Re: Postgres 7.1RC1 on Solaris 7
Previous Message Gordon A. Runkle 2001-04-04 18:54:14 Re: php Compile question

Browse pgsql-sql by date

  From Date Subject
Next Message Birgit Jansen 2001-04-04 19:27:01 searching for dates
Previous Message Poet/Joshua Drake 2001-04-04 18:53:24 [pgsql-general] Baffling Performance