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@xxxxxxxxx> 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!
