| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Mattias Kregert <mattias(at)kregert(dot)se>, TANIDA Yutaka <tanida(at)sra(dot)co(dot)jp>, Boris Popov <boris(at)procedium(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temp rows - is it possible? |
| Date: | 2003-11-10 17:56:06 |
| Message-ID: | 5294.1068486966@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> We recently decided we had to forbid foreign-key references from temp
>> tables to permanent tables because of this effect. I wonder whether
>> we won't end up forbidding temp tables as children of permanent tables
>> too.
> Yep, I think we will have to do that. TODO item?
Plan B would be to arrange for the planner to ignore temp tables of
other backends whenever it is searching for child tables. Then the
behavior would be predictable: you never see any rows inserted in other
people's temp child tables (and cannot update or delete 'em, either).
I'm not sure if this is the behavior the OP wanted, but it seems at
least marginally useful.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-11-10 17:58:55 | Re: SQL query not returning the value expected !!!!!!!!!!!!!!!!!! |
| Previous Message | Peter Eisentraut | 2003-11-10 17:41:22 | Re: case-sensitive sorting and locale settings? |