Обсуждение: Fwd: Bug?

Поиск
Список
Период
Сортировка

Fwd: Bug?

От
"Guillermo E. Villanueva"
Дата:
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:

Imágenes integradas 1


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 Villanueva
Salta - Argentina

Вложения

Re: Fwd: Bug?

От
Ashesh Vashi
Дата:
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.
Version of pgAdmin?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi

 
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:

Imágenes integradas 1


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 Villanueva
Salta - Argentina


Вложения

Re: Fwd: Bug?

От
"Guillermo E. Villanueva"
Дата:
S.O. client: Windows 7
pgAdmin III: 1.20.0
Server: win/lnx 9.0.13/9.0.5

Guillermo Villanueva


2015-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.
Version of pgAdmin?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi

 
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:

Imágenes integradas 1


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 Villanueva
Salta - Argentina



Вложения

Re: Fwd: Bug?

От
Ashesh Vashi
Дата:

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.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



Guillermo Villanueva


2015-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.
Version of pgAdmin?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi

 
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:

Imágenes integradas 1


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 Villanueva
Salta - Argentina




Вложения

Re: Fwd: Bug?

От
Alvaro Herrera
Дата:
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/

Re: Fwd: Bug?

От
"Guillermo E. Villanueva"
Дата:
<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>