Re: Seg fault on "NOT EXISTS"?

If segfault created a core file you could do run gdb on it and get a
stack trace. (I've done this before when something's crashed and I was
scratching my head and one of the developers was able to stear me toward
some more testing that eventually revealed the problem).

On Fri, 10 Jan 2003, David Fetter wrote:

> On Fri, Jan 10, 2003 at 01:20:22PM -0800, elein wrote:
>
> > Show us the query.
>
> OK, now I'm totally befuddled. The query that came with the segfault
> now works.
>
> It's
>
> SELECT *
> FROM reviews
> WHERE NOT EXISTS (
> SELECT authorid
> FROM authors
> WHERE reviews.authorid = authorid
> );
>
> This was a raw import from a "schema" that had no (mumble grumble
> grump) no foreign key constraints. Authors has a primary key of
> authorid.
>
> What else could cause psql to segfault?
>
> Cheers,
> D
>

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
Life is an SQL old chum...