Re: [BUGS] BUG #4220: delete statement deleted too many rows

2008-06-05 Thread hubert depesz lubaczewski
On Wed, Jun 04, 2008 at 01:58:19PM -0700, Lon Varscsak wrote: > Wow, I want it to violate the spec so I can get my rows back! :) > I understand the problem and why it did what it did now though. you might find this post also helpful (for future): http://www.depesz.com/index.php/2007/07/27/update-

Re: [BUGS] BUG #4220: delete statement deleted too many rows

2008-06-04 Thread Lon Varscsak
Wow, I want it to violate the spec so I can get my rows back! :) I understand the problem and why it did what it did now though. Thanks for your help, Lon On Wed, Jun 4, 2008 at 1:08 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > On Wed, Jun

Re: [BUGS] BUG #4220: delete statement deleted too many rows

2008-06-04 Thread Tom Lane
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > On Wed, Jun 04, 2008 at 06:46:42PM +, Lon Varscsak wrote: >> delete from customer_transactions_detail where transaction_id in (select >> transaction_id from test); >> The transaction_id column does NOT exist in the temporary table named >>

Re: [BUGS] BUG #4220: delete statement deleted too many rows

2008-06-04 Thread hubert depesz lubaczewski
On Wed, Jun 04, 2008 at 06:46:42PM +, Lon Varscsak wrote: > delete from customer_transactions_detail where transaction_id in (select > transaction_id from test); > The transaction_id column does NOT exist in the temporary table named > 'test'). I would think this would just result in an error,