Re: From select to delete

----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alexander Farber
Sent: Friday, October 28, 2011 1:03 PM
Cc: pgsql-general
Subject: Re: [GENERAL] From select to delete

Thank you, David -

On Fri, Oct 28, 2011 at 7:00 PM, David Johnston <polobo@yahoo.com> wrote:
> The easiest way is to create FOREIGN KEY relationships between the
> various tables and allow "ON DELETE CASCADE" to do the work.
>
> Otherwise you need to DELETE with an appropriate WHERE clause (and
> sub-selects) or you can use the "USING" clause with the DELETE to add
> additional condition tables.
>
> DELETE FROM t1
> USING (t2 JOIN t3 ON (...)) t_linked
> WHERE t1.something = t_linked.something;
>

I'll try that.

My own 3 commands suggested above fail with

Foreign key violation: 7 ERROR: update or delete on table "pref_games"
violates foreign key constraint "pref_scores_gid_fkey" on table
"pref_scores" DETAIL: Key (gid)=(1998) is still referenced from table
"pref_scores". CONTEXT: SQL statement "delete from pref_games where gid in
(select gid from pref_scores where id= $1 )"

Regards
Alex

------/Original Message --------

Ok.  And your question is?

Dave