Lists: | pgadmin-support |
---|
From: | Marcin Stępnicki <mstepnicki(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | aggregates' INITCOND='' doesn't display in SQL pane |
Date: | 2009-02-27 13:42:40 |
Message-ID: | 179149fe0902270542v4ba8e2a1xf934446c26426ce1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-support |
Hello.
Let's create a simple, not very useful function and aggregate:
create or replace function strcat_pipe(text, text)
returns text as
$$
begin
if $1 = '' then
return $2;
else
return ( $1 || '| ' ) || $2;
end if;
end;
$$ language plpgsql volatile;
create aggregate str_sum_pipe(text) (
SFUNC=strcat_pipe,
STYPE=text,
INITCOND = 'aaa'
);
Now, click on created aggregate and select CREATE SCRIPT. Change the
INITCOND to ''. Save, refresh and look at SQL Pane again. The INITCOND
is missing, which in this particular case means that our aggregate
will always return NULL.
pgAdmin III v. 1.8.2, rev 7032 from Ubuntu 8.04 + PostgreSQL 8.2.11.
Is it a bug or me doing something wrong?
Regards,
Marcin
From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Marcin Stępnicki <mstepnicki(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: aggregates' INITCOND='' doesn't display in SQL pane |
Date: | 2009-02-27 15:06:23 |
Message-ID: | 937d27e10902270706u3ae6dee8m7821f3235332b018@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-support |
On Fri, Feb 27, 2009 at 1:42 PM, Marcin Stępnicki <mstepnicki(at)gmail(dot)com> wrote:
> Now, click on created aggregate and select CREATE SCRIPT. Change the
> INITCOND to ''. Save, refresh and look at SQL Pane again. The INITCOND
> is missing, which in this particular case means that our aggregate
> will always return NULL.
>
> pgAdmin III v. 1.8.2, rev 7032 from Ubuntu 8.04 + PostgreSQL 8.2.11.
>
> Is it a bug or me doing something wrong?
It's a bug - which is now fixed for the next release.
Thanks!
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
From: | Mark Pierce <xfree143(at)hotmail(dot)com> |
---|---|
To: | <dpage(at)pgadmin(dot)org>, <mstepnicki(at)gmail(dot)com> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: aggregates' INITCOND='' doesn't display in SQL pane |
Date: | 2009-02-27 15:47:46 |
Message-ID: | BAY110-W11D4A190CBF0C8784A5AB495AA0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-support |
I am a newbe with PostgreSQL and with pgAdmin so bare with me please. Below you list the steps to fix this issue but I need the steps before the "Now, click on created aggregate..." I can not locate this.
Also I am very impressed with the response time for this help request!
Mark
> Date: Fri, 27 Feb 2009 15:06:23 +0000
> Subject: Re: [pgadmin-support] aggregates' INITCOND='' doesn't display in SQL pane
> From: dpage(at)pgadmin(dot)org
> To: mstepnicki(at)gmail(dot)com
> CC: pgadmin-support(at)postgresql(dot)org
>
> On Fri, Feb 27, 2009 at 1:42 PM, Marcin Stępnicki <mstepnicki(at)gmail(dot)com> wrote:
>
> > Now, click on created aggregate and select CREATE SCRIPT. Change the
> > INITCOND to ''. Save, refresh and look at SQL Pane again. The INITCOND
> > is missing, which in this particular case means that our aggregate
> > will always return NULL.
> >
> > pgAdmin III v. 1.8.2, rev 7032 from Ubuntu 8.04 + PostgreSQL 8.2.11.
> >
> > Is it a bug or me doing something wrong?
>
> It's a bug - which is now fixed for the next release.
>
> Thanks!
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Mark Pierce <xfree143(at)hotmail(dot)com> |
Cc: | mstepnicki(at)gmail(dot)com, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: aggregates' INITCOND='' doesn't display in SQL pane |
Date: | 2009-02-27 15:53:12 |
Message-ID: | 937d27e10902270753p446a1a47w5b9892ac7fb5afbe@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-support |
2009/2/27 Mark Pierce <xfree143(at)hotmail(dot)com>:
> I am a newbe with PostgreSQL and with pgAdmin so bare with me please. Below
> you list the steps to fix this issue but I need the steps before the "Now,
> click on created aggregate..." I can not locate this.
http://archives.postgresql.org/pgadmin-support/2009-02/msg00042.php
> Also I am very impressed with the response time for this help request!
We aim to please :-)
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
From: | Marcin Stępnicki <mstepnicki(at)gmail(dot)com> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: aggregates' INITCOND='' doesn't display in SQL pane |
Date: | 2009-03-01 22:57:03 |
Message-ID: | 179149fe0903011457i49fab857y7c0938001d836743@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-support |
2009/2/27 Dave Page <dpage(at)pgadmin(dot)org>:
>
> It's a bug - which is now fixed for the next release.
Thank you very much. The world has now become a better place ;-)
Regards,
Marcin