1--TEST-- 2PostgreSQL create db 3--EXTENSIONS-- 4pgsql 5--SKIPIF-- 6<?php include("skipif.inc"); ?> 7--FILE-- 8<?php 9// create test table 10 11include('config.inc'); 12 13$db = pg_connect($conn_str); 14if (!($q = @pg_query($db, "SELECT * FROM ".$table_name)) || !@pg_num_rows($q)) 15{ 16 pg_query($db,$table_def); // Create table here 17 for ($i=0; $i < $num_test_record; $i++) { 18 pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');"); 19 } 20} 21else { 22 echo pg_last_error()."\n"; 23} 24 25$v = pg_version($db); 26if (version_compare($v['server'], '9.2', '>=') && (!($q = @pg_query($db, "SELECT * FROM ".$table_name_92)) || !@pg_num_rows($q))) 27{ 28 pg_query($db,$table_def_92); // Create table here 29} 30else { 31 echo pg_last_error()."\n"; 32} 33 34// Create view here 35pg_query($db,$view_def); 36 37pg_close($db); 38 39echo "OK"; 40?> 41--EXPECT-- 42OK 43
