Re: [Modeling-users] Foreign Keys

[Sebastien B. <sbi...@us...>]

Yannick Gingras <yan...@sa...> wrote:
> There is a nice feature in phpMyAdmin to dump a database to XML.
> There is no nice feature in phpMyAdmin to import a XML dump.  So I
> wrote a little script to import this XML dump using the framework.
> This provide me RDBMS independance so I can re-import my dump in
> Postgres in no time.

Nice.

> But if I have some of the records that have been
> deleted, the PKs are not in a continuous sequence so FKs become out of
> synch.

Ok. But could you tell how you are doing this exactly? Are you
building/inserting-in-ec new objects, then saving changes, or are you
using some of the low-level functionalities to execute raw sql inserts,
or something else? Asking this, because I'm trying to understand at
which point exactly you need to provide the PK, where it is stored, etc.

-- S=E9bastien.