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

Re: Seg fault on "NOT EXISTS"?

From: David Fetter <david(at)fetter(dot)org>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: Seg fault on "NOT EXISTS"?
Date: 2003-01-10 21:24:56
Message-ID: 20030110212456.GC1587@fetter.org (view raw or flat)
Thread:
Lists: sfpug
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
-- 
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100    cell: +1 415 235 3778

In response to

Responses

sfpug by date

Next:From: Laurette CisnerosDate: 2003-01-10 21:30:10
Subject: Re: Seg fault on "NOT EXISTS"?
Previous:From: eleinDate: 2003-01-10 21:20:22
Subject: Re: Seg fault on "NOT EXISTS"?

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