On Thu, Feb 08, 2007 at 05:52:37PM -0500, Sven Willenberger wrote:
> Not sure what you mean by ungranted locks. The schemas were created by a
> regular user (i.e non-superuser) while slony is a superuser and should
> be able to restore the indexes. What should I look for to match your
> question?

Creating indexes requires a table lock.  If something else has a
transaction open against the table (vacuum?), you're in trouble.  You
can look in pg_locks to see if that might be your problem.

A

-- 
Andrew Sullivan  | [EMAIL PROTECTED]
If they don't do anything, we don't need their acronym.
                --Josh Hamilton, on the US FEMA
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to