Re: [HACKERS] PostgreSQL from source using MinGW

2005-09-09 Thread Bruce Momjian
Andrew Dunstan wrote: > >>I think we should also tell people how about --without-readline and > >>about installing zlib or using --without-zlib > >> > >> > > > >Agreed. Patch? :-) (You knew I was going to ask, right?) > > > > > > > I will put something together. > > While we're on the

Re: [HACKERS] initdb profiles

2005-09-09 Thread Andrew Dunstan
Jim C. Nasby wrote: On Thu, Sep 08, 2005 at 03:43:17AM +0200, Peter Eisentraut wrote: What I would like to see is that initdb would end with saying that the system is not really tuned and that I should run pg-some-program to improve that. pg-some-program would analyze my system, ask me a

Re: [HACKERS] initdb profiles

2005-09-09 Thread Jim C. Nasby
On Thu, Sep 08, 2005 at 03:43:17AM +0200, Peter Eisentraut wrote: > What I would like to see is that initdb would end with saying that the > system is not really tuned and that I should run pg-some-program to > improve that. pg-some-program would analyze my system, ask me a few > questions, and

Re: [HACKERS] PostgreSQL from source using MinGW

2005-09-09 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: It is adequate for building sources downloaded from ftp (you don't need bison, flex, DTK for this), but it's not adequate for building sources from cvs. Ah. OK. Arguably we should cover both ;-) I think we should also tell people how a

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio & MSVC

2005-09-09 Thread Andrew Dunstan
Dave Page wrote: Just for fun, I went through PostgreSQL 8.1 and did a complete build using Microsoft’s C and the latest Visual Studio. With a few minor tweaks, everything compiled with no errors. My assumption is that because PostgreSQL is a UNIX/Linux-centric project (

Re: [HACKERS] Build with Visual Studio & MSVC

2005-09-09 Thread Joshua D. Drake
However, if you need something to keep yourself amused (unless I can persuade you to come help out with psqlODBC :-) ), we would be interested in patches that allow us to use Microsoft's compiler as an alternative to gcc. It's interesting to know it built fairly easily though... What w

Re: [HACKERS] Build with Visual Studio & MSVC

2005-09-09 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck McDevittSent: 09 September 2005 19:38To: [EMAIL PROTECTED]Cc: PostgreSQL-developmentSubject: [HACKERS] Build with Visual Studio & MSVC Just for fun, I went through PostgreSQL 8.1 and did a c

[HACKERS] Build with Visual Studio & MSVC

2005-09-09 Thread Chuck McDevitt
Just for fun, I went through PostgreSQL 8.1 and did a complete build using Microsoft’s C and the latest Visual Studio. With a few minor tweaks, everything compiled with no errors.   My assumption is that because PostgreSQL is a UNIX/Linux-centric project (and gcc/gdb centric), this reall

Re: [HACKERS] PostgreSQL from source using MinGW

2005-09-09 Thread Bruce Momjian
Andrew Dunstan wrote: > > It is adequate for building sources downloaded from ftp (you don't > > need bison, flex, DTK for this), but it's not adequate for building > > sources from cvs. > > > > Ah. OK. Arguably we should cover both ;-) > > I think we should also tell people how about --without

Re: [HACKERS] initdb profiles

2005-09-09 Thread Steve Atkins
On Thu, Sep 08, 2005 at 08:29:38PM -, Andrew - Supernews wrote: > On 2005-09-08, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > Andrew - Supernews wrote: > >> Running initdb behind the scenes is a proven dangerous practice > > > > Please elaborate. > > Example instance: > http://archives.post

Re: [HACKERS] initdb profiles

2005-09-09 Thread Andrew Dunstan
Dave Page wrote: perhaps your statement would be more accurate as: "Automatically running initdb behind the scenes at system startup is a proven dangerous practice" We've distributed hundreds of thousands of copies of pgInstaller which initdb's behind the scenes and never had any reported pr

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

2005-09-09 Thread AgentM
Just to counter this statement- I am using postgresql mDNSReponder discovery on Linux. In my case, I have several "satellite" machines that need to send events to the database. Zeroconf makes the discovery trivial and I don't have to worry about network settings. I would like to see postg

Re: [HACKERS] [PATCHES] Work-in-progress referential action trigger

2005-09-09 Thread Stephan Szabo
On Fri, 9 Sep 2005, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > Is there a case other than a before trigger updating a row we will want to > > act upon later in the statement where we'll get a row with xmax of our > > transaction and cmax greater than the current command? > > T

Re: [HACKERS] [PATCHES] Work-in-progress referential action trigger timing

2005-09-09 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > Is there a case other than a before trigger updating a row we will want to > act upon later in the statement where we'll get a row with xmax of our > transaction and cmax greater than the current command? The greater-cmax case could occur via any kind of

Re: [HACKERS] [PATCHES] Work-in-progress referential action trigger

2005-09-09 Thread Stephan Szabo
On Fri, 2 Sep 2005, Stephan Szabo wrote: > [Hackers now seems more appropriate] > > On Thu, 1 Sep 2005, Stephan Szabo wrote: > > > > > On Tue, 23 Aug 2005, Stephan Szabo wrote: > > > > > Here's my current work in progress for 8.1 devel related to fixing the > > > timing issues with referential act

Re: [HACKERS] Alternative variable length structure

2005-09-09 Thread Tom Lane
Manfred Koizar <[EMAIL PROTECTED]> writes: > I.e. drop the flags for very short strings. I don't think the interaction of this idea with TOAST has been thought through very carefully. Some points to consider: * If the 'e' (external) bit is set, the actual length is 20 or so bytes. Always. There

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

2005-09-09 Thread Tom Lane
"Paolo Magnoli" <[EMAIL PROTECTED]> writes: > Hi, wouldn't it be better to implement rendezvous with a > free/open/cross-platform implementation like Howl > (http://www.porchdogsoft.com/products/howl/) which should help avoiding > apple's "tricks"? Why bother? AFAIK, no one cares at all about bon

[HACKERS] statement_timeout logging

2005-09-09 Thread Simon Riggs
Currently, when we set a statement_timeout and a query runs over that time there is no log message to say that the statement has timed out. We do get a message which says ERROR: canceling query due to user request and so in the server log it is impossible to tell the difference between a

Re: [HACKERS] Alternative variable length structure

2005-09-09 Thread Manfred Koizar
On Thu, 08 Sep 2005 18:02:44 +0900, ITAGAKI Takahiro <[EMAIL PROTECTED]> wrote: + * The length of varlena2 is encoded as follows: + * + * | First| Trailing | Total | Max | + * | byte | bytes| bits | length | + * +--+--+---+-+ + * | 0*** |

Re: [HACKERS] Case insensitive indexing in posgtres?

2005-09-09 Thread Martijn van Oosterhout
On Fri, Sep 09, 2005 at 04:00:57PM +0530, sandeep satpal wrote: > > Dear , > > One of the difference in mysql and postgresql is case insensitiveness. > I want to midify the code of posgresql so that it can support case > insensitiveness in indexing and in join operation. Use citext: http://gbo

[HACKERS] Case insensitive indexing in posgtres?

2005-09-09 Thread sandeep satpal
Dear , One of the difference in mysql and postgresql is case insensitiveness. I want to midify the code of posgresql so that it can support case insensitiveness in indexing and in join operation. I dont want that user should always write lower and uppder during using it. I just need informat

Re: [HACKERS] statement logging / extended query protocol issues

2005-09-09 Thread Simon Riggs
On Thu, 2005-09-08 at 13:14 +1200, Oliver Jowett wrote: > Simon Riggs wrote: > > Oliver, would it be possible to show a simplified call sequence and what > > you would like to see logged for each call? These are good: Maybe it should even be in the docs for the driver? It would be good if it coul

Re: [HACKERS] initdb profiles

2005-09-09 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Andrew - Supernews > Sent: 09 September 2005 08:16 > To: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] initdb profiles > > On 2005-09-08, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > A

Re: [HACKERS] initdb profiles

2005-09-09 Thread Andrew - Supernews
On 2005-09-08, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Andrew - Supernews wrote: >> On 2005-09-08, Peter Eisentraut <[EMAIL PROTECTED]> wrote: >> > Andrew - Supernews wrote: >> >> Running initdb behind the scenes is a proven dangerous practice >> > >> > Please elaborate. >> >> Example instanc

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

2005-09-09 Thread Paolo Magnoli
Hi, wouldn't it be better to implement rendezvous with a free/open/cross-platform implementation like Howl (http://www.porchdogsoft.com/products/howl/) which should help avoiding apple's "tricks"? Best regards paolo -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] co