Tom,
That does bring up a related question: when are we gonna get DROP
COLUMN capability? Currently my tables are littered with unused columns
because I can't remove them without blowing my referential integrity and
views to heck.
-Josh Berkus
_
[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 automaticall
Hi,
I've got a live database running PSQL 7.0.3. I need to do a couple of
changes to some of the table schema's but need to preserve the data
that currently exists in the tables. I've used pg_dump to make
backups and have verified that I can indeed restore into an empty
database from those back
