Re: [HACKERS] Disaster!

2004-01-30 Thread Randolf Richardson
the close() function return an error? If an invalid file handle was passed to it, it most certainly should indicate this since it's always possible for a separate thread to close it first (or other reasons as well). -- Randolf Richardson - [EMAIL PROTECTED] Vancouver, British Columbi

Re: [HACKERS] Copyright (C) 1996-2002

2004-01-30 Thread Randolf Richardson
"[EMAIL PROTECTED] (Jean-Michel POURE)" stated in comp.databases.postgresql.hackers: > Le Mardi 25 Novembre 2003 07:32, Randolf Richardson a écrit : >> I'm curious, has anyone consulted with a lawyer on this? > > Yes, the lawyer concluded that the number "20

Re: [HACKERS] Change in behaviour of ORDER BY clause in PG7.3

2004-01-03 Thread Randolf Richardson
"Ollie Clark <[EMAIL PROTECTED]>" wrote in comp.databases.postgresql.hackers: [sNip] > which is different from previous versions and different to MySQL and SQL > Server. Is this a bug, or can you turn this behaviour off? It's breaking > a lot of our applications! Could you clarify which

Re: [HACKERS] *sigh*

2003-12-19 Thread Randolf Richardson
an exact count - use count(*) I think this is an excellent solution. -- Randolf Richardson - [EMAIL PROTECTED] Vancouver, British Columbia, Canada Please do not eMail me directly when responding to my postings in the newsgroups. ---(end of broadcast)

Re: [HACKERS] What's the difference between int2 and int16?

2003-12-19 Thread Randolf Richardson
largeint = int8 = int64 The single-digit types represent the number of "bytes" used to store the data, while the double-digit types represne the number if "bits." -- Randolf Richardson - [EMAIL PROTECTED] Vancouver, British Columbia, Canada Ple

Re: [HACKERS] *sigh*

2003-12-19 Thread Randolf Richardson
"Christopher Browne <[EMAIL PROTECTED]>" wrote in comp.databases.postgresql.hackers: > Martha Stewart called it a Good Thing when Randolf Richardson <[EMAIL PROTECTED]> > wrote: [sNip] >> What about queueing all these updates for a separate >> l

Re: [HACKERS] *sigh*

2003-12-05 Thread Randolf Richardson
iority thread? The thread would be the only one with access to update this field. -- Randolf Richardson - [EMAIL PROTECTED] Vancouver, British Columbia, Canada Please do not eMail me directly when responding to my postings in the newsgroups. ---(end of broadcast)

Re: [HACKERS] Day of week question

2003-11-29 Thread Randolf Richardson
and wish to avoid the overhead of using non- standard SQL statements. -- Randolf Richardson - [EMAIL PROTECTED] Vancouver, British Columbia, Canada Please do not eMail me directly when responding to my postings in the newsgroups. ---(end of broadcast)-

Re: [HACKERS] *sigh*

2003-11-29 Thread Randolf Richardson
table which gets incremented/decremented after each row is INSERT/DELETE has been committed. This way, a generic "count(*)" by itself could simply return this value without any delay at all. -- Randolf Richardson - [EMAIL PROTECTED] Vancouver, British Columbia, Cana

Re: [HACKERS] Copyright (C) 1996-2002

2003-11-28 Thread Randolf Richardson
release. (Bruce just did it a week or two back for 7.4, for example.) > Updating for minor releases would create a lot of churn in the stable > CVS branches, for little purpose. I'm curious, has anyone consulted with a lawyer on this? (We wouldn't want SCO to sue

Re: [HACKERS] PostgreSQL on Novell Netware 6.5.

2003-11-28 Thread Randolf Richardson
the PostgreSQL community, but of course, when everything is > 100% done. ;) I agree wholeheartedly that both the Novell and PostgreSQL user and developer communities will benefit greatly from this. From a marketing perspective, both organizations will al