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-----
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),... |