Re: [HACKERS] Cygwin / Debian dpkg / PostgreSQL / KDE2 and 3

2002-06-03 Thread Bruce Momjian
Jean-Michel POURE wrote: > - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB > packages would be downloaded and installed from Debian mirrors, with little > user intervention. PostgreSQL would be installed as a service. > > - a cross-platform GUI environment for (future)

Re: [HACKERS] Search from newer tuples first, vs older tuples first?

2002-06-03 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > It is not that hard to implement, just messy. When the index returns a > > heap row and the heap row is viewed for visibility, if _no_one_ can see > > the row, the index can be marked as expired. It could be a single bit > > in the

Re: [HACKERS] Search from newer tuples first, vs older tuples first?

2002-06-03 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > It is not that hard to implement, just messy. When the index returns a > > heap row and the heap row is viewed for visibility, if _no_one_ can see > > the row, the index can be marked as expired. It could be a single bit > > in the

Re: [HACKERS] Search from newer tuples first, vs older tuples first?

2002-06-03 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > It is not that hard to implement, just messy. When the index returns a > heap row and the heap row is viewed for visibility, if _no_one_ can see > the row, the index can be marked as expired. It could be a single bit > in the index tuple, and doesn't n

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread Igor Kovalenko
That's what Apache does. Note, on most platforms MAP_ANON is equivalent to mmmap-ing /dev/zero. Solaris for example does not provide MAP_ANON but using fd=open(/dev/zero) mmap(fd, ...) close(fd) works just fine. - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Igor Ko

Re: [HACKERS] code contribution

2002-06-03 Thread Bruce Momjian
Sorry, I am just getting to this. I have the patch in my email box too. Can you explain what "buffer of line" is? I want to know if it is of general usefulness. --- Alex Shevlakov wrote: > New 'path' functions (test resu

Re: [HACKERS] pgsql_data/base mapping

2002-06-03 Thread Bruce Momjian
Laurette Cisneros wrote: > > Are the numbers of the directories in the base diretory and the numbers of > the directories under that, etc. traceable to a reference somewhere in the > postgresql server using that data directory (such as the pg_database table > or such)? If so, is there somewhere

[HACKERS] patch for contrib/intarray (7.2 and 7.3)

2002-06-03 Thread Oleg Bartunov
Please apply attached patch to contrib/intarray (7.2, 7.3). Fixed bug with '=' operator for gist__int_ops and define '=' operator for gist__intbig_ops opclass. Now '=' operator is consistent with standard 'array' type. Tnanks Achilleus Mantzios for bug report and suggest

Re: [HACKERS] GOODS - a sensational public domain database backend

2002-06-03 Thread Oleg Bartunov
Kostya is a good qualified programmer. I know him and he is always open for challenges. Some time ago, me and Teodor ask him about GiST support in his another database (Gigabase). It was sort of challenge ( we wanted to port our contrib/tsearch module ) and he did that (using libgist). We work wit

Re: [HACKERS] non-standard escapes in string literals

2002-06-03 Thread Lincoln Yeoh
At 01:20 PM 6/3/02 +0200, Zeugswetter Andreas SB SD wrote: > > for two things, one for escaping single quotes and for escaping standard > > C characters, like \n. While we can use the standard-supported '' to > > insert single quotes, what should we do with \n? The problem is > > switching to st

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread Jason Tishler
On Mon, Jun 03, 2002 at 09:36:51AM -0400, mlw wrote: > Jason Tishler wrote: > > > > On Sun, Jun 02, 2002 at 09:33:57PM -0400, mlw wrote: > > > Bruce Momjian wrote: > > > > mlw wrote: > > > > > Like I told Marc, I don't care. You spec out what you want and I'll > > > > > write it for Windows. > >

[HACKERS] GOODS - a sensational public domain database backend that deserves a SQL frontend

2002-06-03 Thread Robert Schrem
Hi, Some of you might already know GOODS, programmed almost entirely by Konstantin Knizhnik - if not you should really have a look at it right now (be warned: consuming this extraordinary work might change your levels about the required quality of a 'good programmer' forever. At least this

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports - the 'BEST OPEN SOURCE database backend'

2002-06-03 Thread Robert Schrem
Hi, You may want to have a look at: http://www.garret.ru/~knizhnik/ You find there code for a 'Fast synchronized access to shared memory for Windows and for i86 Unix-es". kind regards, Robert > Bruce, > > On Sun, Jun 02, 2002 at 08:49:21PM -0400, Bruce Momjian wrote: > > mlw wrote: > > > Like

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread Jan Wieck
Jason Tishler wrote: > On Sun, Jun 02, 2002 at 09:33:57PM -0400, mlw wrote: > > Bruce Momjian wrote: > > > mlw wrote: > > > > Like I told Marc, I don't care. You spec out what you want and I'll write > > > > it for Windows. > > > > > > > > That being said, a SysV IPC interface for native Windows w

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread Jason Tishler
On Sun, Jun 02, 2002 at 09:33:57PM -0400, mlw wrote: > Bruce Momjian wrote: > > mlw wrote: > > > Like I told Marc, I don't care. You spec out what you want and I'll write > > > it for Windows. > > > > > > That being said, a SysV IPC interface for native Windows would be kind of > > > cool to have.

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread Jason Tishler
Bruce, On Sun, Jun 02, 2002 at 08:49:21PM -0400, Bruce Momjian wrote: > mlw wrote: > > Like I told Marc, I don't care. You spec out what you want and I'll write it > > for Windows. > > > > That being said, a SysV IPC interface for native Windows would be kind of > > cool to have. > > I am wond

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread mlw
Bruce Momjian wrote: > > mlw wrote: > > Like I told Marc, I don't care. You spec out what you want and I'll write it > > for Windows. > > > > That being said, a SysV IPC interface for native Windows would be kind of cool > > to have. > > I am wondering why we don't just use the Cygwin shm/sem co

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread Marc G. Fournier
You might want to go to the archives and catch up on the whole thread and its digressions :) On Sun, 2 Jun 2002, Bruce Momjian wrote: > mlw wrote: > > Like I told Marc, I don't care. You spec out what you want and I'll write it > > for Windows. > > > > That being said, a SysV IPC interface for

Re: [HACKERS] non-standard escapes in string literals

2002-06-03 Thread Zeugswetter Andreas SB SD
On Mon, June 03 Bruce wrote: > > On Wed, May 08, 2002 at 06:47:46PM +0200, Zeugswetter SB SD Andreas wrote: > > > When we are talking about the places where you need double escaping > > > (once for parser, once for input function) to make it work, I would also > > > say that that is very cumber

Re: [HACKERS] non-standard escapes in string literals

2002-06-03 Thread Bruce Momjian
Andrew Pimlott wrote: > On Wed, May 08, 2002 at 06:47:46PM +0200, Zeugswetter Andreas SB SD wrote: > > When we are talking about the places where you need double escaping > > (once for parser, once for input function) to make it work, I would also > > say that that is very cumbersome (not broken

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread Bruce Momjian
Yes, I am having trouble figuring out if I have seen the whole thread yet. --- Marc G. Fournier wrote: > > You might want to go to the archives and catch up on the whole thread and > its digressions :) > > On Sun, 2 Jun 2

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

2002-06-03 Thread coventry
I think its already been determined that the cygwin option is too low performing. However, the apache stuff could be quite useful - but if that effort were to be undertaken, it would make more sense to move all versions of the code the the apache runtime, for all platforms. Are there any other r