Re: [BUGS] BUG #6510: A simple prompt is displayed using wrong charset

2012-03-18 Thread Alexander LAW
I see two ways to resolve the issue. First is to use CharToOemBuff when writing a string to the "con" and OemToCharBuff when reading an input from it. The other is to always use stderr/stdin for Win32 as it was done for msys before. I think it's more straightforward. I tested the attached patch

[BUGS] Fw: Bug in postgresql 8.1

2012-03-18 Thread prem tolani
Below error occurs only when i restart postgre 8.1 service when applicaion is running. Otherwise it works fine, but while application is running and i restart postgre 8.1 service. Application crashes. Please refer to below email. Regards, Prem --- On Sun, 18/3/12, prem tolani wrote: > From: p

[BUGS] Bug in postgresql 8.1

2012-03-18 Thread prem tolani
Please refer to below mail and help, i need urgent help. Thanks in advance. Regards, Prem > I get below error message> > > > PG "FATAL:� could not reattach to shared memory > > (key=5432001, addr=0210): Invalid > > > argument. > > > > This messages occurs in windows 7 eventviewer log.

Re: [BUGS] Fw: Bug in postgresql 8.1

2012-03-18 Thread Jaime Casanova
On Sun, Mar 18, 2012 at 12:13 AM, prem tolani wrote: > Below error occurs only when i restart postgre 8.1 service when applicaion is > running. Otherwise it works fine, but while > application is running and i restart postgre 8.1 service. Application > crashes. Please refer to below email. > po

Re: [BUGS] Bug in postgresql 8.1

2012-03-18 Thread Dave Page
On Sunday, March 18, 2012, Jaime Casanova wrote: > On Sun, Mar 18, 2012 at 12:13 AM, prem tolani wrote: >> Below error occurs only when i restart postgre 8.1 service when applicaion is running. Otherwise it works fine, but while >> application is running and i restart postgre 8.1 service. Applica

Re: [BUGS] Bug in postgresql 8.1

2012-03-18 Thread Jaime Casanova
On Sun, Mar 18, 2012 at 8:11 AM, Dave Page wrote: > > > On Sunday, March 18, 2012, Jaime Casanova wrote: >> On Sun, Mar 18, 2012 at 12:13 AM, prem tolani >> wrote: >>> Below error occurs only when i restart postgre 8.1 service when >>> applicaion is running. Otherwise it works fine, but while >>

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Aren Cambre
Thanks. While creating that very file, I discovered that 1 row had blanks in every field despite a column having a *NOT NULL* constraint and another column being a* *serial. Removing that column appears to fixed the problem. Something about that column made Postgres unhappy, though. If I ran these

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Kevin Grittner
Aren Cambre wrote: > SELECT COUNT(*) > FROM consistent.master > WHERE citation_id IS NOT NULL > UNION > SELECT COUNT(*) > FROM consistent.master > UNION > SELECT COUNT(*) > FROM consistent.master > WHERE citation_id IS NULL > > I got this result: > > 2085344 > 2085343 > 0 > > Not clear how ad

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Aren Cambre
Kevin, You're absolutely correct; there's no telling what order the planner will use. I did in fact run the queries separately and got the same result that I intimated in the UNIONed queries. I can no longer reproduce, however, because I have since altered the table. So if there is a bug, I may n

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Kevin Grittner
"Kevin Grittner" wrote: > Aren Cambre wrote: > >> SELECT COUNT(*) >> FROM consistent.master >> WHERE citation_id IS NOT NULL >> UNION >> SELECT COUNT(*) >> FROM consistent.master >> UNION >> SELECT COUNT(*) >> FROM consistent.master >> WHERE citation_id IS NULL >> >> I got this result: >> >> 2

[BUGS] Applicatin crashing with on postgresql 8.1 service restart

2012-03-18 Thread prem tolani
I running an applicatio in java with postgresql 8.1. When I restart the postgre service the application crashes while it it running. I get this error in windows evenviewer. I am using windows 7. PG "FATAL: could not reattach to shared memory (key=5432001, addr=0210): Invalid argument. Plea

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Aren Cambre
Kevin, Thanks. That was a direct copy/paste. It happened that the *UNION*ed queries spat out those results in the same order that the queries appeared. Just want to again emphasize that my database state has changed, so I am not sure this is remains a good case for finding a bug. Aren On Sun, M

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Tom Lane
Aren Cambre writes: > Just want to again emphasize that my database state has changed, so I am > not sure this is remains a good case for finding a bug. Your description of an apparently-all-nulls row sounds a great deal like data corruption. I suspect there may be more wrong than just the one r

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Aren Cambre
Thanks. I am running this on 1 year old hardware on a wholly-encrypted C drive, encrypted with TrueCrypt. I suspect that I would have been alerted already with that or SMART if I had hardware issues? I am on 9.1.3, although I think the data was inserted back when I was running 9.0.x. I upgraded to