Thread: Fwd: Bug?
In pgAdmin III
I select one function from the Object browser and I can see source code in SQL Pane:
In psql:
nacer=# \df+ nacer.periodos;
List of functions
-[ RECORD 1 ]-------+-------------------------------------------------------------------------------------------------
Schema | nacer
Name | periodos
Result data type | TABLE(per_fecha timestamp without time zone)
Argument data types |
Type | normal
Volatility | volatile
Owner | postgres
Language | plpgsql
Source code |
| declare
| lts_minimo timestamp;
| lts_maximo timestamp;
| begin
| select max(periodo), min(periodo) into lts_maximo, lts_minimo from nacer.historicotemp;
| RETURN QUERY select * from generate_series(lts_minimo, lts_maximo,'1 month'::interval);
| end;
|
Description |
Attachment
Hi Dave and pgadmin team, how are you?First of all I want to thank you for the pgAdmin software, it's great.
I think I detected an error. The explanation Is here:In pgAdmin III
I select one function from the Object browser and I can see source code in SQL Pane:
In psql:
nacer=# \df+ nacer.periodos;
List of functions
-[ RECORD 1 ]-------+-------------------------------------------------------------------------------------------------
Schema | nacer
Name | periodos
Result data type | TABLE(per_fecha timestamp without time zone)
Argument data types |
Type | normal
Volatility | volatile
Owner | postgres
Language | plpgsql
Source code |
| declare
| lts_minimo timestamp;
| lts_maximo timestamp;
| begin
| select max(periodo), min(periodo) into lts_maximo, lts_minimo from nacer.historicotemp;
| RETURN QUERY select * from generate_series(lts_minimo, lts_maximo,'1 month'::interval);
| end;
|
Description |
I hope your comments.Sorry for my english.Guillermo VillanuevaSalta - Argentina
Attachment
On Wed, Apr 1, 2015 at 5:18 PM, Guillermo E. Villanueva <guillermovil@gmail.com> wrote:Hi Dave and pgadmin team, how are you?First of all I want to thank you for the pgAdmin software, it's great.I think I detected an error. The explanation Is here:In pgAdmin III
I select one function from the Object browser and I can see source code in SQL Pane:
In psql:
nacer=# \df+ nacer.periodos;
List of functions
-[ RECORD 1 ]-------+-------------------------------------------------------------------------------------------------
Schema | nacer
Name | periodos
Result data type | TABLE(per_fecha timestamp without time zone)
Argument data types |
Type | normal
Volatility | volatile
Owner | postgres
Language | plpgsql
Source code |
| declare
| lts_minimo timestamp;
| lts_maximo timestamp;
| begin
| select max(periodo), min(periodo) into lts_maximo, lts_minimo from nacer.historicotemp;
| RETURN QUERY select * from generate_series(lts_minimo, lts_maximo,'1 month'::interval);
| end;
|
Description |
I hope your comments.Sorry for my english.Guillermo VillanuevaSalta - Argentina
Attachment
S.O. client: Windows 7pgAdmin III: 1.20.0Server: win/lnx 9.0.13/9.0.5
Guillermo Villanueva2015-04-01 9:02 GMT-03:00 Ashesh Vashi <ashesh.vashi@enterprisedb.com>:On Wed, Apr 1, 2015 at 5:18 PM, Guillermo E. Villanueva <guillermovil@gmail.com> wrote:Hi Dave and pgadmin team, how are you?First of all I want to thank you for the pgAdmin software, it's great.I think I detected an error. The explanation Is here:In pgAdmin III
I select one function from the Object browser and I can see source code in SQL Pane:
In psql:
nacer=# \df+ nacer.periodos;
List of functions
-[ RECORD 1 ]-------+-------------------------------------------------------------------------------------------------
Schema | nacer
Name | periodos
Result data type | TABLE(per_fecha timestamp without time zone)
Argument data types |
Type | normal
Volatility | volatile
Owner | postgres
Language | plpgsql
Source code |
| declare
| lts_minimo timestamp;
| lts_maximo timestamp;
| begin
| select max(periodo), min(periodo) into lts_maximo, lts_minimo from nacer.historicotemp;
| RETURN QUERY select * from generate_series(lts_minimo, lts_maximo,'1 month'::interval);
| end;
|
Description |
I hope your comments.Sorry for my english.Guillermo VillanuevaSalta - Argentina
Attachment
Ashesh Vashi wrote: > On Wed, Apr 1, 2015 at 5:55 PM, Guillermo E. Villanueva < > guillermovil@gmail.com> wrote: > > > S.O. client: Windows 7 > > pgAdmin III: 1.20.0 > > Server: win/lnx 9.0.13/9.0.5 > > > Thanks for the information. > I will look into it. Did this ever result in a fix? -- Álvaro Herrera Developer, http://www.PostgreSQL.org/
<div dir="ltr">As far as I know this issue is not resolved yet at least in 1.20.0 pgadmin version and there is not any newversion available of this product. Am I right?<div class="gmail_extra"><br /><div class="gmail_quote">2015-08-11 13:26GMT-03:00 Alvaro Herrera <span dir="ltr"><<a href="mailto:alvherre@alvh.no-ip.org" target="_blank">alvherre@alvh.no-ip.org</a>></span>:<br/><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px#ccc solid;padding-left:1ex">Ashesh Vashi wrote:<br /> > On Wed, Apr 1, 2015 at 5:55 PM, GuillermoE. Villanueva <<br /> > <a href="mailto:guillermovil@gmail.com">guillermovil@gmail.com</a>> wrote:<br />><br /> > > S.O. client: Windows 7<br /> > > pgAdmin III: 1.20.0<br /> > > Server: win/lnx 9.0.13/9.0.5<br/> > ><br /> > Thanks for the information.<br /> > I will look into it.<br /><br /> Did this everresult in a fix?<br /><span class="HOEnZb"><font color="#888888"><br /><br /><br /> --<br /> Álvaro Herrera Developer, <a href="http://www.PostgreSQL.org/" rel="noreferrer" target="_blank">http://www.PostgreSQL.org/</a><br/></font></span></blockquote></div><br /></div></div>