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