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 Mom
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 par
Peter Bierman wrote:
> >> *** ./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.386461014
>> *** ./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
>> !
May I be allowed to use '\n' as a delimiter for "copy from"?
I was able to use it to "copy to" a file, and it worked as
expected, but when I tried to "copy from" the file, I got an
error because it treated the end of line as the end of the
tuple (which I recognize is documented behavior). If the
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
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 nee
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 VARCHAR(
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 t
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/
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 tabl
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 f
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:
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
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 fo
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 (of
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
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
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 b
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 buil
> -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 probl
> -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 Cyg
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
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'
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 e
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 (sin
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!
Attached is a diff to fix the pclose problem. It turns out there was
code in there to make popen/pclose be _popen/_pclose, but it was only in
common.c, even in 7.2.3 (print.c). Not sure how it would compile in the
past with that. Maybe it didn't. Anyway, this is committed and should
_help_ wit
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 [
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:
> >
>
Dave,
On Tue, Oct 29, 2002 at 04:57:58PM -, Dave Page wrote:
> All regression tests pass with the above hack on:
>
> CYGWIN_NT-5.1 PC9 1.3.14(0.62/3/2) 2002-10-24 10:48 i686 unknown
Thanks for the above.
> Hackers: As the Cygwin release that is actively supported is the
> binary distributio
On Tue, 2002-10-29 at 12:13, Bruce Momjian wrote:
>
> Ports list updated:
>
> http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
except for the version of PG :-)
>
> ---
> Larry Rosenman wrote:
> >
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 rec
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.
--
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 interfa
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
> http://developer.postgresql
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:
>
> ==
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: Res
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 i
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
>
>
> -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
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 -a
> >> 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 ba
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 a
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, sin
Dave,
On Mon, Oct 28, 2002 at 08:58:12PM -, Dave Page wrote:
> > -Original Message-
> > From: Jason Tishler [mailto:jason@;tishler.net]
> > Sent: 28 October 2002 20:42
> > Subject: Re: [HACKERS] Request for supported platforms
> >
> > On Mon, Oct 28, 2002 at 11:20:16AM -0500, Jason T
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 ./expected/geometry-po
"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
> > The problem with flex is, that the generated c file does #include
> > 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 i
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.
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 toolb
Greg Copeland wrote:
I've started playing a little with Postgres to determine if there were
memory leaks running around. After some very brief checking, I'm
starting[1] to think that the answer is yes. Has anyone already gone
through a significant effort to locate and eradicate memory leaks? I
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 PROTECTED]:/usr/obj/usr/src/sys/
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 a
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:
Imp
> -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,
56 matches
Mail list logo