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 months

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 (and

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 the

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

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 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 from a

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, is

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,

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

[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

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?

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 just

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

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

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 article.

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

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? It

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

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 debugger

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,

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

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 PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 12:49

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

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

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 just

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: Here ya go:

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 the debugger