[HACKERS] Is regress/report.php in use?

2002-10-29 Thread Vladimir Chukharev
Hi, Does the developers team follow the http://developer.postgresql.org/regress/report.php ? May be it's worthless to report there? Best regards, Vladimir Chukharev ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

[HACKERS] float output precision questions

2002-10-29 Thread Pedro Miguel Frazao Fernandes Ferreira
Hi All, I wrote a Matlab interface to PostgreSQL based on libpq. It is working fine, supports multiple connections, supports all data types and arrays. It is a C program to do the interface and some Matlab wrapper functions around it to do the job at application level. Matlab has an ODBC

Re: [HACKERS] float output precision questions

2002-10-29 Thread Pedro Miguel Frazao Fernandes Ferreira
Sorry. I forgot to thank for any help from all of you in the previous message. Thanks! :) Just one more thing: I now I can go to the source and change the code which converts floats to strings, and have my problem solved. But this wont be general. Others might need this kind of application.

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Magnus Naeslund(f)
Robert Treat [EMAIL PROTECTED] wrote: I noticed that the supported platforms listed 7.2 for linux alpha but with yesterdays date. I figured it was just a typo, but thought I would try to compile myself just to be sure, but I received 4 failures: horology,geometry,opr_sanity, and misc This is

Re: [HACKERS] 7.3b3 on MacOSX 10.2.1

2002-10-29 Thread Tom Lane
Adam Witney [EMAIL PROTECTED] writes: Just to update the list of supported platforms, 7.3b3 compiles and passes all the regression tests on MacOSX 10.2.1 Although don't know if this is relevant but this appears when running the tests: parallel group (20 tests): ./pg_regress: fork: Resource

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Robert Treat
On Tue, 2002-10-29 at 12:16, Magnus Naeslund(f) wrote: Robert Treat [EMAIL PROTECTED] wrote: I noticed that the supported platforms listed 7.2 for linux alpha but with yesterdays date. I figured it was just a typo, but thought I would try to compile myself just to be sure, but I received 4

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Bruce Momjian
I kept Dave and Jason's name on the report. Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Dave Page wrote: -Original Message- From: Jason Tishler

[HACKERS] CVS TOT fails to build on MacOSX 10.2.1

2002-10-29 Thread Peter Bierman
So first off, what's the best way to tell from a cvs snapshot which release (if any) that snapshot is? I just (2pm) grabbed a full clean cvs checkout, and tried to run the regression tests. This is on a Macintosh G4/450 dual CPU with 512MB. 'make runcheck' in src/test/regress/ fails with:

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Ian Barwick
On Tuesday 29 October 2002 01:56, Bruce Momjian wrote: Sorry, Ian, here is the patch I applied. You can apply this to whatever version you are using and test Irix with that, rather than having to grab CVS. OK, I have carried out make check with the updated tests but got FAILED on the same

Re: [HACKERS] CVS TOT fails to build on MacOSX 10.2.1

2002-10-29 Thread Neil Conway
Peter Bierman [EMAIL PROTECTED] writes: So first off, what's the best way to tell from a cvs snapshot which release (if any) that snapshot is? configure.in, perhaps? 'make runcheck' in src/test/regress/ fails with: bison -y -d preproc.y preproc.y:5560: fatal error: maximum table size

[HACKERS] 7.3b3 passes on MacOSX 10.2.1

2002-10-29 Thread Peter Bierman
At 6:11 PM -0500 10/29/02, Neil Conway wrote: Peter Bierman [EMAIL PROTECTED] writes: So first off, what's the best way to tell from a cvs snapshot which release (if any) that snapshot is? configure.in, perhaps? Ah, thanks. 7.3b3 it is then. 'make runcheck' in src/test/regress/ fails

Re: [HACKERS] Is regress/report.php in use?

2002-10-29 Thread Vladimir Chukharev
Bruce Momjian wrote: Gee. I didn't know that existed. We are probably better off doing it via mailing list so we can discuss the results. The similar systems I know usually post a copy to a corresponding list automatically. Example - FreeBSD send-pr online. V.Chukharev -- Bruce Momjian

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Dave Page
-Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 29 October 2002 04:24 To: Dave Page Cc: PostgreSQL-development; Thomas Lockhart; Tom Lane Subject: Re: [HACKERS] Request for supported platforms I have updated CVS and re-added getopt.c, now in

Re: [HACKERS] idle connection timeout ...

2002-10-29 Thread Mike Mascari
Karel Zak wrote: On Fri, Oct 25, 2002 at 03:31:22PM -0400, Mike Mascari wrote: Bruce Momjian wrote: Added to TODO: * Allow limits on per-db/user connections Could I suggest that such a feature falls under the category of resource limits, and that the TODO should read something like:

[HACKERS] good news: FreeBSD 4.7: all passed (with Bruce's resultmap change).

2002-10-29 Thread Larry Rosenman
With Bruce's resultmap change, and now that we are beyond the DST stuff: == All 89 tests passed. == lerlaptop# uname -a FreeBSD lerlaptop.lerctr.org 4.7-STABLE FreeBSD 4.7-STABLE #13: Fri Oct 25 01:32:16 CDT 2002 [EMAIL

Re: [HACKERS] pg_dump and large files - is this a problem?

2002-10-29 Thread Zeugswetter Andreas SB SD
The problem with flex is, that the generated c file does #include unistd.h before we #include postgres.h. In this situation _LARGE_FILES is not defined for unistd.h and unistd.h chooses to define _LARGE_FILE_API, those two are not compatible. Yeah. AFAICS the only way around this is

Re: [HACKERS] pg_dump and large files - is this a problem?

2002-10-29 Thread Tom Lane
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: Yeah. AFAICS the only way around this is to avoid doing any I/O operations in the flex-generated files. Fortunately, that's not much of a restriction. Unfortunately I do not think that is sufficient, since the problem is already at the

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Strange. I just got report from another OSX 10.2.1 user saying regression tests passed: 10.2.1, Adam Witney ([EMAIL PROTECTED] The proper value seems to be: 15.3864610140472 or 15.3864610140473 in

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Jason Tishler
Matthew, On Mon, Oct 28, 2002 at 10:50:40PM -0500, Matthew T. O'Connor wrote: Are you compiling from CVS or from a released tarball? CVS. The bison requirement was recently raised to bison 1.5 or above (1.75 was recently released also.) This is an issue only when compiling from CVS, since

Re: [HACKERS] Turning the PLANNER off

2002-10-29 Thread David Walker
Does PREPARE turn select * from mytable into select mytable.field1,mytable.field2 from mynamespace.mytable ? I was looking for this functionality for one of my projects so I'm curious. On Monday 28 October 2002 06:55 pm, (Via wrote: That is a good question. The planner does more than just

Re: [HACKERS] pg_dump and large files - is this a problem?

2002-10-29 Thread Zeugswetter Andreas SB SD
Yeah. AFAICS the only way around this is to avoid doing any I/O operations in the flex-generated files. Fortunately, that's not much of a restriction. Unfortunately I do not think that is sufficient, since the problem is already at the #include level. The compiler barfs on the

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Robert Treat
I noticed that the supported platforms listed 7.2 for linux alpha but with yesterdays date. I figured it was just a typo, but thought I would try to compile myself just to be sure, but I received 4 failures: horology,geometry,opr_sanity, and misc This is on alpha running debian 3 linux uname

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Dave Page
-Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 29 October 2002 14:48 To: Dave Page Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; Tom Lane; Pgsql-Cygwin Subject: Re: [HACKERS] Request for supported platforms I found a solution to the

Re: [HACKERS] plpq

2002-10-29 Thread Bruce Momjian
Darko Prenosil wrote: It is wrapper about libpq client library functions for use in PL/PSQL. I agreed with Joe Conway that it may fit within dblink, because dblink is much more easy to work with than the libpq, but sometimes it is Just not enough. So, the idea is to re-implement all

Re: [HACKERS] good news: FreeBSD 4.7: all passed (with Bruce's resultmap

2002-10-29 Thread Bruce Momjian
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Larry Rosenman wrote: With Bruce's resultmap change, and now that we are beyond the DST stuff: ==

Re: [HACKERS] Is regress/report.php in use?

2002-10-29 Thread Bruce Momjian
Gee. I didn't know that existed. We are probably better off doing it via mailing list so we can discuss the results. --- Vladimir Chukharev wrote: Hi, Does the developers team follow the

Re: [HACKERS] float output precision questions

2002-10-29 Thread Bruce Momjian
TODO has: o Add SET REAL_FORMAT and SET DOUBLE_PRECISION_FORMAT using printf args so we have not implemented it yet. --- Pedro Miguel Frazao Fernandes Ferreira wrote: Hi All, I wrote a Matlab interface

Re: [HACKERS] Turning the PLANNER off

2002-10-29 Thread Bruce Momjian
David Walker wrote: Does PREPARE turn select * from mytable into select mytable.field1,mytable.field2 from mynamespace.mytable ? I was looking for this functionality for one of my projects so I'm curious. PREPARE turns the query into an internal format used by the executor. -- Bruce

Re: [HACKERS] good news: FreeBSD 4.7: all passed (with Bruce's

2002-10-29 Thread Bruce Momjian
Oops, I forgot in a few places. Fortunately, I always updated the date so I have fixed them all. We have a pretty good 7.3 list already. --- Larry Rosenman wrote: On Tue, 2002-10-29 at 12:13, Bruce Momjian wrote:

Re: [HACKERS] Is regress/report.php in use?

2002-10-29 Thread Vince Vielhaber
On Tue, 29 Oct 2002, Bruce Momjian wrote: Gee. I didn't know that existed. We are probably better off doing it via mailing list so we can discuss the results. What do you mean you didn't know it existed? It's been there for the last few releases (since 7.1). You've even submitted to it!

Re: [HACKERS] Is regress/report.php in use?

2002-10-29 Thread Bruce Momjian
Vince Vielhaber wrote: On Tue, 29 Oct 2002, Bruce Momjian wrote: Gee. I didn't know that existed. We are probably better off doing it via mailing list so we can discuss the results. What do you mean you didn't know it existed? It's been there for the last few releases (since 7.1).

Re: [HACKERS] Is regress/report.php in use?

2002-10-29 Thread Vince Vielhaber
On Tue, 29 Oct 2002, Bruce Momjian wrote: Vince Vielhaber wrote: On Tue, 29 Oct 2002, Bruce Momjian wrote: Gee. I didn't know that existed. We are probably better off doing it via mailing list so we can discuss the results. What do you mean you didn't know it existed? It's

Re: [HACKERS] Is regress/report.php in use?

2002-10-29 Thread Marc G. Fournier
to be honest ... I forgot it was there too :( On Tue, 29 Oct 2002, Vince Vielhaber wrote: On Tue, 29 Oct 2002, Bruce Momjian wrote: Gee. I didn't know that existed. We are probably better off doing it via mailing list so we can discuss the results. What do you mean you didn't know it

Re: [HACKERS] Is regress/report.php in use?

2002-10-29 Thread Vince Vielhaber
On Tue, 29 Oct 2002, Marc G. Fournier wrote: to be honest ... I forgot it was there too :( Just means I'm gonna have to do a bunch of popup ads! ** ducking and running On Tue, 29 Oct 2002, Vince Vielhaber wrote: On Tue, 29 Oct 2002, Bruce Momjian wrote: Gee. I didn't know that

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Dave Page
-Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 29 October 2002 18:58 To: Dave Page Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; Tom Lane; Pgsql-Cygwin Subject: Re: [HACKERS] Request for supported platforms Hackers: As the Cygwin

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Dave Page
-Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 29 October 2002 19:34 To: Dave Page Cc: PostgreSQL-development; Thomas Lockhart; Tom Lane Subject: Re: [HACKERS] Request for supported platforms Attached is a diff to fix the pclose problem. It

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Jason Tishler
Dave, On Tue, Oct 29, 2002 at 09:00:20PM -, Dave Page wrote: -Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 29 October 2002 18:58 Hackers: As the Cygwin release that is actively supported is the binary distribution that Jason builds, I would

Re: [HACKERS] Trigger on 'create table' ?

2002-10-29 Thread Peter Eisentraut
Paul Ramsey writes: In order to meet the OpenGIS specification, we have to maintain a GEOMETRY_COLUMNS table which includes an entry for every column in the db which holds a spatial column. Why not make a view? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of

Re: [HACKERS] float output precision questions

2002-10-29 Thread Peter Eisentraut
Pedro Miguel Frazao Fernandes Ferreira writes: Is there a way to set query output precision to maximum precision ? For the type of application I mentioned this is crucial. People want to get the 'same' numbers, from querys or dumps, as they inserted them. There isn't a way right now, but it's

Re: [HACKERS] string freeze

2002-10-29 Thread Peter Eisentraut
Dennis Björklund writes: Is there a planned string freeze for postgresql? Let's say right now. ;-) Seriously, beta 3 was the last beta (one hopes), so this is a good time. If there are more changes required due to code fixes, I'll make sure everyone is notified. -- Peter Eisentraut [EMAIL

Re: [HACKERS] pg_dump and large files - is this a problem?

2002-10-29 Thread Peter Eisentraut
Zeugswetter Andreas SB SD writes: AIX is too stupid to wrap unistd.h in an #ifndef to protect against double inclusion? I suppose we could do that for them... I guess that is exactly not wanted, since that would hide the actual problem, namely that _LARGE_FILE_API gets defined (off_t --

Re: [HACKERS] float output precision questions

2002-10-29 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: TODO has: o Add SET REAL_FORMAT and SET DOUBLE_PRECISION_FORMAT using printf args so we have not implemented it yet. IIRC, the last time it was discussed there was disagreement about how it should work; check the pghackers archives for

Re: [HACKERS] Trigger on 'create table' ?

2002-10-29 Thread Tom Lane
Paul Ramsey [EMAIL PROTECTED] writes: We have a similar requirement for PostGIS. In order to meet the OpenGIS specification, we have to maintain a GEOMETRY_COLUMNS table which includes an entry for every column in the db which holds a spatial column. It would be ideal if we could have

Re: [HACKERS] float output precision questions

2002-10-29 Thread Stephan Szabo
On Tue, 29 Oct 2002, Peter Eisentraut wrote: Pedro Miguel Frazao Fernandes Ferreira writes: Is there a way to set query output precision to maximum precision ? For the type of application I mentioned this is crucial. People want to get the 'same' numbers, from querys or dumps, as they

Re: [HACKERS] Trigger on 'create table' ?

2002-10-29 Thread Paul Ramsey
So close... It is a testament to my blockheadedness that I had not considered that (Dave probably did). Here is the standards-mandated definition of the table: CREATE TABLE GEOMETRY_COLUMNS ( F_TABLE_CATALOG VARCHAR(256) NOT NULL, F_TABLE_SCHEMA VARCHAR(256) NOT NULL, F_TABLE_NAME

Re: [HACKERS] float output precision questions

2002-10-29 Thread Bruno Wolff III
On Tue, Oct 29, 2002 at 23:19:05 +0100, Peter Eisentraut [EMAIL PROTECTED] wrote: There isn't a way right now, but it's planned to be able to dump floating-point numbers in some binary form (like printf(%A)) to be able to restore them exactly. Not sure how that would satisfy the needs of

Re: [HACKERS] 7.3b3 passes on MacOSX 10.2.1

2002-10-29 Thread Bruce Momjian
Yes, OSX 10.2.X seems to have this output on _some_ machines, but not others, and we can't seem to figure out why. Can you tell us more about your machine and cpu? --- Peter Bierman wrote: At 6:11 PM -0500 10/29/02, Neil

Re: [HACKERS] 7.3b3 passes on MacOSX 10.2.1

2002-10-29 Thread Peter Bierman
*** ./expected/geometry-powerpc-darwin.out Mon Dec 11 08:45:16 2000 --- ./results/geometry.out Tue Oct 29 15:40:56 2002 *** *** 127,133 ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140472) --- 127,133 ! |

Re: [HACKERS] move 0 behaviour

2002-10-29 Thread Bruce Momjian
Dave Cramer wrote: Currently there is a TODO list item to have move 0 not position to the end of the cursor. Moving to the end of the cursor is useful, can we keep the behaviour and change it to move end, or just leave it the way it is? I did some research on this. It turns out the parser