Thread: PLpgsql debugger question

PLpgsql debugger question

From
Tony Caduto
Date:
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

Re: PLpgsql debugger question

From
Tom Lane
Date:
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

Re: PLpgsql debugger question

From
Tony Caduto
Date:
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

Re: PLpgsql debugger question

From
brian
Date:
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

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----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-----

Re: PLpgsql debugger question

From
Richard Huxton
Date:
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

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----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-----

Re: PLpgsql debugger question

From
Tony Caduto
Date:
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>. 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

Re: PLpgsql debugger question

From
Richard Huxton
Date:
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

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----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-----

Re: PLpgsql debugger question

From
Richard Huxton
Date:
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

Re: PLpgsql debugger question

From
Tom Lane
Date:
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

Re: PLpgsql debugger question

From
Tony Caduto
Date:
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



Re: PLpgsql debugger question

From
Tony Caduto
Date:
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

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----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-----

Re: PLpgsql debugger question

From
Tom Lane
Date:
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

Re: PLpgsql debugger question

From
"Dave Page"
Date:

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

Re: PLpgsql debugger question

From
brian
Date:
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>. 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

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----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-----

Re: PLpgsql debugger question

From
Bruce Momjian
Date:
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. +

Re: PLpgsql debugger question

From
Andrew Sullivan
Date:
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 what (Dunstan? I think?) proposed, which is
something like CPAN for PostgreSQL packages.  Things that _have_ to be in
the core -- hooks and such like -- would be shipped with the basic code, but
everything else could be pulled from pgfoundry.

This approach has a negative, of course -- CPAN modules can occasionally
cause dependency hell.  But the advantage is that bugs in one component with
a small but active user community don't have to either wait for another
general release, or affect the wider community.  This approach is part of
why we made Slony-I an "add on", and even though that has had some
disadvantages, I think on the whole it was a good thing.

A

--
Andrew Sullivan

Re: PLpgsql debugger question

From
Tom Lane
Date:
Andrew Sullivan <ajs@crankycanuck.ca> 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 after that.

> What I'd prefer, in any case, is what (Dunstan? I think?) proposed, which is
> something like CPAN for PostgreSQL packages.  Things that _have_ to be in
> the core -- hooks and such like -- would be shipped with the basic code, but
> everything else could be pulled from pgfoundry.

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, unfortunately --- it needs to know all about
plpgsql's internal data structures, and thus for example will need an
update every time we invent a new plpgsql statement or feature.  I think
ease of maintenance will dictate pulling it into the core "blob", once
it's settled enough for that to be a reasonable thing to do.  Otherwise
the debugger will soon become a maze of twisty little #ifdefs as it
tries to support multiple PG releases.

            regards, tom lane

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 15 Nov 2007 11:00:36 -0500
Tom Lane <tgl@sss.pgh.pa.us> 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, unfortunately --- it needs to know all
> about plpgsql's internal data structures, and thus for example will
> need an update every time we invent a new plpgsql statement or
> feature.'

They don't have to do this. They could simply state that 1.0 is for
8.1, 2.0 is for 8.2, 3.0 is for 8.3.

We don't back patch features, why should they?

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



- -- 

      === 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)

iD8DBQFHPHUtATb/zqfZUUQRArwkAJsGjCEXEL2Kfgx1oDbGKL8SpbYqTgCdE080
BVjFWDS8gMeg8CtSOg98jDg=
=wM0M
-----END PGP SIGNATURE-----

Re: PLpgsql debugger question

From
Tony Caduto
Date:
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 through the hassle of
finding it, then compiling and installing it?

As far as I know it's included in the core.

Things like the debugger need to just be there with no monkeying around.


Later,

Tony

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 15 Nov 2007 10:41:23 -0600
Tony Caduto <tony_caduto@amsoftwaredesign.com> 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 packagers are for. 

> 
> As far as I know it's included in the core.
> 
> Things like the debugger need to just be there with no monkeying
> around.

If you are compiling from source, you are likely monkeying around. It
is the packagers responsibility to package this stuff, not core.

Sincerely,

Joshua D. Drake

> 
> 
> Later,
> 
> Tony
> 


- -- 

      === 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)

iD8DBQFHPHfhATb/zqfZUUQRAovXAJ9icdtpqBJ59ET/gkaZeZf5GP+MTgCgrtL8
+DpSRLoYJjWLkYNL61RB+Y4=
=8yVg
-----END PGP SIGNATURE-----

Re: PLpgsql debugger question

From
Andrew Sullivan
Date:
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 DB2, and MySQL, and SQL Server,
and everyone else) _do so_ have all these add ons.  They just package it in
one thing sometimes, and you think it's "one system".  It is one system.
It's not one program.

This is what packagers are for.

Nobody seems to think it strange that you have to get libc from a
completely other group of programmers than you get the Linux kernel, for
instance.  This is because working systems are not built by people
downloading the source code and building their systems by hand from itty
bitty parts on the ground (any more than you buy your car from GM, Magna
International, and Dow Corning).

Small modules are _good_.  They isolate problems.

(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 instance.)

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 15 Nov 2007 11:57:28 -0500
Andrew Sullivan <ajs@crankycanuck.ca> 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 instance.)

Right.

Joshua D. Drake

> 
> A
> 


- -- 

      === 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)

iD8DBQFHPH0KATb/zqfZUUQRAtejAJ4gxmuwOJYFb8aGumvx53zvEgP8rACgpO4y
O80TjfVvOf/U9E4DG0Ip8qc=
=KVPK
-----END PGP SIGNATURE-----

Re: PLpgsql debugger question

From
Steve Atkins
Date:
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
> lean, and I
> say the same thing every time: Oracle (and DB2, and MySQL, and SQL
> Server,
> and everyone else) _do so_ have all these add ons.  They just
> package it in
> one thing sometimes, and you think it's "one system".  It is one
> system.
> It's not one program.
>
> This is what packagers are for.

Yup. Core vs not-core is for the convenience of the developers,
not the users.

But one difference between PG and others is that there are a lot of
different packagers, who bundle a variety of different subsets of the
addons, effectively creating a number of quite different products,
even though they're all called postgresql.

At one point you could expect that stuff in contrib would likely
be available via package (at least as a -contrib package) and
that stuff on gborg wouldn't be.

Now contrib is mostly going away, the windows installer bundles
all sorts of things that aren't obviously available via other
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 provide ad-hoc support
to new users.

Cheers,
   Steve


Re: PLpgsql debugger question

From
Andrew Sullivan
Date:
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 provide ad-hoc support
> to new users.

Well, we could set up a postgres-bundles project (especially if "CPgAN" got
off the ground) that defined well-outlined sets of packages that work well
together.  This would really be nothing more than a hints file for
packagers; but it'd be something that community members could say, "Here are
things that naturally fit together when we use them," and if enough people
found a given description apposite, we could "endorse" that.

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

Re: PLpgsql debugger question

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 15 Nov 2007 12:34:36 -0500
Andrew Sullivan <ajs@crankycanuck.ca> 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 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 provide ad-hoc support
> > to new users.
> 
> Well, we could set up a postgres-bundles project (especially if
> "CPgAN" got off the ground) that defined well-outlined sets of
> packages that work well together.  This would really be nothing more
> than a hints file for packagers; but it'd be something that community
> members could say, "Here are things that naturally fit together when
> we use them," and if enough people found a given description
> apposite, we could "endorse" that.

I would rather us just start a packaging project. We are already doing
this for RPMS... and the debian folks are all over it... We just need
to provide some help and get them into the repos.

Joshua D. Drake

> 
> A
> 


- -- 

      === 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)

iD8DBQFHPIbPATb/zqfZUUQRAusYAJ9IOcaAFUltmshVCo9ZHwtcLz7/xgCgiL1C
erENXZHVXya0yWiEms4HDOQ=
=PMng
-----END PGP SIGNATURE-----