More update
If I run the concurrent re index locally (psql session) it works fine, but
when run via a connection through php I get the error
Can't be slon, since I can do this locally, but why would postgres have an
issue with a remote connection?
the basic script:
$connectString = "host=server dbname=clsdb user=postgres
password=password";
$dbconn = pg_connect($connectString);
if (!$dbconn) {
print "Could not connect";
die();
}
$result = pg_query( $dbconn, "CREATE INDEX CONCURRENTLY
prc_temp_idx_impressions_log_date ON tracking.impressions USING btree
(log_date) TABLESPACE trackingindexspace;" );
Error about a lock:
*2009-10-07 22:18:02 PDT clsdb postgres 10.13.200.70(46706) ERROR: deadlock
detected*
*2009-10-07 22:18:02 PDT clsdb postgres 10.13.200.70(46706) DETAIL: Process
20939 waits for ShareLock on virtual transaction 16/43817381; blocked by
process 1874.*
* Process 1874 waits for ExclusiveLock on relation 17428 of database
16384; blocked by process 20939.*
*2009-10-07 22:18:02 PDT clsdb postgres 10.13.200.70(46706) STATEMENT:
CREATE INDEX CONCURRENTLY prc_temp_idx_impressions_log_date2 ON
tracking.impressions USING btree (log_date) TABLESPACE trackingindexspace*
*Thanks*
*Tory
*
