Re: [PATCHES] pltcl - "Cache lookup for attribute" error - version

2004-01-23 Thread Jan Wieck
Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: When assigning a tuple to an array, PL/Tcl creates one extra array element .tupno telling the SPI_tuptable index of the result tuple. I think I originally planned to have more of these critters ... but probably never really needed them. It i

[PATCHES] cleanup psql memory handling

2004-01-23 Thread Neil Conway
This patch makes some of the memory manipulation performed by psql a little more sane. Some parts of the code was using a static function xmalloc() that did safe memory allocation (where "safe" means "bail out on OOM"), but most of it was just invoking calloc() or malloc() directly. So I moved xmal

Re: [PATCHES] pltcl - "Cache lookup for attribute" error - version 2

2004-01-23 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > When assigning a tuple to an array, PL/Tcl creates one extra array > element .tupno telling the SPI_tuptable index of the result tuple. I > think I originally planned to have more of these critters ... but > probably never really needed them. It is in ther

[PATCHES] pltcl - "Cache lookup for attribute" error

2004-01-23 Thread Patrick Samson
I got the error message: ERROR: pltcl: Cache lookup for attribute 'pg.droppped.7' type 0 failed when a pltcl trigger handler is fired. Attribute names beginning with a dot are filtered just in one place, in pltcl_trigger_handler(). Attached is a patch to add the same filter in tw

[PATCHES] Calling a java program thru a trigger or a function in postgresql

2004-01-23 Thread venky
Here's a high-level overview of what I want to do: 1. A record in a postgresql database is changed. 2. If the change causes the data record to meet certain conditions based on Boolean logic, a database trigger will invoke a Java UDF. 3. This Java UDF uses the JavaMail API to send an e-

Re: [PATCHES] pltcl - "Cache lookup for attribute" error - version

2004-01-23 Thread Jan Wieck
Tom Lane wrote: Patrick Samson <[EMAIL PROTECTED]> writes: Attribute names beginning with a dot are filtered just in one place, in pltcl_trigger_handler(). (version 7.3.5) I am not sure why that code is there. It is *not* there to prevent the loop from touching dropped attributes, because the sam

Re: [PATCHES] pltcl - "Cache lookup for attribute" error - version 2

2004-01-23 Thread Tom Lane
Patrick Samson <[EMAIL PROTECTED]> writes: > Attribute names beginning with a dot are filtered > just in one place, in pltcl_trigger_handler(). > (version 7.3.5) I am not sure why that code is there. It is *not* there to prevent the loop from touching dropped attributes, because the same code is

[PATCHES] pltcl - "Cache lookup for attribute" error - version 2

2004-01-23 Thread Patrick Samson
After a deeper analysis, this post supersedes my previous one with the same subject. I got the error message: ERROR: pltcl: Cache lookup for attribute 'pg.droppped.7' type 0 failed when a pltcl trigger handler is fired. Attribute names beginning with a dot are filtered just in o