[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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));


>  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
>