Hi people. I'm writing a client application in Visual Basic,
and I need to lock certain records (a read lock) for
a long period of time (well, from the start just to
the stop of my application) so that no one can modify
them. I've seen a lock command, but it seem only capable
to lock an entire tab
Hi people. I would like to make a query that
tells me how many distinct values there are
in a column. Standard count doesn't seems
to support a count distinct option.
select distint count(*) of course doens't
work (distinti clause is applied after the
result are calculated). I've tried to define
Hi people,
I'm trying to install pgsql on NT using cygwin's
last release... well, it seems quite different
from b20, you already got cygwin-ipc and
there's no more a cygwin-b20 directory, the
root directory seems to be unix like even
if you don't install Andy Piper tools...
is there anyone who
Well, I'm here once again... I've managed
to install pgsql 7.02 on my NT box NT 4.0, SP6)
with the latest cygwin's release (1.1) and
I am using cypipc 1.05... I keep getting
"error semaphore semaphore not equal 0"
each time I make a query, and sometimes
the backend freezes... Joost was right,
it s