New PHP/PostgreSQL functions

Hey guys,

Check this out:

http://www.php.net/manual/en/ref.pgsql.php

Note all v3 protocol functions are in for PHP 5.1, like

. pg_transaction_status() - in-transaction status of a database
connection.
. pg_query_params() - execution of parameterized queries.
. pg_prepare() - prepare named queries.
. pg_execute() - execution of named prepared queries.
. pg_send_query_params() - async equivalent of pg_query_params().
. pg_send_prepare() - async equivalent of pg_prepare().
. pg_send_execute() - async equivalent of pg_execute().
. pg_result_error_field() - highly detailed error information,
most importantly the SQLSTATE error code.
. pg_set_error_verbosity() - set verbosity of errors.

Cheers,

Chris

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: New PHP/PostgreSQL functions

That is great for us users of PostgreSQL... but when is 5.1 release date?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Re: New PHP/PostgreSQL functions

> That is great for us users of PostgreSQL... but when is 5.1 release date?

No idea whatsoever :)

Chris

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: New PHP/PostgreSQL functions

El S=E1b 26 Mar 2005 15:11, Christopher Kings-Lynne escribi=F3:
> Hey guys,
>=20
> Check this out:
>=20
> http://www.php.net/manual/en/ref.pgsql.php
>=20
> Note all v3 protocol functions are in for PHP 5.1, like

What about PHP 4.x? Will there be any backporting?

--=20
09:08:52 up 9 days, 13:39, 1 user, load average: 0.72, 0.55, 0.82
------------------------------------------------------------ -----
Mart=EDn Marqu=E9s | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
------------------------------------------------------------ -----

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: New PHP/PostgreSQL functions

>>Hey guys,
>>
>>Check this out:
>>
>>http://www.php.net/manual/en/ref.pgsql.php
>>
>>Note all v3 protocol functions are in for PHP 5.1, like
>
>
> What about PHP 4.x? Will there be any backporting?

No...

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: New PHP/PostgreSQL functions

On Saturday 26 March 2005 13:11, Christopher Kings-Lynne wrote:
> Hey guys,
>
> Check this out:
>
> http://www.php.net/manual/en/ref.pgsql.php
>
> Note all v3 protocol functions are in for PHP 5.1, like
>
> . pg_transaction_status() - in-transaction status of a database
> connection.
> . pg_query_params() - execution of parameterized queries.
> . pg_prepare() - prepare named queries.
> . pg_execute() - execution of named prepared queries.
> . pg_send_query_params() - async equivalent of pg_query_params().
> . pg_send_prepare() - async equivalent of pg_prepare().
> . pg_send_execute() - async equivalent of pg_execute().
> . pg_result_error_field() - highly detailed error information,
> most importantly the SQLSTATE error code.
> . pg_set_error_verbosity() - set verbosity of errors.
>

Thanks much for your work on this Chris. One thing I was wondering is if you
changed any of the existing functions due to differences in the v3 protocol?

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: New PHP/PostgreSQL functions

> Thanks much for your work on this Chris. One thing I was wondering is if you
> changed any of the existing functions due to differences in the v3 protocol?

So far I've changed pg_copy_to and pg_copy_from to use the new v3
functions if they exist. I've still got lots more to do though. I'm
working on pdo_pgsql atm.

Chris

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings