Re: [pgadmin-support] Pgadmin and connection to a server

On 09/07/16 09:52, Nico Aliotta wrote: i'm tryng to access to a db that is on a my server. The port is 5432 open and accept tcp/ip connections. Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x274D

Re: [pgadmin-support] Adding users?

On 22/02/16 13:41, Rob Lewis wrote: Boy do I feel dumb. I just installed Postgres.app and pgAdmin3.app on my Mac (El Capitan). I’ve searched everywhere in the program and the docs and I can’t find out how to simply add a user. Help, please. Use pgadmin to make a connection to a server on the

Re: [pgadmin-support] Copy & paste key commands not working correctly

On 02/09/2016 08:55 AM, Gabriel Sánchez wrote: The same happens to me. Although copying and waiting usually works for me. Have others experienced this behavior? It appears not to affect windows. Are the developers aware of this? Have they tried fixing it or do they plan to fix it? It cou

[pgadmin-support] Keyboard response when defining a new column for a table

Is there any particular reason why, when defining a new column in a table, in the field "Data type" the entry cannot be selected with the keyboard? For example, when defining a serial type, which happens almost always when defining a new table, typing "s" does not take me to the s* in the list?

Re: [pgadmin-support] pgadmin doesn't connect to server

On 12/24/2015 09:02 AM, Michael Eschweiler wrote: Hi, I am using postgresql 9.3 on opensuse 13.2. Last time I used pgadmin is some weeks ago and all seemed to work fine. No I tried to start it, but I get the answer: Error connecting to the server: FATAL: couldn't open file „base/12640/12391“ ..

Re: [pgadmin-support] Editing table in data view, cursor jumps and loses place

Hmmm... must have been fixed, I downloaded source and compiled latest, the problem does not persist into the 1.22 version. On 12/21/2015 10:13 AM, Colin Beckingham wrote: Linux openSUSE Leap 42.1, pgadmin REL 1 20 0, supplied by SUSE repo I seem to be losing control of my keyboard controlled

[pgadmin-support] Editing table in data view, cursor jumps and loses place

Linux openSUSE Leap 42.1, pgadmin REL 1 20 0, supplied by SUSE repo I seem to be losing control of my keyboard controlled cursor when editing fields in data view in a table. Steps to reproduce: 1. open table in edit data view 2. table has a string field character varying(150) 3. record contains

Re: [pgadmin-support] Urgent Urgent help needed !!!

Suggestion: Use pgadmin to connect to the same server, select a different db and click on backup. You may find that in the filename field pgadmin will default to the same filename that was used previously, perhaps the one that was used for your backup if no other backup has been done since. At

Re: [pgadmin-support] Disable or remove 'drop' button on toolbar

On 12/10/15 04:09 AM, Stephen Cook wrote: On 10/12/2015 3:48 AM, Dave Page wrote: Implementing security at the client level is *never* correct. In this case, the users could just use the query tool if they actually wanted to bypass the missing drop option, or go get another client and connect wi

Re: [pgadmin-support] Disable or remove 'drop' button on toolbar

On 09/10/15 01:48 PM, Joseph Marlin wrote: We give pgadmin3 to some managers and other non-developers to allow them to run reports and scripts that we (development) write for them. The ease of pressing the 'drop' button on the main toolbar makes me really worried, even with the confirmation d

Re: [pgadmin-support] How to enable PgAdmin Query Tool Favorites

On 15/09/15 10:46 PM, Vahdet Mert wrote: Hi PGAdmin Support, On 2 Sep, I sent message to pgsql-b...@postgresql.org asking for help with PgAdmin Query Tool Favorites. I havent received any reply and I hope this group will be more helpful: Bug reference: 136

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

Re: [pgadmin-support] Mouse wheel not working in PgAdmin 3

Seems to work OK for me on openSUSE 13.2, (kernel uname -r -> 3.16.7-21-desktop, Gnome 3-14-2, Logitech optical mouse, pgadmin compiled from latest git pull, version 1.20). Might need to give a bit more information? Are you sure it is only on pgadmin3 that this problem occurs? On 19/05/15 07:

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

On Tue, 2014-06-17 at 13:14 -0400, k mac wrote: > Hello, > > > I received one response to my enquiry asking me to "Change your > keyboard" which is something I cannot do, as the keyboard is part of > the notebook I'm typing on. > > > > Not sure of the process here. Should I expect a response f

Re: [pgadmin-support] Latest git compile fails on 'EVP_PKEY_free'

> On Wed, May 8, 2013 at 10:41 AM, Colin Beckingham wrote: > > > > > > On 05/06/2013 04:57 AM, Colin Beckingham wrote: > >> > >> > >> > >> On 05/06/2013 12:19 AM, Ashesh Vashi wrote: > >>> > >>> Hi Colin, > >&g

Re: [pgadmin-support] Latest git compile fails on 'EVP_PKEY_free'

On 05/06/2013 04:57 AM, Colin Beckingham wrote: On 05/06/2013 12:19 AM, Ashesh Vashi wrote: Hi Colin, Can you please send us the output of 'openssl version'? On Sat, May 4, 2013 at 12:11 AM, Colin Beckingham mailto:col...@start.ca>> wrote: Opensuse 12.3 fully patche

[pgadmin-support] Latest git compile fails on 'EVP_PKEY_free'

I think I have the openssl and libcrypto libraries installed but the compile stops at this point. Any suggestions? 32/64 bit issue? -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to you

[pgadmin-support] Make fails on crypto

it. Which crypto might I be looking for? Pity that config does not pick it up. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin

[pgadmin-support] Error on tools - server configuration and status

afelyProcessEvent(wxEvent&) [14] wxMenuBase::SendEvent(int, int) [15] g_closure_invoke [16] g_signal_emit_valist [17] g_signal_emit [18] gtk_widget_activate [19] gtk_menu_shell_activate_item [20] g_closure_invoke [21] g_signal_emit_valist [22] g_signal_emit [23] gtk_propagate_event [24] gtk_main_do_event [

Re: [pgadmin-support] Error during make from git on Opensuse 12.2

On 09/06/2012 05:44 AM, Dave Page wrote: Hi On Thu, Sep 6, 2012 at 10:19 AM, Colin Beckingham wrote: Thanks for the patch, which I see has now been committed in git. I updated from git, and now make reaches: ... .9 -lxml2 -lz -lm -lxslt -L/usr/lib64 -lpq `.text

Re: [pgadmin-support] Error during make from git on Opensuse 12.2

1 exit status make[3]: *** [pgadmin3] Error 1 make[3]: Leaving directory `/home/colin/pgadmin3/pgadmin' make[2]: *** [all] Error 2 make[2]: Leaving directory `/home/colin/pgadmin3/pgadmin' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/colin/pgadmin3' make:

[pgadmin-support] Error during make from git on Opensuse 12.2

ot change things. I can do a make clean but that leads me to a long, long, make, to be avoided if possible. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.post

Re: [pgadmin-support] Font size control in edit data window

On 08/26/2012 03:23 AM, Guillaume Lelarge wrote: On Wed, 2012-08-15 at 09:55 -0400, Colin Beckingham wrote: pgadmin latest dev from git, using wxw 2.9.4: I'm having an issue with font and font size in the edit data window ... So in summary, a couple of thoughts: 1. Is there any be

[pgadmin-support] Font size control in edit data window

ss an alternative might be to autoadjust height based on data and not line number. 2. Row height change for the entire range? 3. Option to reset line heights to default over a range? Thanks. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-su

Re: [pgadmin-support] Wxwidgets has gone to 2.9.4

On 07/27/2012 09:46 AM, Guillaume Lelarge wrote: On Fri, 2012-07-27 at 09:27 -0400, Colin Beckingham wrote: Guillaume and others: I have spent so much time up in the pointy bit I feel uncomfortable elsewhere. ;-) Wxwidgets has now released 2.9.4. Unless I get feedback to the contrary I will

[pgadmin-support] Wxwidgets has gone to 2.9.4

in pgadmin? -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] SQL pane freezes while editing

On 07/27/2012 07:14 AM, Michael Shapiro wrote: Works fine for me. I am running PgAdmin 1.14.2 Under Window 7 SP 1. On Fri, Jul 27, 2012 at 4:59 AM, Colin Beckingham mailto:col...@start.ca>> wrote: On 07/27/2012 05:04 AM, Michael Shapiro wrote: I tried this and cou

Re: [pgadmin-support] SQL pane freezes while editing

left parenthesis and put it back without any problems under both word wrap settings. On Fri, Jul 27, 2012 at 3:14 AM, Colin Beckingham mailto:col...@start.ca>> wrote: Dev 1.17, wxwidgets 2.9.3 Some time ago I reported that my pgadmin SQL editor showed freeze behaviour under c

[pgadmin-support] SQL pane freezes while editing

ed. Anyone else see this? -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Rename column in dev 1.17 segfaults

On 07/22/2012 10:24 AM, Colin Beckingham wrote: Opensuse 12.1, wxw 2.9.3, dev 1.17 Drill down database -> table -> column - Properties Attempt to rename column => Segfault. New name is stored, but pgadmin crashes. No backtrace available. pgadmin started from CLI, no errors t

[pgadmin-support] Rename column in dev 1.17 segfaults

Opensuse 12.1, wxw 2.9.3, dev 1.17 Drill down database -> table -> column - Properties Attempt to rename column => Segfault. New name is stored, but pgadmin crashes. No backtrace available. pgadmin started from CLI, no errors trapped in terminal window. "Segmentation fault

Re: [pgadmin-support] Rename database destroys server connections

On 07/18/2012 05:23 PM, Guillaume Lelarge wrote: On Mon, 2012-07-16 at 11:05 -0400, Colin Beckingham wrote: Using wxw 2.9.3, latest dev 1.17, Opensuse 12.1 With two servers connected, select database in object browser for localhost. Click properties, select database name, edit to something

[pgadmin-support] Rename database destroys server connections

establish connections, click and highlight database, attempt to rename database, dialog box appears, but is showing detail for the schema, not the database. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)

[pgadmin-support] Dialog box obscures information

ialog box draggable independently of the parent to reveal the field names and types. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pg

[pgadmin-support] Jumping around in viewport in long tables

. You can move around in the table viewing data using the slider without problem. The issue only starts once you go into editing mode on a column. Workaround is simple, use filtered records or just close/reopen the editing window and just use the vertical slider once. -- --- Colin Beckingham

Re: [pgadmin-support] Update on two issues

On 05/29/2012 05:52 PM, Guillaume Lelarge wrote: On Mon, 2012-05-21 at 13:59 -0400, Colin Beckingham wrote: I previously reported a couple of odd screen issues: 1. editing a multiple line SQL statement in the pgadmin SQL editor resulted in text disappearing from the edit window that could be

Re: [pgadmin-support] Update on 2 issues

On 05/29/2012 05:52 PM, Guillaume Lelarge wrote: On Mon, 2012-05-21 at 13:59 -0400, Colin Beckingham wrote: I previously reported a couple of odd screen issues: 1. editing a multiple line SQL statement in the pgadmin SQL editor resulted in text disappearing from the edit window that could be

[pgadmin-support] Update on 2 issues

its place in the viewport I have just updated my kernel to 3.4 and both of these issues seem to have disappeared. FYI. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http

[pgadmin-support] Suggestion: keyboard response in data type dropdown

sponsive it would be helpful. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Editing field in record in large tables loses place in viewport

number. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Database designer gone in dev?

download the rest of the message.* You are right, thanks for that link, I was not aware. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin

[pgadmin-support] Database designer gone in dev?

sweet spot. configure --help does not have an indication, but the end of config shows that it does not intend to build the DD. Checked changelog but no note. I'm guessing this is part of prep for issue of a new version. Any hints? -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com --

Re: [pgadmin-support] 1.15 : wxw 2.9.3 : Object browser

On 05/04/2012 11:52 AM, Strauch, Sheldon wrote: The way I've avoided the same issue is to give each of the servers a different background color in the object browser. On Fri, May 4, 2012 at 9:36 AM, Colin Beckingham mailto:col...@start.ca>> wrote: Another thought on us

[pgadmin-support] 1.15 : wxw 2.9.3 : Object browser

and whether it is worth thinking of a one-click hide for all open trees in the tree, say back to schema level which is where a db normally opens? -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to

[pgadmin-support] 1.15 : wxw 2.9.3 : Graphical SQL builder allows dup tables

an impressively intelligent way of dealing with some errors/warnings, popping a warning dialog which contains a facility to suppress this type of error in future. I'm wondering if the dup table error might fall into this category? -- --- Colin Beckingham 613-454-5369 http://www.it4g

[pgadmin-support] 1.15 DD - serial copied as integer

into an editor, then: 1. change integer to serial as required 2. change varchar(0) to something more meaningful 3. inspect numeric (x,y) for accuracy 4. reorder fields as required. Copy text to SQL editor and execute. Works. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via

[pgadmin-support] 1.15 DD - order of columns

is of course to open up the csv in a SS, rearrange the cols to suit, and export back to CSV, or simply drop and recreate the table using the SQL from the original definition if you have that option. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pg

Re: [pgadmin-support] 1.15 Database Designer and character varying length option

On 04/21/2012 05:43 AM, Guillaume Lelarge wrote: On Sat, 2012-04-21 at 05:15 -0400, Colin Beckingham wrote: I was using the Database Designer to make a copy of the design of some tables in one db for inclusion in a new db. The process worked well except that one of the tables in the source

[pgadmin-support] 1.15 Database Designer and character varying length option

happy with this in the source db, however in the generated SQL the fields are marked varchar(0) which kills the execution of the SQL in the destination db. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

On 04/20/2012 04:27 PM, Guillaume Lelarge wrote: On Fri, 2012-04-20 at 10:25 -0400, Colin Beckingham wrote: On 04/20/2012 07:58 AM, Guillaume Lelarge wrote: Hi Colin, On Fri, 2012-04-20 at 13:15 +0200, Guillaume Lelarge wrote: On Wed, 2012-04-11 at 17:13 -0400, Colin Beckingham wrote

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

On 04/20/2012 07:58 AM, Guillaume Lelarge wrote: Hi Colin, On Fri, 2012-04-20 at 13:15 +0200, Guillaume Lelarge wrote: On Wed, 2012-04-11 at 17:13 -0400, Colin Beckingham wrote: On 04/11/2012 04:38 PM, Colin Beckingham wrote: Guillaume, I see the missing column name in index-properties

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

On 04/11/2012 04:38 PM, Colin Beckingham wrote: Guillaume, I see the missing column name in index-properties has been fixed. Thanks. However the column name appears to be truncated one char too early; bookid becomes booki and authid becomes authi. Seems to be consistent across databases. I

[pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

Guillaume, I see the missing column name in index-properties has been fixed. Thanks. However the column name appears to be truncated one char too early; bookid becomes booki and authid becomes authi. Seems to be consistent across databases. -- --- Colin Beckingham 613-454-5369 http

Re: [pgadmin-support] dev 1.15 wxwidgets - constraints with multiple tables

On 04/06/2012 04:10 PM, Guillaume Lelarge wrote: On Fri, 2012-04-06 at 15:11 -0400, Colin Beckingham wrote: On 04/06/2012 02:40 PM, Guillaume Lelarge wrote: On Fri, 2012-04-06 at 08:03 -0400, Colin Beckingham wrote: Given 3 tables, authors, books and words, each has a primary key

Re: [pgadmin-support] dev 1.15 wxwidgets - constraints with multiple tables

On 04/06/2012 02:40 PM, Guillaume Lelarge wrote: On Fri, 2012-04-06 at 08:03 -0400, Colin Beckingham wrote: Given 3 tables, authors, books and words, each has a primary key. Attempting to use pgadmin to add a foreign key to books to link authors to books, and a key to words to link words to

[pgadmin-support] dev 1.15 wxwidgets - constraints with multiple tables

ing a step. table books definitely has a primary key. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] dev 1.15 wxwidgets 2.9.3 - adding constraints

e_invoke() [57] g_signal_emit_valist() [58] g_signal_emit() [59] gtk_propagate_event() [60] gtk_main_do_event() [61] g_main_context_dispatch() [62] g_main_loop_run() [63] gtk_main() -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Constraint column missing from properties?

not listed. This seems a bit strange but it might be deliberate to avoid mistaken deletes, etc. If it sounds like an error I can post detailed process to arrive at the situation. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support

Re: [pgadmin-support] 1.15 dev: cut and paste

On 03/25/2012 04:08 AM, Guillaume Lelarge wrote: On Fri, 2012-03-23 at 13:12 -0400, Colin Beckingham wrote: 1. open database, drill down to table, select show data from context menu 2. select a record with some text fields. Highlight one entry so that it goes into editing mode 3. right click

[pgadmin-support] 1.15 dev: cut and paste

le() [21] wxApp::DoIdle() [22] g_main_context_dispatch() [23] g_main_loop_run() [24] gtk_main() -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] 1.15 dev: cut and paste

into edit mode 5. context menu shows Paste active, but clicking on it does not paste anything; no error. 6. Ctrl+v successfully pastes the contents of the buffer. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To

[pgadmin-support] 1.15 dev: execute plugin error

ent&) [11] wxEvtHandler::SafelyProcessEvent(wxEvent&) [12] g_closure_invoke() [13] g_signal_emit_valist() [14] g_signal_emit() [15] gtk_propagate_event() [16] gtk_main_do_event() [17] g_main_context_dispatch() [18] g_main_loop_run() [19] gtk_main() -- --- Colin Beckingham 613-454-5369 http://www.it4

[pgadmin-support] 1.15 dev: DB designer and new table create

tails entered causes the dialog title bar to appear with draggability and close X. I thought in previous versions a default 'tableX' table name was entered, then having 'OK' and 'generate' buttons active on open makes some sense. -- --- Colin Beckingham 613-

[pgadmin-support] 1.15 dev: error on delete record

) [15] g_closure_invoke() [16] g_signal_emit_valist() [17] g_signal_emit() [18] g_closure_invoke() [19] g_signal_emit_valist() [20] g_signal_emit() [21] g_closure_invoke() [22] g_signal_emit_valist() [23] g_signal_emit() [24] gtk_propagate_event() [25] gtk_main_do_event() [26] g_main_context_dispatch(

Re: [pgadmin-support] Strange character in Table Properties

On 03/13/2012 06:45 PM, Colin Beckingham wrote: On 03/13/2012 05:18 PM, Guillaume Lelarge wrote: On Tue, 2012-03-13 at 08:30 -0400, Colin Beckingham wrote: 1.15 Dev, latest from git. This is not an error, no crash, no backtrace, just an unexplained character in property definition. 1

Re: [pgadmin-support] Strange character in Table Properties

On 03/13/2012 05:18 PM, Guillaume Lelarge wrote: On Tue, 2012-03-13 at 08:30 -0400, Colin Beckingham wrote: 1.15 Dev, latest from git. This is not an error, no crash, no backtrace, just an unexplained character in property definition. 1. open pgadmin 2. drill down and right click a table

[pgadmin-support] Strange character in Table Properties

3-col group, phantom number to the right disappears from the currently selected row and if absent from previously selected row appears there. Looks like the string is pulling in a character from a different buffer. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadm

[pgadmin-support] 1.15 Dev : Insert fails

r::DoTryChain(wxEvent&) [8] wxEvtHandler::ProcessEvent(wxEvent&) [9] wxEvtHandler::ProcessPendingEvents() [10] wxAppConsoleBase::ProcessPendingEvents() [11] wxApp::DoIdle() [12] g_main_context_dispatch() [13] g_main_loop_run() [14] gtk_main() -- --- Colin Beckingham 613-454-5369 http://www.it4gh.co

[pgadmin-support] pgadmin3 window behaviour parenthesis matching

behaviour. This should have eliminated a large number of the configuration possibilities. If anyone has an idea what settings might influence text editing window behaviour it would be interesting to know. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support

[pgadmin-support] 1.15 Dev: menu "table -> maintenance"

ndler::SafelyProcessEvent(wxEvent&) [49] g_closure_invoke() [50] g_signal_emit_valist() [51] g_signal_emit() [52] gtk_propagate_event() [53] gtk_main_do_event() [54] g_main_context_dispatch() [55] g_main_loop_run() [56] gtk_main() -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com --

[pgadmin-support] QB - record count incorrect

On open QB, drill down to table, right click table name, seek menu item View Data, sub menu items top and last contain odd number of records 398316718 which should be 100, table opens correctly, but count of records in status bar is also incorrect. -- --- Colin Beckingham 613-454-5369 http

Re: [pgadmin-support] Error in Query Builder: multi-line sql

On 03/10/2012 09:19 AM, Colin Beckingham wrote: On 03/10/2012 08:38 AM, Guillaume Lelarge wrote: On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote: [...] select distinct on (mname, nname) mname, nname from grammar \ inner join majors using (mid) \ inner join minors using (nid

Re: [pgadmin-support] Error in Query Builder: multi-line sql

On 03/10/2012 08:38 AM, Guillaume Lelarge wrote: On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote: [...] select distinct on (mname, nname) mname, nname from grammar \ inner join majors using (mid) \ inner join minors using (nid) \ inner join

[pgadmin-support] Error on delete row

gnal_emit() [24] gtk_propagate_event() [25] gtk_main_do_event() [26] g_main_context_dispatch() [27] g_main_loop_run() [28] gtk_main() -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Error in Query Builder: multi-line sql

into multiple lines, edits now work ok. I wondered if I am inserting unprinted characters from Kwrite so I tried with CLI editor Joe. Same effect. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to

Re: [pgadmin-support] Error: cannot mix different types of client data

On 03/07/2012 09:10 AM, Guillaume Lelarge wrote: On Wed, 2012-03-07 at 07:07 -0500, Colin Beckingham wrote: Houston, we have a problem. Using 1.15 dev latest pull from git. Steps: 1. connect to postgresql server 2. select a database but the wrong one (deliberate misstep) 3. open query builder

[pgadmin-support] Error: cannot mix different types of client data

ist() [18] g_signal_emit() [19] gtk_widget_activate() [20] gtk_menu_shell_activate_item() [21] g_closure_invoke() [22] g_signal_emit_valist() [23] g_signal_emit() [24] gtk_propagate_event() [25] gtk_main_do_event() [26] g_main_context_dispatch() [27] g_main_loop_run() [28] gtk_main() -- --- Colin Be

[pgadmin-support] View create usage

is not the case. 6. leave name blank 7. enter a definition or security label 8. go back and enter name, status bar updates and OK is active. Suggestion: After name field is updated, status bar indicates new field that is required to activate OK button. -- --- Colin Beckingham 613-454

[pgadmin-support] Dev 1.15 + wxWidgets 2.9.3 : Segfault in search and replace text

r of rows or columns followed by Error XRC error 86 unexpected item in sizer messages repeat. (error message not text copiable so rendering is approximate.) -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To ma

Re: [pgadmin-support] 1.15 Dev + wxWidgets 2.9.3: Macros menu item in QB

On 03/05/2012 09:37 AM, Guillaume Lelarge wrote: On Mon, 2012-03-05 at 09:30 -0500, Colin Beckingham wrote: Confirmed that previous reported errors mopped up. Thanks. New item: Macros menu item 1. open pgadmin3 2. click icon to open query builder 3. click on QB menu item "M

[pgadmin-support] 1.15 Dev + wxWidgets 2.9.3: Macros menu item in QB

signal_emit_valist() [13] g_signal_emit() [14] gtk_widget_activate() [15] gtk_menu_shell_activate_item() [16] g_closure_invoke() [17] g_signal_emit_valist() [18] g_signal_emit() [19] gtk_propagate_event() [20] gtk_main_do_event() [21] g_main_context_dispatch() [22] g_main_loop_run() [23] gtk_ma

[pgadmin-support] 1.15 dev + wxWidgets 2.9.3, properties and index

dexes for a table, attempt to add new index: $ /usr/local/pgadmin3/bin/pgadmin3 09:58:24 AM: Debug: Adding duplicate image handler for 'PNG file' ./src/common/sizer.cpp(1850): assert "m_growableRows[n] < nrows" failed in AdjustForGrowables(): invalid growable row index Tra

Re: [pgadmin-support] Panel height redimensioning in Query builder

On 03/03/2012 02:05 AM, Guillaume Lelarge wrote: On Thu, 2012-03-01 at 00:18 +0100, Guillaume Lelarge wrote: On Tue, 2012-02-28 at 11:26 -0500, Colin Beckingham wrote: On 02/28/2012 10:28 AM, Guillaume Lelarge wrote: On Thu, 2012-02-23 at 13:41 -0500, Colin Beckingham wrote: Using

[pgadmin-support] 15.1 Dev + wxwidgets 2.9.3 - open query builder error

event() [31] g_main_context_dispatch() [32] g_main_loop_run() [33] gtk_main() -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] 1.15 Dev with wxwidgets 2.9.3

On 03/03/2012 10:36 AM, Guillaume Lelarge wrote: On Sat, 2012-03-03 at 15:02 +, Dave Page wrote: On Sat, Mar 3, 2012 at 1:54 PM, Colin Beckingham wrote: Inspired by Guillaume's successful compile of the dev version with 2.9.x I felt adventurous and installed wxWidgets 2.9.3 (from s

Re: [pgadmin-support] 1.15 Dev with wxwidgets 2.9.3

On 03/03/2012 10:02 AM, Dave Page wrote: On Sat, Mar 3, 2012 at 1:54 PM, Colin Beckingham wrote: Inspired by Guillaume's successful compile of the dev version with 2.9.x I felt adventurous and installed wxWidgets 2.9.3 (from source, no 2.9.x version available from opensuse yet) and tri

[pgadmin-support] 1.15 Dev with wxwidgets 2.9.3

boot, no apparent issues. Ran make uninstall, make clean in wxwidgets, reinstalled wxwidgets-container + devel (2.8.x) with Yast, but configure problem in pgadmin persists. My current version of pgadmin3 previously compiled is still working, just cannot update. -- --- Colin Beckingham 613

Re: [pgadmin-support] Panel height redimensioning in Query builder

On 02/28/2012 10:28 AM, Guillaume Lelarge wrote: On Thu, 2012-02-23 at 13:41 -0500, Colin Beckingham wrote: Using OpenSUSE 12.1, pgadmin3 1.15 Dev (updated today) In the query builder, open the SQL editor. 1 - attempt to adjust the height of the editor panel. Cursor changes shape, and drag

[pgadmin-support] Error "column not found in pgSet: current_query"

ht to server status window, but this is overlaid by a message box "column not found in pgSet: current_query". Repeated clicks on OK in msg box have no effect. Repeated clicks on the server status window X control eventually bring up a 'Force quit' dialog which allows me to

[pgadmin-support] Panel height redimensioning in Query builder

er bar the cursor changes and a visual guide bar appears, allowing height adjustment. Suggestion, allow mouse cursor to change on rollover of sensitive area (as in 1) -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgres

[pgadmin-support] Dev 1.15 Database Designer

ete active table in browser -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Feedback on database designer (1.15 Dev)

t multiple items can be selected and moved in a block, and that items do not appear in both panels at the same time! -- --- Colin Beckingham http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [pgadmin-support] Feedback on database designer (1.15 Dev)

ill this have on my original db?" Perhaps none. Maybe it is just a matter of how the prompts are worded/presented. -- --- Colin Beckingham http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Feedback on database designer (1.15 Dev)

lete one of the tables from the designer the relationship link remains in place. This is confusing since one end then points to nothing. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your

[pgadmin-support] Pgadmin3 : Opensuse 11.4 to 12.1 upgrade

en I found that it was using the ip v6 line to authenticate. Once that also was changed to trust it all works again. -- --- Colin Beckingham http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.or

Re: [pgadmin-support] Delete function disabled

On 11/24/2011 04:59 AM, Dave Page wrote: On Thu, Nov 24, 2011 at 9:53 AM, Colin Beckingham wrote: On 11/24/2011 03:52 AM, Nick Rogers wrote: I use pgAdmin v1.14.0 multiple databases stored on multiple servers. I am able to use the GUI to insert rows and edit existing rows. But when it

Re: [pgadmin-support] Delete function disabled

elete" toolbar button is disabled as well as the "Delete" item in the "Edit" menu. This is the case for all of the servers I connect to, including localhost. Why is this happening? Thanks! I get this as well. However if the table has OIDs then the delete button activa

Re: [pgadmin-support] trouble restoring and other bugs

On 11/22/2011 04:18 PM, John Fabiani wrote: On Tuesday, November 22, 2011 11:57:38 AM Colin Beckingham wrote: On 11/22/2011 11:26 AM, John Fabiani wrote: FWIW I tried upgrading to 12.1 OpenSUSE and had the nasty surprise that the upgrade took me from my Postgresql 9.0 to 9.1. From 9.1 I

Re: [pgadmin-support] trouble restoring and other bugs

kup restore procedure: http://www.postgresql.org/docs/9.1/static/backup.html -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Crash on delete record with filter in place

On 09/19/2011 04:53 PM, Colin Beckingham wrote: On 09/19/2011 03:12 PM, Guillaume Lelarge wrote: On Sat, 2011-09-17 at 17:45 -0400, Colin Beckingham wrote: Using pgadmin 1.15 Dev on Opensuse 11.4, kernel 3.0. Viewing the data in a table with full data set visible, select a record for

  1   2   >