Re: [pgadmin-support] Running explain analyze in a transaction

2015-04-11 Thread Tim Uckun
hanks. On Sat, Apr 11, 2015 at 2:50 AM, Guillaume Lelarge wrote: > Hi, > > 2015-04-10 1:13 GMT+02:00 Tim Uckun : > >> I want to to do the following. >> >> begin; >> explain analyze blah >> rollback; >> >> If I do this I don't get the resul

Re: [pgadmin-support] Create, Insert etc scripts

2014-06-26 Thread Tim Uckun
Thanks. I'll take a look at the source. On Thu, Jun 26, 2014 at 7:43 PM, Dave Page wrote: > On Thu, Jun 26, 2014 at 2:54 AM, Tim Uckun wrote: > > Hi All. > > > > What is the technique pgadmin uses to generate those scripts? I would > like > > to b

[pgadmin-support] Create, Insert etc scripts

2014-06-26 Thread Tim Uckun
Hi All. What is the technique pgadmin uses to generate those scripts? I would like to be able to generate them from my own application using a pg connection. Thanks.

[pgadmin-support] Using pgadmin with redshift.

2014-02-27 Thread Tim Uckun
Hi all. I tried to use pgadmin with redshift and it doesn't seem to work very well. It connects to the database but can't seem display anything useful. It throws up some error messages after it connects and can't really show anythinng in the DB. I tried using an older version but that didn't wo

Re: [pgadmin-support] The statistics and other tabs not working on MacOSX

2013-04-22 Thread Tim Uckun
> They work for me, both switching between tabs, or if I put them all > side by side. Can you give more info about what you're doing exactly? > > I am not doing anything special. Connect to the database, navigate to the schema, navigate to tables, click on a table. The right pane shows the structu

[pgadmin-support] The statistics and other tabs not working on MacOSX

2013-04-21 Thread Tim Uckun
Hey guys. It's me again. On the table listings when you click on a table you get the structure of the table on the right hand section of the window (after a pause of course). The other tabs on that section like statistics, dependents etc don't do anything when I click on them. Just FYI.

Re: [pgadmin-support] Why is pgadmin so slow to display data on a Mac?

2013-04-19 Thread Tim Uckun
I am running 1.16.1 OSX 10.8.3 I am using the default config which has the logging set at errors only. I had a discussion with a couple of other people at the office today and they too reported similar problems (and others). Are you guys using a local postgres or a remote one? I am usually using

[pgadmin-support] Why is pgadmin so slow to display data on a Mac?

2013-04-18 Thread Tim Uckun
PgAdmin extremely slow to display data on a Mac (I haven't tried it on other platforms). I have a Macbook Air 2GHz i7 with eight gigs of ram and of course the SSD drive and yet PgAdmin is painful to use. I am almost certain this is due to some problem with rendering results and not fetching the re

Re: [pgadmin-support] PGadmin has a very hard time dealing with momentary network interruptions.

2012-05-02 Thread Tim Uckun
Wed, May 2, 2012 at 2:50 AM, Guillaume Lelarge wrote: > On Tue, 2012-05-01 at 10:59 +1200, Tim Uckun wrote: >> I mentioned this before but. >> >> If PGadmin loses connection even momentarily it causes a crash. First >> you get a syscall error and then it crashes (deta

[pgadmin-support] PGadmin has a very hard time dealing with momentary network interruptions.

2012-04-30 Thread Tim Uckun
I mentioned this before but. If PGadmin loses connection even momentarily it causes a crash. First you get a syscall error and then it crashes (details below) and has to be restarted. Process: pgAdmin3 [5658] Path:/Applications/pgAdmin3.app/Contents/MacOS/pgAdmin3 Identifier:

Re: [pgadmin-support] MacOSX and pg_service

2012-01-25 Thread Tim Uckun
> With the informations you told us, I can only conclude that the problem > is not pgAdmin or the pg_service file, but Mac OS X. You may be right. I was not having this problem with Linux. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscrip

Re: [pgadmin-support] MacOSX and pg_service

2012-01-25 Thread Tim Uckun
> pg_service is only used when connecting. It has nothing to do with > losing connections. Or did I misunderstood something in you mail? > When I was having problems with connections dropping out I was advised to use a pg_service because it sets up keepalives and such like this keepalives=1 keep

[pgadmin-support] MacOSX and pg_service

2012-01-24 Thread Tim Uckun
I recently switched from ubuntu to a mac and pgadmin does not seem to be obeying my pg_service params. Specifically I am suffering from horrible disconnection problems. I had the disconnection problems with ubuntu as well until I upgraded to 1.14 and started using .pg_service file. Does pgadmin lo

Re: [pgadmin-support] Error when trying to build on Ubunt 11.10

2011-10-28 Thread Tim Uckun
I installed a couple of -dev packages and got a little further. Now I get this error. ./db/keywords.c:33:27: fatal error: parser/kwlist.h: No such file or directory compilation terminated. make[3]: *** [keywords.o] Error 1 make[3]: Leaving directory `/usr/local/home/tim/Downloads/pgadmin3-1.14.0/

Re: [pgadmin-support] Error when trying to build on Ubunt 11.10

2011-10-27 Thread Tim Uckun
> All this probably means it doesn't find the wxWidgets headers. How did > you do the configure step? can you tell us a bit more on your way to get > the whole thing? I ran configure and it complained about missing wxwidgets. I did an apt-get install on wxwidgets 2.8 and the configure went throug

[pgadmin-support] Error when trying to build on Ubunt 11.10

2011-10-26 Thread Tim Uckun
I am getting the following error when running make. Configure went smoothly. ./pgAdmin3.cpp: In function ‘wxAppConsole* wxCreateApp()’: ./pgAdmin3.cpp:117:1: error: cannot allocate an object of abstract type ‘pgAdmin3’ ../pgadmin/include/pgAdmin3.h:147:7: note: because the following virtual fun

[pgadmin-support] Debs

2011-10-21 Thread Tim Uckun
I am using Ubuntu 11.10 and the pgadmin in the repos is 1.12. There is a PPA at https://launchpad.net/~rhonda/+archive/pgadmin3 but it hasn't been updated for months so it's still the beta and there is no channel for 11.10. Does anybody know where I can get a deb of 1.14? Cheers. -- Sent via pg

[pgadmin-support] feature request

2011-08-30 Thread Tim Uckun
The drop down boxes in pgadmin don't have autocomplete and don't jump to the items that start with the character you type. Most of them have a very long list of items in seemingly random order (function return types for example) so an autocomplete would make this a lot easier to use. Also while I

Re: [pgadmin-support] Timing out.

2011-08-09 Thread Tim Uckun
>Use a pg_service.conf file, and pgAdmin 1.14. This way, only pgAdmin >will use the connection configuration. Are there debs or a ppa for the pgadmin 1.14? I saw that you had debs for older Ubuntu version but not the recent ones. -- Sent via pgadmin-support mailing list (pgadmin-support@postg

Re: [pgadmin-support] Timing out.

2011-08-09 Thread Tim Uckun
On Tue, Aug 9, 2011 at 7:51 PM, Dave Page wrote: > Use the keep-alive options on the server. That effects all the clients. Tora has a feature where you can tell it to ping the server every once in a while so I think this would be a good feature for pgadmin too. -- Sent via pgadmin-support mail

[pgadmin-support] Timing out.

2011-08-08 Thread Tim Uckun
There was a discussion recently about pgadmin timing out and hanging up. I suffer from this a lot because I work with remote databases and it really is painful. I would like to make a request that there be an option for pgadmin to send a query to the database every 10 seconds or something to keep

Re: [pgadmin-support] Is 1.14 supposed to behave differently when it loses connection?

2011-06-19 Thread Tim Uckun
Hey guys. I have had the misfortune to try and work with pgadmin 1.12 on a remote database for the last couple of days and experience has been miserable to say the least. It frequently lost connection to the database, even pulling up ten or twenty records caused it to throw fits and lock up so I

Re: [pgadmin-support] Is 1.14 supposed to behave differently when it loses connection?

2011-06-15 Thread Tim Uckun
> However, the pgAdmin crash/loss of reliability has nothing to do with > Ms-Windows. This happens to me on a Mac. I want to report that it also happens on linux. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgres

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

2011-06-01 Thread Tim Uckun
> > The default TCP connection timeout is around 3 1/2 minutes. This is left > over from the leased line and slow connection days when the protocol was > defined and has never been updated to match the reality of high speed > networks. This may be the timer it is waiting for. Some of the > MS-Windo

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

2011-06-01 Thread Tim Uckun
> It may just be me, but this sounds like a bug. Have you looked at the > tracker to see if it has already been reported? Since it appears you can > reproduce it 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 Wire

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

2011-05-31 Thread Tim Uckun
> > I have seen similar problems on routers and switches that were > overloaded or misconfigured. Adding memory, or just increasing the > number of buffers available might fix the problem. My router is simply an ADSL modem, I have no control over the multitude of routers that are in the way betwee

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

2011-05-31 Thread Tim Uckun
> > You can play with the tcp parameters in postgresql.conf to make sure > your tcp line is alive. That's an idea. Thanks. -- 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] Pgadmin III loses connection with remote database and then hangs for a long time.

2011-05-28 Thread Tim Uckun
> > And no switch between them? Usually, this kind of issues happens because > of a faulty firewall or switch. I am sure there are lots of switches between me and the database. I live in New Zealand and the server is usually in the US usually a linode or rackspace node but sometimes it's also an E

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

2011-05-26 Thread Tim Uckun
I am using pgAdmin 1.12.1 oct 21 2010 rev-REL-1_12_1 from Martin Pitt's PPA on ubuntu maverick. Often when I connect to remote database the program seems to lose connection to the database and when this happens it just locks up tight with a blank screen. It stays locked up for a pretty long time a