On Wed, 2008-04-02 at 11:52 -0700, Chris Travers wrote:
>
>
> On Wed, Apr 2, 2008 at 11:21 AM, beamends <[EMAIL PROTECTED]> wrote:
> Hi all,
> sorry to a nuisance, but....
>
> When adding a vendor (the first one) I get
>
> DBD::Pg::db do failed: ERROR: duplicate key violates unique
> constraint
> "transactions_pkey"
>
> Error!
> INSERT INTO vendor (name)
> VALUES ('Wed Apr 2 19:15:52 200816161')
> ERROR: duplicate key violates unique constraint
> "transactions_pkey"
> In psql, run:
>
> SELECT setval('id', select max(id) from transactions);
>
>
Hi Chris,
thanks for that. Unfortunately, after finally remembering my password
(!), I get:
postgres=# SELECT setval('id', select max(id) from transactions);
ERROR: syntax error at or near "select"
LINE 1: SELECT setval('id', select max(id) from transactions);
^
Obviously I'm doing something wrong.....
Cheers
Richard
>
>
> any ideas. Also, I'm probably being a bit thick, but what does
> the
> "200816161" bit represent?
>
> 2008 is the year, 16161 is the process id.
>
> We are fixing that sort of thing, BTW :-)
>
> Best Wishes
> Chris Travers
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Ledger-smb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
