27large_object_oid.phpt 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. --TEST--
  2. PostgreSQL create large object with given oid
  3. --SKIPIF--
  4. <?php
  5. include("skipif.inc");
  6. $v = pg_version($conn);
  7. if (version_compare("8.3", $v["client"]) > 0) die("skip - requires pg client >= 8.3\n");
  8. if (version_compare("8.3", $v["server"]) > 0) die("skip - requires pg server >= 8.3\n");
  9. ?>
  10. --FILE--
  11. <?php
  12. include('config.inc');
  13. $db = pg_connect($conn_str);
  14. echo "create LO from int\n";
  15. pg_exec ($db, "begin");
  16. $oid = pg_lo_create ($db, 21000);
  17. if (!$oid) echo ("pg_lo_create() error\n");
  18. if ($oid != 21000) echo ("pg_lo_create() wrong id\n");
  19. pg_lo_unlink ($db, $oid);
  20. pg_exec ($db, "commit");
  21. echo "create LO from string\n";
  22. pg_exec ($db, "begin");
  23. $oid = pg_lo_create ($db, "21001");
  24. if (!$oid) echo ("pg_lo_create() error\n");
  25. if ($oid != 21001) echo ("pg_lo_create() wrong id\n");
  26. pg_lo_unlink ($db, $oid);
  27. pg_exec ($db, "commit");
  28. echo "create LO using default connection\n";
  29. pg_exec ("begin");
  30. $oid = pg_lo_create (21002);
  31. if (!$oid) echo ("pg_lo_create() error\n");
  32. if ($oid != 21002) echo ("pg_lo_create() wrong id\n");
  33. pg_lo_unlink ($oid);
  34. pg_exec ("commit");
  35. echo "OK";
  36. ?>
  37. --EXPECT--
  38. create LO from int
  39. create LO from string
  40. create LO using default connection
  41. OK