Tom Lane wrote: > "Mattias Kregert" <[EMAIL PROTECTED]> writes: > > This is great! > > >> create table a(...); > >> insert into a(...); # fixed values > >> > >> create table b() inherits (a); > >> insert into b values(...); # temporary values > >> > >> select * from a; # You can get both global and temporary values. > > I don't think it's actually reliable. B was meant to be a temp table, > right? The problem is that B will be globally visible to all sessions > as being a child table of A, but because temp tables are processed in > backend-local buffers, it will be quite erratic whether other sessions > can see the rows you've inserted. In an experiment just now, another > session could not see the rows in B until I'd inserted several thousand > of them (enough to overrun the local buffers) ... and then the other > session could see some but not all of them. > > 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? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
