Re: PL/pgSQL function not working in (more info)

2005-05-07 Thread Wolf
onfused now. I'm going through the SqlMaps code to take a peek at what might be happening, but can you point me at a good spot to look? Thanks, Wolf ps - I know the function 'silly' doesn't look very useful, but it is a stripped down version of a more complicated a function.

Re: PL/pgSQL function not working in (more info)

2005-05-07 Thread Wolf
ver on both occasions. I did try select('foo') from dual but I got ERROR: relation "dual" does not exist. I think DUAL is an oracle only psuedo-table. -Wolf On May 7, 2005, at 7:39 PM, Clinton Begin wrote: Try select silly(text) from dual. Cheers, Clinton

PL/pgSQL function not working in

2005-05-05 Thread Wolf
function that causes a row to be inserted into a table. I am able to call it from within psql and have it work as expected. In SqlMaps, it returns the expected result, but does not perform the INSERT. I am using postgres 8.0 in the driver jar and the server. Thanks in advance, Eric Wolf