Re: [Modeling-users] Foreign Keys

[Yannick G. <yan...@sa...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On July 23, 2003 09:04 am, you wrote:
> > Since PKs are automatic, it would be really nice to be able to skip
> > some ids in the sequence.  Mostly when restoring a backup with deleted
> > records using the framework instead of a plain SQL dump (why I do this
> > is pure mystery, even me).
>
>   Could you be more explicit on what you're doing exactly? I suspect
>   that what you need here is the more general feature where you could
>   provide your own pk values.

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

So yes, I'm looking for a way to provide my PK values.

=2D --=20
Yannick Gingras
Byte Gardener, Savoir-faire Linux inc.
(514) 276-5468

=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/HpJ3rhy5Fqn/MRARAjPNAJ403ltRwkRO4jdoXqNRAWLRar+0WACgiQRW
P+nBLzqyLzEcemBLJbjHezA=3D
=3Dek7I
=2D----END PGP SIGNATURE-----