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 functions are included by default in
8.3, but how do you install for 8.2?

Thanks,

Tony Caduto

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Tony Caduto <tony_caduto@amsoftwaredesign.com> 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?

http://www.postgresql.org/docs/faq

Tom Lane wrote:
> Tony Caduto <tony_caduto@amsoftwaredesign.com> 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 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.

Thanks,

Tony

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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 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:

http://pgfoundry.org/projects/edb-debugger/

brian

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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 error IMHO. If anything makes sense as part of
/contrib it's a procedural-language debugger module.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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/...leID=201803375

From the article:

After nine months of work, the new features in 8.3 will be available at
www.postgreSQL.org <http://www.postgreSQL.org>. They will include:
A finished PL/pgSQL debugger, a tool for editing PostgreSQL's version of
the standard SQL data access language in database applications.
Full text search made more accessible by becoming a feature included in
the system code instead of being an add-on option.
Clustering code from Skype for load balancing and spreading queries to a
large database across several PostgreSQL systems.


Now you know what I am talking about :-)

Later,

Tony Caduto

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

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 broadcast)---------------------------
TIP 6: explain analyze is your friend

Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wed, 14 Nov 2007 12:49:37 -0600
> Tony Caduto <tony_caduto@amsoftwaredesign.com> wrote:
>> Here ya go:
>>
>> http://www.informationweek.com/news/...leID=201803375
>
>> Now you know what I am talking about :-)
>
> I see nothing incorrect in that article.

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"

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

Richard Huxton <dev@archonet.com> 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 module.

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.

IIRC there are also some questions about what dependencies the GUI
part of it has got ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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/...leID=201803375
>
> From the article:
>
> After nine months of work, the new features in 8.3 will be available at
> www.postgreSQL.org <http://www.postgreSQL.org>. They will include:
> A finished PL/pgSQL debugger, a tool for editing PostgreSQL's version of
> the standard SQL data access language in database applications.
> Full text search made more accessible by becoming a feature included in
> the system code instead of being an add-on option.
> Clustering code from Skype for load balancing and spreading queries to a
> large database across several PostgreSQL systems.
>
>
> Now you know what I am talking about :-)
>

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 release (did you look at the release
notes?) and also where you can find it.

That said, take this up with Information Week.

brian

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match