Re: [HACKERS] cygwin build failure

2004-11-08 Thread Maarten Boekhold
Hi, Related to the definition of __DLL_IMPORT below, the cygwin port of glib/gmodule just does the following: #define G_MODULE_IMPORT extern #ifdef G_PLATFORM_WIN32 # define G_MODULE_EXPORT __declspec(dllexport) #else /* !G_PLATFORM_WIN32 */ # define G_MODULE_EXPORT

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-09-24 Thread Maarten Boekhold
Neil Conway wrote: On Fri, 2004-09-24 at 01:56, Joe Conway wrote: As other's have pointed out, this is very common in the MS SQL Server world (and I believe Sysbase also supports it). From looking at the docs, it appears this isn't supported by Oracle or DB2 (correct me if I'm wrong). I can see

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-09-24 Thread Maarten Boekhold
Joe Conway wrote: Gavin Sherry wrote: Do you have any idea about databases returning result sets from SQL procedures (ie, not functions). As other's have pointed out, this is very common in the MS SQL Server world (and I believe Sysbase also supports it). It works like: And these databases also r

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Maarten Boekhold
On 11/05/2002 04:42:55 AM Neil Conway wrote: > Mike Mascari <[EMAIL PROTECTED]> writes: > > Is there any thought about changing the protocol to support > > two-phase commit? Not that 2PC and distributed transactions would be > > implemented in 7.4, but to prevent another protocol change in the >

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-04-19 Thread Maarten . Boekhold
gt; 5 > > should probably not use the index ... Oops, you're right of course. Rephrase the above as 'a query that uses a primary key to uniquely qualify a single row' (which pretty much restricts it to the = operator with a constant). Still, this is probably a fairly commo

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-04-18 Thread Maarten . Boekhold
analyze in order to get the optimizer to choose to use the index. I thought that 'create index' also updated pg_stats? Maarten ---- Maarten Boekhold, [EMAIL PROTECTED] Reuters Consulting Dubai Media City Building 1, 5th Floor PO Box 1426 Dubai, United Arab Emirates tel:+971(0)4 3918300