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

[beamends <..hidden..>]

On Sat, 2008-04-05 at 11:16 -0700, Chris Travers wrote:
> Sorry, forgot a set of parenthases.
> 
> On Sat, Apr 5, 2008 at 9:16 AM, beamends <..hidden..> wrote:
> > 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);
> 
> Should be:
> SELECT setval('id', (select max(id) from transactions));
> 

Hi Chris,
thanks - I'll get the hang of this one day!

Cheers
Richard

> 
> >  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
> >
> >
> >  -------------------------------------------------------------------------
> >  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
> >  ..hidden..
> >  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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users