Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-05 Thread Thomas Kellerer
Dave Page, 04.10.2011 21:46: We updated our build system to use BitRock 7 today (for unrelated reasons) which has new features for ACL management. We're going to investigate replacing cacls/icacls with those features tomorrow and will create some test builds ASAP. If you can provide the test bu

Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-05 Thread Craig Ringer
Tom Lane wrote: However, the flaw in that explanation is that it would basically mean pg_dump doesn't work at all on Windows, at least not if you have any user-defined functions, and probably some other cases too because there seem to be multiple instances of the dubious coding. It's a bit hard

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-05 Thread Dave Page
On Wednesday, October 5, 2011, Thomas Kellerer wrote: > Dave Page, 04.10.2011 21:46: >> >> We updated our build system to use BitRock 7 today (for unrelated >> reasons) which has new features for ACL management. We're going to >> investigate replacing cacls/icacls with those features tomorrow and

[BUGS] BUG #6240: About - postgreswdinit.sql

2011-10-05 Thread Chethan HB
The following bug has been logged online: Bug reference: 6240 Logged by: Chethan HB Email address: chethanbasava...@gmail.com PostgreSQL version: 9.0.4 Operating system: Linux Description:About - postgreswdinit.sql Details: In a freshly commissioned h/w, when watchd

Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-05 Thread Magnus Hagander
On Wed, Oct 5, 2011 at 09:24, Craig Ringer wrote: > Tom Lane wrote: >> >> However, the flaw in that explanation is that it would basically mean >> pg_dump doesn't work at all on Windows, at least not if you have any >> user-defined functions, and probably some other cases too because there >> seem

[BUGS] About - postgreswdinit.sql

2011-10-05 Thread Basavaraj, Chethan (EXT-Other - IN/Bangalore)
Hi, In a freshly commissioned h/w, when watchdog is created for the first time, I faced some problem. I never faced this problem earlier. Currenlty we are using the following version: export PGODBC_VERSION=psqlodbc-09.00.0300 Postgres version=9.0.4 Logs are attached here: Jan 1 02:05:09.49273

[BUGS] FW: About - postgreswdinit.sql

2011-10-05 Thread Basavaraj, Chethan (EXT-Other - IN/Bangalore)
> Hi, > > In a freshly commissioned h/w, when watchdog is created for the first > time, I faced some problem. > > I never faced this problem earlier. > > Currenlty we are using the following version: > export PGODBC_VERSION=psqlodbc-09.00.0300 > Postgres version=9.0.4 > > Logs are attached her

Re: [BUGS] BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)

2011-10-05 Thread Daniel Cristian Cruz
2011/9/26 Alvaro Herrera > > Please see if bug #6123 applies to this case. > http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg181541.html I guess, yes, it's related, because we had a trigger that deletes a row, while other foreign key constraint is updating the row setting null. But

Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-05 Thread Pavel Holec
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, October 05, 2011 6:07 AM To: Alvaro Herrera Cc: Pavel Holec; 'Craig Ringer'; Pg Bugs Subject: Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C005 Alvaro Herrera writes: > Excerpts from Tom Lane'

Re: [BUGS] BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)

2011-10-05 Thread Alvaro Herrera
Excerpts from Daniel Cristian Cruz's message of miƩ oct 05 10:00:36 -0300 2011: > 2011/9/26 Alvaro Herrera > > > > > Please see if bug #6123 applies to this case. > > http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg181541.html > > > I guess, yes, it's related, because we had a trig

Re: [BUGS] BUG #6240: About - postgreswdinit.sql

2011-10-05 Thread Tom Lane
"Chethan HB" writes: > Jan 1 02:05:10.531239 warn CLA-0 postgres[9919]: [2-1] ERROR: could not > create file "base/16384/11500": File exists [This error is from > postgres > server] > Jan 1 02:05:10.531317 warn CLA-0 postgres[9919]: [2-2] STATEMENT: create > database postgreswd; Th

Re: [BUGS] BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)

2011-10-05 Thread Daniel Cristian Cruz
2011/10/5 Alvaro Herrera > Well, some people say it's a bug, others say it's not; and even if it > is, changing it means backwards incompatible behavior, so *if* it is > patched, it will only change the behavior on a future release, not > whatever you're using. Well, I'll try to explain better,

Re: [BUGS] BUG #6238: ECPG converts "long long" to long on Windows

2011-10-05 Thread Bruce Momjian
Alvaro Herrera wrote: > > Excerpts from Robert Haas's message of mar oct 04 10:39:27 -0300 2011: > > On Tue, Oct 4, 2011 at 8:15 AM, Michael Meskes > > wrote: > > > >> 2010 on Windows, which accepts "long long" to mean the same thing as > > >> __int64, but ECPG doesn't recognize the later. > >

Re: [BUGS] BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)

2011-10-05 Thread Tom Lane
Daniel Cristian Cruz writes: > 2011/10/5 Alvaro Herrera >> Well, some people say it's a bug, others say it's not; and even if it >> is, changing it means backwards incompatible behavior, so *if* it is >> patched, it will only change the behavior on a future release, not >> whatever you're using.

Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-05 Thread Craig Ringer
On 10/05/2011 09:37 PM, Pavel Holec wrote: Yes, this is the problem. libpq.dll I have built in VC6. With original I had problem with msvcr80.dll and WinSxS because my end client app is also from VC6 and I can't prepare redist msvcr for end user. Can you advice me how to do it? It would've been

Re: [BUGS] BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)

2011-10-05 Thread Daniel Cristian Cruz
Thanks, Tom. Now I got it. I didn't tryed to change BEFORE to AFTER, but reminded something I learned coding triggers a long time ago, and I forgot. This could be a fortune: "The rough rule of thumb is that BEFORE triggers are good for adjusting the contents of the row that's about to be stored,