[pgadmin-support] Improvement to Dropped DB Connections

2007-05-24 Thread Bob
other words --- EVEN IF the DB connection is closed by accident, pgAdmin should not require the user to extra work to open it back up again. Sincerely, --- Bob Connection to database dropped I'm connecting to the database server via a firewall. After some minutes of inactivity, the connecti

[pgadmin-support] Possible Bug Version 1.8.0 Beta 5 on Windows XP Service Pack 2 Postgresql 8.3 on FreeBSD6.2

2007-09-17 Thread Bob
Right click on a table-> go to properties-> create pk constraint and add column click ok. A unhandled exception occurs on my machine and pgadmin exits.

[pgadmin-support] Trouble using debugger and profiler

2007-11-01 Thread Bob
/* We have to log the transactional effect at the proper level */ if (pgstat_info->trans == NULL || ---END pgstat.c.rej--- Any ideas of what might be wrong or if I'm doing something wrong? I appreciate any help on this. Thanks, Bob

Fatal Error

2002-02-25 Thread Bob T
gn next to itand by clicking on the plus you can see the individual databases. If at any time I click on the primary container (Databases) I will get theabove error as pgAdmin II attempts to open all datesbases including templat=e0.Anyone else using pgAdimin II experience this behavior..Bob T

[pgadmin-support] Debian Alpha (unstable) build produces bad binary

2003-09-15 Thread Bob Kimble
m runs just fine on the Mandrake box. I don't know if there's something missing from the Debian package build or what. Anybody have any suggestions on what I should look for? Regards, Bob ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad binary

2003-09-15 Thread Bob Kimble
18a604 in pgAdmin3::OnInit() () #10 0x00012018b7dc in wxAppConsole::CallOnInit() () #11 0x0001205269b4 in wxEntry(int&, wchar_t**) () #12 0x000120526b04 in wxEntry(int&, char**) () #13 0x0001201886f0 in main () (gdb) Regards, Bob ---(end of broadca

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad binary

2003-09-15 Thread Bob Kimble
Here's the backtrace. Doesn't look like much help to me. Is there some way to get the Debian packages to build an executable with the debugging symbols? (gdb) r Starting program: /usr/bin/pgadmin3 (no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)... (no d

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad binary

2003-09-15 Thread Bob Kimble
in3::OnInit(), if I'm reading the output correctly. Is it possible that some bug was introduced into the 2.2.4 version of gtk that I installed? Is there another program I could run to test gtk? I have everything but the kitchen sink installed on that machine -- as I said, it's just for

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad binary

2003-09-15 Thread Bob Kimble
On Monday 15 September 2003 13:06, Andreas Pflug wrote: > Bob Kimble wrote: > Well that looks good, or really bad. It's wxGetSingleChoiceIndex in line > 201 pgAdmin3.cpp, which has just 4 parameters (rest is default), and > they're certainly ok. > wxWindows tries to creat

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad binary

2003-09-16 Thread Bob Kimble
it. :-) I'll try to figure out how to print out the parameters as you indicate. However, if Andreas wants access to my machine, it's no problem. I'll be quite happy to give him an account. It's just an AlphaPC sitting in my basement at home. Regard

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad

2003-09-18 Thread Bob Kimble
o, I didn't. > Actually, that call from wx into gtk is > m_wxwindow = gtk_pizza_new(), > so wx has little chance to screw up the parameters, there are none. > Bob, did you try a wx sample? This can only be solved by somebody with > deep gtk experience, I believe. > > Rega

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad

2003-09-19 Thread Bob Kimble
On Thursday 18 September 2003 11:30, Andreas Pflug wrote: > Hi Bob, > It would have been quite a surprise if that sample didn't crash too. > Please post that issue at wxWindow's bug system. > > Regards, > Andreas Sounds good. However, the version of wxWindows used by

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad

2003-09-19 Thread Bob Kimble
On Thursday 18 September 2003 10:06, Andreas Pflug wrote: > Bob Kimble wrote: > >I'm not really sure what a good example of a wx program is. > > Hi Bob, > > the internat sample is quite good, it uses the same > wxGetSingleChoiceIndex as pgAdmin3 to select the languag

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad

2003-09-20 Thread Bob Kimble
On Thursday 18 September 2003 12:17, Andreas Pflug wrote: > Bob Kimble wrote: > >On Thursday 18 September 2003 11:30, Andreas Pflug wrote: > >>Hi Bob, > >>It would have been quite a surprise if that sample didn't crash too. > >>Please post that issue a

Re: [pgadmin-support] Debian Alpha (unstable) build produces bad

2003-09-21 Thread Bob Kimble
Hi Raphael, On Saturday 20 September 2003 22:34, [EMAIL PROTECTED] wrote: > Nice to hear good news from you Bob, > no other problem than electrical loss with Isabel ? We were fortunate. We just lost electrical power for a little more than half a day. No big deal for us. > I lost many

[pgadmin-support] pgadminIII possible bug

2004-01-29 Thread Bob Kesselman
Title: Message using source installation, windows xp pro (tablet).  No database installed on this machine:  connecting to server via LAN.   when I highlight a table in the tree (left side of interface) and open the query tool, the table structure automatically loads into the query tool.  Gre

[pgadmin-support] Version 1.6.1

2006-12-04 Thread Bob Pawley
the tables manually. With the tables that don't show the anticipated next row this is not possible. In fact, when I attempt to enter information manually PG Admin shuts down. Any help would be appreciated. Bob Pawley

[pgadmin-support] Fw: PG Admin

2006-12-04 Thread Bob Pawley
I just installed PostgreSQL 8.1 and PG Admin 1.6.1 . These versions have a sequential column, that is not part of the table, identifying the rows. Is there any method of accessing those numbers and identifying them with elements within the table?? Bob Pawley

Re: [pgadmin-support] Version 1.6.1

2006-12-04 Thread Bob Pawley
present in both version 1.6.1 and the earlier version that came packaged with the Win 32 PostgreSQL installation. I didn't have this problem with the PG Admin that came with the PostgreSQL 8.0 version - so it may be that I have done something the new version doesn't like. Bob

Re: [pgadmin-support] Version 1.6.1

2006-12-05 Thread Bob Pawley
Yes please send me the fix. I am sure. I didn't know of version 1.6.1 until I had the same problem with the Win installation version. Thanks for your help. Bob - Original Message - From: "Dave Page" <[EMAIL PROTECTED]> To: "Bob Pawley" <[EMAI

[pgadmin-support] v1.8.0 BETA Language Node Question

2007-07-16 Thread Bob Henkel
I can't find the language node(Databases->YOUR DB NAME->Languages. Am I missing something or is this by design? I personally found this node handy in previous versions. Bob

[pgadmin-support] Minor Bug with large grid result

2007-07-24 Thread Bob Henkel
the contents of the app you tabbed from under the grid. Looks like some kind of refresh issue. Thanks Bob

[pgadmin-support] Re: [PORTS] pgadmin3 on Fedora7 - can't run standard binary, can't compile from source..

2007-10-08 Thread Bob Gustafson
am running: gcc (GCC) 4.1.2 20070925 (Red Hat 4.1.2-27) But the incompatible library bug (finessed by downloading and building from new source), is just a lack of testing by someone in the pgadmin -> Fedora chain. Bob G On Mon, 2007-10-08 at 10:55 +0100, Dave Page wrote: > [Bob -

[pgadmin-support] old server still listed in pgAdminIII after upgrade of PostgreSQL

2008-08-20 Thread MacDonald, Bob
the old information removed when I install the new version. Thanks for your help, Bob

[pgadmin-support] View last 100 records

2010-06-08 Thread Bob McConnell
a table? Thank you, Bob McConnell -- 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] pgmigration for pgadminIII

2010-06-17 Thread Bob McConnell
e available, but searching www.pgfoundry.org would > probably be a good start. There are several commercial tools that will automate the migration between those products. But if you are willing to do some of the work, the Perl DBI libraries provide most of the foundation needed. Bob McConnell

Re: [pgadmin-support] Graphical Query Builder -- expanding public requires annoying double click

2010-09-24 Thread Bob McConnell
much of a cost of doing the scan >> anyway? The user will nearly always need to open the schema node >> anyway. >> > > I'm not sure we can do this. The "+" sign appears when the node has > children. And before one double clicks on the node, there a

[pgadmin-support] Version 1.10.5

2011-04-24 Thread Bob Pawley
. Using version 1.10.0 all of these fields are fully accessible. The fields are quite large (3 plus pages in word). Is this a known problem or am I not doing something properly?? Bob

Re: [pgadmin-support] Version 1.10.5

2011-04-26 Thread Bob Pawley
field. So I don't know when the function works and when it doesn't. Do you have a time line when this may be corrected? Bob -- View this message in context: http://postgresql.1045698.n5.nabble.com/Version-1-10-5-tp4336654p4341209.html Sent from the PostgreSQL - pgadmin support mailing

Re: [pgadmin-support] Version 1.10.5

2011-04-28 Thread Bob Pawley
ware and proprietary versions of PGAdmin give me no problems in viewing all geometries. Hope this helps. Bob -- View this message in context: http://postgresql.1045698.n5.nabble.com/Version-1-10-5-tp4336654p4347012.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Re: [pgadmin-support] Usability improvment ideas

2011-05-11 Thread Bob McConnell
them, then hit F9, it will only execute the highlighted statements. Bob McConnell -- 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] facing problem in accessing postgresql with c language normally

2011-05-13 Thread Bob McConnell
PQclear(res); > close_conn(conn); > } > else > { > printf("insert employee record - OK\n"); > } > //create_employee_table clear result > PQclear(res); > } It looks like you need to spend some time learning how to write code in C. You did not a

Re: [pgadmin-support] Pgadmin III loses connection with remote database and then hangs for a long time.

2011-05-31 Thread Bob McConnell
coming from my workstation. > > And no switch between them? Usually, this kind of issues happens because > of a faulty firewall or switch. I have seen similar problems on routers and switches that were overloaded or misconfigured. Adding memory, or just increasing the number of buffers

Re: [pgadmin-support] Pgadmin III loses connection with remote database and then hangs for a long time.

2011-06-01 Thread Bob McConnell
reliably, perhaps you should post it there so the developers can take a closer look at it. If you go that route, I suggest using Wireshark to capture one or more sessions that lock up the client and attach the raw capture files onto the bug report. This will help them identify the actual probl

Re: [pgadmin-support] Pgadmin III loses connection with remote database and then hangs for a long time.

2011-06-01 Thread Bob McConnell
code. I find it much better to report the symptoms with as much supporting data as I can so the people that understand how it works can do the diagnosis. Bob McConnell -- 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] Is 1.14 supposed to behave differently when it loses connection?

2011-06-15 Thread Bob McConnell
tion is no longer usable, and every application running on the client suffers from the delays in the meantime. We are currently troubleshooting this problem with COM+/DCOM connections at a client site. Like your description, theirs seems to be due to firewalls that drop connections from their state tabl

[pgadmin-support] pgadmin3 -- adding CHECK constraint

2011-09-28 Thread Bob Vandy
I've googled and found no answer for the following: (I'm using pgAdmin v 1.14.0) I have a simple table with a column: Status character varying(9) NOT NULL I try to add a CHECK Constraint, whose definition is: Status in ('Assigned', 'Deleted', 'Available') When I click OK, I get

[pgadmin-support] Fwd: pgadmin3 -- adding CHECK constraint

2011-09-28 Thread Bob Vandy
----- From: Bob Vandy Date: Wed, Sep 28, 2011 at 7:04 PM Subject: pgadmin3 -- adding CHECK constraint To: pgadmin-support@postgresql.org I've googled and found no answer for the following: (I'm using pgAdmin v 1.14.0) I have a simple table with a column: Status character varyin

Re: [pgadmin-support] SQL pane font

2011-10-12 Thread Bob McConnell
From: Fernando Hevia > You can use Control key + mouse scroll wheel for instant resizing. > For a permanent setup take a look in the File->Options menu. That makes it a little difficult for me. The Logitech Marble Mouse doesn't have a scroll wheel. Bob McConnell -- Sent via p

Re: [pgadmin-support] SQL pane font

2011-10-12 Thread Bob McConnell
From: Guillaume Lelarge > On Wed, 12 Oct 2011 14:19:53 -0400, "Bob McConnell" wrote: >> From: Fernando Hevia >> >>> You can use Control key + mouse scroll wheel for instant resizing. >>> For a permanent setup take a look in the File->Options menu.

Re: [pgadmin-support] SQL pane font

2011-10-12 Thread Bob McConnell
From: Guillaume Lelarge > On Wed, 2011-10-12 at 14:56 -0400, Bob McConnell wrote: >> From: Guillaume Lelarge >> >> > On Wed, 12 Oct 2011 14:19:53 -0400, "Bob McConnell" >> wrote: >> >> From: Fernando Hevia >> >> >>

Re: [pgadmin-support] SQL pane font

2011-10-12 Thread Bob McConnell
From: Fernando Hevia > Bob, I was going to suggest you get rid of that weird mouse > of yours but it wont be necessary as Ctrl-+ and Ctrl-- already > work as suggested. At least in v1.14.0 it does. > > :) Don't even think about it. The Marble Mouse is the only decent trackba

Re: [pgadmin-support] ask a question

2012-02-17 Thread Bob McConnell
y laptop. I want to ask you, how to create a database in DDI for ISS?? > > > > What is IIS? > > Internet Information Server. I'm wondering what ISS is though :-D International Space Station? Bob McConnell -- Sent via pgadmin-support mailing list (pgadmin-support@

[pgadmin-support] All new member here.

2015-04-28 Thread Basques, Bob (CI-StPaul)
Hello all, So, I've been looking high and low for information about moving a PGADMIN config from one machine (mac) to another (mac & Linux) Is there a method of exporting all the DB connection strings, etc and moving/sharing them to another machine/pgadmin? I've found mostly windows informat

Re: [pgadmin-support] PGAgent Question

2017-04-04 Thread Basques, Bob (CI-StPaul)
daylight savings time?? (CDT vs CEN time?) On Apr 4, 2017, at 4:27 PM, Dave Barter mailto:d...@phased.co.uk>> wrote: All of our scheduled jobs are running 1 hour after the time being set in PGAdmin III Any idea why? The servers report the correct date and the timezone on postgres is set cor