But I think all of triggers of referenced table are not deleted.
We recreate the schemas ... and now it's running.
How is it possible to identify Triggers with no referenced tables ?
Stephan Szabo a écrit:
On Mon, 11 Aug 2003, BenLaKnet wrote:How could I do a pg_dump -s ??on local server ??Yes. I figured you wouldn't want to send your backups with data (I assume you have pg_dump generated backups ;) ). You can use pg_dump locally or remotely (using -h and -p options). Locally, log in as the postgres user and run pg_dump -s <databasename>, remotely do pg_dump -s -h <databasehost> -p <databaseport> <databasename> I believe.
