Re: PDO does not trow Exceptions for queries

Andreas Kalsch wrote:
> $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');

prepare returns a 'pdostatement' which you then have to execute:

$S->execute();

This should generate an exception.

-- 
Postgresql & php tutorials
http://www.designmagick.com/


-- 
Sent via pgsql-php mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php