Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Al Sutton
Is there a rough date for when they'll be available? I have a development team at work who currently have an M$-Windows box and a Linux box each in order to allow them to read M$-Office documents sent to us and develop against PostgreSQL (which we use in production). I know I could have a shared

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Lee Kindness
Al, to be honest I don't think the Windows native would save hassle, rather it'd probably cause more! No disrespect to those doing the version, read on for reasoning... Yes, you get a beta of a Windows native version just now, yes it probably will not be that long till the source is a

Antw: Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Ulrich Neumann
Bruce, you're right, i'm asking about the sources because I want to help. Is it possible to help in this case or not? Ulrich Bruce Momjian [EMAIL PROTECTED] 25.11.2002 18:51:39 Ulrich Neumann wrote: Hello, i've read that there are 2 different native ports for Windows somewhere. I've

Re: [HACKERS] Postgres Security Expert???

2002-11-26 Thread Justin Clift
Hi Chris, Just received this from them. Look like he was trying to claim stuff that wasn't true. :-/ Thanks for pointing this out Chris. :) Regards and best wishes, Justin Clift *** Original Message Subject: Re: Demande de renseignements Defi SYSDOOR Date: Tue,

Re: [HACKERS] Postgres Security Expert???

2002-11-26 Thread Nigel J. Andrews
FWIW, a search on Google gives some hits for the name on the lists this year. First impressions are that it's not Sir Mondred (or whatever the spelling was). On Tue, 26 Nov 2002, Justin Clift wrote: Hi Chris, Just received this from them. Look like he was trying to claim stuff that

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Al Sutton
Lee, I wouldn't go for 7.4 in production until after it's gone gold, but being able to cut the number of boxes per developer by giving them a Win32 native version would save on everything from the overhead of getting the developers familiar enough with Linux to be able to admin their own systems,

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread D'Arcy J.M. Cain
On November 26, 2002 06:33 am, Al Sutton wrote: I wouldn't go for 7.4 in production until after it's gone gold, but being able to cut the number of boxes per developer by giving them a Win32 native version would save on everything from the overhead of getting the developers familiar enough

Re: [HACKERS] RC2? AIX 4.2.1.0 (fwd)

2002-11-26 Thread Samuel A Horwitz
Problem still exists in RC2 [EMAIL PROTECTED] (Samuel A Horwitz) -- Forwarded message -- Date: Mon, 25 Nov 2002 09:12:55 -0500 (EST) From: Samuel A Horwitz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [HACKERS] RC1? AIX 4.2.1.0 (fwd) Sorry forgot to include that I had

[HACKERS] Hirarchical queries a la Oracle. Patch.

2002-11-26 Thread Evgen Potemkin
Hi there! Patch is posted to pgsql-patches. docs inside. SQL 99 version will be later. regards, --- .evgen ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] How can I view the content of Logs?

2002-11-26 Thread WangYuan
Im a new comer of PostgreSQL, could anyone tell me can I view the content of logs( updating a tuple, etc.) ? And if I can, how to do it? Thx!

[HACKERS] possible obvious bug?

2002-11-26 Thread Merlin Moncure
I was playing with the Japanese win32 7.2.1 port and I noticed that select 0 / 0 caused the server to crash and restart. I understand that it is a totally unsupported version, but it should be easy enough to check vs. the current version. Note that select 0.0/0.0 worked fine! Merlin

Re: [HACKERS] Need Quote for 7.3

2002-11-26 Thread Billy O'Connor
[EMAIL PROTECTED] (Nigel J. Andrews) writes: On Tue, 19 Nov 2002, Josh Berkus wrote: Folks, We need a quote from a major code contributor to PostgreSQL about the upcoming 7.3 release -- something about how great the new release is, or some of the features in the release. We need

[HACKERS] PostGres and WIN32, a plea!

2002-11-26 Thread Merlin Moncure
I had read on one of the newsgroups that there is a planned native port to the win32 platform, is this true? I read most of the win32 thread off of the dev site and it was not clear if this was true. In either case, I would like to advocate such a port to be done, and soon, not for any

[HACKERS] 7.3rc2 Test Failures

2002-11-26 Thread David Wheeler
regression.diffs Description: Binary data regression.out Description: Binary data -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

[HACKERS] re [ANNOUNCE] RC1 Packaged for Testing ... AIX 4.2.1 result

2002-11-26 Thread Samuel A Horwitz
system = powerpc-ibm-aix4.2.1.0 configure command env CC=gcc ./configure --with-maxbackends=1024 --with-openssl=/usr/local/ssl --enable-syslog --enable-odbc --disable-nls gmake check output file regression.out -- parallel group (13 tests): text varchar oid int2 char boolean

[HACKERS] Why an array in pg_group?

2002-11-26 Thread Reinoud van Leeuwen
Hi, Is there any reason why the grolist field in the table pg_group is implemented as an array and not as a separate table? According to the documentation: quote source=Postgresql 7.2 User Manual, chapter 6 near the end Arrays are not sets; using arrays in the manner described in the previous

Re: [HACKERS] possible obvious bug?

2002-11-26 Thread Mario Weilguni
I was playing with the Japanese win32 7.2.1 port and I noticed that select 0 / 0 caused the server to crash and restart. I understand that it is a totally unsupported version, but it should be easy enough to check vs. the current version. Note that select 0.0/0.0 worked fine! Seems to work fine

Re: [HACKERS] Need Quote for 7.3

2002-11-26 Thread Rod Taylor
I think it's great - but don't quote me on that. :) PostgreSQL. Because life's too short to learn Oracle. PostgreSQL. For those with more to do than babysit a database. -- Rod Taylor [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4:

Re: [HACKERS] 7.3rc2 Test Failures

2002-11-26 Thread Neil Conway
David Wheeler [EMAIL PROTECTED] writes: COPY onek FROM '/usr/local/src/postgresql-7.3rc2/src/test/regress/results/onek.data'; + ERROR: COPY command, running in backend with effective uid 77, could not open file '/usr/local/src/postgresql-7.3rc2/src/test/regress/results/onek.data' for

Re: [HACKERS] 7.3rc2 Test Failures

2002-11-26 Thread David Wheeler
On Tuesday, November 26, 2002, at 07:12 AM, Neil Conway wrote: Looks like a problem on your end... Oh, the message finally got through, did it? I chatted with Bruce yesterday and ran the tests again and they all passed. Thanks, David -- David Wheeler

[PERFORM] [HACKERS] Realtime VACUUM, was: performance of insert/delete/update

2002-11-26 Thread Curtis Faith
tom lane wrote: Sure, it's just shuffling the housekeeping work from one place to another. The thing that I like about Postgres' approach is that we put the housekeeping in a background task (VACUUM) rather than in the critical path of foreground transaction commit. Thinking with my

Re: [HACKERS] Postgres Security Expert???

2002-11-26 Thread scott.marlowe
On Tue, 26 Nov 2002, Justin Clift wrote: Dear Clift, As a side thought, would you please be able to correct the spelling of PostgreSQL on the same page. Presently it's spelt PostGreSQL, which is incorrect. Better way, i'v remove postgresql name in the site, as i think you want.

Re: [PORTS] Geometry test on NetBSD (was Re: [HACKERS] RC1?)

2002-11-26 Thread Henry B. Hotz
At 1:15 AM -0500 11/20/02, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom, can you clarify why -0 is valid. The IEEE spec absolutely thinks that -0 and +0 are distinct entities. I don't remember why, at one in the morning ... but if you insist I'm sure that plenty sufficient

Re: [PORTS] Geometry test on NetBSD (was Re: [HACKERS] RC1?)

2002-11-26 Thread Henry B. Hotz
At 1:51 PM -0500 11/20/02, Tom Lane wrote: Patrick Welche [EMAIL PROTECTED] writes: On Wed, Nov 20, 2002 at 01:21:47PM -0500, Tom Lane wrote: Ah-hah, so it is a version issue --- we could make the resultmap line something like geometry/.*-netbsd1.[0-5]=geometry-positive-zeros

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Al Sutton
D'Arcy, In production the database servers are seperate multi-processor machines with mirrored disks linked via Gigabit ethernet to the app server. In development I have people extremely familiar with MS, but not very hot with Unix in any flavour, who are developing Java and PHP code which is

Re: [HACKERS] PostGres and WIN32, a plea!

2002-11-26 Thread Dave Page
-Original Message- From: Merlin Moncure [mailto:[EMAIL PROTECTED]] Sent: 22 November 2002 21:25 To: [EMAIL PROTECTED] Subject: [HACKERS] PostGres and WIN32, a plea! I had read on one of the newsgroups that there is a planned native port to the win32 platform, is this true?

Re: [HACKERS] [GENERAL] Bug with sequence

2002-11-26 Thread Peter Gulutzan
[EMAIL PROTECTED] (scott.marlowe) wrote in message news:[EMAIL PROTECTED]... On 21 Nov 2002, Rod Taylor wrote: On Thu, 2002-11-21 at 15:09, scott.marlowe wrote: On 21 Nov 2002, Rod Taylor wrote: On Thu, 2002-11-21 at 14:11, Bruce Momjian wrote: Of course, those would be SQL

Re: [HACKERS] [GENERAL] RC2 Packaged in Preparation for a Wednesday Release ...

2002-11-26 Thread Steve Crawford
SuSE 7..3 (2.4.10-4GB) Compiles and passes regression fine: All 89 tests passed. Installing to dev server next. Cheers, Steve On Monday 25 November 2002 8:19 am, you wrote: Morning all ... On Sunday this weekend, we packaged up PostgreSQL v7.3rc2 for testing ... this release, if all

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread scott.marlowe
On Tue, 26 Nov 2002, Al Sutton wrote: D'Arcy, In production the database servers are seperate multi-processor machines with mirrored disks linked via Gigabit ethernet to the app server. In development I have people extremely familiar with MS, but not very hot with Unix in any flavour,

[HACKERS] Article on Linkers/Loaders

2002-11-26 Thread Bruce Momjian
Here is a good article on linking/loading: http://www.linuxjournal.com/article.php?sid=6463 -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

[HACKERS] Boolean casting in 7.3 - changed?

2002-11-26 Thread Ian Barwick
A quick question: in 7.3 the following no longer works: template1= select 0::bool; ERROR: Cannot cast type integer to boolean The statement must be rewritten as this: template1= select '0'::bool; bool -- f (1 row) Is there a reason for this? I ask because the former

Re: [HACKERS] Request from eWeek for 7.3 comments

2002-11-26 Thread Christopher Kings-Lynne
Hi Lisa, I'm the Lead Programmer for a company that specialises in online weight loss programs in Australia and the USA. We started off using MySQL but turned to PostgreSQL when it became obvious that MySQL lacked many necessary features required for a maximum power and data integrity. We have

[HACKERS] updating on views

2002-11-26 Thread XiaojingLi
Hi! I'd like to bother you with something about updating views. At present, postgresql7.3¡¡doesn't support update on views.When I look up the source code, I see that view is implemented with rules. That is when a view is created, a corresponding ¡®select'¡¡rule is created too.

Re: [HACKERS] PostGres and WIN32, a plea!

2002-11-26 Thread Bruce Momjian
Dave Page wrote: -Original Message- From: Merlin Moncure [mailto:[EMAIL PROTECTED]] Sent: 22 November 2002 21:25 To: [EMAIL PROTECTED] Subject: [HACKERS] PostGres and WIN32, a plea! I had read on one of the newsgroups that there is a planned native port to the

Re: [HACKERS] Location of language .mo files or

2002-11-26 Thread Peter Eisentraut
Zdravo, Darko Prenosil writes: When I install, .mo file is copied to: /usr/local/pgsql/share/locale/hr_HR/LC_MESSAGES/postgres.mo (RedHat). In postgresql.conf is already line that looks like this: LC_MESSAGES = 'hr_HR'. So why I do not see the translated messages ? Hard to tell.

Re: [HACKERS] elog(PANIC) should abort()?

2002-11-26 Thread Peter Eisentraut
Tom Lane writes: I am thinking it would be useful for debugging if elog(PANIC) were to exit by calling abort() so that a core dump would be produced. Going out via proc_exit(), as it now does, seems like a bad idea in any case, since that will try to do a bunch of cleanup activity that's

Re: [PERFORM] [HACKERS] Realtime VACUUM, was: performance of insert/delete/update

2002-11-26 Thread Tom Lane
Curtis Faith [EMAIL PROTECTED] writes: tom lane wrote: Sure, it's just shuffling the housekeeping work from one place to another. The thing that I like about Postgres' approach is that we put the housekeeping in a background task (VACUUM) rather than in the critical path of foreground

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Bruce Momjian
Al Sutton wrote: Lee, I wouldn't go for 7.4 in production until after it's gone gold, but being able to cut the number of boxes per developer by giving them a Win32 native version would save on everything from the overhead of getting the developers familiar enough with Linux to be able to

Re: [HACKERS] Boolean casting in 7.3 - changed?

2002-11-26 Thread Tom Lane
Ian Barwick [EMAIL PROTECTED] writes: in 7.3 the following no longer works: template1= select 0::bool; ERROR: Cannot cast type integer to boolean Note that both old and new versions reject select 0::int4::bool; I believe the behavioral change is a consequence of Rod Taylor's

Re: Antw: Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Bruce Momjian
I am told by PeerDirect that they will release the Win32 source as a patch against current CVS by the end of December. At that point, we will make adjustments then apply the patch and start making any other changes required. I don't think there is much we can do until they supply that patch. I

Re: [HACKERS] updating on views

2002-11-26 Thread Gavin Sherry
On Tue, 26 Nov 2002, Stephan Szabo wrote: Well, it depends. SQL updatable views are fairly limited from what I remember and the general write your own update rules is much broader, so I doubt anyone got terribly excited by doing the limited version. It would take some work to define what

Re: [HACKERS] Auto Vacuum Daemon (again...)

2002-11-26 Thread Shridhar Daithankar
On 26 Nov 2002 at 21:54, Matthew T. O'Connor wrote: First: Do we want AVD integrated into the main source tree, or should it remain a tool that can be downloaded from gborg. I would think it should be controlled by the postmaster, and configured from GUC (at least basic on off settings) Since

Re: [PERFORM] [HACKERS] Realtime VACUUM, was: performance of insert/delete/update

2002-11-26 Thread Bruce Momjian
Good ideas. I think the master solution is to hook the statistics daemon information into an automatic vacuum that could _know_ which tables need attention. --- Curtis Faith wrote: tom lane wrote: Sure, it's just

Re: [HACKERS] Boolean casting in 7.3 - changed?

2002-11-26 Thread Ian Barwick
On Wednesday 27 November 2002 06:23, Tom Lane wrote: (B Ian Barwick [EMAIL PROTECTED] writes: (B in 7.3 the following no longer works: (Btemplate1= select 0::bool; (BERROR: Cannot cast type integer to boolean (B (B Note that both old and new versions reject (B select

Re: [HACKERS] Location of language .mo files or 'Zato postgres ne govori Hrvatski' ???

2002-11-26 Thread Darko Prenosil
On Tuesday 26 November 2002 18:42, Peter Eisentraut wrote: Zdravo, Darko Prenosil writes: When I install, .mo file is copied to: /usr/local/pgsql/share/locale/hr_HR/LC_MESSAGES/postgres.mo (RedHat). In postgresql.conf is already line that looks like this: LC_MESSAGES = 'hr_HR'.

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Hannu Krosing
Al Sutton kirjutas T, 26.11.2002 kell 20:37: D'Arcy, In production the database servers are seperate multi-processor machines with mirrored disks linked via Gigabit ethernet to the app server. In development I have people extremely familiar with MS, but not very hot with Unix in any

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread bpalmer
D'Arcy, In production the database servers are seperate multi-processor machines with mirrored disks linked via Gigabit ethernet to the app server. In development I have people extremely familiar with MS, but not very hot with Unix in any flavour, who are developing Java and PHP code

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread scott.marlowe
On 27 Nov 2002, Hannu Krosing wrote: Al Sutton kirjutas T, 26.11.2002 kell 20:37: D'Arcy, In production the database servers are seperate multi-processor machines with mirrored disks linked via Gigabit ethernet to the app server. In development I have people extremely familiar with

Re: [HACKERS] Hirarchical queries a la Oracle. Patch.

2002-11-26 Thread Hannu Krosing
Evgen Potemkin kirjutas R, 22.11.2002 kell 15:57: Hi there! Patch is posted to pgsql-patches. docs inside. It would of course be nice to support both Oracle and ISO/ANSI syntaxes, but I'm afraid that the (+) may clash with our overloadable operators feature. SQL 99 version will be later. I

Re: [HACKERS] Why an array in pg_group?

2002-11-26 Thread Hannu Krosing
Reinoud van Leeuwen kirjutas K, 20.11.2002 kell 17:03: Hi, Is there any reason why the grolist field in the table pg_group is implemented as an array and not as a separate table? most likely for performance reasons. According to the documentation: quote source=Postgresql 7.2 User

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread Hannu Krosing
scott.marlowe kirjutas K, 27.11.2002 kell 01:40: On 27 Nov 2002, Hannu Krosing wrote: You could try out VMWare and run a linux virtual machine under Windows, You could set it up once with all necessary servers and then copy the files to each new developers machine. VMWare is not free,

Re: [HACKERS] possible obvious bug?

2002-11-26 Thread scott.marlowe
On 27 Nov 2002, Hannu Krosing wrote: Merlin Moncure kirjutas T, 26.11.2002 kell 08:00: I was playing with the Japanese win32 7.2.1 port and I noticed that select 0 / 0 caused the server to crash and restart. I understand that it is a totally unsupported version, but it should be easy

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread scott.marlowe
On 27 Nov 2002, Hannu Krosing wrote: scott.marlowe kirjutas K, 27.11.2002 kell 01:40: On 27 Nov 2002, Hannu Krosing wrote: You could try out VMWare and run a linux virtual machine under Windows, You could set it up once with all necessary servers and then copy the files to each new

Re: [HACKERS] possible obvious bug?

2002-11-26 Thread Christopher Kings-Lynne
Merlin Moncure kirjutas T, 26.11.2002 kell 08:00: I was playing with the Japanese win32 7.2.1 port and I noticed that select 0 / 0 caused the server to crash and restart. I understand that it is a totally unsupported version, but it should be easy enough to check vs. the current

Re: [HACKERS] possible obvious bug?

2002-11-26 Thread Christopher Kings-Lynne
Merlin Moncure kirjutas T, 26.11.2002 kell 08:00: I was playing with the Japanese win32 7.2.1 port and I noticed that select 0 / 0 caused the server to crash and restart. I understand that it is a totally unsupported version, but it should be easy enough to check vs. the current

[HACKERS] Request from eWeek for 7.3 comments

2002-11-26 Thread Bruce Momjian
I just spoke with Lisa Vaas from eWeek. She is writing an article on the upcoming PostgreSQL 7.3 release. (The release of 7.3 is scheduled for tomorrow.) She would like comments from users about the upcoming 7.3 features, listed at:

Re: [HACKERS] error codes

2002-11-26 Thread Fernando Nasser
Insisting on Andreas suggestion, why can't we just prefix all error message strings with the SQLState code? So all error messages would have the format CCSSS - Where CCSSS is the standard SQLState code and the message text is a more

[HACKERS] contrib/ltree patches

2002-11-26 Thread Dan Langille
I have been looking at contrib/ltree in the PostgreSQL repository. I've modified the code to allow / as a node delimiter instead of . which is the default. Below are the patches to make this change. I have also moved the delimiter to a DEFINE so that other customizations are easily done. This

Re: [HACKERS] Why an array in pg_group?

2002-11-26 Thread snpe
On Tuesday 26 November 2002 09:05 pm, Hannu Krosing wrote: Reinoud van Leeuwen kirjutas K, 20.11.2002 kell 17:03: Hi, Is there any reason why the grolist field in the table pg_group is implemented as an array and not as a separate table? most likely for performance reasons. According

Re: [HACKERS] elog(PANIC) should abort()?

2002-11-26 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane writes: I am thinking it would be useful for debugging if elog(PANIC) were to exit by calling abort() so that a core dump would be produced. But is this appropriate? PANIC: The database cluster was initialized with CATALOG_VERSION_NO

Re: [HACKERS] Request from eWeek for 7.3 comments

2002-11-26 Thread David Wheeler
I am the maintainer and lead developer for Bricolage, an enterprise-class open-source content management system built on a PostgreSQL database. The Bricolage developers really look forward to 7.3's new features, which, like every release of PostgreSQL, set a new standard against which other

[HACKERS] Auto Vacuum Daemon (again...)

2002-11-26 Thread Matthew T. O'Connor
Several months ago tried to implement a special postgres backend as an Auto Vacuum Daemon (AVD), somewhat like the stats collector. I failed due to my lack of experience with the postgres source. On Sep 23, Shridhar Daithankar released an AVD written in C++ that acted as a client program

[HACKERS] Interface update for 7.3

2002-11-26 Thread Bruce Momjian
I have worked on several gborg projects migrated from our CVS tree, and all but one have new packaged releases, ready for 7.3: libpq++ pgeasy pgperl I am working with David Wheeler on DBD:pg and hope to have a release packaged up tomorrow. -- Bruce Momjian