Re: [HACKERS] Alterations to backend/client protocol - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Alterations to backend/client protocol
Date
Msg-id 11380.919784213@sss.pgh.pa.us
Whole thread Raw
In response to Alterations to backend/client protocol  (Philip Shiels <philip.shiels@jrc.it>)
List pgsql-hackers
Philip Shiels <philip.shiels@jrc.it> writes:
> Is it possible to change the protocol between the backend/client to
> include the the table names (or some unique value allowing me get to
> the table name) ?

A protocol upgrade is certainly possible --- I caused one to happen
myself for 6.4.  However it incurs a certain amount of pain all around,
since new clients won't talk to old servers.  I think there'd have to
be some discussion and hopefully a consensus about whether the proposed
new features are worth the trouble.

BTW, changing the backend's rules for making default column labels would
be a way to provide the same info without needing a protocol upgrade.
It might break some application-level client logic, however.  Offhand
I'm not sure which way would give fewer headaches.  But people have
complained for a long time that the current default labels aren't
informative enough, so I think you could probably sell them on a more
useful labeling scheme even if it did break a few old clients.

> I am, depending on how much effort this takes, willing to perform the
> development myself, can you measure the effort ?

Any changes needed in the protocol (see the protocol chapter in the
developer's guide) and libpq would be trivial enough.  I do not know
whether it is practical to get the information you want inside the
backend, however --- in particular, for queries involving joins,
I think that the data effectively comes from a "temporary table" that
is the joined relation.  Can you identify the ancestry of columns in
that temp table?  I dunno.

My guess is that it'd be less work and less impact on other Postgres
users to modify the queries you send in the first place...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Brian P Millett
Date:
Subject: postmaster fails with 2-23 snapshot
Next
From: Brian P Millett
Date:
Subject: postmaster failure with 2-23 snapshot