09notice.phpt 743 B

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. --TEST--
  2. PostgreSQL notice function
  3. --SKIPIF--
  4. <?php
  5. include("skipif.inc");
  6. _skip_lc_messages();
  7. ?>
  8. --INI--
  9. pgsql.log_notice=1
  10. pgsql.ignore_notice=0
  11. --FILE--
  12. <?php
  13. include 'config.inc';
  14. include 'lcmess.inc';
  15. $db = pg_connect($conn_str);
  16. _set_lc_messages();
  17. $res = pg_query($db, 'SET client_min_messages TO NOTICE;');
  18. var_dump($res);
  19. pg_query($db, "BEGIN;");
  20. pg_query($db, "BEGIN;");
  21. $msg = pg_last_notice($db);
  22. if ($msg === FALSE) {
  23. echo "Cannot find notice message in hash\n";
  24. var_dump($msg);
  25. }
  26. echo $msg."\n";
  27. echo "pg_last_notice() is Ok\n";
  28. ?>
  29. --EXPECTF--
  30. resource(%d) of type (pgsql result)
  31. Notice: pg_query(): %s already a transaction in progress in %s on line %d
  32. %s already a transaction in progress
  33. pg_last_notice() is Ok