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

Re: Implementing SQL/PSM for PG 8.2 - debugger

From: "Mark Cave-Ayland" <m(dot)cave-ayland(at)webbased(dot)co(dot)uk>
To: "'Jonah H(dot) Harris'" <jharris(at)tvi(dot)edu>,"'Dave Cramer'" <pg(at)fastcrypt(dot)com>
Cc: "'Pavel Stehule'" <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>,"'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"'Neil Conway'" <neilc(at)samurai(dot)com>,"'Jan Wieck'" <JanWieck(at)Yahoo(dot)com>,"'Denis Lussier'" <denis(at)enterprisedb(dot)com>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Implementing SQL/PSM for PG 8.2 - debugger
Date: 2005-06-29 09:33:28
Message-ID: 9EB50F1A91413F4FA63019487FCD251D11341C@WEBBASEDDC.webbasedltd.local (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi guys,

> I lean with you and Tom.  While running it over the same libpq protocol 
> would be helpful in some ways, it would have a lot of drawbacks and 
> would really change the function of libpq.  I think a separate debugging 
> protocol is in order.

Just putting on my network hat for a moment... Would an approach be to come
up with a generic encapsulation protocol, similar in principle to PPP, in
which we could run any protocols we wanted?

If we had something like a PGSQL Encapsulation Protocol (PGEP) used to
transfer all data between a PostgreSQL client/server, then we can use this
to tunnel libpq requests as they are at the moment through to the other
side. However, it would also mean that people could add any other protocols
as they see fit for debugging, statistics and all sorts of things that
people have yet to think of.

Obviously this would require a client/server interface change so it's not to
be taken lightly, but I thought I'd mention it since people have mentioned
the possibility of changes to the FE/BE protocol.


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk
 



Responses

pgsql-hackers by date

Next:From: Martin M√ľnstermannDate: 2005-06-29 09:41:04
Subject: symbol name clash with libpq.so: md5_hash
Previous:From: Michael PaesoldDate: 2005-06-29 09:05:24
Subject: Re: commit_delay, siblings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group