[ADMIN] Broken index? (the revenge)

2001-09-12 Thread Paul Green
I don't think this reached the list, so I thought I'd send it again... On 2001.09.11 14:35 Paul Green wrote: Hi again, Ok, for those of you who have been following my troubles with my indexes on my site, this may interest you. I'd also appreciate any help once again, because now

[ADMIN] Broken index? (the revenge!)

2001-09-11 Thread Paul Green
27;t be a problem with locale and such. I originaly thought that this error may be due to having multiple non-unique inserts in a transaction, but each of these inserts was added through its own transaction. Does anyone have any idea why this is happening? Is it the JDBC driver, my installation, my

Re: [ADMIN] Broken index?

2001-09-07 Thread Paul Green
On 2001.09.07 15:53 Tom Lane wrote: > Paul Green <[EMAIL PROTECTED]> writes: > >> Hmm. What PG version is this, on what platform? > > > Redhat 7.1, (Linux 2.4.2-2) on a K6-2 300 with 128 mb ram running PG > 7.0 > > > What *is* wierd is that if I do, sa

Re: [ADMIN] Broken index?

2001-09-07 Thread Paul Green
On 2001.09.07 15:10 Tom Lane wrote: > Paul Green <[EMAIL PROTECTED]> writes: > > I am having a problem with duplicates appearing in a unique index and I > > have no idea why. > > Hmm. What PG version is this, on what platform? Redhat 7.1, (Linux 2.4.2-2) on a K6-2

[ADMIN] Broken index?

2001-09-07 Thread Paul Green
ery annoying problem. If you'd like to check the site out where it is used, go to http://www.fragmeter.com. Cheers! -- Paul Green Programmer Jippii Midlands 85 London Road, Leicester, England, LE2 0PF. tel: 0116 2230662 fax: 0116 2221305 Please visit www.businessjippii.co.uk to view our latest Internet