Date: Fri, 8 Jul 2005 09:23:39 -0600
From: Michael Fuhr <mike@fuhr.org>
To: Tim Jackson <tim.jackson@ints.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: C set return function differences on 8.0?
Message-ID: <20050708152339.GA81341@winnie.fuhr.org>
References: <42CDCFB4.2030908@ints.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42CDCFB4.2030908@ints.com>

On Thu, Jul 07, 2005 at 05:58:28PM -0700, Tim Jackson wrote:
> 
> I re-compiled the .so using 8.0 server development source and rebuilt 
> the views on 8.0 and now only some views will pull up data. These are 
> views using the same data that worked under 7.4 and now just abort.  

What do you mean by "abort" -- does the backend crash?  If so, and
if you get a core dump, then it might be useful to see a stack trace.

Could you post a simple, self-contained test case that works in 7.4
and fails in 8.0?  That is, all SQL, C code, and data that somebody
could use to reproduce the problem from an empty database.  Please
do distill the example so it's as simple as possible -- that way
the analysis won't be distracted by irrelevant factors.

Exactly which versions of 7.4 and 8.0 are you running, and on what
platform?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/