On Sat, Nov 6, 2010 at 1:56 AM, [email protected] <[email protected]> wrote:
...
> Did you read this on Dieter's FAQ page
> (http://sql-ledger.com/cgi-bin/nav.pl?page=misc/faq.html&title=FAQ)?
No, I'm a typical guy -- I rarely read the instructions, I just forge
ahead until I get myself into so much trouble that I can't get out of
it -- only THEN do I read the instructions. :-)
> "PostgreSQL 8.x PostgreSQL added a restriction in v8.x that a sequence
> cannot be dropped after if it is referenced by a table. However backups
> created with SQL-Ledger v2.6.13 and earlier have a DROP SEQUENCE step in the
> backup which will fail. To fix this edit the backup before restoring on a
> 8.x system.
>
> This typically looks like this:
>
> DROP SEQUENCE id ;
> CREATE SEQUENCE id START 10579;
...
> Change it to:
>
> SELECT SETVAL('id', 10579);
That is exactly what I did after I figured it out on my own, without
reading the FAQ. Seems to have worked!
--
Best Regards,
Wallace
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
