Found a weird problem: ¿bug?

From: pgomez(at)arrakis(dot)es
To: pgsql-general(at)hub(dot)org
Subject: Found a weird problem: ¿bug?
Date: 1999-10-01 00:41:00
Message-ID: 199910010041.CAA02540@albireo.berza.int
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I have a table with this structure (excerpt):

carrusel=> \d wrk_data
Table = wrk_data
+------------------------+--------------------------+-------+
| Field | Type | Length|
+------------------------+--------------------------+-------+
...
| reintentos | int4 default 0 | 4 |
| bloq_hasta | timestamp default 'now' | 4 |
+------------------------+--------------------------+-------+

If, using tclsh + libpgtcl.so I do:

-----------------

pgomez(at)darkstar:/home/pgomez > tclsh % load
/usr/local/pgsql/lib/libpgtcl.so

% set db [pg_connect carrusel]

% pg_exec $db "update wrk_data set reintentos=0,bloq_hasta = bloq_hasta
+ '30 minute'"
pgsql3.0

----------------

It works fine. But if I do the same throug psql:

carrusel=> update wrk_data set reintentos=0,bloq_hasta=bloq_hasta+'30
minutes';

ERROR: No such function 'datetime_stamp' with the specified
attributes

Is this a bug? I was trying to program a pl/tcl function and it behaves
like psql, no tcl+libpgtcl :-(

Any idea?

Saludos,
Pablo GOMEZ

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 1999-10-01 03:23:25 Re: [GENERAL] Constraint Problem
Previous Message Doran L. Barton 1999-09-30 22:21:47 Keeping postmaster running or restarting