Re: PHP, exception and PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux