Re: SQL-Dump and refertial Integrity - Mailing list pgsql-novice

From Joshua b. Jore
Subject Re: SQL-Dump and refertial Integrity
Date
Msg-id Pine.BSO.4.40.0204151429250.11829-100000@kitten.greentechnologist.org
Whole thread Raw
In response to SQL-Dump and refertial Integrity  (Thomas Woehlke <Thomas.Woehlke@ESC-Electronics.de>)
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Oh sure, look in the archives a few days ago for some functions I posted:
EnableTriggers(), DisableTriggers().

Joshua b. Jore
http://www.greentechnologist.org

On Mon, 15 Apr 2002, Thomas Woehlke wrote:

> Hi @All!
>
> I have a problem on dumping a database:
>
> If I export the Structure via pg_dump
> the table are dumped in alphabetical order, but the order violates
> the refenrential integrity of my db.
>
> At inserting it via psql db < db_structure.sql it throws errors and the
> database is not not correctly build on the other server. Tables are
> missing.
>
> Are there any known solutions or a workaround?
>
> I would greatly appreciate receiving an helping answer even if this
> question is very newbie-like.
>
> Thank You
>
> Thomas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8uyo3fexLsowstzcRAgBUAJ0ds4bgDaY8tnMcDBsIl+E/F1nFGQCglaPL
KdAj1m9gwJnpKx0VHicRjOQ=
=AfQt
-----END PGP SIGNATURE-----


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL-Dump and refertial Integrity
Next
From: Jeff Post
Date:
Subject: Pl/Pgsql function troubles