Re: SQL-Dump and refertial Integrity

From: "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org>
To: Thomas Woehlke <Thomas(dot)Woehlke(at)ESC-Electronics(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL-Dump and refertial Integrity
Date: 2002-04-15 19:29:57
Message-ID: Pine.BSO.4.40.0204151429250.11829-100000@kitten.greentechnologist.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-04-15 19:34:14 Re: MAX(column1),MAX(column2),...
Previous Message Bjarte Aagnes 2002-04-15 18:38:12 MAX(column1),MAX(column2),...