Re: Upgrade error

["Chris Travers" <..hidden..>]

Eeek....
Ok, before you do anything else, do:
select setval('id', (select max(id) + 1 FROM transactions);

THen, you can send me a summary (off-list if you prefer) of the
duplicate data so we can try to get this sorted out.

Best Wishes,
Chris Travers

On 11/12/06, G. Net <..hidden..> wrote:
> > As I am thinking about it, probably the easiest way to track down this
> > problem is to drop the transactions table, then recreate it without a
> > primary key:
>
> well uhmm... I since didnt have a transactions table I went straight onto this then?...
>
> > create table transactions (id int, table_name text);
>
> and then this turns up about 200 record where the same ID is used in diferent tables
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users