80_bug39971.phpt 617 B

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