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