|
|
Posted by Richard Lynch on 02/07/05 20:13
Konference wrote:
> is here somebody who works with PostgreSQL in PHP?
Yes. :-)
> I have a PL/SQL
> function, which can raise an exception. I am not able to catch _only_
> exception error message in PHP. I can parse "Warning: pg_query():
> Query failed: ERROR: Exception error string. in..." but I think, it is
> not "clear" solution. Thank you for your reply.
Open up an SSH shell and use the PostgreSQL monitor program:
psql -U __YOUR_USERNAME__ __YOUR_DB_NAME__
You'll be prompted for the password.
Then you can do:
\df+ __FUNCTION_NAME__
to see the full definition of your function.
Post that here, and maybe somebody can tell you what is wrong with it.
Another possibility, while you're in psql, is to go ahead and try to call
the function with some sample data.
--
Like Music?
http://l-i-e.com/artists.htm
Navigation:
[Reply to this message]
|