Skip site navigation (1) Skip section navigation (2)

PDO does not trow Exceptions for queries

From: Andreas Kalsch <andreaskalsch(at)gmx(dot)de>
To: pgsql-php(at)postgresql(dot)org
Subject: PDO does not trow Exceptions for queries
Date: 2009-08-03 18:37:35
Message-ID: 4A772E6F.1000108@gmx.de (view raw or flat)
Thread:
Lists: pgsql-php
$C->DB is my connection, but no exceptions will be thrown for the last 
queries - althogh there is an error (whoch the command line would show).
Is there another option to activate throwing of exceptions?


$C->DB->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$C->DB->query('DROP TABLE key');

$C->DB->query('CREATE TABLE key ( id SERIAL NOT NULL PRIMARY KEY, k TEXT 
NOT NULL UNIQUE )');

$S = $C->DB->prepare('INSERT INTO key (k)
SELECT lower(k) FROM current_node_tags LIMIT 100');


What my phpinfo() says:

PHP Version 5.2.6-1+lenny3

This server is protected with the Suhosin Patch 0.9.6.2

PDO
PDO support    enabled
PDO drivers     pgsql

pdo_pgsql
PDO Driver for PostgreSQL    enabled
PostgreSQL(libpq) Version     8.3.7
Module version     1.0.2
Revision     $Id: pdo_pgsql.c,v 1.7.2.11 2006/03/14 10:49:18 edink Exp $

pgsql
PostgreSQL Support    enabled
PostgreSQL(libpq) Version     8.3.7
Multibyte character support     enabled
SSL support     enabled
Active Persistent Links     0
Active Links     0
pgsql.allow_persistent    On    On
pgsql.auto_reset_persistent    Off    Off
pgsql.ignore_notice    Off    Off
pgsql.log_notice    Off    Off
pgsql.max_links    Unlimited    Unlimited
pgsql.max_persistent    Unlimited    Unlimited

Responses

pgsql-php by date

Next:From: Carol WalterDate: 2009-08-03 19:50:03
Subject: pg_query_params version?
Previous:From: Carol WalterDate: 2009-07-22 22:09:10
Subject: Re: pg_query_params

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group