Re: [HACKERS] version() output vs. 32/64 bits

2009-01-07 Thread Peter Eisentraut
Greg Smith wrote: I think I'm now up to having wrote something to break apart the output from version() into individual fields for 3 different companies. If you're got a bunch of database servers on a network, it seems inevitable that eventually you'll end up collecting information about them

Re: [HACKERS] version() output vs. 32/64 bits

2009-01-06 Thread Magnus Hagander
Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian br...@momjian.us writes: So what do we want to do for 8.4? Add 32/64-bit version() indicator and add OUT parameters to the TODO list? +1. There seems a good case for making the 32/64bit distinction visible somewhere, and the text version

Re: [HACKERS] version() output vs. 32/64 bits

2009-01-06 Thread Greg Smith
On Wed, 31 Dec 2008, Tom Lane wrote: No one has asked for access to individual components of the version string, other than the PG version number itself, which we already dealt with. I think I'm now up to having wrote something to break apart the output from version() into individual fields

Re: [HACKERS] version() output vs. 32/64 bits

2009-01-05 Thread Bruce Momjian
Zdenek Kotala wrote: Alvaro Herrera p??e v st 31. 12. 2008 v 12:54 -0300: Maybe we could have a separate function which returned the info in various columns (OUT params). Maybe it would be useful to normalize the info as reported the buildfarm, which right now is a bit ad-hoc. +1 it

Re: [HACKERS] version() output vs. 32/64 bits

2009-01-05 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: So what do we want to do for 8.4? Add 32/64-bit version() indicator and add OUT parameters to the TODO list? +1. There seems a good case for making the 32/64bit distinction visible somewhere, and the text version string is as good as anyplace. I think

Re: [HACKERS] version() output vs. 32/64 bits

2009-01-05 Thread Zdenek Kotala
Alvaro Herrera píše v st 31. 12. 2008 v 12:54 -0300: Maybe we could have a separate function which returned the info in various columns (OUT params). Maybe it would be useful to normalize the info as reported the buildfarm, which right now is a bit ad-hoc. +1 it sounds good. Zdenek

Re: [HACKERS] version() output vs. 32/64 bits

2009-01-05 Thread Zdenek Kotala
Bruce Momjian píše v st 31. 12. 2008 v 11:22 -0500: Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: On Wednesday 31 December 2008 04:45:01 Bruce Momjian wrote: PostgreSQL 8.4devel on i386-pc-bsdi4.3.1, compiled by GCC 2.95.3, 32-bit Maybe we should separate all that, e.g.,

Re: [HACKERS] version() output vs. 32/64 bits

2009-01-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: So what do we want to do for 8.4? Add 32/64-bit version() indicator and add OUT parameters to the TODO list? +1. There seems a good case for making the 32/64bit distinction visible somewhere, and the text version string is as good

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Magnus Hagander
Bruce Momjian wrote: Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: ... Moreover, there does not actually seem to be a way to find out whether you have a 32-bit or a 64-bit build (except by using OS tools). I think the basic definition of 32 bit or 64 bit, certainly for our

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Peter Eisentraut
On Wednesday 31 December 2008 04:45:01 Bruce Momjian wrote: Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: ... Moreover, there does not actually seem to be a way to find out whether you have a 32-bit or a 64-bit build (except by using OS tools). I think the basic

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On Wednesday 31 December 2008 04:45:01 Bruce Momjian wrote: PostgreSQL 8.4devel on i386-pc-bsdi4.3.1, compiled by GCC 2.95.3, 32-bit Maybe we should separate all that, e.g., SELECT version(); = 'PostgreSQL 8.4devel' SELECT pg_host_os(); =

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Alvaro Herrera
Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: On Wednesday 31 December 2008 04:45:01 Bruce Momjian wrote: PostgreSQL 8.4devel on i386-pc-bsdi4.3.1, compiled by GCC 2.95.3, 32-bit Maybe we should separate all that, e.g., SELECT version(); = 'PostgreSQL 8.4devel' SELECT

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Bruce Momjian
Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: On Wednesday 31 December 2008 04:45:01 Bruce Momjian wrote: PostgreSQL 8.4devel on i386-pc-bsdi4.3.1, compiled by GCC 2.95.3, 32-bit Maybe we should separate all that, e.g., SELECT version(); = 'PostgreSQL 8.4devel' SELECT

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Alvaro Herrera
Bruce Momjian wrote: Tom Lane wrote: I didn't actually see a user request for finding out the pointer width, either, but if there is one then Bruce's proposal seems fine. It is true no one asked for this information except Peter (I assume for just academic reasons), Huh, count us

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Peter Eisentraut
On Wednesday 31 December 2008 18:22:50 Bruce Momjian wrote: It is true no one asked for this information except Peter (I assume for just academic reasons), no -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Pavel Stehule
Hello 2008/12/31 Alvaro Herrera alvhe...@commandprompt.com: Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: On Wednesday 31 December 2008 04:45:01 Bruce Momjian wrote: PostgreSQL 8.4devel on i386-pc-bsdi4.3.1, compiled by GCC 2.95.3, 32-bit Maybe we should separate all that,

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: 2008/12/31 Alvaro Herrera alvhe...@commandprompt.com: Maybe we could have a separate function which returned the info in various columns (OUT params). Maybe it would be useful to normalize the info as reported the buildfarm, which right now is a

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread David Fetter
On Wed, Dec 31, 2008 at 01:25:34PM -0500, Tom Lane wrote: Pavel Stehule pavel.steh...@gmail.com writes: 2008/12/31 Alvaro Herrera alvhe...@commandprompt.com: Maybe we could have a separate function which returned the info in various columns (OUT params). Maybe it would be useful to

[HACKERS] version() output vs. 32/64 bits

2008-12-30 Thread Peter Eisentraut
It has been pointed out to me that the output of the version() function is becoming more confusing in face of mixed 32/64 bit environments. Output like i486-pc-linux-gnu just says what kind of kernel the build environment has, not whether you actually have a IA-32 build. Conversely,

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-30 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: ... Moreover, there does not actually seem to be a way to find out whether you have a 32-bit or a 64-bit build (except by using OS tools). I think the basic definition of 32 bit or 64 bit, certainly for our purposes, is sizeof(void *). That is

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-30 Thread Bruce Momjian
Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: ... Moreover, there does not actually seem to be a way to find out whether you have a 32-bit or a 64-bit build (except by using OS tools). I think the basic definition of 32 bit or 64 bit, certainly for our purposes, is