[GENERAL] NT + cygipc + postgresql = boom!

2000-06-21 Thread Andrea Aime
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

[GENERAL] PostgreSQL on NT: new cygwin?

2000-06-19 Thread Andrea Aime
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

[GENERAL] count & distinct

2000-06-15 Thread Andrea Aime
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

[GENERAL] Lock record

2000-06-14 Thread Andrea Aime
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