Re: PDO does not trow Exceptions for queries - Mailing list pgsql-php

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/