Re: [HACKERS] poor performance of subquery in psql

2003-01-29 Thread Tom Lane
John Liu [EMAIL PROTECTED] writes: why psql subquery is not smarter enough to use indexes if obviously? IN is smarter as of CVS tip. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] FW: [GENERAL] problems with dropped columns

2003-01-29 Thread Christopher Kings-Lynne
This came to -general, it seems like a serious problem... Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Damjan Pipan Sent: Tuesday, 28 January 2003 9:36 PM To: [EMAIL PROTECTED] Subject: [GENERAL] problems with dropped columns Hi!

Re: [HACKERS] Specifying Rowtypes

2003-01-29 Thread Christopher Kings-Lynne
No, in 7.3 you can create anonymous composite types using the CREATE TYPE command. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Curt Sampson Sent: Wednesday, 29 January 2003 1:45 PM To: PostgreSQL Development Subject: [HACKERS] Specifying

Re: [HACKERS] Can we revisit the thought of PostgreSQL 7.2.4?

2003-01-29 Thread Tom Lane
Ross J. Reedstrom [EMAIL PROTECTED] writes: On Sat, Jan 25, 2003 at 09:55:25PM -0500, Bruce Momjian wrote: If we can get them all, it is a big win. If we can't, I don't think it is a win. In the context of backporting, this is true, but in general, if you don't worry about putting locks on

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Tom Lane
Curtis Faith [EMAIL PROTECTED] writes: If a developer can simply download the source, click on the Visual C++ project in the win32 directory and then build PostgreSQL, and they can see that Windows is not the poor stepchild because the VC project is well laid out, they will be more likely to

Re: [HACKERS] [GENERAL] tsearch comments

2003-01-29 Thread Oleg Bartunov
On 28 Jan 2003, [EMAIL PROTECTED] wrote: Hi, I guess what we're looking for is something on the order (as much as I hate using it as a reference) of MySQL's full text search which does offer some ranking. Just putting ranking alone in tsearch would be a huge benefit. Users can then decide

Re: [HACKERS] Specifying Rowtypes

2003-01-29 Thread Tom Lane
Curt Sampson [EMAIL PROTECTED] writes: So currently the only way to specify a row type is by using a table, No, as of 7.3 there's CREATE TYPE foo AS (column list). But ... This is returning a row that (to my mind) doesn't match the type of the table above, because it's returning null for

Re: [HACKERS] Specifying Rowtypes

2003-01-29 Thread Curt Sampson
On Tue, 28 Jan 2003, Stephan Szabo wrote: You can also return records at which point you have to give a definition at select time. create function aa1() returns record as 'select 1,2;' language 'sql'; select * from aa1() as aa1(a int, b int); Yeah, I tried that approach too, but it got ugly

[HACKERS] signal handling

2003-01-29 Thread Luis Alberto Amigo Navarro
hi all: is there any unused signal on postgres? TIA and regards

Re: [HACKERS] Strange Prepare bug

2003-01-29 Thread Rod Taylor
I get ERROR: Function pg_catalog.pg_name_pattern(text) does not exist It could be the error is inside your custom function? I forgot that is a new function :) Try this one: PREPARE pg_psql_dd2(text,text) AS SELECT true FROM ( SELECT true FROM pg_catalog.pg_proc p, (SELECT

[HACKERS] client_encoding directive is ignored in postgresql.conf

2003-01-29 Thread Tatsuo Ishii
There is a nasty bug with the client_encoding directive in postgresql.conf. It is simply ignored. This bug exists in both 7.3 or later and in current. Interesting thing is show client_encoding command shows expected encoding but this only shows the GUC internal variable and the actual internal

Re: [HACKERS] Request for qualified column names

2003-01-29 Thread Reggie Burnett
I'm certainly not trying to be difficult, I just don't know a lot about the internals of PostgreSQL. I'm developing some interfaces to various databases and certainly wanted to include PostgreSQL. From my less-than-qualified viewpoint, I would have thought including the base table name and bit

Re: [HACKERS] Recursive unions

2003-01-29 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: What was the result of the recursive unions thread? I remember Tom maybe saying that the Redhat guys like the DB2 (SQL99) syntax the best, however was it said that that was going to be done by Redhat for 7.4? It'll be looked at; whether it

Re: [HACKERS] FW: [GENERAL] problems with dropped columns

2003-01-29 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: This came to -general, it seems like a serious problem... By and large, there's no support for dropped columns in function result types. Feel free to fix it ... regards, tom lane ---(end of

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Katie Ward
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Wednesday, January 29, 2003 3:37 AM To: Curtis Faith Cc: 'Al Sutton'; 'Bruce Momjian'; [EMAIL PROTECTED] Subject: Re: [mail] Re: [HACKERS] Windows Build System Curtis Faith [EMAIL

Re: [HACKERS] client_encoding directive is ignored in postgresql.conf

2003-01-29 Thread Tom Lane
Tatsuo Ishii [EMAIL PROTECTED] writes: + /* Flag to we need to initialize client encoding info */ + static bool need_to_init_client_encoding = -1; Surely that should be int, not bool. ! if (!PQsendQuery(conn, begin; select pg_client_encoding(); commit))

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, Katie Ward wrote: flame on In all honesty, I do not *want* Windows people to think that they're not running on the poor stepchild platform.If we go down that path, they'll start trying to run production databases on Windows, and then we'll get blamed for the

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Dave Page
-Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 16:27 To: Katie Ward Cc: Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: Re: [mail] Re: [HACKERS] Windows Build System The only assumption I see being made here is this: I believe

Re: [HACKERS] Specifying Rowtypes

2003-01-29 Thread Tom Lane
Stephan Szabo [EMAIL PROTECTED] writes: On Wed, 29 Jan 2003, Curt Sampson wrote: ...produces rows with nulls in them. That's a bug in pl/pgsql I believe. Or a bug in the domain-constraints implementation. plpgsql just executes the input function for the datatype --- which is the same as the

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Curtis Faith
tom lane wrote: flame on In all honesty, I do not *want* Windows people to think that they're not running on the poor stepchild platform. We should distinguish between poor stepchild from a client support perspective and a production environment perspective. What is the downside to supporting

Re: [HACKERS] JDBC drivers and streaming content

2003-01-29 Thread Dave Cramer
Chris, It's already being done, you should post this to the jdbc list. Dave On Fri, 2003-01-24 at 11:07, Chris Smith wrote: I'm about to start implemention streaming of queries to the server in the pgsql jdbc drivers when PreparedStatement is used with setBinaryStream... but before I get

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Justin Clift
Curtis Faith wrote: snip If people are deciding what open-source database server they want to use, Linux or FreeBSD is the obvious choice for the server OS. The kind of people who are inclined to use PostgreSQL or MySQL will mostly NOT be considering Windows servers. For another perspective,

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Andrew Dunstan
*sigh* Often there isn't a choice of OS. If I am selling to a large enterprise whose corporate standards say they will only run Windows in their data center, my chances of getting them to make an exception are none. But my chances of getting them to install Pg just for my application are far

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, James Hubbard wrote: Vince Vielhaber wrote: On Wed, 29 Jan 2003, Dave Page wrote: The code's been available for what a week or two? Do you actually think that can be considered conclusive by any standard? Public beta testing (but closed source) has been going on

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread James Hubbard
Vince Vielhaber wrote: snip So you've been running these unscientific tests you're telling us about being so successful for some months? Vince. I open my mouth and insert foot: Where do I get any of these scientific tests to determine if the latest and greatest 7.3.x will not fall down on my

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, Dave Page wrote: -Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 16:27 To: Katie Ward Cc: Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: Re: [mail] Re: [HACKERS] Windows Build System The only assumption

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Dave Page
-Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 16:36 To: Dave Page Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: Re: [mail] Re: [HACKERS] Windows Build System On Wed, 29 Jan 2003, Dave Page wrote:

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread cbbrowne
Justin Clift wrote: For another perspective, we've been getting a few requests per day through the PostgreSQL Advocacy and Marketing site's request form along the lines of: Is there a license fee for using PostgreSQL? We'd like to distribute it with our XYZ product that needs a

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, Dave Page wrote: hammering the betas is a far cry from an industrial-strength solution. Have you a better suggestion? Seems a bit catch 22 if testing won't prove it's good and we can't use it until we know it's good... Still, industrial strength testing or not, it's

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, Katie Ward wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vince Vielhaber Sent: Wednesday, January 29, 2003 11:45 AM To: Dave Page Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: Re: [mail] Re:

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Tom Lane
Dave Page [EMAIL PROTECTED] writes: I'll admit my methods were not particularly scientific, but over the last few weeks I've had far more grief from DB2 and SQL Server than I did from the PostgreSQL native betas. My gripe had to do with questioning the reliability of the platform, not of the

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Dave Page
-Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 16:45 To: Dave Page Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: Re: [mail] Re: [HACKERS] Windows Build System On Wed, 29 Jan 2003, Dave Page wrote: hammering

Re: [HACKERS] client_encoding directive is ignored in

2003-01-29 Thread Tatsuo Ishii
Tatsuo Ishii [EMAIL PROTECTED] writes: + /* Flag to we need to initialize client encoding info */ + static bool need_to_init_client_encoding = -1; Surely that should be int, not bool. Oops. Will fix. ! if (!PQsendQuery(conn, begin; select

[HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Marc G. Fournier
Morning all ... I jsut bundled up v7.2.4 with all the recent security fixes ... can a few ppl do some regression tests and report back before I announce in the morning? I did a configure and build here and all looks fine, but some confirmations is always nice ;)

[HACKERS] Linux.conf.au 2003 Report

2003-01-29 Thread Christopher Kings-Lynne
Linux.conf.au Report The Linux.conf.au is an international Linux/Open Source event that attracts lots of international speakers. Total conf attendance was around 360, maybe even 400 I think. Gavin Sherry was speaking at this particular conf, and I attended as a hobbyist.

Re: [HACKERS] [pgsql-advocacy] Linux.conf.au 2003 Report

2003-01-29 Thread Neil Conway
On Wed, 2003-01-29 at 21:49, Christopher Kings-Lynne wrote: * IPV6 data types Looks like this will be in 7.4, in one form or another. - The standard table modification tactic (that I also use) or renaming table to *_old and creating new one breaks because the primary key of the new table is

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Rod Taylor
I jsut bundled up v7.2.4 with all the recent security fixes ... can a few ppl do some regression tests and report back before I announce in the morning? I did a configure and build here and all looks fine, but some confirmations is always nice ;) Updated to tag REL7_2_4 on FreeBSD 4.7 and

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Dave Page
-Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 16:57 To: Katie Ward Cc: Dave Page; Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: RE: [mail] Re: [HACKERS] Windows Build System The code's been available for what a week or two? Do

Re: [HACKERS] [pgsql-advocacy] Linux.conf.au 2003 Report

2003-01-29 Thread Justin Clift
Christopher Kings-Lynne wrote: snip We found out all sorts of interesting places that PostgreSQL is being used: a large Australian Telco, several restaurants in the Perth area, the Debian inventory system and the Katie revision control system. It is also being evaluated for process control

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Ron Mayer
Cool irony in the automated .sig on the mailinglist software... On Wed, 29 Jan 2003, Vince Vielhaber wrote: ... hammering the betas is a far cry from an industrial-strength solution. ... TIP 4: Don't 'kill -9' the postmaster Sounds like you're basically saying is _do_ 'kill -9' the

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Tom Lane
Rod Taylor [EMAIL PROTECTED] writes: Updated to tag REL7_2_4 on FreeBSD 4.7 and cannot compile it. gram.y errors complaining: invalid character: ','. bash-2.05b$ bison --version bison (GNU Bison) 1.75 We just had that discussion on pgcore. The 7.2 grammar was developed against bison 1.28;

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: I jsut bundled up v7.2.4 with all the recent security fixes ... can a few ppl do some regression tests and report back before I announce in the morning? I did a configure and build here and all looks fine, but some confirmations is always nice ;)

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Christopher Kings-Lynne
Where do I get it from? I can't see it on any of the FTP sites... Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marc G. Fournier Sent: Thursday, 30 January 2003 10:00 AM To: [EMAIL PROTECTED] Subject: [HACKERS] v7.2.4 bundled ...

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Kevin Brown
Tom Lane wrote: Curtis Faith [EMAIL PROTECTED] writes: If a developer can simply download the source, click on the Visual C++ project in the win32 directory and then build PostgreSQL, and they can see that Windows is not the poor stepchild because the VC project is well laid out, they

Re: [HACKERS] Linux.conf.au 2003 Report

2003-01-29 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: Linux.conf.au Report [ much snipped ] * IPV6 data types - Apparently there are some ISPs in some countries that have started to bill people for IPV6 bandwidth, and the lack of IPV6 address types is hurting them. Yeah. This is a pretty

Re: [HACKERS] Linux.conf.au 2003 Report

2003-01-29 Thread Christopher Kings-Lynne
Yeah. This is a pretty self-contained problem, it just needs someone who's motivated to work on it. Mostly what we need is to understand how we want to extend the previously-agreed-to I/O behaviors for IPv4 inet and cidr types into the v6 domain. (Or should we back up and ask if the

Re: [HACKERS] Linux.conf.au 2003 Report

2003-01-29 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: Maybe we should create a new type 'inet6'??? I'd lean towards allowing the existing inet and cidr types to store both v4 and v6 addresses, if at all possible. Is there a good motivation for doing otherwise? regards, tom

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Magnus Naeslund(f)
Redhat 6.2 Linux gserver1 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002 alpha unknown All 79 tests passed. Magnus ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Dave Page
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 16:57 To: Dave Page Cc: Vince Vielhaber; Katie Ward; Curtis Faith; [EMAIL PROTECTED] Subject: Re: [mail] Re: [HACKERS] Windows Build System Dave Page [EMAIL PROTECTED] writes: I'll admit

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: Where do I get it from? I can't see it on any of the FTP sites... Not all the mirrors have updated yet, but I see it at ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/source/v7.2.4/ for one ... regards, tom lane

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Kevin Brown
Tom Lane wrote: Rod Taylor [EMAIL PROTECTED] writes: Updated to tag REL7_2_4 on FreeBSD 4.7 and cannot compile it. gram.y errors complaining: invalid character: ','. bash-2.05b$ bison --version bison (GNU Bison) 1.75 We just had that discussion on pgcore. The 7.2 grammar was

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Kevin Brown
Tom Lane wrote: Rod Taylor [EMAIL PROTECTED] writes: Updated to tag REL7_2_4 on FreeBSD 4.7 and cannot compile it. gram.y errors complaining: invalid character: ','. bash-2.05b$ bison --version bison (GNU Bison) 1.75 We just had that discussion on pgcore. The 7.2 grammar was

Re: [HACKERS] v7.2.4 bundled ...

2003-01-29 Thread Christopher Kings-Lynne
All tests pass on FreeBSD/Alpha. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Magnus Naeslund(f) Sent: Thursday, 30 January 2003 2:13 PM To: Marc G. Fournier; [EMAIL PROTECTED] Subject: Re: [HACKERS] v7.2.4 bundled ... Redhat 6.2

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, Dave Page wrote: I would be interested to know how many windows servers those that are against a windows port of PostgreSQL have or do manage, and how experienced they are with that platform... At this point I'm not for or against. But you're going to have to do more

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Tom Lane
Dave Page [EMAIL PROTECTED] writes: Aside from load testing as suggested by Vince, I'd be interested to hear what happens when you pull the power cord under load (repeatedly). This would give some evidence about the robustness of the Windows filesystem and its ability to emulate Unix

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, Dave Page wrote: The code's been available for what a week or two? Do you actually think that can be considered conclusive by any standard? Public beta testing (but closed source) has been going on for some months. So you've been running these unscientific tests

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Dave Page
-Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 17:10 To: Dave Page Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: RE: [mail] Re: [HACKERS] Windows Build System On Wed, 29 Jan 2003, Dave Page wrote: I would be

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Dave Page
-Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 17:13 To: Dave Page Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: RE: [mail] Re: [HACKERS] Windows Build System On Wed, 29 Jan 2003, Dave Page wrote: The code's

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, Katie Ward wrote: On Wed, 29 Jan 2003, Katie Ward wrote: On Wed, 29 Jan 2003, Dave Page wrote: hammering the betas is a far cry from an industrial-strength solution. Have you a better suggestion? Seems a bit catch 22 if testing won't

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Vince Vielhaber
On Wed, 29 Jan 2003, Dave Page wrote: -Original Message- From: Vince Vielhaber [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 17:10 To: Dave Page Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED] Subject: RE: [mail] Re: [HACKERS] Windows Build System On Wed,

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Katie Ward
The latest build is still: ftp://209.61.187.152/postgres/postgres_beta4.zip This is not exactly what Jan submitted, and the catalog number is slightly different, but it should do for testing. Katie -Original Message- From: Dave Page [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread James Hubbard
Vince Vielhaber wrote: On Wed, 29 Jan 2003, Dave Page wrote: The code's been available for what a week or two? Do you actually think that can be considered conclusive by any standard? Public beta testing (but closed source) has been going on for some months. So you've been running these

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Justin Clift
Katie Ward wrote: The latest build is still: ftp://209.61.187.152/postgres/postgres_beta4.zip This is not exactly what Jan submitted, and the catalog number is slightly different, but it should do for testing. In case anyone's interested, there are step by step installation instructions for

Re: [HACKERS] Testing for int64 (was Re: [COMMITTERS] pgsql-server/ /configure

2003-01-29 Thread Peter Eisentraut
Tom Lane writes: I think a reasonable choice in cross-compiling situations would be to assume int64 works if we have a long long int datatype, but to force use of our own snprintf rather than trusting to luck with the platform's. That's approximately what's happening. Formerly it insisted on

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread Justin Clift
James Hubbard wrote: snip I open my mouth and insert foot: Where do I get any of these scientific tests to determine if the latest and greatest 7.3.x will not fall down on my favorite Unix? For Open Source benchmarks, there is: Open Source Database Benchmark: http://osdb.sf.net With this,

Re: [HACKERS] Fix for log_min_error_messages

2003-01-29 Thread Peter Eisentraut
Bruce Momjian writes: I now realize panic isn't really off, but I don't expect panic to happen too often. :-) Just add a level past panic that actually says off and really is off. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of

Re: [HACKERS] Fix for log_min_error_messages

2003-01-29 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Bruce Momjian writes: I now realize panic isn't really off, but I don't expect panic to happen too often. :-) Just add a level past panic that actually says off and really is off. Would anyone actually use it? *Should* anyone actually use it? I

Re: [HACKERS] Win32 port patches submitted

2003-01-29 Thread Jan Wieck
Peter Eisentraut wrote: Justin Clift writes: The advantages to having the Win32 port be natively compatible with Visual Studio is that it already is (no toolset-porting work needed there), You're missing a couple of points here. First, the MS Visual whatever compiler can also be

Re: [HACKERS] Win32 port patches submitted

2003-01-29 Thread Dann Corbit
-Original Message- From: Jan Wieck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:47 AM To: Peter Eisentraut Cc: Justin Clift; Hannu Krosing; Bruce Momjian; Tom Lane; Postgres development Subject: Re: [HACKERS] Win32 port patches submitted Peter Eisentraut

Re: [HACKERS] Recursive unions

2003-01-29 Thread Hannu Krosing
Tom Lane kirjutas K, 29.01.2003 kell 17:58: Christopher Kings-Lynne [EMAIL PROTECTED] writes: What was the result of the recursive unions thread? I remember Tom maybe saying that the Redhat guys like the DB2 (SQL99) syntax the best, however was it said that that was going to be done by

Re: [HACKERS] Recursive unions

2003-01-29 Thread Tom Lane
Hannu Krosing [EMAIL PROTECTED] writes: Tom Lane kirjutas K, 29.01.2003 kell 17:58: It'll be looked at; whether it will be done in time for 7.4 is anyone's guess. Is anyone actually working on it ? I don't think any significant work has been done yet. If you wanted to update your existing