Re: [GENERAL] CTTAS w/ DISTINCT ON crashes backend

2004-01-21 Thread Tom Lane
Mike Mascari <[EMAIL PROTECTED]> writes: > Could you give me a bit of direction? > [ same query works in one DB and crashes in another ] I have a feeling this is a problem with an incorrect plan --- possibly the same thing I just fixed a few days ago, http://archives.postgresql.org/pgsql-committe

Re: [GENERAL] CTTAS w/ DISTINCT ON crashes backend

2004-01-21 Thread Mike Mascari
Tom Lane wrote: In a nutshell: CREATE TEMPORARY TABLE foo AS SELECT DISTINCT ON (x, y, z) * FROM bar; crashes the backend and screws up data pages associated with the catalog under 7.4.1. Works for me ... ... Perhaps providing a specific test case would help. Could you give me a bit o