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