Postgres Pro
Downloads
Home   >   mailing lists

Re: Need to do an ALTER TABLE. - Mailing list pgsql-sql

From Tom Lane
Subject Re: Need to do an ALTER TABLE.
Date
Msg-id 8038.986410530@sss.pgh.pa.us
Whole thread Raw
In response to Need to do an ALTER TABLE.  (jkakar@expressus.com)
Responses Re: Need to do an ALTER TABLE.
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Srikanth Rao
Date:
Subject: Memory exhaustion
Next
From: Birgit Jansen
Date:
Subject: searching for dates