Skip site navigation (1) Skip section navigation (2)


From: "Kevin McArthur" <postgresql-list(at)stormtide(dot)ca>
To: "Neil Conway" <neilc(at)samurai(dot)com>, "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RESULT_OID Bug
Date: 2005-07-27 07:19:51
Message-ID: 004901c5927b$94ab8ab0$0701a8c0@kdesktop (view raw, whole thread or download thread mbox)
Lists: 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 

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(at)samurai(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>; "Kevin McArthur" 
<postgresql-list(at)stormtide(dot)ca>; <pgsql-hackers(at)postgresql(dot)org>
Sent: Tuesday, July 26, 2005 11:34 PM

> 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

In response to


pgsql-hackers by date

Next:From: Dawid KuroczkoDate: 2005-07-27 08:40:55
Subject: Idea - optimising (left) joins?
Previous:From: Neil ConwayDate: 2005-07-27 06:34:31
Subject: Re: RESULT_OID Bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group