Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: FKs on temp tables: hard, or just omitted?

  • From: "Sander Steffann" <steffann(at)nederland(dot)net>
  • To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • Cc: <josh(at)agliodbs(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
  • Subject: Re: FKs on temp tables: hard, or just omitted?
  • Date: Sun, 30 Oct 2005 11:34:56 +0100
  • Message-id: <002001c5dd3d$928d3b40$64c8a8c0(at)balefirehome>
Hi,


Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:

You solve it by allowing other backends to lock and examine your
temporary tables. But AIUI temporary tables are not stored in shared
memory so how do you get a consistant view of it?



Not unsolvable, but very tricky.


Right, the problem isn't that "it can't be done", it's that "it can't be
done without giving up most of the performance advantages of temp tables".
Which seems like a bad tradeoff, at least to me ...


Ah, now I understand the problem :-)

And I think you are right. It would be a very bad tradeoff.
Sander
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group