public inbox for [email protected]  
help / color / mirror / Atom feed
Bug
14+ messages / 12 participants
[nested] [flat]

* Bug
@ 2003-11-10 08:55  =?Windows-1251?B?xOzo8vDo6SDP7u/u4g==?= <[email protected]>
  0 siblings, 1 reply; 14+ messages in thread

From: =?Windows-1251?B?xOzo8vDo6SDP7u/u4g==?= @ 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] 14+ messages in thread

* Re: Bug
@ 2003-11-10 23:55  Andreas Pflug <[email protected]>
  parent: =?Windows-1251?B?xOzo8vDo6SDP7u/u4g==?= <[email protected]>
  0 siblings, 1 reply; 14+ messages in thread

From: Andreas Pflug @ 2003-11-10 23:55 UTC (permalink / raw)
  To: =?windows-1251?Q?=C4=EC=E8=F2=F0=E8=E9_=CF=EE=EF=EE=E2?= <[email protected]>; +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] 14+ messages in thread

* Re: Bug
@ 2003-11-11 01:57  Hiroshi Saito <[email protected]>
  parent: Andreas Pflug <[email protected]>
  0 siblings, 0 replies; 14+ messages in thread

From: Hiroshi Saito @ 2003-11-11 01:57 UTC (permalink / raw)
  To: Andreas Pflug <[email protected]>; =?Windows-1251?B?xOzo8vDo6SDP7u/u4g==?= <[email protected]>; +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" <[email protected]>
To: "Дмитрий Попов" <[email protected]>
Cc: <[email protected]>
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] 14+ messages in thread

* bug?
@ 2004-01-10 05:05  gary <[email protected]>
  0 siblings, 0 replies; 14+ 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] 14+ messages in thread

* Re: bug?
@ 2004-01-11 10:48  Dave Page <[email protected]>
  0 siblings, 0 replies; 14+ messages in thread

From: Dave Page @ 2004-01-11 10:48 UTC (permalink / raw)
  To: gary <[email protected]>; pgadmin-support

Hi Gary, 

> -----Original Message-----
> From: gary [mailto:[email protected]] 
> Sent: 10 January 2004 05:05
> To: [email protected]
> 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] 14+ messages in thread

* Bug
@ 2019-06-25 09:47  Faran Ali <[email protected]>
  0 siblings, 2 replies; 14+ messages in thread

From: Faran Ali @ 2019-06-25 09:47 UTC (permalink / raw)
  To: [email protected]

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] 14+ messages in thread

* Re: Bug
@ 2019-06-25 09:59  Fahar Abbas <[email protected]>
  parent: Faran Ali <[email protected]>
  1 sibling, 1 reply; 14+ messages in thread

From: Fahar Abbas @ 2019-06-25 09:59 UTC (permalink / raw)
  To: Faran Ali <[email protected]>; Christoph Berg <[email protected]>; +Cc: pgadmin-support lists.postgresql.org <[email protected]>

Adding  [email protected] 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 <[email protected]> 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] 14+ messages in thread

* Re: Bug
@ 2019-06-25 10:05  Christoph Berg <[email protected]>
  parent: Fahar Abbas <[email protected]>
  0 siblings, 2 replies; 14+ messages in thread

From: Christoph Berg @ 2019-06-25 10:05 UTC (permalink / raw)
  To: Fahar Abbas <[email protected]>; +Cc: Faran Ali <[email protected]>; pgadmin-support lists.postgresql.org <[email protected]>

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] 14+ messages in thread

* Fwd: Bug
@ 2019-06-25 10:12  Faran Ali <[email protected]>
  parent: Christoph Berg <[email protected]>
  1 sibling, 0 replies; 14+ messages in thread

From: Faran Ali @ 2019-06-25 10:12 UTC (permalink / raw)
  To: [email protected]; +Cc: Christoph Berg <[email protected]>; [email protected]

---------- Forwarded message ---------
From: Faran Ali <[email protected]>
Date: Tue, Jun 25, 2019 at 3:08 PM
Subject: Re: Bug
To: Christoph Berg <[email protected]>


Hi,
Please find the log attached below

Regards,
Faran.

On Tue, Jun 25, 2019 at 3:05 PM Christoph Berg <[email protected]> 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] 14+ messages in thread

* Re: Bug
@ 2019-06-26 02:01  Michael Paquier <[email protected]>
  parent: Faran Ali <[email protected]>
  1 sibling, 0 replies; 14+ messages in thread

From: Michael Paquier @ 2019-06-26 02:01 UTC (permalink / raw)
  To: Faran Ali <[email protected]>; +Cc: [email protected]

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 (833B, ../../[email protected]/2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Bug
@ 2019-06-26 13:32  Christoph Berg <[email protected]>
  parent: Christoph Berg <[email protected]>
  1 sibling, 0 replies; 14+ messages in thread

From: Christoph Berg @ 2019-06-26 13:32 UTC (permalink / raw)
  To: Fahar Abbas <[email protected]>; +Cc: Faran Ali <[email protected]>; pgadmin-support lists.postgresql.org <[email protected]>

Re: To Fahar Abbas 2019-06-25 <[email protected]>
> 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] 14+ messages in thread

* bug
@ 2026-06-20 09:28  Виктор Надточий <[email protected]>
  0 siblings, 1 reply; 14+ messages in thread

From: Виктор Надточий @ 2026-06-20 09:28 UTC (permalink / raw)
  To: [email protected]

 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] 14+ messages in thread

* Re: bug
@ 2026-06-22 17:50  Ashesh Vashi <[email protected]>
  parent: Виктор Надточий <[email protected]>
  0 siblings, 1 reply; 14+ messages in thread

From: Ashesh Vashi @ 2026-06-22 17:50 UTC (permalink / raw)
  To: Виктор Надточий <[email protected]>; +Cc: [email protected]

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 Виктор Надточий <[email protected]>
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] 14+ messages in thread

* Re: bug
@ 2026-06-23 04:54  Aditya Toshniwal <[email protected]>
  parent: Ashesh Vashi <[email protected]>
  0 siblings, 0 replies; 14+ messages in thread

From: Aditya Toshniwal @ 2026-06-23 04:54 UTC (permalink / raw)
  To: Ashesh Vashi <[email protected]>; +Cc: Виктор Надточий <[email protected]>; [email protected]

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 <[email protected]>
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 Виктор Надточий <[email protected]>
> 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] 14+ messages in thread


end of thread, other threads:[~2026-06-23 04:54 UTC | newest]

Thread overview: 14+ 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==?= <[email protected]>
2003-11-10 23:55 ` Andreas Pflug <[email protected]>
2003-11-11 01:57   ` Hiroshi Saito <[email protected]>
2004-01-10 05:05 bug? gary <[email protected]>
2004-01-11 10:48 Re: bug? Dave Page <[email protected]>
2019-06-25 09:47 Bug Faran Ali <[email protected]>
2019-06-25 09:59 ` Fahar Abbas <[email protected]>
2019-06-25 10:05   ` Christoph Berg <[email protected]>
2019-06-25 10:12     ` Faran Ali <[email protected]>
2019-06-26 13:32     ` Christoph Berg <[email protected]>
2019-06-26 02:01 ` Michael Paquier <[email protected]>
2026-06-20 09:28 bug Виктор Надточий <[email protected]>
2026-06-22 17:50 ` Re: bug Ashesh Vashi <[email protected]>
2026-06-23 04:54   ` Re: bug Aditya Toshniwal <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox