Re: Sorry to be a pain...........

[beamends <..hidden..>]

On Wed, 2008-04-02 at 11:52 -0700, Chris Travers wrote:
> 
> 
> On Wed, Apr 2, 2008 at 11:21 AM, beamends <..hidden..> 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users