Thread: 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

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.

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.

Thanks,

Mark A. Taff

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

 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.

 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.

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.