Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Andrew Sullivan
On Thu, Nov 15, 2007 at 09:20:33AM -0800, Steve Atkins wrote: > packages, so there are an awful lot of versions of the postgresql > application, some very different from a users point of view. > > I tend to think of that as feature as much as bug, but it does > cause some confusion while trying to

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Tony Caduto
Joshua D. Drake wrote: Don't get me wrong the debugger is certainly useful but I see no technical argument (and I am sure you will correct me if I am wrong :)) that deems it needs to be in core. Joshua D. Drake I would have to disagree. So if you are using Oracle do you have to go throu

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 15 Nov 2007 11:00:36 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Something like that could work well for modules that are moderately > independent of the core database version. I'm afraid that won't be > true for the plpgsql debugger, unfort

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Andrew Sullivan
On Wed, Nov 14, 2007 at 02:03:50PM -0500, Tom Lane wrote: > > At some point it might get integrated, but right now it seems to need > its own release schedule. We put the core hooks in for 8.2 but the > thing didn't actually get published for many months after that. What I'd prefer, in any case,

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 15 Nov 2007 12:34:36 -0500 Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Thu, Nov 15, 2007 at 09:20:33AM -0800, Steve Atkins wrote: > > packages, so there are an awful lot of versions of the postgresql > > application, some very different fr

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Steve Atkins
On Nov 15, 2007, at 8:57 AM, Andrew Sullivan wrote: On Thu, Nov 15, 2007 at 10:41:23AM -0600, Tony Caduto wrote: So if you are using Oracle do you have to go through the hassle of finding it, then compiling and installing it? This canard comes up every time we discuss keeping the codebase

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 15 Nov 2007 11:57:28 -0500 Andrew Sullivan <[EMAIL PROTECTED]> wrote: > (None of this is an argument against Tom's point that deep-in-there > hooks at least have to be shipped with the core stuff. The same is > true for replication, for insta

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Andrew Sullivan
On Thu, Nov 15, 2007 at 10:41:23AM -0600, Tony Caduto wrote: > > So if you are using Oracle do you have to go through the hassle of > finding it, then compiling and installing it? This canard comes up every time we discuss keeping the codebase lean, and I say the same thing every time: Oracle (a

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 15 Nov 2007 10:41:23 -0600 Tony Caduto <[EMAIL PROTECTED]> wrote: > > > I would have to disagree. > :) > So if you are using Oracle do you have to go through the hassle of > finding it, then compiling and installing it? That is what t

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Wed, Nov 14, 2007 at 02:03:50PM -0500, Tom Lane wrote: >> At some point it might get integrated, but right now it seems to need >> its own release schedule. We put the core hooks in for 8.2 but the >> thing didn't actually get published for many mon

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Bruce Momjian
Joshua D. Drake wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Wed, 14 Nov 2007 15:44:39 -0500 > brian <[EMAIL PROTECTED]> wrote: > > > I should have pointed out that I wasn't questioning whether or not > > there was an article that stated this. I was simply pointing out that > >

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 19:01:04 + Richard Huxton <[EMAIL PROTECTED]> wrote: > Joshua D. Drake wrote: > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > On Wed, 14 Nov 2007 12:49:37 -0600 > > Tony Caduto <[EMAIL PROTECTED]> wrote: > >> Her

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Tom Lane
Tony Caduto <[EMAIL PROTECTED]> writes: > Who said anything was incorrect? It's just a bit misleading (the Info > Week Article). Three out of the four features mentioned in your quote are not part of core Postgres, so the author was obviously taking a very wide view of what "Postgres" is. Or was

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 15:44:39 -0500 brian <[EMAIL PROTECTED]> wrote: > I should have pointed out that I wasn't questioning whether or not > there was an article that stated this. I was simply pointing out that > the debugger was *not* included in the r

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread brian
Tony Caduto wrote: brian wrote: I don't know what you're referring to when you say it was "advertised as a feature" but it's not a part of the PG release. You can get it here: Here ya go: http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375 From the article: After n

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Dave Page
> --- Original Message --- > From: Richard Huxton <[EMAIL PROTECTED]> > To: "Joshua D. Drake" <[EMAIL PROTECTED]> > Sent: 14/11/07, 19:01:04 > Subject: Re: [GENERAL] PLpgsql debugger question > > Joshua D. Drake wrote: > > -BEGIN P

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Tony Caduto
Richard Huxton wrote: So you're saying the finished plpgsql debugger will be available from www.postgresql.org ? "After nine months of work, the new features in 8.3 will be available at www.postgreSQL.org. They will include: * A finished PL/pgSQL debugger" There is no mention of an

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Tony Caduto
Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 12:49:37 -0600 Tony Caduto <[EMAIL PROTECTED]> wrote: Here ya go: http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375 I see nothing incorrect in that article. Sincerely, Jo

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> writes: > Joshua D. Drake wrote: >> It is a pgfoundry project which is part of PostgreSQL. A quick co >> of /trunk shows that it is not in contrib. > Which is probably an error IMHO. If anything makes sense as part of > /contrib it's a procedural-language debugg

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Richard Huxton
Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 12:49:37 -0600 Tony Caduto <[EMAIL PROTECTED]> wrote: Here ya go: http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375 Now you know what I am talking about :-) I see nothing incor

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 12:49:37 -0600 Tony Caduto <[EMAIL PROTECTED]> wrote: > > > Here ya go: > > http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375 > > Now you know what I am talking about :-) I see nothing incorrect in that a

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Richard Huxton
Joshua D. Drake wrote: Which is probably an error IMHO. If anything makes sense as part of /contrib it's a procedural-language debugger module. Take it up with those who didn't submit it for inclusion :) Fair enough. -- Richard Huxton Archonet Ltd ---(end of broa

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Tony Caduto
brian wrote: I don't know what you're referring to when you say it was "advertised as a feature" but it's not a part of the PG release. You can get it here: Here ya go: http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375 From the article: After nine months of work,

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 18:40:26 + Richard Huxton <[EMAIL PROTECTED]> wrote: > Joshua D. Drake wrote: > > So the debugger is a feature of 8.3. It just isn't included in core. > > > >>> Is it going to be included as a contrib module or something else?

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Richard Huxton
Joshua D. Drake wrote: So the debugger is a feature of 8.3. It just isn't included in core. Is it going to be included as a contrib module or something else? It is a pgfoundry project which is part of PostgreSQL. A quick co of /trunk shows that it is not in contrib. Which is probably an err

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 12:46:07 -0500 brian <[EMAIL PROTECTED]> wrote: > Tony Caduto wrote: > > > > Back in Sept the debugger was advertised as a feature of 8.3, so if > > it's not included how is it a feature? Advocacy of PostgreSQL includes more than

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread brian
Tony Caduto wrote: Back in Sept the debugger was advertised as a feature of 8.3, so if it's not included how is it a feature? Is it going to be included as a contrib module or something else? I am talking about the server side stuff not the EDB GUI client. I don't know what you're referri

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Tony Caduto
Tom Lane wrote: Tony Caduto <[EMAIL PROTECTED]> writes: As I understand it the debugger functions are included by default in 8.3, That's incorrect. regards, tom lane Ok, thanks for the info. Back in Sept the debugger was advertised as a feature of 8.3, so

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Tom Lane
Tony Caduto <[EMAIL PROTECTED]> writes: > As I understand it the debugger functions are included by default in > 8.3, That's incorrect. regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

[GENERAL] PLpgsql debugger question

2007-11-14 Thread Tony Caduto
Hi, Does anyone know if there is a debugger function that will return the line numbers that are executable? Also, is the debugger code available at pgfoundry the GUI client that EnterpriseDB has done or is the module that needs to be installed on the server? As I understand it the debugger