Re: Do we force dependency?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Do we force dependency?
Date: 2005-06-06 02:58:37
Message-ID: 6156.1118026717@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> writes:
> The reason I raise this question is because I corrupted pg_trigger by
> concurrently perform drop/create table (with foreign keys).

That should be impossible because drop/create take out locks at the
table level. Can you provide a reproducible test case?

If you can't make it happen easily by hand, one possible way to proceed
is to run one or both sessions under gdb and set breakpoints at key
places like recursiveDeletion(). If there is a timing issue it should
be possible to expose it by delaying a process at the right places in
this way.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2005-06-06 03:35:58 Re: lastval()
Previous Message Qingqing Zhou 2005-06-06 02:32:49 Re: Do we force dependency?