[Bucardo-general] b5: delta_ rows not being deleted
josh at endpoint.com
Fri Jun 21 14:44:12 UTC 2013
On Thu, Jun 20, 2013 at 03:13:40PM -0400, Bill McGonigle wrote:
> but then, onto the full statement, as a SELECT instead of DELETE for
> investigation purposes, and I get:
> ecommerce=# SELECT count(txntime) FROM
> bucardo.delta_public_saved_cart USING (SELECT txntime AS tt FROM
> bucardo.track_public_saved_cart GROUP BY 1) AS foo WHERE txntime =
> tt AND txntime < now() - interval '45 seconds';
> ERROR: syntax error at or near "USING"
> LINE 1: ...unt(txntime) FROM bucardo.delta_public_saved_cart USING (SEL...
> I can't seem to find documentation about using 'USING' without a
> JOIN (is it implicit?).
> These are on v8.4 - I'm wondering if either of these might behave
> differently on v9. Equally as likely I'm missing something.
"USING" is DELETE's way of specifying a cross join, so if you wanted to change
that DELETE statement into a SELECT, you'd have to do more than just change
DELETE to SELECT count(whatever). You might try instead to append "RETURNING
<something>" to the DELETE statement, and doing it all within a transaction
that you eventually roll back. That will prevent you from actually deleting
anything, and still let you get results from the query.
Josh Tolley josh at endpoint.com 801-987-0252
End Point Corporation http://www.endpoint.com
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 836 bytes
Desc: Digital signature
More information about the Bucardo-general