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

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

2007-03-19 Thread John DeSoi
and then I can choose to retrieve others if I need to. That would be a whole different patch. Feel free to submit one :-) John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 1: if posting/reading thro

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

[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] 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

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] 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

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