pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sam Sutch <samuraiblog@gmail.com>
To: paulf@quillandmouse.com
Cc: pgsql-php@postgresql.org
Subject: Re: Chatter elimination
Date: Wed, 29 Mar 2006 21:25:01 -0700
Message-ID: <219837f70603292025n1d7781abi3934ece7f8cf7cb5@mail.gmail.com> (raw)
In-Reply-To: <442B59F9.7030505@quillandmouse.com>
References: <442B59F9.7030505@quillandmouse.com>

Suppress the errors of the expression using the @ error suppression operator.

For example:

@pg_connect(/*your details*/);

Will suppress the errors for that expression. You can use it like this too

$connection = @pg_connect(/*your details*/);

You can also use this at the top of your script:

error_reporting(0); // see php.net/error_reporting

-Sam (shit, sorry, forgot to reply to all)

On 3/29/06, Paul M Foster <paulf@quillandmouse.com> wrote:
> I have a php file called "coldstart.php" which is supposed to check if a
>   database exists, and if not create it, and create the tables
> associated with it. It attempts a pg_connect() with the database name
> and other parameters. The first time it's run, this call returns false,
> because the database doesn't exist. At that point, I connect to the
> template1 database and create my target database, etc. After this, I
> redirect to a different PHP script, using the header() directive.
>
> This process works fine, insofar as it creates the database and tables.
> However, when the first pg_connect() is called with the name of the
> non-existent database, PostgreSQL/PHP dumps the following error message:
>
> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL:
> database "webcust" does not exist in /var/www/qmsi/webcust/db.php on line 39
>
> Well and good. Except that when the script gets down to the header()
> call (after creating the database and tables), it has a problem, because
> headers have already been sent, in the form of the aforementioned error
> message. So it barfs right there.
>
> So the question is: Is it possible to shut off this "chatter" that
> PostgreSQL/PHP puts out when an error such as this occurs?
>
> --
> Paul M. Foster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>



view thread (2+ messages)

Message-ID: <219837f70603292025n1d7781abi3934ece7f8cf7cb5@mail.gmail.com>
Permalink:  ../219837f70603292025n1d7781abi3934ece7f8cf7cb5@mail.gmail.com/
Also on:    postgresql.org/message-id/219837f70603292025n1d7781abi3934ece7f8cf7cb5@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: samuraiblog@gmail.com, paulf@quillandmouse.com
  Subject: Re: Chatter elimination
  In-Reply-To: <219837f70603292025n1d7781abi3934ece7f8cf7cb5@mail.gmail.com>
  References: <442B59F9.7030505@quillandmouse.com> <219837f70603292025n1d7781abi3934ece7f8cf7cb5@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox