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