Re: [SQL] Need to do an ALTER TABLE.

[Tom Lane]

[EMAIL PROTECTED] 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster