Re: [BUGS] "ERROR: Query-specified return tuple and actual function

2003-01-13 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Without this change, any table that has had a column dropped would not > be able to be used as a function's return type at all. Yup, that was the idea ;-) > start with table test, attributes (a,b,c) > drop attribute b from test > tupledesc_mismatch checks

Re: [BUGS] "ERROR: Query-specified return tuple and actual function

2003-01-13 Thread Joe Conway
Tom Lane wrote: > Joe Conway <[EMAIL PROTECTED]> writes: >> Hmmm, looks like nodeFunctionscan.c:tupledesc_mismatch needs to be >> taught about attisdropped. I'll submit a patch this evening if no >> one else gets to it first. > > Actually, I believe I deliberately left it like that because I was >

Re: [BUGS] "ERROR: Query-specified return tuple and actual function

2003-01-13 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Andrzej Kosmala wrote: >> PostgreSQL 7.3 on Linux >> After dropping column functions return error message: "ERROR: >> Query-specified return tuple and actual function return tuple do not match" > Hmmm, looks like nodeFunctionscan.c:tupledesc_mismatch needs

Re: [BUGS] Bug #871: FW: How to solve the problem

2003-01-13 Thread Josh Berkus
Derek, > Long Description > NOTICE: Message from PostgreSQL backend: > The Postmaster has informed me that some other backend > died abnormally and possibly corrupted shared memory. > I have rolled back the current transaction and am > going to terminate your data

[BUGS] Bug #873: 7.3.1 install fails for RH7.3... cannot find ascii_and_mic.so

2003-01-13 Thread pgsql-bugs
Jeffrey Graham ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description 7.3.1 install fails for RH7.3... cannot find ascii_and_mic.so Long Description On a RH 7.3 machine using gcc 3.1, everything builds fine (set --prefix to a nonstanda

Re: [BUGS] "ERROR: Query-specified return tuple and actual function

2003-01-13 Thread Joe Conway
Andrzej Kosmala wrote: PostgreSQL 7.3 on Linux After dropping column functions return error message: "ERROR: Query-specified return tuple and actual function return tuple do not match" Hmmm, looks like nodeFunctionscan.c:tupledesc_mismatch needs to be taught about attisdropped. I'll submit a pa

[BUGS] "ERROR: Query-specified return tuple and actual function return tuple do not match" after dropping column

2003-01-13 Thread Andrzej Kosmala
PostgreSQL 7.3 on Linux After dropping column functions return error message: "ERROR: Query-specified return tuple and actual function return tuple do not match" template1=# create table test(id integer, cdate timestamp); CREATE TABLE template1=# INSERT INTO test VALUES (1,now()); INSERT 17515 1 t