sql listen fails using libpgtcl

From: Judith Retief <JudithR(at)inet(dot)co(dot)za>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: sql listen fails using libpgtcl
Date: 2006-01-31 09:42:36
Message-ID: DCB87AFF9E026D4FB9BB769D86DB2E5703ED6BD9@mail.inet.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi there

I don't know too much about either TCL or Postgres, so this might be a
really silly thing. Anyways. We've got a TCL script interfacing against a
(remote) PG server using libpgtcl. I've got to move that script to another
machine, where I've installed libpgtcl doing "apt-get install libpgtcl".

Everything works (can connect to the remove db and do a few select
statements), but where the script attempts a "sql listen <tablename>
<notification>" statement I get a run-time error:
"bad option 'listen': should be one of
sql cget -option
sql commit
[etc]"

The Postgres server is 7.2.1 on debian linux.

On the machine where the script is working, the libpgtcl's debian package
gives its version as 7.2.1-2woody4; where it's not working the version is
7.2.1-2woody8, if that is of help at all.

Any ideas on what this could be? Thanks.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Brett Schwarz 2006-01-31 15:52:05 Re: sql listen fails using libpgtcl
Previous Message Kris Jurka 2006-01-30 23:37:10 Re: Find out if a parameter/return field is NULLABLE