summaryrefslogtreecommitdiff
path: root/ext/pgsql/tests/80_bug39971.phpt
blob: 14c7fbd547baeea4ac7d3afda964d6c8005225cb (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
--TEST--
Bug #39971 (8.0+) (pg_insert/pg_update do not allow now() to be used for timestamp fields)
--SKIPIF--
<?php
require_once('skipif.inc');
?>
--FILE--
<?php

require_once('config.inc');

$dbh = @pg_connect($conn_str);
if (!$dbh) {
	die ("Could not connect to the server");
}

pg_query("CREATE TABLE php_test (id SERIAL, tm timestamp NOT NULL)");

$values = array('tm' => 'now()');
pg_insert($dbh, 'php_test', $values);

$ids = array('id' => 1);
pg_update($dbh, 'php_test', $values, $ids);

pg_query($dbh, "DROP TABLE php_test");
pg_close($dbh);
?>
===DONE===
--EXPECT--
===DONE===