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

Re: Upgrade error

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
Ledger-smb-users mailing list