Re: [HACKERS] Win32 port patches submitted

2003-01-26 Thread Hannu Krosing
Bruce Momjian kirjutas P, 26.01.2003 kell 05:07: > Tom Lane wrote: > > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > > I don't see a strong reason not > > > to stick with good old configure; make; make install. You're already > > > requiring various Unix-like tools, so you might as well require

Re: [HACKERS] Win32 port patches submitted

2003-01-26 Thread Justin Clift
Hannu Krosing wrote: Bruce Momjian kirjutas P, 26.01.2003 kell 05:07: Tom Lane wrote: Peter Eisentraut <[EMAIL PROTECTED]> writes: I don't see a strong reason not to stick with good old configure; make; make install. You're already requiring various Unix-like tools, so you might as well req

Re: [HACKERS] Win32 port patches submitted

2003-01-26 Thread Justin Clift
Justin Clift wrote: Since March 2002 (less than 1 year ago), it's been downloaded about 120,000,000 times. Wow. 120 Million downloads in less than 1 year. That's a pretty popular IDE (16th most popular project on SourceForge) Arrrgh. Thought that sounded a bit too high. Wrong column, i

Re: [HACKERS] [SQL] Function for adding Money type

2003-01-26 Thread D'Arcy J.M. Cain
On Friday 24 January 2003 19:17, Josh Berkus wrote: > The MONEY type is depreciated, and should have been removed from the > Postgres source but was missed as an oversight. Use NUMERIC instead. Note that not all of us agree. I had to change all of our fields from MONEY to NUMERIC recently beca

Re: [HACKERS] [CYGWIN] Have a PG 7.3.1 Windows (cygwin) easy installer... now

2003-01-26 Thread mlw
I thought I sent off an email about how to do it, OK here goes: Create a working minimal cygwin with postgres install. Delete unwanted utilities and files. Test if you can start, stop, initdb, and query Postgres. Use the attached pgsql.iss script to make the install. Notes: My version of the cons

[HACKERS] postgresql.org

2003-01-26 Thread Greg Copeland
Should it be saying, "Temporarily Unavailable"? Regards, -- Greg Copeland <[EMAIL PROTECTED]> Copeland Computer Consulting ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [

Re: [HACKERS] [SQL] Function for adding Money type

2003-01-26 Thread Oliver Elphick
On Sun, 2003-01-26 at 13:53, D'Arcy J.M. Cain wrote: > This year, my team is planning on improving the MONEY type. Of course, we can > always make it a user defined type if PostgreSQL doesn't want it. We will at > least put it into contrib. However, if people think that it is useful and > wa

Re: [HACKERS] [CYGWIN] Have a PG 7.3.1 Windows (cygwin) easy installer... now what to do with it?

2003-01-26 Thread Dave Page
> -Original Message- > From: Justin Clift [mailto:[EMAIL PROTECTED]] > Sent: 26 January 2003 03:12 > To: PostgreSQL Hackers Mailing List; PostgreSQL Cygwin Mailing List > Subject: [CYGWIN] Have a PG 7.3.1 Windows (cygwin) easy > installer... now what to do with it? > > Anyway, spent the

Re: [HACKERS] Call for objections: put back OIDs in CREATE TABLE AS/SELECT

2003-01-26 Thread Bruce Momjian
Ross, you make some powerful arguments here. Probably the most significant was the idea that you need a unique identifier for every row, and it should be of a consistent type, which primary key is not. We clearly need a GUC parameter to turn on/off oids. But it seems we will always need the abi

[HACKERS] Request for qualified column names

2003-01-26 Thread Dave Cramer
-- Dave Cramer <[EMAIL PROTECTED]> Cramer Consulting This is useful for some O/R tools. The JDBC spec has a getTableName method for each column in a result set. One issue which will come up is what to do with aggregate, and computed values. For now, we could return null So for a "select a, b

Re: [HACKERS] Sorting Chinese data in Postgresql 7.3.1

2003-01-26 Thread Tatsuo Ishii
> Tatsuo, > > I have been trying to get the sorting of Chinese data in Postgresql > 7.3.1 to work without much success. Here is what I did. > > I rebuilt the executables with ./configure -enable-multibyte=ENC_CN on > a RedHat Linux 8.0 Pentium 2 system. The build was successful. I created > a t

Re: [HACKERS] Request for qualified column names

2003-01-26 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > So for a "select a, b, a+b as sum from c" returns c.a, c.b, ?table?.sum This might be something to consider as part of the planned protocol overhaul. We cannot simply change the returned column names --- at least not without breaking a lot of application

Re: [HACKERS] Call for objections: put back OIDs in CREATE TABLE

2003-01-26 Thread Curt Sampson
On Sun, 26 Jan 2003, Bruce Momjian wrote: > Ross, you make some powerful arguments here. Probably the most > significant was the idea that you need a unique identifier for every > row, and it should be of a consistent type, which primary key is not. I don't see why you need a unqiue identifier p

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

2003-01-26 Thread Tom Lane
Bruce, I've finished digging for stuff that seems to be appropriate to back-patch for 7.2.4. Do you have time to generate the release notes and brand the release? Attached are the CVS commit messages for all the changes in that branch since 7.2.3. regards, tom lane 2003

Re: [HACKERS] Windows Build System

2003-01-26 Thread Bruce Momjian
Are there no already-written converters from Makefile to VC project files? --- Curtis Faith wrote: > I (Curtis Faith) previously wrote: > > > The Visual C++ Workspaces and Projects files are actually > > > text files that ha

Re: [HACKERS] Sorting Chinese data in Postgresql 7.3.1

2003-01-26 Thread Tatsuo Ishii
> I tried initdb -E EUC_CN --no-locale and tested "order by" with the same > Chinese data, I got the same result: the "order by" clause does not have > any effect. The locale on my Redhat Linux 8.0 is en_US.UTF-8. > > By the way, the manual page for initdb does not show an option > --no-locale.

Re: [HACKERS] [CYGWIN] Have a PG 7.3.1 Windows (cygwin) easy installer... now

2003-01-26 Thread Justin Clift
Dave Page wrote: Hi Justin, Does it use the Microsoft Installer service so we can provide a merge module for embedded installations in other products as we do for psqlODBC? If not, I for one will probably end up redoing it all anyway :-( Hi Dave, It's an installation "setup.exe" type of thing

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

2003-01-26 Thread Christopher Kings-Lynne
> I think we have to accept the statement that in 7.2.X malicious SQL > queries can cause database failure, and fixing one or two of the ten > known problems doesn't change that fact. > > I don't have a problem with releasing 7.2.4 and including all the fixes, > including security fixes, but I don'

Re: [HACKERS] unquoted special constants

2003-01-26 Thread Christopher Kings-Lynne
No actually, the docs. I need to know for the phpPgAdmin project... Chris > -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 26 January 2003 10:03 AM > To: Christopher Kings-Lynne > Cc: Hackers > Subject: Re: [HACKERS] unquoted special constants > > > >

Re: [HACKERS] [BUGS] New hashed IN code ignores distinctiveness of subquery

2003-01-26 Thread Bradley Baetz
[Moving -> -hackers] On Mon, Jan 27, 2003 at 12:00:08AM -0500, Tom Lane wrote: > Bradley Baetz <[EMAIL PROTECTED]> writes: > > However, its much faster (although not as fast as sticking the DISTINCT > > in there myself), but the actual rows coming from the sort is really odd > > - where is that n

Re: [HACKERS] Call for objections: put back OIDs in CREATE TABLE

2003-01-26 Thread Antti Haapala
> > Ross, you make some powerful arguments here. Probably the most > > significant was the idea that you need a unique identifier for every > > row, and it should be of a consistent type, which primary key is not. > > I don't see why you need a unqiue identifier per row, nor do I see why, > if yo

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

2003-01-26 Thread Al Sutton
Theres a script at http://ptolemy.eecs.berkeley.edu/other/makevcgen which may work, I've not tried it, but someone may want to give it a spin. Combining it with the software at http://unxutils.sourceforge.net could give us a MS build environment which only relies on installation support programs r