Re: PostgreSQL, exception and PHP

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Konference <konference(at)menea(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL, exception and PHP
Date: 2005-02-07 17:23:48
Message-ID: 20050207172348.GA34535@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 07, 2005 at 03:10:58PM +0100, Konference wrote:
>
> is here somebody who works with PostgreSQL in PHP? 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.

What does your PHP code look like? Are you using functions like
pg_last_error() or pg_result_error() to get the exception message?
You might have to strip off a leading "ERROR: " but that's easy.

If that doesn't answer your question, then please show what you're
doing, exactly what results you're getting, and exactly what results
you'd like to get.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message CG 2005-02-07 17:28:24 Creating an index-type for LIKE '%value%'
Previous Message Clodoaldo Pinto 2005-02-07 17:07:13 Out of memory error