[PHP-DB] PDO and PostgreSQL - RAISE NOTICE

Hi ! I'm new on this mailling list, so i don't realy know if you know the response and if it is realy here that I have to ask my question :-) I'm working with PostgreSQL (8.3 form sources) and PDO (PHP 5.2.10 from sources). In a Postgres function, I have a RAISE NOTICE command. My function works

Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

('SELECT * FROM public.test_info()')-fetch(); More information on the PDO::query method can be found here: http://au.php.net/manual/en/pdo.query.php Cheers Sent from my iPhone On 05/10/2009, at 2:06 AM, Samuel ROZE samuel.r...@aliceadsl.fr wrote: Hi ! I'm new on this mailling list

Re: [PHP-DB] Need help in triggers

What are you really want to do ? This is an exemple: CREATE FUNCTION myfunction () RETURNS trigger AS $$ BEGIN NEW.update_date = 'now'::date; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER set_update_date AFTER INSERT ON matable FOR EACH ROW EXECUTE PROCEDURE myfunction();

Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

me... :-) Thanks Lester ! Samuel. Le lundi 05 octobre 2009 à 08:36 +0100, Lester Caine a écrit : Samuel ROZE wrote: Hi, Thanks for your reply. In fact, my request returns a result which i get with the fetch method. But, it must returns other informations, which are not in the result

[PHP-DB] PDO PgSQL: _pdo_pgsql_notice

Hi ! I'm reading the source of PDO PostgreSQL driver and i see that there's an empty function, _pdo_pgsql_notice, which is very interesting ! I think that it is used when PostgreSQL throw Notices. But, nothing is done... I want to know if somebody know why the content of the function is

Re: [PHP-DB] PDO PgSQL: _pdo_pgsql_notice

! Samuel. (French) Le lundi 05 octobre 2009 à 20:58 +0200, Samuel ROZE a écrit : Hi ! I'm reading the source of PDO PostgreSQL driver and i see that there's an empty function, _pdo_pgsql_notice, which is very interesting ! I think that it is used when PostgreSQL throw Notices. But, nothing is done

Re: [PHP-DB] DB interface problem

Why not using PDO ? It is a global and standardized method to access to data. :-) 2009/10/27 Giff Hammar gham...@sv-phoenix.com: I started having trouble with a DBI interface to my PostgreSQL database after I built a new Ubuntu machine. The Postgres version is 8.3 and the DBI was written