On Sun, Oct 30, 2005 at 05:31:07PM -0800, Josh Berkus wrote:
> Folks,
>
> Thanks, all! Now, if only I could remember who asked me the question ...
ISTM we should add a note about this to the docs...
Here's a patch for create_table.sgml, though there's probably some other
places this could go...
Folks,
Thanks, all! Now, if only I could remember who asked me the question ...
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-n
Hi,
Martijn van Oosterhout 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
Martijn van Oosterhout 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
-Original Message-
From: [EMAIL PROTECTED] on behalf of Sander Steffann
Sent: Sat 10/29/2005 1:54 PM
To: josh@agliodbs.com; Tom Lane
Cc: PostgreSQL-development
Subject: Re: [HACKERS] FKs on temp tables: hard, or just omitted?
>> You can have foreign keys between temp tables, ju
On Sat, Oct 29, 2005 at 02:54:31PM +0200, Sander Steffann wrote:
> >You can have foreign keys between temp tables, just not between temp and
> >permanent tables. The latter case is either fairly silly, or
> >technically hard, depending on which direction you have in mind.
>
> A temp table referen
You can have foreign keys between temp tables, just not between temp and
permanent tables. The latter case is either fairly silly, or
technically hard, depending on which direction you have in mind.
A temp table referencing a permanent table wouldn't be very silly IMHO...
Sander.
---
Josh Berkus writes:
> Are foreign keys on temp tables not allowed just because nobody requested
> them, or because they're hard to do?
You can have foreign keys between temp tables, just not between temp and
permanent tables. The latter case is either fairly silly, or
technically hard, dependin
Folks,
Are foreign keys on temp tables not allowed just because nobody requested
them, or because they're hard to do?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 5: don't forget to increase your free