Re: [BUGS] backend crash with certain statements/tables

2004-03-02 Thread Jeff Bohmer
Jeff Bohmer <[EMAIL PROTECTED]> writes: Great! I'd like to try out the patch when it's ready. Here ya go. Works for me on OS X and Linux. Thank you very much! - Jeff -- Jeff Bohmer VisionLink, Inc. _ 303.402.0170 www.visionlink.org _

Re: [BUGS] backend crash with certain statements/tables

2004-03-02 Thread Tom Lane
Jeff Bohmer <[EMAIL PROTECTED]> writes: > Great! I'd like to try out the patch when it's ready. Here ya go. regards, tom lane Index: src/backend/executor/execAmi.c === RCS file: /cvsroot/pgsql-server/src/bac

Re: [BUGS] backend crash with certain statements/tables

2004-03-02 Thread Jeff Bohmer
I should have a patch later today. Great! I'd like to try out the patch when it's ready. Thanks, - Jeff -- Jeff Bohmer VisionLink, Inc. _ 303.402.0170 www.visionlink.org _ People. Tools. Change. Community. ---

Re: [BUGS] backend crash with certain statements/tables

2004-03-02 Thread Tom Lane
Jeff Bohmer <[EMAIL PROTECTED]> writes: > Running any of these statements on my database causes the backend to > crash (example from PG log below): Crash confirmed here. Seems to be a side-effect of the 7.4 optimization that tries to avoid "unnecessary" projection steps. In the "SELECT * FROM f

[BUGS] backend crash with certain statements/tables

2004-03-02 Thread Jeff Bohmer
Reproduced in PG 7.4.1 on ... OS X Server 10.2.8 OS X 10.2.8 RHL 9 (2.4.20-30.9) Running any of these statements on my database causes the backend to crash (example from PG log below): create temp table foo as select * from server_prefs limit 1; create table foo as select * from server_prefs lim