PLpgsql debugger question

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

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

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 14 Nov 2007 12:46:07 -0500
brian <brian@zijn-digital.com> 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 the core code. It also
includes the promotion of all the very cool projects surrounding
PostgreSQL.

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.

Sincerely,

Joshua D. Drake

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHOzgVATb/zqfZUUQRAh1TAKCeSXRXDRk8yjZ8Agy9a0efLqtdIgCfUCAB
gvqXEgrOwkmKlyJGid46fOU=
=F/OB
-----END PGP SIGNATURE-----

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 14 Nov 2007 18:40:26 +0000
Richard Huxton <dev@archonet.com> 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 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.

Take it up with those who didn't submit it for inclusion :)

Joshua D. Drake

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHO0KuATb/zqfZUUQRAooIAKCs9fhSFZ1BVtfwtBzgpImMafUs1gCeKbI9
r233WBvPi6UHsxcONQw4nEY=
=1Ek/
-----END PGP SIGNATURE-----

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, the new features in 8.3 will be available at
www.postgreSQL.org <http://www.postgreSQL.org&gt;. 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

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

-----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/showArticle.jhtml?articleID=201803375

Now you know what I am talking about :-)

I see nothing incorrect in that article.

Sincerely,

Joshua D. Drake

Later,

Tony Caduto

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

http://archives.postgresql.org/

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHO0UkATb/zqfZUUQRAtJdAJ9F21oN6o793BmyjVfxewbogFUSSQCeO85X
J43wWzv1c++1b8pUpSxK6iQ=
=7HEG
-----END PGP SIGNATURE-----

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/showArticle.jhtml?articleID=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

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

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/showArticle.jhtml?articleID=201803375

I see nothing incorrect in that article.

Sincerely,

Joshua D. Drake

Who said anything was incorrect? It's just a bit misleading (the Info
Week Article).

It's just after reading that MANY readers would think that if they
install 8.3, the debugger hooks/whatever would be ready out of the box.

Whoever is doing the release notes may want to have something in there
about the debugger and the fact that it's not included and has to be
manually compiled and all that.

In the current release notes for 8.3 it makes NO mention of the debugger.

Later,

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 anything debugger related in the 8.3 beta release
notes either.

Kind of seems like its not really a feature to me, but what do I know :-)

The article is very misleading with regards to the debugger.

Later,

Tony Caduto

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 14 Nov 2007 19:01:04 +0000
Richard Huxton <dev@archonet.com> wrote:

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/showArticle.jhtml?articleID=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 ?

http://www.postgresql.org/ftp/projects/pgFoundry/edb-debugger/

Joshua D. Drake

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

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHO0jmATb/zqfZUUQRAga0AJ9pu3u1ukHbT1KhQt2efOmh62VhVACeNnEY
mCyvw/Mwg7lFOOA+cz+K+k8=
=zPJA
-----END PGP SIGNATURE-----

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

Whoever is doing the release notes may want to have something in there
about the debugger and the fact that it's not included and has to be
manually compiled and all that.

Yup, I can see it now:

<para>
Never believe anything you read in Information Week.
</para>

Seriously, we can't be expected to worry about misstatements made by
others. If we had to add a paragraph to the release notes for every
incorrect thing that's ever been said about Postgres, they'd be
completely unreadable rather than just mostly.

regards, tom lane

------- Original Message -------
From: Richard Huxton <dev@archonet.com>
To: "Joshua D. Drake" <jd@commandprompt.com>
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:37 -0600
Tony Caduto <tony_caduto@amsoftwaredesign.com> 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.

So you're saying the finished plpgsql debugger will be available from
www.postgresql.org ?

It all is, so that is correct.

/D

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 nine months of work, the new features in 8.3 will be available at
www.postgreSQL.org <http://www.postgreSQL.org&gt;. 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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 14 Nov 2007 15:44:39 -0500
brian <brian@zijn-digital.com> 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 release (did you look at the
release notes?) and also where you can find it.

That said, take this up with Information Week.

Please don't. Bruce and I both have talked with them about that article
and although it isn't exactly accurate, it is close enough and is a
positive endorsement of our project.

Sincerely,

Joshua D. Drake

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

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHO19hATb/zqfZUUQRAsHIAJ9KpmbaZZFTkOsLmQhVziWWgbOWIQCfdZpN
2AhlI01p6j3Pg9SfiU3r57Q=
=Q5ME
-----END PGP SIGNATURE-----

Joshua D. Drake wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 14 Nov 2007 15:44:39 -0500
brian <brian@zijn-digital.com> 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 release (did you look at the
release notes?) and also where you can find it.

That said, take this up with Information Week.

Please don't. Bruce and I both have talked with them about that article
and although it isn't exactly accurate, it is close enough and is a
positive endorsement of our project.

Oh, yea, that article. There was some confusion by the author over 3rd
party stuff vs main project stuff. It was a "stuff-is-coming" article so
we couldn't get it 100% accurate after the fact.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +