Re: pg_connect: Call to undefined function pg_connect()

On Tue, 2023-12-05 at 16:14 -0500, Aziz Saleh wrote: > Check the php.ini and see that it has the extension set/uncommented (php_pgsql.dll). If that > doesn't solve it try installing the php8.0-pgsql package. > > On Tue, Dec 5, 2023 at 4:08 PM John <john.iliffe@iliffe.ca> wrote: > > I have moved a number of php scripts from PHP 7.2.9 to PHP 8.0.27 and I am encountering > > the > > following error: > > [05-Dec-2023 15:34:41 America/Toronto] PHP Fatal error:  Uncaught Error: Call to > > undefined > > function > > pg_connect() in /usr/httpd/xxx0002.php:211 > > > > line 211, which worked as expected up until now is: > >   $db_handle = pg_connect('dbname=xxxx user=xxxx password=xxxx'); > > and the online docs show this as still acceptable but deprecated.  I noticed that the > > result > > will be > > a "PgSql\Connection" object. > > > > Two questions: > > 1. since the syntax is still valid why am I getting an undefined function error? > > > > 2. since the result is different, am I going to encounter a lot of other problems in this > > conversion > > and where can I find a full list of these changes? > > > > Thanks, > > > > John > > ====== Thanks; I'll read the change log file this evening. I checked the init file and this is all that is set for pgsql (exclude comment lines) [PostgreSQL] 1181 pgsql.allow_persistent = On 1183 ; Detect broken persistent links always with pg_pconnect(). 1186 pgsql.auto_reset_persistent = Off 1190 pgsql.max_persistent = -1 1194 pgsql.max_links = -1 1199 pgsql.ignore_notice = 0 Since this is the O/S supplied version of PHP I would really prefer to make as few changes as possible to avoid having an unknown crash sometime when the source makes the next update!