Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

[Dieter S. <dsi...@sq...>]

On Fri, 5 Jan 2007, Jason Kay wrote:

> Well, that didn't help.  There aren't any sequence number values for
> the invoiceid or orderitemsid in my older backups.  I did find some
> values for them in a backup I had made using pg_dumpall quite a long
> time ago.  I thought I would try putting them in my recent backup file
> and restoring it anyway, but I still get old payments and such showing
> up on new invoices.

Trust me, there is a value in the backup file.

This is from a v2.4 backup

search for 'DROP SEQUENCE' and you'll see the starting numbers.

DROP SEQUENCE id ;
CREATE SEQUENCE id START 17515;
--
DROP SEQUENCE invoiceid ;
CREATE SEQUENCE invoiceid START 17006;
--
DROP SEQUENCE orderitemsid ;
CREATE SEQUENCE orderitemsid START 475;

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================