Re: [BUGS] BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement

2007-02-19 Thread Arjen van der Meijden
On 20-2-2007 8:07 Tom Lane wrote: It's surely incorrect as a means of getting out of a COPY state. To tell the truth, if their intention is to close the connection unceremoniously, they should just do that, ie PQfinish or just quit the application. So I'd suggest removing that loop. I think i

Re: [BUGS] BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement

2007-02-19 Thread Tom Lane
Arjen van der Meijden <[EMAIL PROTECTED]> writes: > I had a look at that _close_pgsql_link-function and this it the code: > while ((res = PQgetResult(link))) { > PQclear(res); > } > So there is indeed a very clear loop. But I'm not sure whether this code > is incorrect as a ge

Re: [BUGS] BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement

2007-02-19 Thread Arjen van der Meijden
On 20-2-2007 4:42 Tom Lane wrote: "Arjen van der Meijden" <[EMAIL PROTECTED]> writes: I'm not sure whether this is a php-issue or a postgresql-client-api one, but when connecting gdb to that process and doing a 'bt' it displays: #0 0xa7c36d9f in free () from /lib/tls/libc.so.6 #1 0xa7c38c4f in

Re: [BUGS] BUG #2913: Subscript on multidimensional array yields no value

2007-02-19 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I can confirm this is a bug. Added to the TODO list: > > o ARRAY[[1,2],[3,4]])[1] should return the same values as > > ARRAY[[1,2],[3,4]])[1:1]; > > This is not a bug, this is a definitional disagreement, and your T

Re: [BUGS] BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement

2007-02-19 Thread Tom Lane
"Arjen van der Meijden" <[EMAIL PROTECTED]> writes: > I'm not sure whether this is a php-issue or a postgresql-client-api one, but > when connecting gdb to that process and doing a 'bt' it displays: > #0 0xa7c36d9f in free () from /lib/tls/libc.so.6 > #1 0xa7c38c4f in malloc () from /lib/tls/libc

Re: [BUGS] "Julian day" date format is off by 12 hours

2007-02-19 Thread Bruce Momjian
I did some research on this, and because Oracle fails with that query, we can't use them as a guide. What is happening in the code is that the "J" is independent from the "" and "MS", so you are getting a "J" based on the date (assuming midnight start/stop), and not on the actual time in the

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

2007-02-19 Thread Bruce Momjian
I have not seen an updated patch for FAQ_Solaris yet. --- Zdenek Kotala wrote: > Rich Teer wrote: > > The following bug has been logged online: > > > > Bug reference: 2969 > > Logged by: Rich Teer > > Email ad

Re: [BUGS] BUG #2973: Compile Error with MIPSpro compiler

2007-02-19 Thread Bruce Momjian
I see no one replied to this report. All I can say that many people compile ecpg, and this is the first report we have seen of this problem. I see "CDECIMALTYPE" defined in sqltypes.h. --- Thomas wrote: > > The following

[BUGS] BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement

2007-02-19 Thread Arjen van der Meijden
The following bug has been logged online: Bug reference: 3031 Logged by: Arjen van der Meijden Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: Debian Linux (etch, 2.6.17 kernel) Description:PHP (and others?) cannot close a connection when