[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] gui elements

From: catmat
Subject: Re: [Gnumed-devel] gui elements
Date: Sat, 13 Nov 2004 11:29:16 +1100
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.3) Gecko/20040913

To solve which problem ? In-database metadata such as primary
keys should never ever be of used outside the database in fear
of them acquiring business meaning. In light of this it is
probably good that PostgreSQL makes re-using sequence
values rather painful.

It solves export and import as simple pg_dump -a / psql -f operations, because the primary keys are never repeatable, even in schemas on different machines where used sequence numbers
do not match.

Another approach, more involved and requiring more programming, is to export to some structured document file, and to reimport it with a importer that parses the structured document and issues sql insert statements. I was wondering if Carlos or someone has already / or is doing this already.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]