Re: [BUGS] BUG #2631: database locking problem

2006-09-16 Thread Tom Lane
"Ross Elliott" <[EMAIL PROTECTED]> writes: > So, what happened between 8.1.3 and 8.1.4 that may > have affected locking? Nothing that I know of. Please provide a self-contained test case (but are you sure this is not a PostGIS bug?) ... regards, tom lane

[BUGS] BUG #2631: database locking problem

2006-09-16 Thread Ross Elliott
The following bug has been logged online: Bug reference: 2631 Logged by: Ross Elliott Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Red Hat AS 4 Description:database locking problem Details: I have a dataset of aprox 650 million rows

Re: [BUGS] BUG #2629: libpq - Cannot deallocate prepared statement created with PQprepare()

2006-09-16 Thread Tom Lane
"Andy McCurdy" <[EMAIL PROTECTED]> writes: > result = PQprepare(conn, "MyQuery", "select * from pg_stat_activity", 0, > NULL); I believe the above will result in preparing a statement named "MyQuery", ie, no case-folding happens on the second argument of PQprepare, because it never goes through th

Re: [BUGS] BUG #2629: libpq - Cannot deallocate prepared statement created with PQprepare()

2006-09-16 Thread Michael Fuhr
On Fri, Sep 15, 2006 at 07:39:32AM +, Andy McCurdy wrote: > result = PQprepare(conn, "MyQuery", "select * from pg_stat_activity", 0, > NULL); > > /* > THE FOLLOW PQEXEC() FAILS. Error message says: ERROR: prepared statement > "myquery" does not exist" > */ > result = PQexec(conn, "DEALLOCA

Re: [BUGS] BUG #2630: Can't unpack

2006-09-16 Thread Magnus Hagander
> > Bug reference: 2630 > Logged by: Alan Escreet > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: Windows > Description:Can't unpack > Details: > > I am unable to unpack the database from the tar.gz file. I > have tried all the sug

[BUGS] BUG #2630: Can't unpack

2006-09-16 Thread Alan Escreet
The following bug has been logged online: Bug reference: 2630 Logged by: Alan Escreet Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows Description:Can't unpack Details: I am unable to unpack the database from the tar.gz file. I ha

Re: [BUGS] wrong behavior using to_char()

2006-09-16 Thread Jorge Godoy
"Euler Taveira de Oliveira" <[EMAIL PROTECTED]> writes: > In the pt_BR locale, the thousand separator is "". So it should return The thousands separator in pt_BR is ".". > 12345,670. Looking at the source, I saw that the test cases for locale This should be "12.345,670". -- Jorge Godoy

[BUGS] Clarification : Postmaster crash

2006-09-16 Thread Lakshminarayanan Radhakrishan
Hi, Postmaster is crashing in my system and following trace is recorded in the log file. Can you please check and let me know the root cause of the crash ? LOG: database system was interrupted at 2006-09-13 13:28:51 CEST LOG: record with zero length at 0/B37888 LOG: invalid primary checkpoi

[BUGS] BUG #2629: libpq - Cannot deallocate prepared statement created with PQprepare()

2006-09-16 Thread Andy McCurdy
The following bug has been logged online: Bug reference: 2629 Logged by: Andy McCurdy Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows XP Description:libpq - Cannot deallocate prepared statement created with PQprepare() Details: A

[BUGS] backup + restore fails

2006-09-16 Thread Schoenen, Holger
I have installed the new postgresql-8.1.msi on windows XP. All standard as proposed except: encoding UTF8 and locale Germany/german as a service. (UTF8 seams to be important, the locale not?) Using pgAdmin-III I have connected and created a new database. Optionally I can create a table - same res

[BUGS] BUG #2628: jdbc2

2006-09-16 Thread viniciusasousa
The following bug has been logged online: Bug reference: 2628 Logged by: viniciusasousa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: windows Description:jdbc2 Details: I has problem: org.postgresql.jdbc2.Jdbc2DatabaseMetaData.locatorsU