agora inbox for pgadmin-support@postgresql.org
help / color / mirror / Atom feedBug
30+ messages / 20 participants
[nested] [flat]
* Bug
@ 2003-11-10 08:55 =?Windows-1251?B?xOzo8vDo6SDP7u/u4g==?= <ibmpc@mail.ru>
0 siblings, 1 reply; 30+ messages in thread
From: Дмитрий Попов @ 2003-11-10 08:55 UTC (permalink / raw)
To: pgadmin-support
pgAdmin III, v1.0.0, pgSql 7.3.1 Windows Russian
Hello!
PostrgeSQL on windows make SuperUser's name symbols as current system
user. When user in windows include russian, PgSQL make user with
russian symbols too.
But pgAmin replace it to "_".
For Example: My user was "Dmitriy" (Дмитрий). There is PgSQL error:
'Uncknown user "_______"'.
I know, that russian usernames it's bad, but differnt other pgSQL
manager's (like EMS PostrgeSQL manager) work with russian names
correct.
P.S. Sorry for my English - i'm from Russia and speak English very
bad.
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Bug
@ 2003-11-10 23:55 Andreas Pflug <pgadmin@pse-consulting.de>
parent: =?Windows-1251?B?xOzo8vDo6SDP7u/u4g==?= <ibmpc@mail.ru>
0 siblings, 1 reply; 30+ messages in thread
From: Andreas Pflug @ 2003-11-10 23:55 UTC (permalink / raw)
To: Дмитрий Попов <ibmpc@mail.ru>; +Cc: pgadmin-support
Дмитрий Попов wrote:
>pgAdmin III, v1.0.0, pgSql 7.3.1 Windows Russian
>
>Hello!
>
>PostrgeSQL on windows make SuperUser's name symbols as current system
>user. When user in windows include russian, PgSQL make user with
>russian symbols too.
>But pgAmin replace it to "_".
>
>
>For Example: My user was "Dmitriy" (Дмитрий). There is PgSQL error:
>'Uncknown user "_______"'.
>
>I know, that russian usernames it's bad, but differnt other pgSQL
>manager's (like EMS PostrgeSQL manager) work with russian names
>correct.
>
>
>
>
>
Hi Dmitriy,
actually I didn't understand exactly what the problem is, so I'm
guessing that you got a conversion problem. Do you have SQL_ASCII as
database encoding? If yes, this is a problem, because Russian characters
are not ascii.
There are two options:
1) (the better option)
use UNICODE or the Russian encoding in the database.
2) Use a newer pgAdmin3 version, we have a new workaround for SQL_ASCII
databases with wrong characters.
Regards,
Andreas
>P.S. Sorry for my English - i'm from Russia and speak English very
>bad.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Bug
@ 2003-11-11 01:57 Hiroshi Saito <saito@inetrt.skcapi.co.jp>
parent: Andreas Pflug <pgadmin@pse-consulting.de>
0 siblings, 0 replies; 30+ messages in thread
From: Hiroshi Saito @ 2003-11-11 01:57 UTC (permalink / raw)
To: Andreas Pflug <pgadmin@pse-consulting.de>; Дмитрий Попов <ibmpc@mail.ru>; +Cc: pgadmin-support
Dear Дмитрий Попов .
I believe the reappearance of this problem.
IMHO,You must not use multi-byte for the user ID.
It seems you that it that a user was made under the condition of the multi-byte
connection is right by the intervention of conversion.
However,
The user character line won't correspond so far as conversion is never minded
at the time of the connection connection.
regards,
Hiroshi Saito
----- Original Message -----
From: "Andreas Pflug" <pgadmin@pse-consulting.de>
To: "Дмитрий Попов" <ibmpc@mail.ru>
Cc: <pgadmin-support@postgresql.org>
Sent: Tuesday, November 11, 2003 8:55 AM
Subject: Re: [pgadmin-support] Bug
> Дмитрий Попов wrote:
>
> >pgAdmin III, v1.0.0, pgSql 7.3.1 Windows Russian
> >
> >Hello!
> >
> >PostrgeSQL on windows make SuperUser's name symbols as current system
> >user. When user in windows include russian, PgSQL make user with
> >russian symbols too.
> >But pgAmin replace it to "_".
> >
> >
> >For Example: My user was "Dmitriy" (Дмитрий). There is PgSQL error:
> >'Uncknown user "_______"'.
> >
> >I know, that russian usernames it's bad, but differnt other pgSQL
> >manager's (like EMS PostrgeSQL manager) work with russian names
> >correct.
> >
> >
> >
> >
> >
> Hi Dmitriy,
>
> actually I didn't understand exactly what the problem is, so I'm
> guessing that you got a conversion problem. Do you have SQL_ASCII as
> database encoding? If yes, this is a problem, because Russian characters
> are not ascii.
> There are two options:
>
> 1) (the better option)
> use UNICODE or the Russian encoding in the database.
>
> 2) Use a newer pgAdmin3 version, we have a new workaround for SQL_ASCII
> databases with wrong characters.
>
> Regards,
> Andreas
>
> >P.S. Sorry for my English - i'm from Russia and speak English very
> >bad.
> >
^ permalink raw reply [nested|flat] 30+ messages in thread
* bug?
@ 2004-01-10 05:05 gary <gary@virtrail.com>
0 siblings, 0 replies; 30+ messages in thread
From: gary @ 2004-01-10 05:05 UTC (permalink / raw)
To: pgadmin-support
hi,
i have succesfully migrated the MSSQL database to postgresql using
the database migration wizard of pgadmin. is there a way to disable the
naming modification during the migration process.
.for example, all the foreign key is append with the string '_fk' . And
one thing i notice is that if my MSSQL index name contain the string
'name' eg IX_UC_Community_name, migration will rename it to
IX_UC_Community_-0
great software though!
thanks
gary
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: bug?
@ 2004-01-11 10:48 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 30+ messages in thread
From: Dave Page @ 2004-01-11 10:48 UTC (permalink / raw)
To: gary <gary@virtrail.com>; pgadmin-support
Hi Gary,
> -----Original Message-----
> From: gary [mailto:gary@virtrail.com]
> Sent: 10 January 2004 05:05
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] bug?
>
> hi,
> i have succesfully migrated the MSSQL database to
> postgresql using the database migration wizard of pgadmin. is
> there a way to disable the naming modification during the
> migration process.
> .for example, all the foreign key is append with the string
> '_fk' .
No, I'm afraid this is not possible unless you can modify the code
yourself.
> And one thing i notice is that if my MSSQL index name
> contain the string 'name' eg IX_UC_Community_name, migration
> will rename it to IX_UC_Community_-0
The algorithm actually creates the name as:
<tablename>_<indexname>_idx-<num>
However the <tablename>_<indexname> section is truncated to a maximum of
26 characters. There are various historical reasons for this - mainly it
is to ensure that the name is both unique across the database, not too
long (for older versions of PostgreSQL), and vaguely useful. Again
though, you cannot modify this behaviour without changing the code.
> great software though!
Thanks!
Regards, Dave.
^ permalink raw reply [nested|flat] 30+ messages in thread
* Bug
@ 2004-10-08 01:25 Tony Caduto <tony.caduto@amsoftwaredesign.com>
0 siblings, 1 reply; 30+ messages in thread
From: Tony Caduto @ 2004-10-08 01:25 UTC (permalink / raw)
To: pgadmin-support
When creating a new function if you select the owner, and in my case the
only one available in the picklist is postgres, the function will fail to
create.
To reproduce, just pick a owner name and then try to create the function.
It works fine if you leave it blank, but for many new users who don't know
this it causes problems. I had a developer who works with me spend a hour
trying to get his function to work until he finally ask for help.
Thanks,
TC
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Bug
@ 2004-10-08 10:41 Andreas Pflug <pgadmin@pse-consulting.de>
parent: Tony Caduto <tony.caduto@amsoftwaredesign.com>
0 siblings, 0 replies; 30+ messages in thread
From: Andreas Pflug @ 2004-10-08 10:41 UTC (permalink / raw)
To: Tony Caduto <tony.caduto@amsoftwaredesign.com>; +Cc: pgadmin-support
Tony Caduto wrote:
> When creating a new function if you select the owner, and in my case the
> only one available in the picklist is postgres, the function will fail to
> create.
> To reproduce, just pick a owner name and then try to create the function.
I can't reproduce this on 8.0.
Apparently owner isn't supported on older versions, I'll change pgAdmin
accordingly.
Regards,
Andreas
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: BUG
@ 2004-10-21 14:36 Andreas Pflug <pgadmin@pse-consulting.de>
parent: yoursoft@freemail.hu <yoursoft@freemail.hu>
0 siblings, 0 replies; 30+ messages in thread
From: Andreas Pflug @ 2004-10-21 14:36 UTC (permalink / raw)
To: yoursoft@freemail.hu <yoursoft@freemail.hu>; +Cc: pgadmin-support
yoursoft@freemail.hu wrote:
> An fk key definition:
> ALTER TABLE xtable
> ADD CONSTRAINT cvbcbvc FOREIGN KEY (kod) REFERENCES ytable (kod) ON
> UPDATE DEFAULT ON DELETE SET NULL;
Here's the reason: it should read ON UPDATE SET DEFAULT, not just
DEFAULT. Since the reverse engineered string was wrong, so was the dialog.
Fixed in CVS, thanks for reporting.
Regards,
Andreas
^ permalink raw reply [nested|flat] 30+ messages in thread
* BUG
@ 2004-10-21 20:11 yoursoft@freemail.hu <yoursoft@freemail.hu>
0 siblings, 1 reply; 30+ messages in thread
From: yoursoft@freemail.hu @ 2004-10-21 20:11 UTC (permalink / raw)
To: pgadmin-support
Dear List!
My Platform is: WinXp
My versions: All Binary Snapsots to 20041016; Version 1.1
Try the following:
1.
create tables:
CREATE TABLE ytable
(
kod varchar(30) NOT NULL
);
CREATE TABLE xtable
(
kod varchar(30) NOT NULL
);
An fk key definition:
ALTER TABLE xtable
ADD CONSTRAINT cvbcbvc FOREIGN KEY (kod) REFERENCES ytable (kod) ON
UPDATE DEFAULT ON DELETE SET NULL;
2. View it in pgAdmin:
Browse in left object tree to the 'xtable' / Constarins / 'cvbcbvc'.
Select 'Properties' / Action tab.
The 'On update' radio button group will be wrong value: 'RESTRICT' (
I think the good value is: 'SET DELETE').
Best Regards:
Ferenc
^ permalink raw reply [nested|flat] 30+ messages in thread
* bug?
@ 2004-12-01 08:34 s.marcantonio@libero.it <s.marcantonio@libero.it>
0 siblings, 0 replies; 30+ messages in thread
From: s.marcantonio@libero.it @ 2004-12-01 08:34 UTC (permalink / raw)
To: pgadmin-support
Hallo!
when i tray to start pgadmin3, this is the message:
pgadmin3: symbol lookup error: pgadmin3: undefined symbol:
_gtk_accel_group_attach
thanks.
Peppe.
____________________________________________________________
Libero ADSL: navighi gratis a 1.2 Mega, senza canone e costi di attivazione.
Abbonati subito su http://www.libero.it
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: bug?
@ 2004-12-02 08:42 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 30+ messages in thread
From: Dave Page @ 2004-12-02 08:42 UTC (permalink / raw)
To: s.marcantonio@libero.it; pgadmin-support
> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> s.marcantonio@libero.it
> Sent: 01 December 2004 08:35
> To: pgadmin-support
> Subject: [pgadmin-support] bug?
>
> Hallo!
> when i tray to start pgadmin3, this is the message:
>
> pgadmin3: symbol lookup error: pgadmin3: undefined symbol:
> _gtk_accel_group_attach
>
What OS are you on? Are you using a binary installation?
This bug is caused by an old version of GTK - perhaps you are running an
FC3 RPM on FC1 or something similar?
Regards, Dave.
^ permalink raw reply [nested|flat] 30+ messages in thread
* BUG
@ 2012-03-09 22:15 Cecil Eduardo Campos Costa <cecilcosta@yahoo.com>
0 siblings, 1 reply; 30+ messages in thread
From: Cecil Eduardo Campos Costa @ 2012-03-09 22:15 UTC (permalink / raw)
To: pgadmin-support
Just want to submit a issue: open bracket and open brace doesnt work with Spanish keyboard on macintosh, even with the lastest version
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: BUG
@ 2012-03-09 23:04 Guillaume Lelarge <guillaume@lelarge.info>
parent: Cecil Eduardo Campos Costa <cecilcosta@yahoo.com>
0 siblings, 1 reply; 30+ messages in thread
From: Guillaume Lelarge @ 2012-03-09 23:04 UTC (permalink / raw)
To: Cecil Eduardo Campos Costa <cecilcosta@yahoo.com>; +Cc: pgadmin-support
On Fri, 2012-03-09 at 14:15 -0800, Cecil Eduardo Campos Costa wrote:
> Just want to submit a issue: open bracket and open brace doesnt work with Spanish keyboard on macintosh, even with the lastest version
Can you be more specific?
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: BUG
@ 2012-03-10 13:47 Guillaume Lelarge <guillaume@lelarge.info>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 30+ messages in thread
From: Guillaume Lelarge @ 2012-03-10 13:47 UTC (permalink / raw)
To: Cecil Eduardo Campos Costa <cecilcosta@yahoo.com>; +Cc: pgadmin-support
On Fri, 2012-03-09 at 15:14 -0800, Cecil Eduardo Campos Costa wrote:
> When I open a query window and type a open brace ({) or a open bracket
> ([) it doesnt work with the spanish keyboard in Macintosh, so I have
> to type in a separated editor and then copy and paste it.
> I use PGAdmin from 3 or 4 years ago and with different mac os x
> (leopard, snow leopard, etc...) and those keys never worked in those
> environments.
>
>
Works for me but I don't own a spanish keyboard. It seems related to
this issue (http://trac.wxwidgets.org/ticket/9663), IOW a wxWidgets
issue. Unfortunately, I'm not sure we can do something about it.
PS: keep the replies to the list and, please, don't top-post.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
^ permalink raw reply [nested|flat] 30+ messages in thread
* Fwd: Bug?
@ 2015-04-01 11:48 Guillermo E. Villanueva <guillermovil@gmail.com>
0 siblings, 1 reply; 30+ messages in thread
From: Guillermo E. Villanueva @ 2015-04-01 11:48 UTC (permalink / raw)
To: pgadmin-support
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:
[image: 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
Attachments:
[image/png] image.png (74.9K, ../../CANm+PCCehFbbCZL3QF47kR_VOrFSLHf6o8M1e3HHfLO9qhbneg@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Fwd: Bug?
@ 2015-04-01 12:02 Ashesh Vashi <ashesh.vashi@enterprisedb.com>
parent: Guillermo E. Villanueva <guillermovil@gmail.com>
0 siblings, 1 reply; 30+ messages in thread
From: Ashesh Vashi @ 2015-04-01 12:02 UTC (permalink / raw)
To: Guillermo E. Villanueva <guillermovil@gmail.com>; +Cc: pgadmin-support
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.enterprisedb.com;
*http://www.linkedin.com/in/asheshvashi*
<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:
>
> [image: 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
>
>
Attachments:
[image/png] image.png (74.9K, ../../CAG7mmowFf9XHph1Vs-2vj_ACta96Rao9pj0Qcxrt3dwjpbWJ7w@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Fwd: Bug?
@ 2015-04-01 12:25 Guillermo E. Villanueva <guillermovil@gmail.com>
parent: Ashesh Vashi <ashesh.vashi@enterprisedb.com>
0 siblings, 1 reply; 30+ messages in thread
From: Guillermo E. Villanueva @ 2015-04-01 12:25 UTC (permalink / raw)
To: Ashesh Vashi <ashesh.vashi@enterprisedb.com>; +Cc: pgadmin-support
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.enterprisedb.com;
>
>
> *http://www.linkedin.com/in/asheshvashi*
> <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:
>>
>> [image: 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
>>
>>
>
Attachments:
[image/png] image.png (74.9K, ../../CANm+PCBTc=t1NV5GV-cE1kQuuUg9w=W-6i563Fx19PiJmrdT1w@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Fwd: Bug?
@ 2015-04-07 04:52 Ashesh Vashi <ashesh.vashi@enterprisedb.com>
parent: Guillermo E. Villanueva <guillermovil@gmail.com>
0 siblings, 1 reply; 30+ messages in thread
From: Ashesh Vashi @ 2015-04-07 04:52 UTC (permalink / raw)
To: Guillermo E. Villanueva <guillermovil@gmail.com>; +Cc: pgadmin-support
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
<http://www.enterprisedb.com/;
*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi;
>
> 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.enterprisedb.com;
>>
>>
>> *http://www.linkedin.com/in/asheshvashi*
>> <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:
>>>
>>> [image: 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
>>>
>>>
>>
>
Attachments:
[image/png] image.png (74.9K, ../../CAG7mmoxNYsnVRhO3fhnAhEELBWUa6wyk_404gSnOFim+vKK7MQ@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* bug
@ 2015-04-15 07:36 Nico Bosua <nico.bosua@gmail.com>
0 siblings, 0 replies; 30+ messages in thread
From: Nico Bosua @ 2015-04-15 07:36 UTC (permalink / raw)
To: pgadmin-support
Hi,
I am having an issue with pgAdmin 3 making it literally unusable to me.
I'm connecting to a remote server using SSH tunnel. I can connect to the
server fine and retrieve the design no problems.
As soon as I click on the SQL Editor button the pgAdmin client crashes.
Sometimes it does open the Editor but as soon as I open my sql script
file it looses the connection to the server. Then I need to connect
again and then it crashes.
# Platform you're running on - Windows 8.1 64bit
# Language - ??
# Distribution you used (source tarball, or binary) - Windows Installer
# Version you tested - 1.20
# If possible and appropriate, include a backtrace from the crash. You may
need to recompile wxWidgets and pgAdmin with the --enable-debug option
to do this.- see screen grabs below;
I have tried reinstalling the Microsoft visual c++ 2013 distribution
file but made no difference.
Please assist me in resolving this.
Thanks,
Nico Bosua
Attachments:
[image/png] image.png (6.8K, ../../552E1515.2070501@gmail.com/3-image.png)
download | view image
[image/png] image.png (13.8K, ../../552E1515.2070501@gmail.com/4-image.png)
download | view image
[image/png] image.png (69.7K, ../../552E1515.2070501@gmail.com/5-image.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Fwd: Bug?
@ 2015-08-11 16:26 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Ashesh Vashi <ashesh.vashi@enterprisedb.com>
0 siblings, 1 reply; 30+ messages in thread
From: Alvaro Herrera @ 2015-08-11 16:26 UTC (permalink / raw)
To: Ashesh Vashi <ashesh.vashi@enterprisedb.com>; +Cc: Guillermo E. Villanueva <guillermovil@gmail.com>; pgadmin-support
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/
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Fwd: Bug?
@ 2015-08-12 14:40 Guillermo E. Villanueva <guillermovil@gmail.com>
parent: Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 0 replies; 30+ messages in thread
From: Guillermo E. Villanueva @ 2015-08-12 14:40 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: Ashesh Vashi <ashesh.vashi@enterprisedb.com>; pgadmin-support
As far as I know this issue is not resolved yet at least in 1.20.0 pgadmin
version and there is not any new version available of this product. Am I
right?
2015-08-11 13:26 GMT-03:00 Alvaro Herrera <alvherre@alvh.no-ip.org>:
> 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/
>
^ permalink raw reply [nested|flat] 30+ messages in thread
* Bug
@ 2019-06-25 09:47 Faran Ali <faran.ali@purelogics.net>
0 siblings, 2 replies; 30+ messages in thread
From: Faran Ali @ 2019-06-25 09:47 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
Hi,
*pgAdmin: *v4.8
*OS: *Tried on Ubuntu 19.04/18.10/18.04
*Server Mode: *True
*Python: *Tried Python 3.5/3.6/3.7/3.8
I've Installed pgAdmin from APT repository and while others can get it to
work simply I get an error in the screen attached below whenever I try to
take a backup or restore from pgAdmin
[image: image.png]
Please let me know if you need anything else.
Regards,
Faran.
Attachments:
[image/png] image.png (66.0K, ../../CADM9EruJ-uq_8QkQLJSWn9Opte9mhM4+KpL-qrNcLouGdgeAkA@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Bug
@ 2019-06-25 09:59 Fahar Abbas <fahar.abbas@enterprisedb.com>
parent: Faran Ali <faran.ali@purelogics.net>
1 sibling, 1 reply; 30+ messages in thread
From: Fahar Abbas @ 2019-06-25 09:59 UTC (permalink / raw)
To: Faran Ali <faran.ali@purelogics.net>; Christoph Berg <myon@debian.org>; +Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Adding pgadmin-support@lists.postgresql.org email and Removing pgsql-bugs
email.
Hi Faran!
Can you please share the pgadmin4.log file as well?
Kind regards,
On Tue, Jun 25, 2019 at 2:47 PM Faran Ali <faran.ali@purelogics.net> wrote:
> Hi,
> *pgAdmin: *v4.8
> *OS: *Tried on Ubuntu 19.04/18.10/18.04
> *Server Mode: *True
> *Python: *Tried Python 3.5/3.6/3.7/3.8
>
> I've Installed pgAdmin from APT repository and while others can get it to
> work simply I get an error in the screen attached below whenever I try to
> take a backup or restore from pgAdmin
> [image: image.png]
>
> Please let me know if you need anything else.
>
> Regards,
> Faran.
>
--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com
Attachments:
[image/png] image.png (66.0K, ../../CAJFwRrOM6Q+uK_9Qmps-kpQxJ7he5yXZbN0JO+HitJpG7WGq3w@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Bug
@ 2019-06-25 10:05 Christoph Berg <myon@debian.org>
parent: Fahar Abbas <fahar.abbas@enterprisedb.com>
0 siblings, 2 replies; 30+ messages in thread
From: Christoph Berg @ 2019-06-25 10:05 UTC (permalink / raw)
To: Fahar Abbas <fahar.abbas@enterprisedb.com>; +Cc: Faran Ali <faran.ali@purelogics.net>; pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Re: Fahar Abbas 2019-06-25 <CAJFwRrOM6Q+uK_9Qmps-kpQxJ7he5yXZbN0JO+HitJpG7WGq3w@mail.gmail.com>
> > I've Installed pgAdmin from APT repository and while others can get it to
> > work simply I get an error in the screen attached below whenever I try to
> > take a backup or restore from pgAdmin
That's https://redmine.postgresql.org/issues/4088
The packages use python3, and I haven't yet told the pgadmin4 backup
machinery to do that as well. (At least that's what I think the
problem is, haven't investigated yet.)
Christoph
^ permalink raw reply [nested|flat] 30+ messages in thread
* Fwd: Bug
@ 2019-06-25 10:12 Faran Ali <faran.ali@purelogics.net>
parent: Christoph Berg <myon@debian.org>
1 sibling, 0 replies; 30+ messages in thread
From: Faran Ali @ 2019-06-25 10:12 UTC (permalink / raw)
To: fahar.abbas@enterprisedb.com; +Cc: Christoph Berg <myon@debian.org>; pgadmin-support@lists.postgresql.org
---------- Forwarded message ---------
From: Faran Ali <faran.ali@purelogics.net>
Date: Tue, Jun 25, 2019 at 3:08 PM
Subject: Re: Bug
To: Christoph Berg <myon@debian.org>
Hi,
Please find the log attached below
Regards,
Faran.
On Tue, Jun 25, 2019 at 3:05 PM Christoph Berg <myon@debian.org> wrote:
> Re: Fahar Abbas 2019-06-25 <
> CAJFwRrOM6Q+uK_9Qmps-kpQxJ7he5yXZbN0JO+HitJpG7WGq3w@mail.gmail.com>
> > > I've Installed pgAdmin from APT repository and while others can get it
> to
> > > work simply I get an error in the screen attached below whenever I try
> to
> > > take a backup or restore from pgAdmin
>
> That's https://redmine.postgresql.org/issues/4088
>
> The packages use python3, and I haven't yet told the pgadmin4 backup
> machinery to do that as well. (At least that's what I think the
> problem is, haven't investigated yet.)
>
> Christoph
>
Attachments:
[application/octet-stream] pgadmin.log (1.6K, ../../CADM9Eru4Qau9HAgY62sikKawnuAhiKWTUqE9UB-ppY-RN1PRug@mail.gmail.com/3-pgadmin.log)
download
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Bug
@ 2019-06-26 02:01 Michael Paquier <michael@paquier.xyz>
parent: Faran Ali <faran.ali@purelogics.net>
1 sibling, 0 replies; 30+ messages in thread
From: Michael Paquier @ 2019-06-26 02:01 UTC (permalink / raw)
To: Faran Ali <faran.ali@purelogics.net>; +Cc: pgsql-bugs@lists.postgresql.org
On Tue, Jun 25, 2019 at 02:47:07PM +0500, Faran Ali wrote:
> I've Installed pgAdmin from APT repository and while others can get it to
> work simply I get an error in the screen attached below whenever I try to
> take a backup or restore from pgAdmin
> [image: image.png]
You may want to contact the pgadmin crew here:
https://www.pgadmin.org/support/list/
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../../20190626020125.GD1714@paquier.xyz/2-signature.asc)
download
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: Bug
@ 2019-06-26 13:32 Christoph Berg <myon@debian.org>
parent: Christoph Berg <myon@debian.org>
1 sibling, 0 replies; 30+ messages in thread
From: Christoph Berg @ 2019-06-26 13:32 UTC (permalink / raw)
To: Fahar Abbas <fahar.abbas@enterprisedb.com>; +Cc: Faran Ali <faran.ali@purelogics.net>; pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Re: To Fahar Abbas 2019-06-25 <20190625100525.GA11330@msg.df7cb.de>
> That's https://redmine.postgresql.org/issues/4088
>
> The packages use python3, and I haven't yet told the pgadmin4 backup
> machinery to do that as well. (At least that's what I think the
> problem is, haven't investigated yet.)
Could you try the 4.8-3 packages I uploaded some hours ago?
Christoph
^ permalink raw reply [nested|flat] 30+ messages in thread
* bug
@ 2026-06-20 09:28 Виктор Надточий <victor.nadtochy@gmail.com>
0 siblings, 1 reply; 30+ messages in thread
From: Виктор Надточий @ 2026-06-20 09:28 UTC (permalink / raw)
To: pgadmin-support@lists.postgresql.org
pgadmin4-9.16-x64.exe
<https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v9.16/windows/pgadmin4-9.16-x64.exe;
2026-06-18
12:04:12
for Windows
PostgreSQL 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit
[image: изображение.png]
[image: изображение.png]
Attachments:
[image/png] изображение.png (84.4K, ../../CACNUSTbtB9gKMjJmyvaArdD1A0Tu4BLcxP9LReA=YCju3=aVbQ@mail.gmail.com/3-%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png)
download | view image
[image/png] изображение.png (12.5K, ../../CACNUSTbtB9gKMjJmyvaArdD1A0Tu4BLcxP9LReA=YCju3=aVbQ@mail.gmail.com/4-%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: bug
@ 2026-06-22 17:50 Ashesh Vashi <ashesh.vashi@enterprisedb.com>
parent: Виктор Надточий <victor.nadtochy@gmail.com>
0 siblings, 1 reply; 30+ messages in thread
From: Ashesh Vashi @ 2026-06-22 17:50 UTC (permalink / raw)
To: Виктор Надточий <victor.nadtochy@gmail.com>; +Cc: pgadmin-support@lists.postgresql.org
PostgreSQL 12 was EOL a long time ago, and not supported by pgAdmin 9.16.
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com;
*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi;
On Mon, Jun 22, 2026 at 9:09 PM Виктор Надточий <victor.nadtochy@gmail.com>
wrote:
> pgadmin4-9.16-x64.exe
> <https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v9.16/windows/pgadmin4-9.16-x64.exe; 2026-06-18
> 12:04:12
> for Windows
> PostgreSQL 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4) on x86_64-pc-linux-gnu,
> compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit
>
> [image: изображение.png]
>
> [image: изображение.png]
>
>
>
Attachments:
[image/png] изображение.png (84.4K, ../../CAG7mmoyxHToQdAzq5YQwsHtpKVTn_8PDmy9dsXsazBHmBSzoTA@mail.gmail.com/3-%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png)
download | view image
[image/png] изображение.png (12.5K, ../../CAG7mmoyxHToQdAzq5YQwsHtpKVTn_8PDmy9dsXsazBHmBSzoTA@mail.gmail.com/4-%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
* Re: bug
@ 2026-06-23 04:54 Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
parent: Ashesh Vashi <ashesh.vashi@enterprisedb.com>
0 siblings, 0 replies; 30+ messages in thread
From: Aditya Toshniwal @ 2026-06-23 04:54 UTC (permalink / raw)
To: Ashesh Vashi <ashesh.vashi@enterprisedb.com>; +Cc: Виктор Надточий <victor.nadtochy@gmail.com>; pgadmin-support@lists.postgresql.org
Adding to what Ahesh said - you can check versions supported in the release
notes
https://www.pgadmin.org/docs/pgadmin4/9.16/release_notes_9_16.html#supported-database-servers
On Mon, Jun 22, 2026 at 11:20 PM Ashesh Vashi <ashesh.vashi@enterprisedb.com>
wrote:
> PostgreSQL 12 was EOL a long time ago, and not supported by pgAdmin 9.16.
>
>
> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company
> <http://www.enterprisedb.com;
>
>
> *http://www.linkedin.com/in/asheshvashi*
> <http://www.linkedin.com/in/asheshvashi;
>
>
> On Mon, Jun 22, 2026 at 9:09 PM Виктор Надточий <victor.nadtochy@gmail.com>
> wrote:
>
>> pgadmin4-9.16-x64.exe
>> <https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v9.16/windows/pgadmin4-9.16-x64.exe; 2026-06-18
>> 12:04:12
>> for Windows
>> PostgreSQL 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4) on x86_64-pc-linux-gnu,
>> compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit
>>
>> [image: изображение.png]
>>
>> [image: изображение.png]
>>
>>
>>
--
Thanks,
Aditya Toshniwal
Sr. Staff SDE II | *enterprisedb.com* <https://www.enterprisedb.com/;
"Don't Complain about Heat, Plant a TREE"
Attachments:
[image/png] изображение.png (84.4K, ../../CAM9w-_=mnf8S8Q2On0WRahvOWdNekK_mWDV27yPMUz977w55sw@mail.gmail.com/3-%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png)
download | view image
[image/png] изображение.png (12.5K, ../../CAM9w-_=mnf8S8Q2On0WRahvOWdNekK_mWDV27yPMUz977w55sw@mail.gmail.com/4-%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png)
download | view image
^ permalink raw reply [nested|flat] 30+ messages in thread
end of thread, other threads:[~2026-06-23 04:54 UTC | newest]
Thread overview: 30+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-10 08:55 Bug =?Windows-1251?B?xOzo8vDo6SDP7u/u4g==?= <ibmpc@mail.ru>
2003-11-10 23:55 ` Andreas Pflug <pgadmin@pse-consulting.de>
2003-11-11 01:57 ` Hiroshi Saito <saito@inetrt.skcapi.co.jp>
2004-01-10 05:05 bug? gary <gary@virtrail.com>
2004-01-11 10:48 Re: bug? Dave Page <dpage@vale-housing.co.uk>
2004-10-08 01:25 Bug Tony Caduto <tony.caduto@amsoftwaredesign.com>
2004-10-08 10:41 ` Andreas Pflug <pgadmin@pse-consulting.de>
2004-10-21 20:11 BUG yoursoft@freemail.hu <yoursoft@freemail.hu>
2004-10-21 14:36 ` Re: BUG Andreas Pflug <pgadmin@pse-consulting.de>
2004-12-01 08:34 bug? s.marcantonio@libero.it <s.marcantonio@libero.it>
2004-12-02 08:42 Re: bug? Dave Page <dpage@vale-housing.co.uk>
2012-03-09 22:15 BUG Cecil Eduardo Campos Costa <cecilcosta@yahoo.com>
2012-03-09 23:04 ` Re: BUG Guillaume Lelarge <guillaume@lelarge.info>
2012-03-10 13:47 ` Re: BUG Guillaume Lelarge <guillaume@lelarge.info>
2015-04-01 11:48 Fwd: Bug? Guillermo E. Villanueva <guillermovil@gmail.com>
2015-04-01 12:02 ` Re: Fwd: Bug? Ashesh Vashi <ashesh.vashi@enterprisedb.com>
2015-04-01 12:25 ` Re: Fwd: Bug? Guillermo E. Villanueva <guillermovil@gmail.com>
2015-04-07 04:52 ` Re: Fwd: Bug? Ashesh Vashi <ashesh.vashi@enterprisedb.com>
2015-08-11 16:26 ` Re: Fwd: Bug? Alvaro Herrera <alvherre@alvh.no-ip.org>
2015-08-12 14:40 ` Re: Fwd: Bug? Guillermo E. Villanueva <guillermovil@gmail.com>
2015-04-15 07:36 bug Nico Bosua <nico.bosua@gmail.com>
2019-06-25 09:47 Bug Faran Ali <faran.ali@purelogics.net>
2019-06-25 09:59 ` Fahar Abbas <fahar.abbas@enterprisedb.com>
2019-06-25 10:05 ` Christoph Berg <myon@debian.org>
2019-06-25 10:12 ` Faran Ali <faran.ali@purelogics.net>
2019-06-26 13:32 ` Christoph Berg <myon@debian.org>
2019-06-26 02:01 ` Michael Paquier <michael@paquier.xyz>
2026-06-20 09:28 bug Виктор Надточий <victor.nadtochy@gmail.com>
2026-06-22 17:50 ` Re: bug Ashesh Vashi <ashesh.vashi@enterprisedb.com>
2026-06-23 04:54 ` Re: bug Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox