It is the only one that currently appears to _for this bug_.
Kevin
- Original Message -
From: "Andrew Dunstan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, July 27, 2005 11:57 AM
Subject: Re: [HACKERS] RESULT_OID Bug
Andrew - Supernews
uot;Andrew Dunstan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
Sent: Wednesday, July 27, 2005 3:35 PM
Subject: Re: [HACKERS] RESULT_OID Bug
On Wed, Jul 27, 2005 at 01:20:29PM -0700, Kevin McArthur wrote:
Changing just the one appears to resolve the oid bug. Should probably
t
On Wed, Jul 27, 2005 at 01:20:29PM -0700, Kevin McArthur wrote:
> Changing just the one appears to resolve the oid bug. Should probably talk
> to neilc to see why he changed it.
Initializing isnull to false in exec_stmt_getdiag() appears to fix
the bug on my Solaris 9 box as well. I'd guess the
lt;[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, July 27, 2005 11:57 AM
Subject: Re: [HACKERS] RESULT_OID Bug
Andrew - Supernews wrote:
On 2005-07-27, Michael Fuhr <[EMAIL PROTECTED]> wrote:
So far the problem does seem to be specific to whatever PL/pgSQL's
is doing, and it affect
Andrew - Supernews wrote:
On 2005-07-27, Michael Fuhr <[EMAIL PROTECTED]> wrote:
So far the problem does seem to be specific to whatever PL/pgSQL's
is doing, and it affects ROW_COUNT as well as RESULT_OID. I haven't
been able to reproduce the problem with PL/Tcl or with C and SPI.
On 2005-07-27, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> So far the problem does seem to be specific to whatever PL/pgSQL's
> is doing, and it affects ROW_COUNT as well as RESULT_OID. I haven't
> been able to reproduce the problem with PL/Tcl or with C and SPI.
src/pl/plpgsql/src/pl_exec.c, funct
>
To: "Kevin McArthur" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 26, 2005 4:19 PM
Subject: Re: [HACKERS] RESULT_OID Bug
On Tue, Jul 26, 2005 at 03:36:26PM -0700, Kevin McArthur wrote:
Recent cvs versions are failing the following script;
create table oidtest(a time defa
On Wed, Jul 27, 2005 at 12:19:51AM -0700, Kevin McArthur wrote:
> This error has come up in the last week or so, and my suspicion remains
> that its caused by something to do with roles but that could be way wrong.
>
> The FreeBSD machines were confirmed to work as of about a week ago ( i
> rein
On Wed, Jul 27, 2005 at 12:19:51AM -0700, Kevin McArthur wrote:
> The target system for my reproduction is on FreeBSD.
What version of FreeBSD? What compiler and version? So far I
haven't been able to reproduce the problem on FreeBSD 4.11-STABLE/
i386/gcc 2.95.4.
> Though I sitll cannot get the
f the equation).
Kevin McArthur
- Original Message -
From: "Neil Conway" <[EMAIL PROTECTED]>
To: "Michael Fuhr" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>; "Kevin McArthur"
<[EMAIL PROTECTED]>;
Sent:
Michael Fuhr wrote:
Can anybody else reproduce the problem?
I couldn't repro it, on x86 / Debian unstable / gcc 3.4.4, with current
CVS sources.
-Neil
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Wed, Jul 27, 2005 at 12:56:15AM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > Could this be platform-specific?
>
> Seems that way. I tried it on HPUX 10.20/HPPA/gcc 2.95.3.
No luck on FreeBSD 4.11-STABLE/i386/gcc 2.95.4. The box that does
have a problem is Solaris 9/s
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Wed, Jul 27, 2005 at 12:08:18AM -0400, Tom Lane wrote:
>> I tried to reproduce the problem ... no joy ...
> Hmmm...not even with the example that starts from initdb?
Nope...
> Could this be platform-specific?
Seems that way. I tried it on HPUX 10.2
On Wed, Jul 27, 2005 at 12:08:18AM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > Is anybody with a deeper understanding of the code looking at this?
>
> I tried to reproduce the problem ... no joy ...
Hmmm...not even with the example that starts from initdb? I'm up
to dat
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Is anybody with a deeper understanding of the code looking at this?
I tried to reproduce the problem ... no joy ...
regards, tom lane
---(end of broadcast)---
TIP 6: explain analyze
On Tue, Jul 26, 2005 at 04:31:21PM -0700, Kevin McArthur wrote:
> I cannot repoduce your experience with this bug. No matter what I do,
> reconnect session or otherwise, it never returns a proper oid on the
> newer cvs vers (I suspect it may be related to the roles update)
I'm seeing varying resu
FUNCTION
test3=#
test3=# SELECT oidtest();
oidtest
-
(1 row)
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Kevin McArthur" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 26, 2005 4:58 PM
Subject: Re: [HACKERS] RESULT_OID Bug
On
On Tue, Jul 26, 2005 at 04:31:21PM -0700, Kevin McArthur wrote:
> I cannot repoduce your experience with this bug. No matter what I do,
> reconnect session or otherwise, it never returns a proper oid on the newer
> cvs vers (I suspect it may be related to the roles update)
Hmmm...my system is on
>
To: "Kevin McArthur" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 26, 2005 4:19 PM
Subject: Re: [HACKERS] RESULT_OID Bug
On Tue, Jul 26, 2005 at 03:36:26PM -0700, Kevin McArthur wrote:
Recent cvs versions are failing the following script;
create table oidtest(a time defa
On Tue, Jul 26, 2005 at 03:36:26PM -0700, Kevin McArthur wrote:
> Recent cvs versions are failing the following script;
>
> create table oidtest(a time default now()) with oids;
>
> CREATE OR REPLACE FUNCTION oidtest() RETURNS integer AS $oidtest$
> DECLARE
> insert_oid_var INTEGER;
> BEGIN
>
Recent cvs versions are failing the following
script;
create table oidtest(a time default now()) with
oids;
CREATE OR REPLACE FUNCTION oidtest() RETURNS integer
AS $oidtest$ DECLARE insert_oid_var
INTEGER; BEGIN INSERT INTO oidtest DEFAULT
VALUES; GET DIAGNOSTICS insert_oid_var =
RE
21 matches
Mail list logo
