xref: /PHP-8.0/ext/pgsql/tests/80_bug39971.phpt (revision f8d79582)
1--TEST--
2Bug #39971 (8.0+) (pg_insert/pg_update do not allow now() to be used for timestamp fields)
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6?>
7--FILE--
8<?php
9
10require_once('config.inc');
11
12$dbh = @pg_connect($conn_str);
13if (!$dbh) {
14    die ("Could not connect to the server");
15}
16
17pg_query("CREATE TABLE php_test (id SERIAL, tm timestamp NOT NULL)");
18
19$values = array('tm' => 'now()');
20pg_insert($dbh, 'php_test', $values);
21
22$ids = array('id' => 1);
23pg_update($dbh, 'php_test', $values, $ids);
24
25pg_query($dbh, "DROP TABLE php_test");
26pg_close($dbh);
27?>
28===DONE===
29--EXPECT--
30===DONE===
31