Re: BUG - dropping `{` & `}` in plperl

[Dave Page]

�
<BLOCKQUOTE dir=ltr 
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; 
MARGIN-RIGHT: 0px">
  
  <FONT 
  face=Tahoma size=2>-----Original Message-----From: Mark A. Taff 
  [mailto:[EMAIL PROTECTED]] Sent: 21 December 2001 
  22:02To: [EMAIL PROTECTED]: 
  [pgadmin-hackers] BUG - dropping `{` & `}` in plperl
  
  <SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">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.<SPAN 
  style="mso-spacerun: yes">� 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
<SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">�<SPAN 
class=811140621-23122001>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.
<BLOCKQUOTE dir=ltr 
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; 
MARGIN-RIGHT: 0px">
  <SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">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.
<SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">�<SPAN 
class=811140621-23122001>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.
<BLOCKQUOTE dir=ltr 
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; 
MARGIN-RIGHT: 0px">
  <SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">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.
<SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN 
class=811140621-23122001>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.
<SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN 
class=811140621-23122001>�
<SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN 
class=811140621-23122001>Regards, 
Dave.