[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] SEGFAULT on SELECT * FROM view
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2011-12-29 23:13:31
Message-ID: 652.1325200411 () sss ! pgh ! pa ! us
[Download RAW message or body]

"chris r." <chricki@gmx.net> writes:
>> Nothing; that looks like a planner bug to me.  Please submit a
>> self-contained test case.

> I ported the entire schema to my test DB server and could not reproduce
> the error there. Note that probably recreating the view solves this
> issue. Given this, how should I proceed to create a test case? Any
> tutorial on this? (I'm not too familiar with all this yet.)

It's possibly statistics-dependent; make sure you have the same stats
targets on both DBs, and try re-analyzing a few times.  Check other
planner parameters are the same, too.

			regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
[prev in list] [next in list] [prev in thread] [next in thread]