|
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 |
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 numbersTo 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.
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.
[Prev in Thread] | Current Thread | [Next in Thread] |