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. John O

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

2010-04-02 Thread John Gage
I suggest very, very strongly that those who use and admire pgAdmin read through the documentation for psql (http://www.postgresql.org/docs/8.4/static/app-psql.html ), the command line client for postgres and also click on the Plugins menu of pgAdmin to launch the psql Console to try it out.

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
This is my opportunity to say that I do use the graphical query builder. It would be great if it could be brought into line with (subsume the code for) DBUML, the ArgoUML class diagramming software for databases (http://sourceforge.net/projects/dbuml/ ). Seeing the relationships between tabl

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 change

[pgadmin-support] Soft return

2010-03-11 Thread John Gage
When entering data directly into a field using pgAdmin, one can enter a "soft" return by pressing the Shift key down while pressing Return or Enter. What is the UTF-8 code for the "soft" return? And, where in the documentation could I find this sort of information? Sorry for the novice q

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
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 ; SELECT * FROM prof_texts_lines WHERE source_lines ~* '

[pgadmin-support] Word wrap in the Edit Data window

2008-11-07 Thread John Gage
I have a text field in my table which I would like to edit in the Edit Data window. Unfortunately, there is no word wrap in the text field column, making it essentially impossible to edit a lengthy text entry. Is there a way of setting word wrap to "on" for text fields in the Edit Data win