Re: [BUGS] Duplicate values found when reindexing unique index

2007-12-30 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: >> I wonder whether it's just a coincidence that these have the same offset >> number... > I can't imagine any Postgres bug which would depend on the offsets > being the same. But what I could imagine is filesystem

Re: [BUGS] Duplicate values found when reindexing unique index

2007-12-30 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: >> Here's the system column data you requested. > >> id | ctid | xmin | xmax | cmin | cmax >> ---+--+--+--+--+-- >> 151341072 | (1508573,11) |2 |0 | 19 |0 >> 151341072 | (1818219,11) |2

Re: [BUGS] Duplicate values found when reindexing unique index

2007-12-30 Thread Tom Lane
"Mason Hale" <[EMAIL PROTECTED]> writes: > I have downloaded, compiled and installed pg_filedump -- but I am not sure > how to determine which file I should have it dump. I am not very familiar > with the postgres file structure. Can you please provide some guidance? How > do I determine the correc

Re: [BUGS] BUG #3841: core dump in uuid-ossp

2007-12-30 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > if (err != NULL) > > ereport(ERROR, > > (errmsg("OSSP uuid failure: %s", err))); > > else > > ereport(ERROR, > > (errmsg("OSSP uuid failure: error code %d", rc))); > > Maybe "OS

Re: [BUGS] Duplicate values found when reindexing unique index

2007-12-30 Thread Tom Lane
"Mason Hale" <[EMAIL PROTECTED]> writes: > I found a single pair of rows that were duplicated. Interestingly it was not > just the guid and feed_id that were duplicated but all columns were > indentical, including the primary key, except an update_at column which is > automatically populated via a

Re: [BUGS] Duplicate values found when reindexing unique index

2007-12-30 Thread Tom Lane
"Mason Hale" <[EMAIL PROTECTED]> writes: > Given my experience, the reliability of unique indexes is becoming somewhat > suspect. Please help. ;-) Well, as in the previous report, there is not enough information here to offer much chance of understanding what's going wrong. Have you tried reindex

Re: [BUGS] BUG #3845: tray icon that service is running

2007-12-30 Thread Bill Moran
Magnus Hagander <[EMAIL PROTECTED]> wrote: > > Bill Moran wrote: > > "Usama Dar" <[EMAIL PROTECTED]> wrote: > >> On Dec 30, 2007 3:51 AM, Bozhan <[EMAIL PROTECTED]> wrote: > >> > >>> > >>> postgres needs icon in tray to show that service is running. to > >>> stop/start/restart postgres maybe. > >>>

Re: [BUGS] BUG #3845: tray icon that service is running

2007-12-30 Thread Magnus Hagander
Harald Armin Massa wrote: >> There is one already: >> >> http://pgfoundry.org/projects/pgtray/ > > > could it be bundled into the installer? There are more uses for a > database server then servers alone... If someone makes a stackbuilder compatible installer for it (which I think may have alrea

[BUGS] Duplicate values found when reindexing unique index

2007-12-30 Thread Mason Hale
Hello -- I noticed recently some errors in my postgres log like the following: ERROR: could not open segment 9 of relation 1663/16830/1384385 (target block 776929292): No such file or directory These are occurring at a rate of 1 every 2-3 days. But that rate has been increasing. After Googling

Re: [BUGS] BUG #3845: tray icon that service is running

2007-12-30 Thread Harald Armin Massa
> There is one already: > > http://pgfoundry.org/projects/pgtray/ could it be bundled into the installer? There are more uses for a database server then servers alone... Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 f

Re: [BUGS] BUG #3845: tray icon that service is running

2007-12-30 Thread Tom Lane
Bill Moran <[EMAIL PROTECTED]> writes: > In any case, I doubt it deserves to be part of PostgreSQL proper. If > someone is interested, probably a pgfoundry project would make sense. It's been done ... http://pgfoundry.org/projects/pgtray/ regards, tom lane --

Re: [BUGS] BUG #3845: tray icon that service is running

2007-12-30 Thread Magnus Hagander
Bill Moran wrote: > "Usama Dar" <[EMAIL PROTECTED]> wrote: >> On Dec 30, 2007 3:51 AM, Bozhan <[EMAIL PROTECTED]> wrote: >> >>> The following bug has been logged online: >>> >>> Bug reference: 3845 >>> Logged by: Bozhan >>> Email address: [EMAIL PROTECTED] >>> PostgreSQL version:

Re: [BUGS] BUG #3845: tray icon that service is running

2007-12-30 Thread Bill Moran
"Usama Dar" <[EMAIL PROTECTED]> wrote: > > On Dec 30, 2007 3:51 AM, Bozhan <[EMAIL PROTECTED]> wrote: > > > > > The following bug has been logged online: > > > > Bug reference: 3845 > > Logged by: Bozhan > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 8.3-beta4 > >

Re: [BUGS] BUG #3845: tray icon that service is running

2007-12-30 Thread Usama Dar
On Dec 30, 2007 3:51 AM, Bozhan <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 3845 > Logged by: Bozhan > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3-beta4 > Operating system: WinfowsXP > Description:tray icon