Re: RESULT_OID Bug - Mailing list pgsql-hackers

From Kevin McArthur
Subject Re: RESULT_OID Bug
Date
Msg-id 004901c5927b$94ab8ab0$0701a8c0@kdesktop
Whole thread Raw
In response to RESULT_OID Bug  ("Kevin McArthur" <postgresql-list@stormtide.ca>)
Responses Re: RESULT_OID Bug  (Michael Fuhr <mike@fuhr.org>)
Re: RESULT_OID Bug  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers
The target system for my reproduction is on FreeBSD.

Though I sitll cannot get the initdb started one to work the first time 
around.

I cannot reproduce the bug on my linux machine, however I cannot test the 
full initdb procedure until tomorrow on freebsd.

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 
reinstalled for a timezone patch and I'm pretty sure it was working then )

I can note that the \set for lastoid is properly updated when I insert into 
a table. Thus the problem has to be somewhere between plpgsql and that data 
via the get diagnostics interface (under the assumption that the lastoid 
structure is consistent for all inserts and psql having lastoid working at 
all eliminates that part of the equation).

Kevin McArthur

----- Original Message ----- 
From: "Neil Conway" <neilc@samurai.com>
To: "Michael Fuhr" <mike@fuhr.org>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>; "Kevin McArthur" 
<postgresql-list@stormtide.ca>; <pgsql-hackers@postgresql.org>
Sent: Tuesday, July 26, 2005 11:34 PM
Subject: Re: [HACKERS] RESULT_OID Bug


> 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
> 



pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: RESULT_OID Bug
Next
From: Dawid Kuroczko
Date:
Subject: Idea - optimising (left) joins?