Re: [pgadmin-support] Bug: Error generating backup

-support] Bug: Error generating backup I am not able to re-produce this issue on my side, I tested on Ubuntu 16.04 with Apache. Could you provide more information like OS version, Postgres version, what exactly trigger this behaviour? For now you can follow this step (Link <h

Re: [pgadmin-support] Bug: Error generating backup

I am not able to re-produce this issue on my side, I tested on Ubuntu 16.04 with Apache. Could you provide more information like OS version, Postgres version, what exactly trigger this behaviour? For now you can follow this step (Link ) to remove proce

[pgadmin-support] Bug: Error generating backup

Hello everyone, This error happens when a backup is generated: pgAdmin4-1.4 The window for showing the state of backup generation shows the text "Status Running..." all the time, never change to complet state, however the backup is generated correctly. Steps for reproduce: 1. Generate b

[pgadmin-support] Bug #1851: SQL view of a function returning a table showing 'setof "

The open bug in pgAdmin 4 #1851 titled, "SQL view of a function returning a table showing 'setof "', (https://redmine.postgresql.org/issues/1851) seems similar to a bug that was fixed in pgAdmin III mentioned here: https://www.postgresql.org/message-id/flat/054.6d0eab0204030aa6d4bc6c0f3ab2f42c%4

[pgadmin-support] Bug report pgadmin III on Ubuntu 16.04

Using pgadmin 1.22.2 Ubuntu 16.04 Properties dialog for a login role displays this: an assertion failed! ASSERT INFO: /usr/include/wx-3.0/wx/datetime.h(1733): assert "IsValid()" failed in GetValue(): invalid wxDateTime BACKTRACE: [1] wxString wxString::Format(wxFormatString const&, int) [2] w

[pgadmin-support] Bug in PGADMIN4 - V 1.1 Mac OSX

When trying to add a new value to “Minute” in a Repeat for a job scheduled by pageant I get:- ERROR: malformed array literal: "[true,false,false,false,false,true,false,false,false,false,true,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,fals

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

I put a build at https://developer.pgadmin.org/~dpage/pgadmin4-1.1-x86.exe. There's a Mac build there as well for anyone that wants it: https://developer.pgadmin.org/~dpage/pgadmin4-1.1.dmg Both are *completely untested*. On Mon, Dec 5, 2016 at 2:12 AM, Dave Page wrote: > Oh sorry - I forgot the

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

Oh sorry - I forgot there's a change in the required dependencies for Python (so you should roll back your changes). When I'm back in the office tomorrow, I'll see if I can roll you a custom build. Please remind me if I forget! Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @p

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

Am 03.12.2016 um 05:06 schrieb Dave Page: On Sat, Dec 3, 2016 at 2:44 AM, Andreas wrote: Am 03.12.2016 um 03:13 schrieb Dave Page: Where can I get the 1.2? An editor without search&replace is a wee bit suboptimal. It's not out yet, but you can get the code from the GIT repo (https://git.po

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

On Sat, Dec 3, 2016 at 2:44 AM, Andreas wrote: > Am 03.12.2016 um 03:13 schrieb Dave Page: >> >> On Sat, Dec 3, 2016 at 1:41 AM, Andreas wrote: >>> >>> Am 03.12.2016 um 02:00 schrieb Dave Page: On Sat, Dec 3, 2016 at 12:35 AM, Andreas wrote: > > >>> yes, but there is this V1.23 LTS of

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

Am 03.12.2016 um 03:13 schrieb Dave Page: On Sat, Dec 3, 2016 at 1:41 AM, Andreas wrote: Am 03.12.2016 um 02:00 schrieb Dave Page: On Sat, Dec 3, 2016 at 12:35 AM, Andreas wrote: yes, but there is this V1.23 LTS of BigSQL. That is nothing to do with us. Their Installer is on the Postgre

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

On Sat, Dec 3, 2016 at 1:41 AM, Andreas wrote: > Am 03.12.2016 um 02:00 schrieb Dave Page: >> On Sat, Dec 3, 2016 at 12:35 AM, Andreas wrote: >>> Hi, >>> there appears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I >>> Drag&Drop a script into the editor. >> >> pgAdmin 3 is no longer suppor

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

Am 03.12.2016 um 02:00 schrieb Dave Page: > On Sat, Dec 3, 2016 at 12:35 AM, Andreas wrote: >> Hi, >> there appears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I >> Drag&Drop a script into the editor. > > pgAdmin 3 is no longer supported I'm afraid. yes, but there is this V1.23 LTS of Bi

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

On Sat, Dec 3, 2016 at 12:35 AM, Andreas wrote: > Hi, > there appears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I > Drag&Drop a script into the editor. pgAdmin 3 is no longer supported I'm afraid. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http:

[pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

Hi, there appears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I Drag&Drop a script into the editor. The script is read in fine but the editor doesn't remember the name of the file. So when I want to save the changes, I need to select the allready existing file and get asked if I want

Re: [pgadmin-support] Bug report

Hi On Mon, Nov 21, 2016 at 3:46 PM, Robert van Geel wrote: > Dave, I've added the main list again in the cc of this mail so people > finding this post will also know the solution. > > Your comment: > >Can you please run the registry editor on Windows, and check the value of > the following key?

Re: [pgadmin-support] Bug report

Dave, I've added the main list again in the cc of this mail so people finding this post will also know the solution. Your comment: >Can you please run the registry editor on Windows, and check the value of the following key? > >HKEY_CLASSES_ROOT\.css\Content Type > >It should be "text/css" (w

Re: [pgadmin-support] Bug report

Dave, I'll send you the zip in a private mail, I'm not sure if the log files are relevant to other people. I patched the python code to serve browser.css without authentication in an attempt to solve this myself, but I'm still experiencing the same. If you want I'm happy to provide you with

Re: [pgadmin-support] Bug report

Hi On Sat, Nov 19, 2016 at 7:32 PM, Robert van Geel wrote: > Hi, > > I have an issue getting pgadmin going. > > Version: latest (4.1.1) > Platform: windows 10 > Configuration: out of the box, just install -> start -> symptom experienced > Symptom: the screen looks off, like a web page with no cs

[pgadmin-support] Bug report

Hi, I have an issue getting pgadmin going. Version: latest (4.1.1) Platform: windows 10 Configuration: out of the box, just install -> start -> symptom experienced Symptom: the screen looks off, like a web page with no css applied or something, I added a screenshot below Additional information

[pgadmin-support] Bug report: Cannot install pgAdmin 4 from PostgreSQL apt repository for Debian Jessie

Hi, I followed the descripion at https://wiki.postgresql.org/wiki/Apt to get http://apt.postgresql.org/pub/repos/apt/ as an apt source for Jessie. However, apt-get install pgadmin4 other than apt-get install pgadmin3 surprisingly did not work. -- Cheers, Alex -- Sent via pgadmin-supp

Re: [pgadmin-support] BUG: Cannot add primary key, etc during create table

Hi Mark, It is collapsed & you have to expand it, Click on edit button(first button in the row on left hand side) and provide all your definition. Same applied to foreign/unique keys. -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Sat

[pgadmin-support] BUG: Cannot add primary key, etc during create table

pgadmin4 1.1 Problem: Add columns to table in "create table" dialog Navigate to 'primary key' Enter primary key name Cannot select column to primary key on This also is a problem for foreign keys and unique keys -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.or

Re: [pgadmin-support] Bug: Opening pgAdmin with a file with mixed line endings

[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Matthew Pava Sent: Wednesday, July 13, 2016 10:06 PM To: 'pgadmin-support@postgresql.org' Subject: [pgadmin-support] Bug: Opening pgAdmin with a file with mixed line endings   Running pgAdmin Version 1.22.1 (Feb 9, 2016, rev:

[pgadmin-support] Bug: Opening pgAdmin with a file with mixed line endings

Running pgAdmin Version 1.22.1 (Feb 9, 2016, rev: REL-1_22_1) on Windows 10 Pro I am opening a file that has mixed line endings. When I open it through the pgAdmin interface Query window, I receive the following Warning dialog: "The file contains mixed line endings. They will be converted to t

Re: [pgadmin-support] Bug: webpage links incorrect

On Mon, Jun 6, 2016 at 12:26 PM, Weatherby,Gerard wrote: > Page: https://www.pgadmin.org/download/macosx.php download links point to, > e.g. > > http://www.postgresql.org/ftp/pgadmin3/release/v1.22.1/osx/ > > The actual location is > https://www.postgresql.org/ftp/pgadmin/pgadmin3/v1.22.1/osx/ A

[pgadmin-support] Bug: webpage links incorrect

Page: https://www.pgadmin.org/download/macosx.php download links point to, e.g. http://www.postgresql.org/ftp/pgadmin3/release/v1.22.1/osx/ The actual location is https://www.postgresql.org/ftp/pgadmin/pgadmin3/v1.22.1/osx/ -- Gerard Weatherby | Application Architect NMRbox | Department of Molec

[pgadmin-support] Bug: rows in Query Output pane are too narrow with higher DPI

I'm seeing a problem similar to http://www.postgresql.org/message-id/f246364e-8def-4b0a-acb6-1d6113b7a...@pobox.com, but only with higher DPI (more than the default 96). With DPI 96 the height of the columns/rows has enough height, but with 176 (or 140) the cell contents gets cut off. The same

[pgadmin-support] [Bug report] pgAdmin 1.22.1 crashes when connection lost

pgAdmin 1.22.1 crashes when a connection is established, then lost and the user tries to click somewhere in the DB tree. pgAdmin 1.22.1 OS: Windows 10 (happens on Windows 7 and Mac OS X 1.10.4) To reproduce: 1. Start pgAdmin and open a DB connection 2. Expand to some scheme and click on an

[pgadmin-support] bug of import data into table in pgadminIII 1.20.0

Hello! I think I find a bug of import in pgadmin III 1.20.0 . OS: win10 version: pgadminIII 1.20.0 (I intall it by an Graphical installer) I set my pgadminIII in Chinese, then I use Import. it failed: And I vi

Re: [pgadmin-support] bug report: pgadmin3 server status dialog malfunction

Glad it's working for you - thanks for letting us know. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL Company > On 4 Feb 2016, at 19:27, StanC wrote: > > Thanks again Dave, > > I went to a non-functional

Re: [pgadmin-support] bug report: pgadmin3 server status dialog malfunction

Thanks again Dave, I went to a non-functional instance, removed all wxwidgets3.0, removed all pgadmin3 1.22 (that was installed from Ubuntu's package), made sure wxwidgets2.8 deps were there, downloaded source pgadmin 1.22, compiled etc. ** It works now. I also noticed that Archlinux packages

Re: [pgadmin-support] bug report: pgadmin3 server status dialog malfunction

OK - that makes it pretty clear. The one that works is using wxWidgets 2.8, whilst the others are using wxWidgets 3.0. We've never fully tested with 3.0, so there are almost certainly known issues with such a build. It is recommended that packagers use 2.8 at the moment, so I would suggest complain

Re: [pgadmin-support] bug report: pgadmin3 server status dialog malfunction

Here it is: (beside the ** lines). Note for #1 where 1.22 exists, I don't recall installing 1.20 nor do my synaptic logs show this. Please don't hesitate to send me off on subsequent debug paths. Especially to corroborate any data I provide - I don't want to send you off on a wrong path due to any

Re: [pgadmin-support] bug report: pgadmin3 server status dialog malfunction

Thanks - unfortunately as far as I can see that doesn't actually tell me how pgAdmin was built. The easiest way to get that info is to run the following command on each system: apt-cache showpkg pgadmin3 Can you get me that output please? Thanks. On Tue, Feb 2, 2016 at 8:01 PM, StanC wrote: >

Re: [pgadmin-support] bug report: pgadmin3 server status dialog malfunction

Hi What version of wxWidgets is used by the pgAdmin build on each of those machines? Thanks. On Tue, Feb 2, 2016 at 3:26 AM, StanC wrote: > Bug report details follows this summary: > > When accessing the Server Status dialog, it consistently presents blank > windows, no headings, columns, and n

[pgadmin-support] bug report: pgadmin3 server status dialog malfunction

Bug report details follows this summary: When accessing the Server Status dialog, it consistently presents blank windows, no headings, columns, and no data. This occurs for 1.20 and 1.22. (Machine instance #1 and #2 below) Two different machines with 1.18 work OK. One of the 1.18 working version

[pgadmin-support] Bug#797804: pgadmin3 segfaults after rightclick (fwd)

Hi, we are unfortunately still seeing segfaults with pgadmin3 on Debian: Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". 07:49:15: Debug: Adding duplicate image handler for 'PNG file' [New Thread 0x7fffe606a700 (LWP 4318)] Program received signal SIGSEGV, Segmentation

Re: [pgadmin-support] bug report: pgadmin 1.20.0 Windows 8.1 MATERIALIZED VIEW with INDEX, pgadmin doesn't show the INDEX

hello. In the SQL pane I don't see the index, and they aren't in the Object browser either: it's already implemented and will appear in version 1.22. On 10.09.2015 1:34, Emery Lapinski wrote: For example: set search_path = scratch; drop materialized view if exists temp_a; create materializ

[pgadmin-support] bug report: pgadmin 1.20.0 Windows 8.1 MATERIALIZED VIEW with INDEX, pgadmin doesn't show the INDEX

For example: set search_path = scratch; drop materialized view if exists temp_a; create materialized view temp_a as select version() as str; create index on temp_a (str); select * from temp_a; Data Output: str text PostgreSQL 9.3.9 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4

Re: [pgadmin-support] Bug with scratch pad

Subject: Re: [pgadmin-support] Bug with scratch pad On 20/08/15 03:33 AM, Julius Grybinas wrote: Hello, I'd like to inform you, that I found bug with scratch pad and Query tool. The bug is easy repeatable. * Launch pgAdmin * Connect to server (any?) * Launch Query tool (sql e

Re: [pgadmin-support] Bug with scratch pad

On 20/08/15 03:33 AM, Julius Grybinas wrote: Hello, I’d like to inform you, that I found bug with scratch pad and Query tool. The bug is easy repeatable. ØLaunch pgAdmin ØConnect to server (any?) ØLaunch Query tool (sql editor) ØType anything into scratch pad, leaving main window (query w

[pgadmin-support] Bug with scratch pad

Hello, I'd like to inform you, that I found bug with scratch pad and Query tool. The bug is easy repeatable. * Launch pgAdmin * Connect to server (any?) * Launch Query tool (sql editor) * Type anything into scratch pad, leaving main window (query window) empty * Jump to Graphical q

[pgadmin-support] Bug: pgagent doesn't log SQL errors

All, We recently dealt with a site where, do to mistakes in migrating servers, the sequences for pgagent got reset to 1. This caused primary key conflicts which caused pgagent to fail. However, no failures of any kind appeared in the pgagent log, even though PK violation errors were appearing in

[pgadmin-support] bug

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

Re: [pgadmin-support] Bug report - Version 1.20.0 REL-1_20_0

Hi Dave, Definitely looks like a bug. Using the '{}'::character varying[] format for the array seems to work fine though. Example; CREATE OR REPLACE FUNCTION ng_research.test( filter_param json, prefix_param character varying DEFAULT 'attributes'::character varying, column_prefixes ch

[pgadmin-support] Bug report - Version 1.20.0 REL-1_20_0

Pgadmin cannot cope with default function parameters that are text arrays:- CREATE OR REPLACE FUNCTION ng_research.test(     filter_param json,  prefix_param character varying DEFAULT 'attributes'::character varying,  column_prefixes character varying[] DEFAULT ARRAY['FA'::text,'

[pgadmin-support] bug report: unable to modify servers after failed create

Hello all, thanks again for PgAdmin :) One thing I've noticed is the following: you click the "plug" icon to create a new server. Type in your credentials, but with the wrong password, hit ok. It says "An error has occurred:..." and you click OK. It takes you back to the New Server Registration po

[pgadmin-support] Bug report: pgAdmin on Windows does not support password-protected private key

On windows, attempting to connect to a postgresql server requiring authentication via client certificate using a password protected private key results in the following error: --- pgAdmin III --- An error has occurred: Error connecting to the ser

[pgadmin-support] Bug Report: Length incorrectly specified when creating columns of 'time without time zone'

pgAdmin version: 1.18.1 OS: Windows 7 SP1 x64 Bug: adding a column type 'time without time zone' with length will produce invalid sql syntax: e.g: ALTER TABLE mytable ADD COLUMN mytimecolumn time without time zone(4); it should've produce this sql statement: ALTER TABLE mytable ADD COLUMN

[pgadmin-support] Bug#754114: pgadmin3 crashes - Debug: Adding duplicate image handler for 'PNG file'

Hi, we got several reports that pgadmin3 is crashing in various dialogs, possibly related by the switch to wx3.0. http://bugs.debian.org/754114 Could someone have a look at that? Thanks, Christoph -- c...@df7cb.de | http://www.df7cb.de/ --- Begin Message --- Package: pgadmin3 Followup-For: Bug

[pgadmin-support] Bug in UI

Version: 1.18.1 How to reproduce: Open some table in left tree, open section called "Indexes", right-click on it; you'll see small menu with "New index" click "new index", add some column, press ok to add index, the tree is refreshed (if all is OK). right-cilck immediately on same "Indexes" and yo

[pgadmin-support] BUG REPORT: SQL Editor selects too much text after you hit return and select "one line"

PRODUCT: pgADMIN SQL Editor VERSION: pgADMIN version 1.18.1 (Apr 9 2014, rev: REL-1_18_1) ISSUE: Editor selects too much text after you hit return and select "one line". The following example illustrates the issue: cursor-1.png shows three lines of text in SQL Editor, with the cursor positione

[pgadmin-support] [BUG] Account Expires Date on PGAdmin3 1.18.1 running Ubuntu 13.10 and Ubuntu 14.04 Beta2

Hi All, The account expire date bug got reintroduced again in PGAdmin3 version 1.18.1 on Ubuntu 13.10 and Ubuntu 14.04 LTS Beta 2. - The account expire date always set to current date at 00:00:00 as opposed to the "1970-01-01 00:00:00" bug back then. - This bug made the database.php coul

[pgadmin-support] [Bug] Resize Query Window Mac OSX

Version: 1.18.1 rev: REL-1_18_1 OS: Mac OSX V 10.9.2 I am able to crash pgadmin by resizing a query window from the bottom right hand corner, however it is very difficult to reproduce consistently as it kills the entire application. This is a regular occurrence, not sure if it is related to my en

Re: [pgadmin-support] Bug: Reverting Return Type

1.18.1 (Jan 21 2014, REL-1_18_1) Linux 3.2.0-60-generic #91-Ubuntu SMP Wed Feb 19 03:54:44 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux Ubuntu Trusty Tahr (development branch) \n \l​

Re: [pgadmin-support] Bug: Reverting Return Type

What version of pgAdmin II are you using? On Fri, Mar 21, 2014 at 11:29 AM, Thangalin wrote: > Hi, > > Create a new function that uses a TABLE return type definition: > > CREATE OR REPLACE FUNCTION testing(IN p_test bigint) > RETURNS TABLE (id int) AS > $BODY$ > SELECT 1 AS id > $BODY$ >

[pgadmin-support] Bug: Reverting Return Type

Hi, Create a new function that uses a TABLE return type definition: CREATE OR REPLACE FUNCTION testing(IN p_test bigint) RETURNS TABLE (id int) AS $BODY$ SELECT 1 AS id $BODY$ LANGUAGE sql STABLE; Expected Results The return type retains the ID column name and continues to use a TABLE for

Re: [pgadmin-support] bug report role properties expiration date

On Mon, Feb 24, 2014 at 8:17 AM, David Elbert wrote: > Hi Dinesh- > > Thank you. Is there a schedule for the release of the next installer or > is it a question of when there is enough to be worth the rebuild and > release? > > Hi David, I believe, someone from our team will respond you on the

[pgadmin-support] [bug report] underscores in table cell not visible

Hi together, As recommended on http://www.pgadmin.org/support/list.php, I'd like to report a bug in pgAdmin 1.18.1 running on Ubuntu 13.10 with Linux 3.11.0-14-generic. If the user enters data including and underscore in a column of type text, the underscore is not visible in the table data table.

[pgadmin-support] Bug report

PGadmin version 1.18.0 (present in previous versions down to 1.16 from memory) OS Windows 7 64 bit current Installed from binary. There exist a few bugs in PGadmin where a connection to a remote server will time out or be closed and the program will crash when various operations are attempted. S

[pgadmin-support] Bug report -- can't type single quotes (') on OS X 10.9

Here's a bug I found: on OS X 10.9 (Mavericks), if the current keyboard layout is "U.S. International - PC" one is unable to type single quotes on SQL Editor. The key acts as backspace instead. This bug is easy to reproduce and isn't intermittent: it happens 100% of the time. Platform: Mac OS X 1

[pgadmin-support] Bug report -- can't type single quotes (') on OS X 10.9

Here's a bug I found: on OS X 10.9 (Mavericks), if the current keyboard layout is "U.S. International - PC" one is unable to type single quotes on SQL Editor. The key acts as backspace instead. This bug is easy to reproduce and isn't intermittent: it happens 100% of the time. Platform: Mac OS X 1

Re: [pgadmin-support] Bug report: pgAdmin III quit when pressing F1 or selecting "Postgresql Help" menu item

On Sun, Sep 22, 2013 at 3:00 AM, Ashesh Vashi wrote: > On Sun, Sep 22, 2013 at 5:23 AM, Gang Liang > wrote: > >> pgAdmin III >> Version: 1.18.0 (NOT a development snapshot version) >> >> Detail: when F1 key is pressed, or the menu item "Help -> Postgresql >> Help" is selected, or the toolbar ico

Re: [pgadmin-support] Bug report: pgAdmin III quit when pressing F1 or selecting "Postgresql Help" menu item

On Sun, Sep 22, 2013 at 5:23 AM, Gang Liang wrote: > pgAdmin III > Version: 1.18.0 (NOT a development snapshot version) > > Detail: when F1 key is pressed, or the menu item "Help -> Postgresql Help" > is selected, or the toolbar icon "Display help on the sql commands" is > clicked, the running pgA

[pgadmin-support] Bug report: pgAdmin III quit when pressing F1 or selecting "Postgresql Help" menu item

pgAdmin III Version: 1.18.0 (NOT a development snapshot version) Detail: when F1 key is pressed, or the menu item "Help -> Postgresql Help" is selected, or the toolbar icon "Display help on the sql commands" is clicked, the running pgAdmin will emit an error then quit. I checked the other items i

Re: [pgadmin-support] BUG report: role validity term

Thanks a lot. Pozdrawiam, Bartek 2013/9/20 Dinesh Kumar > Hi, > > Thanks for reporting this issue. > > Yes, this issue has been reported in the pgadmin generals, send some fixes > as well. But unfortunately, the fix is not properly working on Mac machine > where it's working on other platforms

Re: [pgadmin-support] BUG report: role validity term

Hi, Thanks for reporting this issue. Yes, this issue has been reported in the pgadmin generals, send some fixes as well. But unfortunately, the fix is not properly working on Mac machine where it's working on other platforms. I am trying to figure that out as soon as possible and send a patch to

[pgadmin-support] BUG report: role validity term

Hi all, I've notices small bug with role validity term. Use case: - Open properties window for existing role with non existing validity term (valid until infinity); - DO NOT change anything; - switch to SQL panel; - There is SQL similar to: ALTER ROLE myrole VALID UNTIL '2013-09-19

[pgadmin-support] Bug report: Stable crash PgAdmin III 1.18 (Sep 10 2013, Rev: REL-1_18_0)

Hi, all! Platform: Windows XP Language: English Distribution: binary Version: PgAdmin III 1.18 (Sep 10 2013, Rev: REL-1_18_0) How to reproduce: 1. Start PgAdmin III 1.18 2. Connect to DB 3. Start 'Grid Editor' with any table 4. Repeat 63 times: a) Click 'Sort/Filter options.' and b) press 'ESC'

Re: [pgadmin-support] BUG: Can not wait for thread termination pgAdmin III 1.18.0-beta1

On Fri, Jul 5, 2013 at 1:22 AM, Paragon Corporation wrote: > This seems to be an issue with the Query window. I should note that if I > run > the same commands using psql > Errors just return back without any weird alert and also doesn't happen if > I > run an older pgAdmin with 9.3beta2 -- pgAdm

[pgadmin-support] BUG: Can not wait for thread termination pgAdmin III 1.18.0-beta1

This seems to be an issue with the Query window. I should note that if I run the same commands using psql Errors just return back without any weird alert and also doesn't happen if I run an older pgAdmin with 9.3beta2 -- pgAdmin III 1.16.1 for example does not have this problem. --- I just insta

Re: [pgadmin-support] [BUG] Wrong colors on SQL table result

Hello Guillaume, Thanks for your answer. However, I just tested 1.16.1. The problem is still present. Regards, --- Luiz Angelo Daros de Luca, Me. luizl...@gmail.com 2013/6/19 Guillaume Lelarge > On Wed, 2013-06-19 at 16:07 -0300, Luiz Angelo Daros de Luca wrote: > > Hello,

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

On Fri, Jun 21, 2013 at 10:11 AM, Timon wrote: > i have tested it already, and it works great. Both problems are solved. > Thank you for your work :) > Thanks a lot. That's a relief for me. :-) > > > 2013/6/20 Ashesh Vashi > >> Hi Timon, >> >> I've sent patch to Dave (and, pgadmin-hackers) and

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

i have tested it already, and it works great. Both problems are solved. Thank you for your work :) 2013/6/20 Ashesh Vashi > Hi Timon, > > I've sent patch to Dave (and, pgadmin-hackers) and he already checked-in. > > Can you please confirm both the behavior with the latest code? > (1. Repeated m

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

Hi Timon, I've sent patch to Dave (and, pgadmin-hackers) and he already checked-in. Can you please confirm both the behavior with the latest code? (1. Repeated messages and 2. Cancellation on Query Execution) If you can spend some time, that will be very helpful. On Tue, Jun 18, 2013 at 2:16 PM

Re: [pgadmin-support] [BUG] Wrong colors on SQL table result

On Wed, 2013-06-19 at 16:07 -0300, Luiz Angelo Daros de Luca wrote: > Hello, > > I'm using pgadmin3 1.14.3 on OpenSUSE 12.3. I'm facing problems with > pgadmin3 color on SQL query result table when using "OpenSUSE Dark theme" > on KDE. pgadmin3 uses: > > non selected cell background color = View

[pgadmin-support] [BUG] Wrong colors on SQL table result

Hello, I'm using pgadmin3 1.14.3 on OpenSUSE 12.3. I'm facing problems with pgadmin3 color on SQL query result table when using "OpenSUSE Dark theme" on KDE. pgadmin3 uses: non selected cell background color = View Background (correct) non selected cell text color = Button text (wrong, should be

Re: [pgadmin-support] (Bug) Numeric fault calculation

On Tue, 2013-06-18 at 15:30 -0700, David Johnston wrote: > Guillaume Lelarge-3 wrote > > If you use a floating > > point datatype (which is what happens when you don't specificy the > > type), > > I covered this in my prior post but per the documentation this is incorrect. > > http://www.postg

Re: [pgadmin-support] (Bug) Numeric fault calculation

Kanitchet Vaiassava wrote > (Bug) Numeric fault calculation > > postgresql : 714.355 > long division method: 714.356 FYI: My prior posts use a result cast "::text" in order to avoid any kind of interaction with how pgAdmin would handle numbers. This is not a pgadmin bug/issue it is

Re: [pgadmin-support] (Bug) Numeric fault calculation

Guillaume Lelarge-3 wrote > If you use a floating > point datatype (which is what happens when you don't specificy the > type), I covered this in my prior post but per the documentation this is incorrect. http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-CONSTAN

Re: [pgadmin-support] (Bug) Numeric fault calculation

Guillaume Lelarge-3 wrote > On Sun, 2013-06-16 at 04:59 -0700, Chirag Mittal wrote: >> Dear Kanitchet, >> >> Please try this >> >> SELECT (260739.94 * (1.00/365.00))::numeric(20,7) >> >> I am a beginner but I think we need to explicitly mention the "output" >> format required to get accuracy. >

Re: [pgadmin-support] (Bug) Numeric fault calculation

On Sun, 2013-06-16 at 04:59 -0700, Chirag Mittal wrote: > Dear Kanitchet, > > Please try this > > SELECT (260739.94 * (1.00/365.00))::numeric(20,7) > > I am a beginner but I think we need to explicitly mention the "output" > format required to get accuracy. > Nope, you simply need to use the

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

Thanks Timon for point out. I already know about this - I've made that mistake and will resolve it very soon. Made some changes in pgQueryThread class, which leads to this bug. Actually - I was busy with some other stuff, and couldn't spend time on pgadmin3. On Tue, Jun 18, 2013 at 2:05 PM, Timon

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

seems that commit 140e8aee4cb5d423bb76ad81874e442d3e17b5c1 (Rewrite the debugger to resolve numerous known issues and instabilities mostly due to the threading code.) also broke ability to cancel query by pressing stop button in query editor 2013/5/16 Dave Page : > Ashesh - this appears to be rela

Re: [pgadmin-support] (Bug) Numeric fault calculation

Dear Kanitchet, Please try this SELECT (260739.94 * (1.00/365.00))::numeric(20,7) I am a beginner but I think we need to explicitly mention the "output" format required to get accuracy. Hope it helped. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Bug-Numeric-fau

[pgadmin-support] Bug in foreign key constraint SQL

On Testing Version 1.18.0 Alpha 1 I noticed that in the SQL pane for a self-referencing foreign key constraint the match type is listed as "unknown". I'm running pgAdmin on windows 7 64bit on postgresql 9.3 beta1 on the same OS Here's the text from the SQL pane. -- Foreign Key: core.menu_nodes_p

Re: [pgadmin-support] Bug report - multidimensional arrays

Hi Dave, thank you for reply. I did not notice this in PostgreSql documentation. It is clear to me now. Best regards, Josh 2013/6/3 Dave Page > Hi > > On Fri, May 31, 2013 at 6:36 PM, Joshua Boshi > wrote: > > Hi, > > > > I would like to report a bug on pgAdmin 1.16.1 installed on Ubuntu 13

Re: [pgadmin-support] Bug report - multidimensional arrays

Hi On Fri, May 31, 2013 at 6:36 PM, Joshua Boshi wrote: > Hi, > > I would like to report a bug on pgAdmin 1.16.1 installed on Ubuntu 13.04 > from repository. > PgAdmin ignores multidimensional array types in it's outputs. > > I defined a table using this command: > > CREATE TABLE test ( > id seri

[pgadmin-support] Bug report - multidimensional arrays

Hi, I would like to report a bug on pgAdmin 1.16.1 installed on Ubuntu 13.04 from repository. PgAdmin ignores multidimensional array types in it's outputs. I defined a table using this command: CREATE TABLE test ( id serial NOT NULL, test character varying(150)[][], PRIMARY KEY (id) ) WITH (

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

Ashesh - this appears to be related to the debugger changes. Can you take a look please? Thanks. On Thu, May 16, 2013 at 2:07 PM, Gabriele Franch wrote: > Hello, > I'm using pgadmin 1.18.0 Alpha 1 (compiled from > http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

It could be because of the changes in pgThread, made to redesign the debugger. I will investigate it. Thanks for the report. On Thu, May 16, 2013 at 6:37 PM, Gabriele Franch wrote: > Hello, > I'm using pgadmin 1.18.0 Alpha 1 (compiled from > > http://ftp.postgresql.org/pub/pgadmin3/release/v1.18

[pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

Hello, I'm using pgadmin 1.18.0 Alpha 1 (compiled from http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz). Messages are repeated multiple times in messages pane. Version 1.16.1 does not expose this behavior. Example SQL: DROP FUNCTION IF EXISTS r

Re: [pgadmin-support] [BUG?] Account expire date

On Wed, 2013-05-08 at 08:52 +0200, Bartosz Dmytrak wrote: > Hi all, > On login role properties window, "Definition" tab, there is account expire > date. Odd thing is that checkbox is checked and date is assigned even when > there is no valid date set on account. > Consequence is when you click "OK"

[pgadmin-support] [BUG?] Account expire date

Hi all, On login role properties window, "Definition" tab, there is account expire date. Odd thing is that checkbox is checked and date is assigned even when there is no valid date set on account. Consequence is when you click "OK" button without do anything, then SQL: ALTER ROLE "MyRole" VALID

Re: Fw: [pgadmin-support] (Bug) Numeric fault calculation

iace.co.th> ; Thanarit Maneechote <mailto:thanarit....@thaiace.co.th> *Subject:* Re: [pgadmin-support] (Bug) Numeric fault calculation Try select (260739.94::double precision * (1.00::double precision / 365.00::double precision) ) default precision in postgres is pretty lossy, use do

Fw: [pgadmin-support] (Bug) Numeric fault calculation

2 744 2288; Fax +66 2 379 1166 --- From: Alexander Yerenkow Sent: Tuesday, April 23, 2013 3:48 PM To: Kanitchet Vaiassava Cc: pgadmin-support@postgresql.org ; Kanitchet Vaiassava ; Thanarit Maneechote Subject: Re: [pgadmin-support] (Bug) Numeric fault calculat

Re: [pgadmin-support] (Bug) Numeric fault calculation

Try select (260739.94::double precision * (1.00::double precision / 365.00::double precision) ) default precision in postgres is pretty lossy, use double precision whenever you need max precision. 2013/4/23 Kanitchet Vaiassava > ** > *(Bug) Numeric fault calculation* > > My company has usi

[pgadmin-support] (Bug) Numeric fault calculation

(Bug) Numeric fault calculation My company has using postgresql as database for ERP application which in-house developed. For store financial and accounting data, we chose "numeric" type for accurate calculation (and with recommend by postgres's documentation) and we faced the problem by using

Re: [pgadmin-support] bug with pgAdmin 1.16.1 create database?

On Fri, 2013-04-05 at 19:19 +, Belbin, Peter wrote: > I'm using pgAdmin 1.16.1 on Windows and am seeing this curious behavior: > > I'm connected to postgresql 9.2.4. > > When creating a database, I click on the owner combo-box, and see what > appears to be a composite list of available roles

  1   2   3   4   5   6   7   8   >