Re: [pgadmin-support] pgAdmin 4 Connection to the server has been lost.

2017-03-28 Thread Boblitz John
Okay - short, sweet and to the point! Thanks > -Original Message- > From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support- > ow...@postgresql.org] On Behalf Of Dave Page > Sent: Dienstag, 28. März 2017 2:58 > To: Boblitz John > Cc: pgadmin-support@postgr

[pgadmin-support] pgAdmin 4 Connection to the server has been lost.

2017-03-28 Thread Boblitz John
, select it and select the properties or SQL tabs, I get "Connection to the server has been lost". Dashboard shows updated information statistics and dependencies are okay. On the new server, the properties and sql are shown correctly. Is there any way to fix this? Best Regards, John Boblitz

[pgadmin-support] Remove Me From The Mailing List

2017-01-05 Thread John Banfield
Thanks, John

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

2015-12-08 Thread John Banfield
Can anyone tell me if a log is kept when a backup is done with PGAdmin 3 We backed up a database then deleted the Database, now can not find the backup !!! Obviously this is a urgent appeal for guidance Regards, John

[pgadmin-support] Transition to wxWidgets 3.0

2015-03-12 Thread John Huss
re already in process in support of next version of wxWidgets.) Thanks for the report. Ashesh Vashi On Thu, Mar 3, 2011 at 4:33 AM, John Huss wrote: Platform: Mac OS X 10.6.6 Language: en Distribution: binary Version: 1.12.2 When I copy text from a plain text file in Eclipse and paste into pgA

Re: [pgadmin-support] Possible Bug: pgAdmin3 , OSX multi monitor quirk.

2015-03-03 Thread John Abraham
e All" or whatever window moving/tiling solutions are available in the app in the Window menu. Can we just add the standard "Window" menu to the OSX version of PgAdmin3, or is that too much of an operating system specific addition? It would be very nice to have a Window menu with the list of open windows at the bottom of it, as per standard OSX practice, so that I don't have to right-click on the dock and select "Show All Windows" and squint to figure out which one I want to interact with. — John Abraham > > -- > 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] Possible Bug: pgAdmin3 , OSX multi monitor quirk.

2015-03-03 Thread John Abraham
reset your preference file. 2) changing screen resolution to fix it each time it happens. This is easier and more reliable than unplugging the monitor. -- John Abraham Sent from my iPhone, please excuse any typos. > On Mar 2, 2015, at 2:18 PM, mark wrote: > > Hello, > >

[pgadmin-support] pgadmin3 segfaults (re-loading) a database

2014-07-16 Thread John Bleichert
9.1.13) Suggestions? Should I open a bug report? Let me know if I can provide more info. Debian stable server, Debian jessie client running pgadmin3 1.18.1. Thanks! -- --- John Bleichert-syb...@earthlink.net The heat from below can burn your eyes

[pgadmin-support] Problem with pg_baselinebackup

2014-01-16 Thread Sebastian, John (CONTR)
Hi Folks, I'm pretty new to Postgres. I have an extensive Oracle and MySQL background here. We are putting up test and production servers. I'm interested in doing online backups with WAL archiving turned on so that I can do point in time recovery. My database files are stored in /u01/postgres/d

[pgadmin-support] wxWidgets Debug Alert assert "sizeNew == -1"

2014-01-06 Thread John Abraham
ld I be filing a bug report or something? -- John Abraham j...@hbaspecto.com 403-232-1060 wxWidgets Debug Alert ../src/generic/grid.cpp(8116): assert "sizeNew == -1" failed in UpdateRowOrColSize(): New size must be positive or -1. Call stack: [00] wxGrid::DoSetColSize(int, int)

Re: [GENERAL] [pgadmin-support] Lost database

2013-12-09 Thread John R Pierce
, and pg_stop_backup() afterwards, which I sort of doubt would have been done based on what was written. -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make

Re: [pgadmin-support] Password setting having somewhat bizarre results.

2013-08-16 Thread John Foelster
You appear to have the situation in hand and the issue is quite easy to work around now that it has been identified. I can just await the roll out of the next Windows build while avoiding the errant behavior. As such I will be unsubscribing from the list, but can be reached if any further test

Re: [pgadmin-support] Password setting having somewhat bizarre results.

2013-08-13 Thread John Foelster
Not being quite sure how to get jpegs into my Comcast space, it's been a while since I had to share a screen cap, I just sent seven to you and the list as an attachment. The message bounced back from the list. are you, Dinesh, in receipt?

Re: [pgadmin-support] Password setting having somewhat bizarre results.

2013-08-12 Thread John Foelster
Ø Hi John, Ø Thank you so much for your co-ordination on fixing this issue. Ø I believe, i have found the cause of this. This is due to "VALID UNTIL '1969-12-31 00:00:00';" option. For confirming this, do you mind to do the following steps once again and let me know the

Re: [pgadmin-support] Password setting having somewhat bizarre results.

2013-08-12 Thread John Foelster
OK. I have done a quick test in my local windows 7. 1. I have logged into PG 9.2 as a super user("postgres"). 2. Created new login role by performing right click on "Login Role" - > "Create New Login". 3. Entered the new login name and password. 4. Disconnected from pgAdmin and re-logged in the

Re: [pgadmin-support] Password setting having somewhat bizarre results.

2013-08-11 Thread John Foelster
Apologies that this got sent to Dinesh rather than the mailing list. L Hi Dinesh, Sorry, I reread my original request for help and it was extremely unclear as I wrote it. Basically, I was using the PGAdmin interface to set passwords, and the interface reported that I had set them succ

[pgadmin-support] Password setting having somewhat bizarre results.

2013-08-11 Thread John Foelster
I'm migrating some moderately sized DBs from Access to Postgres because I can't deal with Access' performance issues and ANSI SQL noncompliance. I hit a snag at a rather unexpected place. Before we get started I should state that I'm using PGAdmin 1.16.1 on a Windows 8 64 bit machine. I'm awa

Re: [pgadmin-support] backup improvements

2013-01-22 Thread John Abraham
up or restore takes place.) -- John Abraham j...@hbaspecto.com On 2013-01-22, at 8:55 AM, Michal Kozusznik wrote: > Hello > I have idea about one more improvement to be queued. > After executing backup, Backup button turns into Done one (curious the Cancel > button remains, can't im

[pgadmin-support] how to build pgadmin3 when wxgtk was built with --disable-unicode ?

2013-01-07 Thread John Spencer
i built my wxgtk with --disable-unicode, because otherwise it uses the bloated UCS4 format, and the option --enable-utf8only doesnt have any effect (wx will still use UCS4). according to a wxgtk developer, using --disable-unicode will work fine with UTF8, which is usually used in linux. now

[pgadmin-support] Launching Application on Desktop in RHEL 6.1 pgsql 8.4

2012-07-12 Thread John Olsen
-- Hi We have RHEL 6.1 and postgres 8.4  we wanted to see and launch pgadmin from application pad but not visible  (neither is postgres itself) How do you attach the postgres system to the desktop app launch system in RHEL 6?

Re: [pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-15 Thread John Abraham
Excel specific format, which we don't > know. No, the same format that data is copied out, just text with some separators and quote characters. Just an additional row at the top with the column names. > 3. I don't own a copy of Excel, meaning I cannot test such a change. Paste it into a text editor to test it. Thanks a lot! -- John Abraham j...@hbaspecto.com

[pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-15 Thread John Abraham
udio to select data and copy them out, then paste them into another app (usually Excel.) With PGAdmin I select and copy the data, paste them into Excel, then *manually* type the column headers. I think both of these should be easy to implement, so I hope they can be implemented. --

[pgadmin-support] versions

2011-12-11 Thread John Fabiani
Hi, johnf@linux-12:~> pg_dump --version pg_dump (PostgreSQL) 9.1.1 johnf@linux-12:~> pg_restore --version pg_restore (PostgreSQL) 9.1.1 Can I still use the above version with Postgres 8.4 Johnf -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your

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

2011-11-22 Thread John Fabiani
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 cou

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

2011-11-22 Thread John Fabiani
On Monday, November 21, 2011 12:53:31 PM John Fabiani wrote: > Hi, > openSUSE 12.1 > pgadmin version 1.14.0(Oct 30, 2011) REl-1_14_0 > Postgres 8.4 > > I installed pgadmin using Yast. > > First I'm new to this interface and it could be that I'm doing somet

[pgadmin-support] trouble restoring and other bugs

2011-11-21 Thread John Fabiani
Hi, openSUSE 12.1 pgadmin version 1.14.0(Oct 30, 2011) REl-1_14_0 Postgres 8.4 I installed pgadmin using Yast. First I'm new to this interface and it could be that I'm doing something wrong. I have used earlier version of pgadmin for years without issues. 1. None of the messages that normall

[pgadmin-support] Wish list: Generate Reports

2011-06-21 Thread Boblitz John
dually - name would default to the table name, possibly appended with report type (ddl etc...). Lastly a generic location could be specified for the output ... Thanks,  John Who is General Failure, and why is he reading my hard disk? -- Sent via pgadmin-support mailing list (p

[pgadmin-support] PGAdmin - saving result sets from queries where one or more columns are of the type boolean

2011-04-16 Thread John Pagakis
I've noticed this problem for a while, but haven't reported it. Sorry. If you run a query in PGAdmin saving the results to disk and that query selects one or more booleans it takes orders of magnitude longer for the result set to save to disk that it does if you do not select those columns in the

Re: SOLVED [pgadmin-support] pgadminIII Configuration problem

2011-03-06 Thread Boblitz John
Merci! That fixed the problem! Cheers, John Who is General Failure, and why is he reading my hard disk? -Ursprüngliche Nachricht- Von: Guillaume Lelarge [mailto:guilla...@lelarge.info] Gesendet: Samstag, 5. März 2011 20:27 An: Boblitz John Cc: pgadmin-support@postgresql.org

[pgadmin-support] pgadminIII Configuration problem

2011-03-03 Thread Boblitz John
age that an adminpack needs to be set up. Supposedly, this is already in the postgresql-contrib* - but I am unable to find the correct Directory /usr/local/pgsql/share/contrib/. Any ideas what I have done wrong? (last time I'll ask ... :D ) John Who is General Failure, and why is he

[pgadmin-support] paste into SQL editor from Eclipse on Mac doesn't work

2011-03-02 Thread John Huss
Platform: Mac OS X 10.6.6 Language: en Distribution: binary Version: 1.12.2 When I copy text from a plain text file in Eclipse and paste into pgAdmin's SQL editor window it pastes this (see next line): ˇ˛S As a workaround you can paste into TextEdit and then copy that and paste into pgAdmin and i

[pgadmin-support] pgadminIII Configuration problem

2011-03-01 Thread Boblitz John
ontrib* - but I am unable to find the correct Directory /usr/local/pgsql/share/contrib/. Any ideas what I have done wrong? John Who is General Failure, and why is he reading my hard disk? -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes t

Re: [pgadmin-support] pgAdmin III v1.10.5. Unable to Delete/Drop a server

2010-12-30 Thread John Skillings
you for you help. Best Regards, John On Thu, Dec 30, 2010 at 5:21 PM, Dave Page wrote: > On Fri, Dec 31, 2010 at 12:44 AM, John Skillings > wrote: > > Hi All, > > > > Earlier today, I upgraded my postgres database from 8.3 to 8.4.6. My > > development platform i

[pgadmin-support] pgAdmin III v1.10.5. Unable to Delete/Drop a server

2010-12-30 Thread John Skillings
configuration information? If so, where I can I find it. Thanks. John

Re: [pgadmin-support] [GENERAL] Byte order mark added by (the envelope please...) pgAdmin3 !!

2010-04-22 Thread John Gage
Additionally, if the Vim option "bomb" is set to "nobomb" it will strip the BOM. This solves my "problem" by permitting editing files in both Vim and pgAdmin3 Query tool and then being able to run the files in psql. :set nobomb [in Vim] On Apr 22, 2010, at 12:12 PM, Magnus Hagander wro

Re: [pgadmin-support] [GENERAL] Byte order mark added by (the envelope please...) pgAdmin3 !!

2010-04-22 Thread John Gage
t 11:50 AM, Dave Page wrote: On Thu, Apr 22, 2010 at 10:41 AM, John Gage wrote: This may be germane: Filename: trunk/pgadmin3/src/ui/pgadmin3.lng Revision 2954 - (view) (download) - [select for diffs] Modified Sun Nov 30 20:13:28 2003 GMT (6 years, 4 months ago) by andreas File length: 1301 by

Re: [pgadmin-support] [GENERAL] Byte order mark added by (the envelope please...) pgAdmin3 !!

2010-04-22 Thread John Gage
This may be germane: Filename: trunk/pgadmin3/src/ui/pgadmin3.lng Revision 2954 - (view) (download) - [select for diffs] Modified Sun Nov 30 20:13:28 2003 GMT (6 years, 4 months ago) by andreas File length: 1301 byte(s) Diff to previous 2840 adding UTF-8 BOM I do not think that it is a feature.

[pgadmin-support] Byte order mark added by (the envelope please...) pgAdmin3 !!

2010-04-22 Thread John Gage
Well, well, well. Guess who the culprit is... I edited the file both in Vim and in pgAdmin3 (1.10.2, Mar 9 2010, rev 8217), and the BOM shows up after saving the file with pgAdmin3. I don't know if pgAdmin3 wants to keep this feature... Thank everyone again for the excellent help.

Re: [pgadmin-support] minor annoyances...

2010-04-02 Thread John Gage
approximate UML diagrams of tables in a database. That is extremely useful. John Appendix: The interaction between vim and psql is extraordinary. One can open a psql session in vim (much preferable to opening vim in psql IMHO) and do whatever you want to do with innumerable other vim

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread John Gage
An incremental approach is undoubtedly best. Identifying the PK's and FK's (not connecting them, just identifying them) in the Query Builder might be an easy first step. On Mar 17, 2010, at 12:29 PM, Guillaume Lelarge wrote: Le 15/03/2010 09:29, John Gage a écrit : This is my o

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-15 Thread John Gage
tables and the tables themselves is a tremendous convenience. I wish I could offer to do this myself, but my C/C++ coding skills simply aren't anywhere near good enough. In any case, pgAdmin is one of the wonders of the world (along with Postgres)! John On Mar 14, 2010, at 9:

Re: [pgadmin-support] Missing Options dialog

2010-03-12 Thread John Gage
icult than using the tab key IMHO. Thank you again for your help, John On Mar 12, 2010, at 12:03 PM, Guillaume Lelarge wrote: Le 12/03/2010 12:00, Guillaume Lelarge a écrit : Le 12/03/2010 11:55, Guillaume Lelarge a écrit : Le 12/03/2010 11:46, John Gage a écrit : When I do that, and go to

[pgadmin-support] Missing Options dialog

2010-03-12 Thread John Gage
I am running pgAdmin 1.10.2 on Mac OSX 10.5.8. I am unable to find the Options Dialog in order to change autcompletion to tab. It does not appear in the file menu. What am I doing wrong? Thanks, John -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make

[pgadmin-support] Soft return

2010-03-11 Thread John Gage
Sorry for the novice question :) John -- 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] Feature request : Reindentation of code

2010-03-02 Thread John Gage
May I pile on by saying that incorporating Vim features if not Vim itself into a discretionary editor (Vim being decidedly not proprietary) would make pgAdmin (and pg itself) into an even greater wonder of the world. Gratuitously, John On Mar 2, 2010, at 6:32 PM, Cousin Florence wrote

Re: [pgadmin-support] Output to file

2010-02-27 Thread John Gage
, 2010, at 11:04 PM, John Gage wrote: Is there a way to have sequential SELECT queries output to the same file without having the second SELECT overwrite the first. Here is a sample: SELECT * FROM prof_texts_lines WHERE source_lines ~* '(enregistrement)' ORDER BY line_no ; SEL

[pgadmin-support] Output to file

2010-02-27 Thread John Gage
e second query appended to the results of the first in the same file. And I don't want the two query's results intermingled as would occur presumptively with one query statement using an or for the match text. John -- Sent via pgadmin-support mailing list (pgadmin-support

[pgadmin-support] Help!

2009-11-12 Thread John Weller
. Any help will be gratefully received. TIA John Weller 01380 723235 07976 393631 -- 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] dropping connection

2009-10-13 Thread John
Hi, I have a fellow assocate that uses pgAdmin3 remotely (he is in GA the DB is in CA). He insists that a "time out" is somewhere in pgAdmin. He loses connection often. It has happen while are talking on Skype, or not talking on Skype. It's also has happened while I was remotely connected.

[pgadmin-support] 64 bit systems

2009-07-24 Thread John
Is there a 64 bit version for openSUSE 11 Thanks Johnf -- 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] Word wrap in the Edit Data window

2008-11-07 Thread John Gage
Edit Data window? There are, obviously, work arounds for this problem involving other applications, but I would prefer to stay in pgAdmin III. Thanking you, John -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.post

Re: [pgadmin-support] Feature Request: query history

2008-09-10 Thread John Huss
Yeah, that sounds good. It would be great if it stored the history across sessions too so if you close the app you can still get to the previous queries later. John My half-patch had a menu, kind of like the history menu in firefox (or > whatever browser - I'm sure they all have it).

[pgadmin-support] Feature Request: query history

2008-09-09 Thread John Huss
I would like to have the ability the view and edit and run any query that has already been executed in the Query screen. Ideally this would keep track of queries persistently and not just for the current session. Lots of other DB management software has this; for example, Interbase 7.1+ (IBConsol

[pgadmin-support] Bug Report: i18n/pgadmin3.lng file not found in MacPorts version of pgAdmin III 1.8.2

2008-03-02 Thread John Wenger
MacPorts, and don't know how to contact the maintainer. I don't know if this is of any interest to you or not, but I typed it so I guess I will mail it. I sure wish the Mac ran Debian or something I knew something about. John Wenger

[pgadmin-support] pgAdmin download/install problem Ubuntu

2008-01-25 Thread John
found 2. Looking at my local mirror site (http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/pgadmin3/release/ubuntu/dists/gutsy/) it appears that only i386 is available (no AMD64). Regards John

Re: [pgadmin-support] Weird characters saved in SQL file

2007-09-22 Thread John DeSoi
you are seeing is a unicode byte order mark (BOM): http://en.wikipedia.org/wiki/Byte_Order_Mark I don't know what encoding pgAdmin is using, but if it is UTF-8 then there is probably no reason to have it. Or at least there needs to be preference to leave it out. John DeSoi, Ph.D. http

[pgadmin-support] How do I connect postgres table structures and view structures to an existing svn repository?

2007-07-31 Thread John Mitchell
Hi, How do I connect postgres table structures and view structures to an existing svn repository? Thanks, -- John J. Mitchell

Re: [pgadmin-support] Default "maximum rows to retrieve" setting

2007-03-19 Thread John DeSoi
add a limit clause. Unfortunately, I don't recall seeing a way set this using libpq or EXECUTE. John On Mar 19, 2007, at 5:03 AM, Dave Page wrote: Ideally what I'd like is to set the default rows to retrieve to 1000, so it downloads the first 1000 rows when I open the table,

Re: [pgadmin-support] crash on Mac OS X in version >= 1.6.2 when using owner comboboxes

2007-02-04 Thread John DeSoi
Yes, this crash is reproducible for me too. Work-around is to type the name in the combo box rather than using the popup menu. On Feb 2, 2007, at 8:14 AM, David Lowry wrote: Anybody else having this problem? Thanks for looking into this. John DeSoi, Ph.D. http://pgedit.com/ Power Tools

Re: [pgadmin-support] Postgis Manual

2006-06-16 Thread John Cole
to html help. If you could find some way of putting all of your sources into one html file (we use the wiki include and transclude plugins) and following a similar path, you might find that merging HTML is easier than merging hhp projects. John -Original Message- From: [EMAIL PROTECTED

Re: [pgadmin-support] Postgis Manual

2006-06-16 Thread John Cole
Dave, How are you generating your help file? We use a xsl stylesheet to convert xhtml to docbook and from there generate the help project. I'd be happy to give you the stylesheet and our tool chain instructions. John Cole -Original Message- From: [EMAIL PROTECTED] [mailto:[

[pgadmin-support] Postgres question

2006-06-11 Thread OConnell, John
    When we run PgAdmin III, the “connect to server” box pops up with the username already prefilled. This is disabled so we Can not change it, we can only enter our id. How can we change userids? Any help on this would be appreciated, thanks.  Statement of confidentiality: The infor

[pgadmin-support] pg schema prefix

2006-05-17 Thread John DeSoi
://www.postgresql.org/docs/8.1/interactive/ddl-schemas.html Any reason all "pg" prefixed schemas are hidden rather than using "pg_"? OS X 10.4, pgAdmin3 1.4.2 John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--

Re: [pgadmin-support] Mac version can't dump/restore

2006-03-20 Thread John DeSoi
than include libpq in the package so there is no path dependency at all? I thought this is what you are doing on Windows already. Just curious. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 1: if po

Re: [pgadmin-support] Mac version can't dump/restore

2006-03-17 Thread John DeSoi
or your continued efforts and especially for supporting the Mac. John John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[pgadmin-support] Mac version can't dump/restore

2006-03-16 Thread John DeSoi
ive to the executable folder. Example: install_name_tool -change /usr/local/pgsql/lib/libpq.4.dylib @executable_path/libpq.4.1.dylib pg_restore Also, I noticed that the pgAdmin package has PkgInfo at the same level as the Contents folder. I thought it should be in the Contents folder.

Re: [pgadmin-support] COPY permissions problem - Windows XP

2006-01-03 Thread john . rylander
BTW, copying the relevant CSV file to the "My Documents" folder of the "postgres" user did not make things work with pgAdmin III Query (1.4.1)--same permissions problem as noted in the original message: ERROR: could not open file "C:\Documents and Settings\postgres\My Documents\Cumulative.csv" fo

Re: [pgadmin-support] COPY permissions problem - Windows XP

2006-01-03 Thread john . rylander
Jim, Your reference to \COPY proved extremely useful for me--thanks! At first, I didn't much pay attention to it, because the portion of the docs you excerpted focussed on STDIN; but when I read the whole doc set for the command, it was clear that I could indeed plug in any old file spec as with

Re: [pgadmin-support] COPY permissions problem - Windows XP

2006-01-02 Thread john . rylander
Same problem here, and same mystification. As someone coming from a basically single-user perspective who's looking at PostgresQL mainly for capacity (Microsoft Access 2003 keeps running out of space even though the tables I'm working with are under 100 MB) and license reasons (I'm uncomfortable w

Re: [pgadmin-support] backup/restore buttons deactivated

2005-11-28 Thread John DeSoi
- didn't test restore though. Both backup and restore seem to be working. And thanks for fixing the file dialog on the backup interface. John John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP

Re: [pgadmin-support] backup/restore buttons deactivated

2005-11-22 Thread John DeSoi
ll have to wait until the weekend. OK, great - thanks. Excellent, I think this is the best option. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-support] backup/restore buttons deactivated

2005-11-20 Thread John DeSoi
next on my Mac. No, an application launched from the Dock or Finder won't have the user's search path. Here is link which explains it and one possible solution. But hopefully there is a better solution than creating a plist file. http://www.misplaced.net/fom/X11/36.html John Jo

Re: [pgadmin-support] backup/restore buttons deactivated

2005-11-18 Thread John DeSoi
ose an existing file. Basically, an "open" file dialog is used rather than one that allows you to specify the path. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [pgadmin-support] [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released for testing

2005-10-25 Thread John DeSoi
at one point. I'll look at this as well. If it uses .pgpass and it works after prompting me the first time, maybe the issue is that it does not look for password unless the "store password" property is set for the server. It works now and my .pgpass is not modified.

Re: [pgadmin-support] [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released for testing

2005-10-25 Thread John DeSoi
n localhost:5432 and I had the entry below in my .pgpass but it still prompted me for the password. But it is very nice the password prompt window now allows me to save the password. Where are they stored? localhost:5432:*:user:pass Great job on the new version. John DeSoi, Ph.D. http

[pgadmin-support] serial types, pg_depend, permissions

2005-10-07 Thread Christopher St John
purely a configuration problem? - if it's a configuration problem, why does the query-tool version work? shouldn't pgadmin be spitting out the shorthand version and letting postgres do the sequence creation and pg_depend work? thanks, -cks Christopher St. John Chief Softwa

Re: [pgadmin-support] pgAdmin Error when trying to run a simple SELECT

2005-09-12 Thread John DeSoi
he correct spelling you need to use: SELECT * from "refUSERS"; John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[pgadmin-support] OSX crash - edit data

2005-08-03 Thread John Jackson
ly doesn't display the text typed in. John Jackson Dir. of Educational Technology Office of Medical Education UVA School of Medicine (434)924-1528 [EMAIL PROTECTED] AIM: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched ou

[pgadmin-support] OS X issues

2005-06-29 Thread John DeSoi
type). Version 1.2.2, OS X 10.4.1 John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's da

[pgadmin-support] mac osX edit table data

2005-06-26 Thread John Iannicello
7;s interface looks great. John ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [pgadmin-support] OS X version problems

2005-06-16 Thread John DeSoi
Version: ??? (???) PID: 640 Thread: Unknown Link (dyld) error: dyld: /Applications/pgAdmin3.app/Contents/MacOS/pgAdmin3 can't open library: /usr/lib/libstdc++.6.dylib (No such file or directory, errno = 2) John DeSoi, Ph.D. http://pgedit.com/ Power Tools for Postg

[pgadmin-support] OS X version problems

2005-06-16 Thread John DeSoi
least with Safari). I'm using OS X 10.3.9. Congrats on the OS X version! John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if

[pgadmin-support] pgAdmin III error when connecting to server

2003-10-22 Thread Robert John Shepherd
issue? Yours Unwhettedly, Robert John Shepherd. Editor DVD REVIEWER The UK's BIGGEST Online DVD Magazine http://www.dvd.reviewer.co.uk For a copy of my Public PGP key, email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched

[pgadmin-support] pgadmin iii ...... pg 7.3.4

2003-09-11 Thread John Bercik
I'm getting "error connecting to server FATAL password authentication failed for user postgres" using pgadmin 3. It worked fine in 7.3.3 but now i can't connect in 7.3.4. Any ideas? I'm getting: it says unsupported frontend protocol in the postgres log. Thanks B

Re: [pgadmin-support] Copy / Paste not working

2003-07-03 Thread John Bercik
On Thu, 2003-07-03 at 07:23, Vadim Zeitlin wrote: > On 03 Jul 2003 07:24:28 -0400 John Bercik <[EMAIL PROTECTED]> wrote: > > JB> The pgAdmin3 developers tell me that they use the wxWindows manager and > JB> that the copy / paste problem is from that. > > They

[pgadmin-support] CVS server ?

2003-07-03 Thread John Bercik
Is the server down? [EMAIL PROTECTED] root]# cvs -z3 -d :pserver:[EMAIL PROTECTED]:/disk1/cvsroot co pgadmin3 Unknown host cvs.pgadmin.org. -- Best regards, John Bercik E-Mail: [EMAIL PROTECTED] Systems Programmer Office: 843/792

[pgadmin-support] CVS

2003-07-02 Thread John Bercik
one pgAdmin3 says: [EMAIL PROTECTED] bin]# pgAdmin3 pgAdmin3: error while loading shared libraries: libwx_gtk2u_stc-2.5.so: cannot open shared object file: No such file or directory -- Best regards, John Bercik E-Mail: [EMAIL PROTECTED] Syste

Re: [pgadmin-support] schema support

2003-07-02 Thread John Bercik
and also a ; is needed after -- ALTER TABLE i.tblsitegroups DROP CONSTRAINT > fk_tblsatellitemanager_tblsites_fk On Wed, 2003-07-02 at 11:47, John Bercik wrote: > Hi, My sql appears to be missing my "i" schema. I believe it should > be "REFERENCES i.tblsites".

[pgadmin-support] schema support

2003-07-02 Thread John Bercik
Hi, My sql appears to be missing my "i" schema. I believe it should be "REFERENCES i.tblsites". When I make it with "i." it works fine. Thanks for any ideas. John -- Foreign Key: i.fk_tblsatellitemanager_tblsites_fk -- ALTER TABLE i

[pgadmin-support] copy paste ?

2003-07-01 Thread John Bercik
I still can't copy / paste from pgadmin3 to anything else. I got the latest rpm July 1, 2003. Is there anything else I can test or try to get this working? -- Best regards, John ---(end of broadcast)--- TIP 3: if posting/reading th

[pgadmin-support] pgadmin3 error

2003-06-30 Thread John Bercik
I'm getting this error in pgadmin3 when I pick a sequence in a schema. It works fine in windows / pgadminII. http://htnweb1.emr.musc.edu/test.jpg -- Best regards, John Bercik E-Mail: [EMAIL PROTECTED] Systems Programmer Office: 84

[pgadmin-support] PGA 3 Copy

2003-06-24 Thread John Bercik
Should Copy work in PGA3 ? I'm trying to copy the text for a constraint in the bottom right pane without success. -- Best regards, John Bercik Medical University of South Carolina [EMAIL PROTECTED] 843-792-1715 ---(end of broadcast)---

[pgadmin-support] pgadmin3

2003-06-24 Thread John Bercik
Hi, I installed pgadmin3 but how do i run it ? rpm -i pgadmin3-0.1.1-20030624.i386.rpm -- Best regards, John Bercik Medical University of South Carolina [EMAIL PROTECTED] 843-792-1715 ---(end of broadcast)--- TIP 8: explain analyze is your

[pgadmin-support] PGadmin db migration

2003-06-24 Thread John Bercik
that sequences already exist. Thanks, John Bercik ---(end of broadcast)--- TIP 8: explain analyze is your friend

[pgadmin-support] Parse errors

2003-02-02 Thread John Wells
offending field or line, etc). Additionally, is this a typical error? Is there a typical fix ;-)? Thanks, John ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PRO

Re: [pgadmin-support] Data Migration Wizard and rollbacks

2003-01-17 Thread John Wells
Hmloaded VS Service pack 5 and it's still doing it. Any suggestions? Thanks! John John Wells said: > Dave, > > Hello again. > > Is SP5 a requirement for this vb project? I'm trying to load it in a > base VB6 install and getting errors from the forms like:

Re: [pgadmin-support] Data Migration Wizard and rollbacks

2003-01-17 Thread John Wells
sorry for the wasted bandwidth. Checked em out with linux cvs and was bitten by the CR-LF bug. Thanks, John ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [pgadmin-support] Data Migration Wizard and rollbacks

2003-01-17 Thread John Wells
Dave, Hello again. Is SP5 a requirement for this vb project? I'm trying to load it in a base VB6 install and getting errors from the forms like: '0' could not be loaded Line 0: The file C:\windows\Desktop\pg\pgadmin2\frmConnect.frm could not be loaded. Any ideas?

Re: [pgadmin-support] Data Migration Wizard and rollbacks

2003-01-17 Thread John Wells
You're right. I'm at work currently, and I forgot the bastards up in the Ivory Tower of Firewalls and Security-through-Obscurity started blocking our cvs access around a month ago. Sorry about that...I'll get it tonight. Thanks Dave. John Dave Page said: > I don't

[pgadmin-support] Data Migration Wizard and rollbacks

2003-01-17 Thread John Wells
ble migration, rather than the entire db migration. If no way exists currently, I'd be interested in possibly adding the functionality. Trying to download the source out of cvs, but it keeps timing out on me. Anyway, thanks for your help. John ---(end of broadcast)---

  1   2   >