Your name : Steve McClure
Your email address : skmcclure@mediaone.net
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Celeron 800Mhz
Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.2-2 ELF
RedHat 7.1
PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.2
Compiler used (example: gcc 2.8.0) : Binary install
Please enter a FULL description of your problem:
------------------------------------------------
I'm creating a database by cat <filename> | psql <dbname>
and populating it with test data the same way.
I'm using data type serial for the primary key field on each table and
one table consistent has the incorrect value in the sequence after
creation causing inserts to fail with a duplicate key message. If I
use pg_dump, modify the SQL for the sequence in question and create a
new database with that dump output file, everything works correctly.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
I will be glad to provide my schema files that I am using to reproduce
this problem.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Thanks,
--
Steve McClure 430 10th St NW
Racemi Suite N-210
http://www.racemi.com Atlanta, GA 30318
smcclure@racemi.com voice/fax: 404-892-5850