Thank you Dave. The auto-tab feature you describe would certainly help some; probably quite a bit.
Happy holidays.
Mark Taff
-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Sunday, December 23, 2001 1:17 PM
To: 'Mark A. Taff'; pgadmin-hackers@postgresql.org
Subject: RE: [pgadmin-hackers] BUG - dropping `{` & `}` in plperl
-----Original Message-----
From: Mark A. Taff [mailto:mark@libertycreek.net]
Sent: 21 December 2001 22:02
To: pgadmin-hackers@postgresql.org
Subject: [pgadmin-hackers] BUG - dropping `{` & `}` in plperl
While writing libraries of functions in the execute SQL pane, whenever I cut, copy, paste, or drag n' drop, either from the same pane or different panes, the brace characters `{}` disappear. It is quite a pain to have to add them back in every time. This only affects plperl as far as I can tell. I am running win2k, AMD K62-400 256MB, pgadmin 1.1.72, ODBC 7.19, PostgreSQL 7.1.3
Confirmed and fixed for the next release. Actually this is a display bug in the Highlightbox control, so affects any text. If you enter a couple of braces in a box, then paste at least two more characters in in a single paste operation, the original 2 braces will vanish. Thanks for the bug report.
Also in plperl functions, `#` cannot be used as a comment character, only `--`, and then only at the beginning of a line. I do not know if this is a bug in plperl or pgadmin, but it is bothersome.
I suspect this is because # is an operator, however I can't easily test this at the moment. pgAdmin does seem to handle them OK, and certainly won't remove them from any queries you write.
On the wishlist, a tab function for indenting function code in the SQL pane would be very nice. I like to indent 4 characters, and right now that means a lot of spacing.
I have considered an auto-tab function that will duplicate the number of spaces at the beginning of the previous line - would that suffice? Incidently, to insert a real tab, use Control-Tab rather than just Tab.
Regards, Dave.