Skip site navigation (1) Skip section navigation (2)

Re: Problem with plpython editing

From: "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp>
To: "Luigi Lumento" <luigi(dot)lumento(at)tin(dot)it>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Problem with plpython editing
Date: 2003-07-28 23:36:43
Message-ID: 014801c35561$1aa53850$1f324d80@w2k (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Dear Luigi Lumento.

----- Original Message -----

> I'm writing to submit a problem on using pgadmin2 to
> write plpython functions. It didn' happen with pltcl.
> When i write a function that is longer than one line of code,
> the server accepts its definition but isn't able to execute it due to
> a sintax error at the second line. I suppose it is because of
> linefeed/carriage return characters at the end of each line.
> Hope the problem can be resolved.

It is strange.

Will you try this?
Try to add this before the SQL practice of about the 32nd line.
  ' change CRLF -> LF
  szSQL = Replace(szSQL, vbCrLf,  vbLf)

 Set rsQuery = frmMain.svr.Databases(szDatabase).Execute(szSQL, , , qryUser)
Frank Lupo will apply it if this seems to be normal.


In response to

pgadmin-support by date

Next:From: frank_lupoDate: 2003-07-29 10:14:45
Subject: Re: Problem with plpython editing
Previous:From: Jorgensen, AddanDate: 2003-07-28 22:24:32
Subject: Error Message

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group