Hi Patric,
This doesn't seem to be a question pertaining to the PERFORM queue.
If I understand you correctly, this should solve your problems, without the
need for any RULES / TRIGGERS.
CREATE TABLE y
(
y1 int4 NOT NULL,
y2 varchar,
CONSTRAINT a PRIMARY KEY (y1)
)
CREATE TABLE z
(
z1 i
Yannick Le Guédart wrote:
Greetings,
I was trying to get informations on #portgresql about a query plan I
think is quite strange, and I was said to post on this list. I hope my
mail will be clear enough. I have included the query, the query plan,
and the table definitions. I just
On 2008-01-14 Patric wrote:
> Well I've a normalized database..
> For instance:
>
> create table Y ( pk, data... );
> create table Z ( pk , data...);
>
> create table X ( char, references Y, references Z);
>
> SELECT * from X;
>
> Now I want to make a listing of the resul
Hi,
There will be some flames i suppose.
Well I've a normalized database..
For instance:
create table Y ( pk, data... );
create table Z ( pk , data...);
create table X ( char, references Y, references Z);
SELECT * from X;
Now I want to make a listing of the result set
Jakub Ouhrabka <[EMAIL PROTECTED]> writes:
> What does it mean?
Look at src/include/storage/sinval.h and src/include/utils/syscache.h.
What you seem to have here is a bunch of tuple updates in pg_class
(invalidating caches 29 and 30, which in 8.2 correspond to RELNAMENSP
and RELOID), followed by a
Yannick Le Guédart writes:
> Greetings,
>
> I was trying to get informations on #portgresql about a query plan I
> think is quite strange, and I was said to post on this list. I hope my
> mail will be clear enough. I have included the query, the query plan,
> and the table definitions
Greetings,
I was trying to get informations on #portgresql about a query plan I
think is quite strange, and I was said to post on this list. I hope my
mail will be clear enough. I have included the query, the query plan,
and the table definitions. I just don't understand the "Seq
On Mon, Jan 14, 2008 at 03:05:27PM +0100, Florian Weimer wrote:
Hmm. It's an argument for a separate CIDR type, not against a host
type.
I don't think anyone argued against the CIDR type. :-)
Mike Stone
---(end of broadcast)---
TIP 6: explain a
* Michael Stone:
>>Classful addressing is still part of many user interfaces, for
>>instance Cisco's IOS. It's not just that the CLI accepts it, it's
>>also the standard[*] output format (that is, "192.0.2.0" instead of
>>"192.0.2.0/24"; if no prefix length is given, the one based on the
>>class
Hi Tom,
> Strange. The best idea that comes to mind is to add some debugging
> code to SendSharedInvalidMessage to log the content of each message
> that's sent out. That would at least tell us *what* is going into
> the queue, even if not directly *why*.
we've patched postgresql and run one o
On Mon, Jan 14, 2008 at 09:27:52AM +0100, Florian Weimer wrote:
* Steve Atkins:
I don't think there's ambiguity about what an dotted-quad without a
netmask means, and hasn't been for a long time. Am I missing
something?
Classful addressing is still part of many user interfaces, for
instance Ci
* Steve Atkins:
> I don't think there's ambiguity about what an dotted-quad without a
> netmask means, and hasn't been for a long time. Am I missing
> something?
Classful addressing is still part of many user interfaces, for
instance Cisco's IOS. It's not just that the CLI accepts it, it's
also
12 matches
Mail list logo