I'd be in favour
of removing the distinction - a few people have asked me about the difference.
> It's a historic thing - procedures actually appeared in
> early versions
of EnterpriseDB originally where they were
> considered different objects
from functions if memory
> serves. The distinction
Dave Page wrote:
Milen A. Radev wrote:
I consider the decision to distinguish between functions and procedures
in pgAdmin's UI very unfortunate.
(..)
I'm happy to discuss re-engineering that if people want (can't guarantee
I'll actually get time to change anything myself though).
As I have
I just found out the same thing, running a test install on another pc. I must
have skipped that step with my screenshots.
Sorry for taking up so much bandwidth on this.
Raymond O wrote:
>
> On 28 Nov 2006 at 10:29, novnov wrote:
>
>> I've not actually reinstalled pgsql (8.1). What I did is to
On 28 Nov 2006 at 10:29, novnov wrote:
> I've not actually reinstalled pgsql (8.1). What I did is to review the
> screenshots I took of my installation process, and there wasn't any
> step (at least that I captured) for contrib modules. Also, in the
I've had to do that at times, and have never ha
Thanks for haning in there with me on this. I know the contrib modules stuff
is pgsql, not pgAdmin, but pgAdmin could probably be extended to allow for
simpler access to the template1 db. I'd guess that it could be loaded just
like any db and altered, though of course should only be exposed by spe
On 28 Nov 2006 at 9:42, novnov wrote:
> I will resort to ininstalling pgsql and reinstalling. I have to say
> that this aspect of pgsql is rather difficult to work with. Starting
> with why cube and g_cube modules are included by default and ending
> with the difficulty of manipulating template1..
I've tried to follow the instructions on the pgsql site for replacing
template1 with template0. It gets pretty complicated, because you can't
delete a template db, so you have to convert it to a non-template, then
delete, then proceed with the replacement. So, I did all of that and as far
as I cou
Milen A. Radev wrote:
I consider the decision to distinguish between functions and procedures
in pgAdmin's UI very unfortunate.
It's a historic thing - procedures actually appeared in early versions
of EnterpriseDB originally where they were considered different objects
from functions if mem
novnov написа:
> I am still very confused by pgsql's approach to functions vs procedures.
>
> In my testing using pgAdmin III, if I create both In and Out args it's
> listed as a proc. If I add only a In or only an Out, both are listed as
> functions and the args are 'gone'. Does that make sense?
I am still very confused by pgsql's approach to functions vs procedures.
In my testing using pgAdmin III, if I create both In and Out args it's
listed as a proc. If I add only a In or only an Out, both are listed as
functions and the args are 'gone'. Does that make sense?
I am puzzled by the fac
On 24 Nov 2006 at 18:59, novnov wrote:
> OK, thanks...and I take it that there is nothing about the cube
> functions that are inherently needed? I've never touched template1,
> this is an out of the box postgres 8.1 windows install.
I'm not aware of the the cube functions - others may know what
OK, thanks...and I take it that there is nothing about the cube functions
that are inherently needed? I've never touched template1, this is an out of
the box postgres 8.1 windows install.
Raymond O wrote:
>
> On 22 Nov 2006 at 17:21, novnov wrote:
>
>> Not sure this is a pgAdmin question eithe
On 22 Nov 2006 at 17:21, novnov wrote:
> Not sure this is a pgAdmin question either but why does pg seem to
> create a mass of cube and g_cube functions for each new db? They sure
> clutter up the place, but maybe they are needed by postgres?
It soundsas if one of the contrib modules may be load
Hi,
On Thursday 23 November 2006 02:21, novnov wrote:
| pgAdmin III is quite a nice tool but one thing I can't figure out is what
| the difference is between what pgAdmin calls a function and what it calls a
| procedure.
As of PostgreSQL-8.1 function arguments can be declared IN (default), OUT or
pgAdmin III is quite a nice tool but one thing I can't figure out is what the
difference is between what pgAdmin calls a function and what it calls a
procedure. They have almost the same properties in the edit dialog (but not
quite). I've looked in the postgres and pgAdmin help docs and there seem
15 matches
Mail list logo
