Re: [HACKERS] PostgreSQL win32 & NT4

2006-01-13 Thread pmagnoli
NT4 is officially dead, IMHO no need for PostgreSQL to officially support it, let's leave place for companies offering commercial postgresql versions to work on it if they have enough customer requests. BTW Win 2000 is more or less 6 years old now ... Regards Paolo "Magnus Hagander" <[EMAIL PROTE

Re: [HACKERS] Why don't we allow DNS names in pg_hba.conf?

2006-01-02 Thread pmagnoli
Yes, it would be good to implement this. A warning about security and (possible) slow connections due to name resolution issues should be placed in the docs. Regards paolo elein <[EMAIL PROTECTED]> ha scritto > I also support this change. My clients have tended to move > machines and networks a

Re: [HACKERS] HOOKS for Synchronous Replication?

2005-12-08 Thread pmagnoli
I can only add that patched code did not build on windows, contacted author about that and never got an answer back. Regards paolo Tom Lane <[EMAIL PROTECTED]> ha scritto > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > > Anyone remember this patch? > > http://gorda.di.uminho.pt/community

Re: [HACKERS] Tablespace on ramdisk

2005-11-21 Thread pmagnoli
I'd like to mimic MySQL's in-memory tables (engine=memory), which structure survives a server restart (data lost of course). I suspected that a server restart would be a problem in this case. Thank you anyway. Paolo Tino Wildenhain <[EMAIL PROTECTED]> ha scritto > [EMAIL PROTECTED] schrieb: > >

[HACKERS] Tablespace on ramdisk

2005-11-21 Thread pmagnoli
Hi, does anyone have experiences about putting a tablespace on ramdisk? Does it work (and keep working after a restart of the server)? Thanks in advance for any insight. Paolo ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [HACKERS] MERGE vs REPLACE

2005-11-14 Thread pmagnoli
I think you translated it correctly, MySQL has another way of specifying this which is "INSERT ... ON DUPLICATE KEY UPDATE ..." (http://dev.mysql.com/doc/refman/5.0/en/insert.html) Regards Paolo Jochem van Dieten <[EMAIL PROTECTED]> ha scritto > On 11/13/05, Petr Jelinek wrote: > > > > I am real

[HACKERS] Postgresql 8.1 XML2

2005-11-11 Thread pmagnoli
Hi all, I just installed PostgreSQL 8.1 win32 and didn't find option to install contrib/xml2, is it available on win32? Shall I build it on my own? Thanks in advance Paolo ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[HACKERS] Constraint exclusion, some questions

2005-09-29 Thread pmagnoli
Hi, I'm testing constraint exclusion on PostgreSQL 8.1 beta 1 on windows with the GEOIP countries database and I have a few questions: 1. Can I say that an index created on the "parent" table is a "global" index, an index that spans over data in all derived tables? 2. Can I say that an index creat

Re: [HACKERS] Rendezvous/Bonjour broken in 8.1 beta

2005-09-08 Thread pmagnoli
Hi Andrew, you wrote: > I don't recall ever hearing that this has been done. bonjour is the new name of Apple's rendezvous technology, an old email (http://archives.postgresql.org/pgsql-hackers/2005-05/msg00739.php) stated that rendezvous support was working at least on macosx and windows, so I t

[HACKERS] Rendezvous/Bonjour broken in 8.1 beta

2005-09-08 Thread pmagnoli
Hi, I'm trying to compile Postgresql 8.1 beta on my own in mingw/windows. I tried to compile it with --with-bonjour but it is looking for the wrong file, it looks for "DNSServiceDiscovery.h" but Apple provides a file named "dns_sd.h" (Bonjour SDK for windows as of May 5 2005), after renaming it ./c