Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-04-27 Thread Tom Lane
DNS <[EMAIL PROTECTED]> writes: > 3- In pgsql log, I have this message: > 2007-04-27 14:15:05 EDT user database WARNING: 25P01: there is no > transaction in progress This is just a warning, which most likely is there only because somebody typed COMMIT or ABORT unnecessarily. What problem are yo

Re: [BUGS] BUG #3244: problem with PREPARE

2007-04-27 Thread Tom Lane
"William Lawrance" <[EMAIL PROTECTED]> writes: > This program that does "PQprepare" and then > "PQexecPrepared" has worked previously, but doesn't > work now. The error message is" >ERROR: bind message supplies 1 parameters, but > prepared statement "stmtopen" requires 0 I've ap

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-04-27 Thread DNS
I forget to add, it's PGSQL version 8.1 . Thank you! ---(end of broadcast)--- TIP 6: explain analyze is your friend

[BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-04-27 Thread DNS
Hello, I have the following Warning with Postgresql, can anybody helps: 1- My server is crashing suddenbly 2- I do a cold reboot 3- In pgsql log, I have this message: 2007-04-27 14:15:05 EDT user database WARNING: 25P01: there is no transaction in progress 2007-04-27 14:15:05 EDT user database

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-27 Thread Heikki Linnakangas
Tom Lane wrote: I'm still not very sure why you're hitting the problem more often than other people. There might be some tweak you could make in your application code to dodge the issue. The initial size of the local lock hash table is 128. That's a lot of locks, most applications probably do

Re: [BUGS] BUG #3256: msi installer failed to upgrade to newer version

2007-04-27 Thread Magnus Hagander
On Fri, Apr 27, 2007 at 07:51:46AM +, Hao Zhang wrote: > > The following bug has been logged online: > > Bug reference: 3256 > Logged by: Hao Zhang > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.4 > Operating system: Windows XP SP2 > Description:msi

[BUGS] BUG #3256: msi installer failed to upgrade to newer version

2007-04-27 Thread Hao Zhang
The following bug has been logged online: Bug reference: 3256 Logged by: Hao Zhang Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows XP SP2 Description:msi installer failed to upgrade to newer version Details: When using the win32

[BUGS] BUG #3255: Proper escaping missing

2007-04-27 Thread Bernd Fuhrmann
The following bug has been logged online: Bug reference: 3255 Logged by: Bernd Fuhrmann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows XP SP2 Description:Proper escaping missing Details: I just tried to use pgAdmin to create a d

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-27 Thread Tom Lane
"Dorochevsky,Michel" <[EMAIL PROTECTED]> writes: > Are you planning to provide a binary fix for 8.2.x? I personally am not --- IIRC you are running on Windows, which I don't even have a build environment for. But you could pull REL8_2_STABLE branch tip from the CVS server and build it for yoursel

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-27 Thread Dorochevsky,Michel
> Tom Lane wrote > I've committed a fix for this; it'll be in the next set of releases. > > regards, tom lane Tom, Thanks a lot for all your work and help, I am very impressed by the PostgreSQL Team. Just a last question. Are you planning to provide a binary fix for 8.2.x?