Joe Markwardt joe
Thu Jul 7 20:31:14 PDT 2005
On Thu, 2005-07-07 at 15:18 -0400, Jan Wieck wrote:
> On 7/7/2005 2:44 PM, Joe Markwardt wrote:
> 
> > On Thu, 2005-07-07 at 12:21 -0400, Jan Wieck wrote:
> >> On 7/7/2005 11:54 AM, Joe Markwardt wrote:
> >> > Greetings all, 
> >> > 	I'm posting this question here per suggestion from Tom Lane on the
> >> > postgres-general mailing list.
> >> > 
> >> > The thread on the postgres list:
> >> > http://archives.postgresql.org/pgsql-general/2005-07/msg00126.php
> 
> after reading the entire thread it appears that you attempted to drop
> the table on the subscriber before the event for removing the table from
> the set actually propagated to the subscriber. That would be the only
> chance that the denyaccess trigger is still defined for it and the
> foreign key triggers are still "parked" on the tables PK index (that's
> one of the weird things Tom was talking about).
> 

That could be I usually check the logs before I make any changes like
this to make sure my slonik commands have propogated, but I may have
forgotten this time.  Any idea's on how to fix it other than re-starting
replication from scratch?

Thanks
	Joe





More information about the Slony1-general mailing list