Re: concurrent reindex issues

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