이번에 새로운 서버로 옮기면서 최신버전으로 설치를 하면서 보니 ..

PostgreSQL관련 함수이름이 많이 바뀌었더군요.

주로 많이 쓰는 함수가 pg_exec, pg_numrows,pg_numfields였는데..

이름이 바뀌어서 바꾸느라 고생좀 했습니다.... ^^;

저만 모르고 있었나요? ^^;

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_exec()          pg_query()
pg_getlastoid()    pg_last_oid()
pg_cmdtuples()     pg_affected_rows()
pg_numrows()       pg_num_rows()
pg_numfields()     pg_num_fields()
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_result()        pg_fetch_result()
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()

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().