In my case (FreeBSD 6 and 7) psql does not freezes, but for some reason
part of pasted code get corrupted when size of the code relatively big.
It seems like some timeout used, or buffer overflows:
1. locally with xterm for the first time pasting function of 9K:
base=> create or replace functi
I've got a simple 'spool' table, one process 'worker' reads and updates
this table, other 'stat' performs 'delete ... where ... returning *'.
Sometimes I've got dedlocks on delete operation in 'stat', seems like at
the moment of expiration of data by timeout some state changes arrived
from work
Craig Ringer wrote:
Роман Маширов wrote:
I've got a simple 'spool' table, one process 'worker' reads and updates
this table, other 'stat' performs 'delete ... where ... returning *'.
Sometimes I've got dedlocks on delete operation
Ups, sorry, I'm idiot... changes from the default casting to text is
really helpful in clearing brain bugs...
Роман Маширов wrote:
Hi!
Excuse me, if this been discussed before, but following thing seems to
me a little bit strange:
select '2009-01-12'::date - null::date <
Hi!
Excuse me, if this been discussed before, but following thing seems to
me a little bit strange:
select '2009-01-12'::date - null::date < '1 day'::interval;
ERROR: operator does not exist: integer < interval
LINE 1: select '2009-11-12'::date - null::date < '1 day'::interval;
Seems I've missed something important about time zones. On my server
i've got local timezone 'W-SU' (Moscow time):
=> show timezone;
TimeZone
--
W-SU
=> select now();
now
---
2009-03-24 13:23:39.655057+03
Till now all seems ok. Tha
