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

Re: Seg fault on "NOT EXISTS"?

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: Seg fault on "NOT EXISTS"?
Date: 2003-01-10 21:30:10
Message-ID: Pine.LNX.4.44.0301101327400.19017-100000@visor.corp.nextbus.com (view raw or flat)
Thread:
Lists: sfpug
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...


In response to

Responses

sfpug by date

Next:From: David FetterDate: 2003-01-10 21:32:52
Subject: Re: Seg fault on "NOT EXISTS"?
Previous:From: David FetterDate: 2003-01-10 21:24:56
Subject: Re: Seg fault on "NOT EXISTS"?

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