Thread

Re: [HACKERS] Arrays broken on temp tables

Bruce Momjian <maillist@candle.pha.pa.us> — 1999-11-11T04:33:13Z

> No, our code is *not* OK.  It's true that the original example was given
> without a WHERE clause, whereas a practical UPDATE would usually have a
> WHERE clause; but that has nothing to do with whether the planner will
> generate a join or not.  If a join is done then the wrong things will
> happen, WHERE or no WHERE.
> 
> The bottom line here is that we mustn't generate separate RTEs for the
> logical and physical table names.

Are you saying a join on a temp table will not work?  Can you give an
example?


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026