How to use and hints
Warning
Using the PostgreSQL module with PHP 4.0.6 is not recommended
due to a bug in the notice message handling code. Use 4.1.0
or later.
Warning
PostgreSQL function names will be changed in 4.2.0 release
to confirm to current coding standards. Most of new names
will have additional underscores, e.g. pg_lo_open(). Some
functions are renamed to different name for consistency.
e.g. pg_exec() to pg_query(). Older names can be used in
4.2.0 and a few releases from 4.2.0, but they may be deleted
in the future.
Table 2. Function names changed
Old name New name
pg_cmdtuples() pg_affected_rows()
pg_errormessage() pg_last_error()
pg_exec() pg_query()
pg_fieldname() pg_field_name()
pg_fieldsize() pg_field_size()
pg_fieldnum() pg_field_num()
pg_fieldprtlen() pg_field_prtlen()
pg_fieldisnull() pg_field_is_null()
pg_freeresult() pg_free_result()
pg_getlastoid() pg_last_oid()
pg_loreadall() pg_lo_read_all()
pg_locreate() pg_lo_create()
pg_lounlink() pg_lo_unlink()
pg_loopen() pg_lo_open()
pg_loclose() pg_lo_close()
pg_loread() pg_lo_read()
pg_lowrite() pg_lo_write()
pg_loimport() pg_lo_import()
pg_loexport() pg_lo_export()
pg_numrows() pg_num_rows()
pg_numfields() pg_num_fields()
pg_result() pg_fetch_result()
The old pg_connect()/pg_pconnect() syntax will be deprecated
to support asynchronous connections in the future. Please
use a connection string for pg_connect() and pg_pconnect().
Not all functions are supported by all builds. It depends
on your libpq (The PostgreSQL C Client interface) version
and how libpq is compiled. If there is missing function,
libpq does not support the feature required for the function.
It is also important that you do not use an older libpq
than the PostgreSQL Server to which you will be connecting.
If you use libpq older than PostgreSQL Server expects, you
may have problems.
Since version 6.3 (03/02/1998) PostgreSQL uses unix domain
sockets by default. TCP port will NOT be opened by default.
A table is shown below describing these new connection possibilities.
This socket will be found in /tmp/.s.PGSQL.5432. This option
can be enabled with the '-i' flag to postmaster and its
meaning is: "listen on TCP/IP sockets as well as Unix
domain sockets".
|