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 important libpq functions lik
On Fri, Oct 25, 2002 at 03:31:22PM -0400, Mike Mascari wrote:
> Bruce Momjian wrote:
> > Andrew Sullivan wrote:
> >
> >>On Fri, Oct 25, 2002 at 11:02:48AM -0400, Tom Lane wrote:
> >>
> >>>So? If it hits the installation-wide limit, you'll have the same
> >>>problem; and at that point the (presuma
I have updated CVS and re-added getopt.c, now in /port, and updated
win32.mak. That should help.
---
Dave Page wrote:
>
>
> > -Original Message-
> > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us]
> > Sent:
On Mon, 2002-10-28 at 21:45, Bruce Momjian wrote:
> Larry Rosenman wrote:
> > On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> > >
> > > See the resultmap file in the regression directory. I see:
> > >
> > > geometry/.*-bsdi=geometry-bsdi-precision
> > > geometry/.*-darwin=geometry-powerp
Are you compiling from CVS or from a released tarball? 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
the bison stuff is preprocessed for released tarballs. So you might
want to try the just
Ports list updated:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
---
Magnus Naeslund(f) wrote:
> Linux alpha.
>
> An Redhat 6.2, "Linux gsX 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002
> alpha
Larry Rosenman wrote:
> On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> >
> > See the resultmap file in the regression directory. I see:
> >
> > geometry/.*-bsdi=geometry-bsdi-precision
> > geometry/.*-darwin=geometry-powerpc-darwin
> > geometry/i.86-.*-freebsd=geometry-positive-
OK, I just updated CVS to add a freebsd 4.7 entry to use the bsdi
output. Please update cvs and let me know if it passes now. Thanks.
---
Larry Rosenman wrote:
> On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> >
> > S
Linux alpha.
An Redhat 6.2, "Linux gsX 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002
alpha unknown" (ev56 ruffian).
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
./configure \
--prefix=/usr/local/pgsql-7.3b3 \
--with-maxbackends=512 \
--with-tcl \
--without-tk
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-powerpc-darwin.out. Which is it, folks?
-
On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
>
> See the resultmap file in the regression directory. I see:
>
> geometry/.*-bsdi=geometry-bsdi-precision
> geometry/.*-darwin=geometry-powerpc-darwin
> geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd
> geometry/al
See the resultmap file in the regression directory. I see:
geometry/.*-bsdi=geometry-bsdi-precision
geometry/.*-darwin=geometry-powerpc-darwin
geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd
geometry/alpha.*-freebsd=geometry-positive-zeros
geometry/i
On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> Ignore the first one, stupid me forgot about permissions.
>
> Here is the real one (horology and geometry):
> (and I expect horology is due to DST change day).
The geometry on FreeBSD4.7 MA
Ports list updated:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
---
Adam Witney wrote:
>
> Just to update the list of supported platforms, 7.3b3 compiles and passes
> all the regression tests
Dennis Björklund wrote:
> Is there a planned string freeze for postgresql?
>
> There was a (good) change some weeks ago that altered lots of witespace.
> Remember that it's enough to change a single space to make that
> translation of that string not work. To do "psql --help" and get half the
> en
Ports list updated:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
---
Andrew Sullivan wrote:
> On Mon, Oct 28, 2002 at 05:32:04PM -0500, Andrew Sullivan wrote:
> > Solaris 7, 2xUltraSPARC-II 400
Is there i faq item or maybe some other way that we can tell users
that --disable-rpath should be used when checking regressiontests if you
have an install already on the box?
The rpath defaults to the installdir even in the temporary install that
is made when doing "gmake check", and that confuses
Ports list updated:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
---
Andrew Sullivan wrote:
> On Fri, Oct 25, 2002 at 10:17:22PM -0400, Bruce Momjian wrote:
> > OK, Tom will be away next week,
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
triggers run on CREATE TABLE, DROP TABLE, and AL
Sorry, I can't think of any to have a view created automatically for
every table creation. Interesting idea, though. I wonder if you could
pass the CREATE string into a function that does the proper creation.
---
Bruce Dav
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.
---
Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > P
That is a good question. The planner does more than just analyse the
query. It generates the Plan used by the executor, so that can't be
removed.
It is always a pain when the optimizer/planner takes longer than the
executor. We do have PREPARE/EXECUTE in 7.3beta for you to use.
-
On Mon, Oct 28, 2002 at 05:32:04PM -0500, Andrew Sullivan wrote:
> Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests
> pass. Solaris 8 forthcoming.
I should have mentioned that this is for beta 3; I don't have the
necessary bison installed to compile from CVS.
Solaris 8, 2xUltra
On Tuesday 29 October 2002 00:08, Bruce Momjian wrote:
> Neil Conway wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > Ports list updated:
> >
> > Shouldn't the "join" regression test failure be fixed?
>
> OK, I have updated the join regression test to add ORDER BY in the
> queries Irix di
Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Ports list updated:
>
> Shouldn't the "join" regression test failure be fixed?
OK, I have updated the join regression test to add ORDER BY in the
queries Irix differed. Ian, would you retest the CVS version of
PostgreSQL to see i
On Fri, Oct 25, 2002 at 10:17:22PM -0400, Bruce Momjian wrote:
> OK, Tom will be away next week, and Thomas will too. I can do it.
> Folks. start sending in those plaform reports, OS name and version
> number please.
Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests
pass. Solari
On Mon, 2002-10-28 at 14:58, Dave Page wrote:
>
> > >
> > > My WAG is that you will be able to upgrade your Cygwin installation
> > > before I fix the Cygwin build issues. :,)
> >
> > I guess my WAG was wrong... :,)
>
> I've been meaning to ask this for a while - what exactly is a WAG? :-)
Wild
> -Original Message-
> From: Jason Tishler [mailto:jason@;tishler.net]
> Sent: 28 October 2002 20:42
> To: Dave Page
> Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart;
> Tom Lane; Pgsql-Cygwin
> Subject: Re: [HACKERS] Request for supported platforms
>
>
> Dave,
>
> On Mon,
Dave,
On Mon, Oct 28, 2002 at 11:20:16AM -0500, Jason Tishler wrote:
> On Mon, Oct 28, 2002 at 02:56:01PM -, Dave Page wrote:
> > Ok, but this is going to take a while as few of the mirrors seem to
> > have this release yet. I also need to download a new set of everything
> > for reasons I won
Would you tell us exactly what this is.
---
Darko Prenosil wrote:
> Tree weeks later than I promised, but it is finished (I hope).
>
> In attachment are files:
> dblink.c
> dblink.h
> dblink.sql.in
>
On 28 Oct 2002, Larry Rosenman wrote:
> On Mon, 2002-10-28 at 11:33, Marc G. Fournier wrote:
> >
> > Ummm .. by the fact that you see [ANNOUNCE] in the above subject, I did
> > send it to -announce :)
> I think he was saying that this was **NOT** stuff he wants to see on
> -ANNOUNCE.
Oops, just r
"Dave Page" <[EMAIL PROTECTED]> writes:
>> Horology failures are normal for a day or so on either side
>> of a DST change --- see the "regression tests interpretation"
>> docs. I have no time right now to examine the other diffs.
> The docs say:
> Some of the queries in the timestamp test will
"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
> 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
On Mon, 2002-10-28 at 11:33, Marc G. Fournier wrote:
>
> Ummm .. by the fact that you see [ANNOUNCE] in the above subject, I did
> send it to -announce :)
I think he was saying that this was **NOT** stuff he wants to see on
-ANNOUNCE.
LER
--
Larry Rosenman http://www.lerctr
Ummm .. by the fact that you see [ANNOUNCE] in the above subject, I did
send it to -announce :)
On 28 Oct 2002, Adrian 'Dagurashibanipal' von Bidder wrote:
> Yo!
>
> Would it be sensible not to use -announce for such things? These bits
> are not really interesting if I'm subscribed to -announ
Yo!
Would it be sensible not to use -announce for such things? These bits
are not really interesting if I'm subscribed to -announce to keep on top
of what's happening wrt to new releases and such things.
(Yes, I'm also subscribed to a few postgres lists, but I only read them
when I have spare tim
> > > The question is *which* seek APIs we need to support. Are there any
> > > besides fseeko() and fgetpos()?
> >
> > On AIX we have
> > int fseeko64 (FILE* Stream, off64_t Offset, int Whence);
> > which is intended for large file access for programs that do NOT
> > #define _LARGE_FILES
> >
On Mon, 2002-10-28 at 10:20, Jason Tishler wrote:
> > > 2. Cygwin bison limit exceeded:
> > >
> > > make[4]: Entering directory
> > > `/home/jt/src/pgsql/src/interfaces/ecpg/preproc'
> > > [snip]
> > > bison -y -d preproc.y
> > > preproc.y:5560: fatal error: maximum table size (32767) exceeded
Change directory in src/pl/plperl
and execute gcc command with option -D_GNU_SOURCE
(2 files)
and then continue make form base directory
You must add /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/libperl.so in
/etc/ld/so/conf or in LD_LIBRARY_PATH
regards
Haris Peco
On Monday 28 October 200
Dave,
On Mon, Oct 28, 2002 at 02:56:01PM -, Dave Page wrote:
> > -Original Message-
> > From: Jason Tishler [mailto:jason@;tishler.net]
> > Sent: 28 October 2002 13:33
> > Subject: Re: [HACKERS] Request for supported platforms
> >
> > Please try with Cygwin 1.3.14-1 while I attempt t
Larry Rosenman <[EMAIL PROTECTED]> forwards:
>>> My inclination is to change the code for ApplySortFunction to look like
>>>
>>> #if defined(__GNUC__)
>>> __inline__
>>> #endif
>>> int32
>>> ApplySortFunction
>>>
>>> so that the inline optimization only gets done for gcc, which we know
>>> interp
> -Original Message-
> From: Tom Lane [mailto:tgl@;sss.pgh.pa.us]
> Sent: 28 October 2002 15:53
> To: Jason Tishler
> Cc: Dave Page; Bruce Momjian; PostgreSQL-development; Thomas
> Lockhart; Pgsql-Cygwin
> Subject: Re: [HACKERS] Request for supported platforms
>
>
> >> Make installch
>> Make installcheck also failed on horology, copy2 and domain - see
>> attached output.
>>
>> The clocks changed here on Saturday night, so I guess that shouldn't
>> have caused the first error (or should the docs be updated?).
Horology failures are normal for a day or so on either side of a DS
> -Original Message-
> From: Jason Tishler [mailto:jason@;tishler.net]
> Sent: 28 October 2002 13:33
> To: Dave Page
> Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart;
> Tom Lane; Pgsql-Cygwin
> Subject: Re: [HACKERS] Request for supported platforms
>
>
> Dave,
>
> Thanks
Dave,
Thanks for the details, I've copied this reply back to the PostgreSQL
guys as well.
LER
On Mon, 2002-10-28 at 09:00, Dave Prosser wrote:
> Larry Rosenman wrote:
> > From: Tom Lane <[EMAIL PROTECTED]>
> > To: Larry Rosenman <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [
> i would like to use postgresql to store any data (some include chinese), but
>when i access the chinese data in postgresql, i can't get back correct data, it
>return any unknow word/data to me.
> How can i solve it? i am using the RedHat Linux 7.2 and Postgresql 7.1, and i
>haven't install
I thought the join was part of the timezone change, but I see now that
it is separate. I will fix it by adding ORDER BY.
---
Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Ports list updated:
>
> Should
On 27 Oct 2032 at 0:24, Timothy Chan wrote:
>
> Hi
> i would like to use postgresql to store any data (some include chinese),
> but when i access the chinese data inpostgresql, i can't get back correct
> data, it return any unknow word/data to me.
> How can i solve it? i am using the RedHat Li
Dave,
Thanks for the heads up...
On Mon, Oct 28, 2002 at 10:31:00AM -, Dave Page wrote:
> > -Original Message-
> > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us]
> > Sent: 26 October 2002 03:17
> > Subject: [HACKERS] Request for supported platforms
> >
> > Folks. start sending
> -Original Message-
> From: Tommy [mailto:tmartin1@;telocity.com]
> Sent: 28 October 2002 03:56
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] Pgsql and .NET (Help!)
>
>
> I have been trying for 3 days to connect to my postgres linux
> box via vb .net on a windows box. I have to make t
The standard approach to such a scenario would imho be to write stored procedures
for the complex queries (e.g. plpgsql) and use that from the client.
Maybe even eliminate a few ping pongs between client and server.
Andreas
Does it reduce the time taken by the planner?
Are server side SQL f
I'm looking at different ways of optimizing queries with a large number of
joins. I write the same query in a number of different ways and compare
the running times. Now the problem is I do not want the optimizer
changing the queries. So I explicit state the order of the joins in the
FROM clause
Tree weeks later than I promised, but it is finished (I hope).
In attachment are files:
dblink.c
dblink.h
dblink.sql.in
pqtest.sql
In file pqtest.sql is sample queries and results. It seem OK to me.
There are two reasons why I did not make a diff.
1. The
On Tue, Oct 22, 2002 at 05:05:38PM +0200, Igor Georgiev wrote:
> or my nightmare a cygwin on Win 98 everybody can can access everything
Or =my= nightmare: Anything important on any Windows platform.
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
Eldorado Computing, Inc. 602-604
Thomas & Tom,
Thanks for all your help, I have updated all the defaults to use timestamptz
and everything is working fine again.
We can't wait for 7.3, keep up the good work.
John
-Original Message-
From: Tom Lane [mailto:tgl@;sss.pgh.pa.us]
Sent: 23 October 2002 19:47
To: Hosen, Joh
Regression Diffs:
*** ./expected/geometry-positive-zeros-bsd.out Tue Sep 12 16:07:16 2000
--- ./results/geometry.out Mon Oct 28 00:06:41 2002
***
*** 114,120
| (5.1,34.5) | [(1,2),(3,4)] | (3,4)
| (-5,-12) | [(1,2),(3,4)]
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 temporarily
unavailable
./pg_regress: fork:
Tom Lane wrote:
Bruce Momjian writes:
>Folks. start sending in those plaform reports, OS name and version
>number please.
I've checked CVS tip on:
HPUX 10.20, using both gcc and vendor's cc
PPC Linux
Mac OS X 10.1
Here's the regression.diffs file from Mac OS X 10.2.1 (Jaguar). It
faile
Hi
i would like to use postgresql to store any
data (some include chinese), but when i access the chinese data
in postgresql, i can't get back correct data, it return any unknow
word/data to me.
How can i solve it? i am using the RedHat Linux 7.2 and
Postgresql 7.1, and i haven't install
I have been trying for 3 days to connect to my postgres linux box via vb
.net on a windows box. I have to make this work somehow.
I found npgsql provider and tried it but could not make it connect either. I
would prefer to use the OleDbConnection if possible.
Has anyone been able to connect via t
All,
I'm trying to implement row level security using PostgreSQL. I envision
having column on each and every table in the database that will contain a
discriminating value that determines if a given user is able to see that row
or not. Users do not directly access the database; they get at it on
RH 8.0 has perl 5.8, here are the details:
From config.log:
configure:4159: checking for perl
configure:4177: found /usr/bin/perl
configure:4189: result: /usr/bin/perl
configure:4198: checking for Perl archlibexp
configure:4201: result: /usr/lib/perl5/5.8.0/i386-linux-thread-multi
configure:4203:
Is there a planned string freeze for postgresql?
There was a (good) change some weeks ago that altered lots of witespace.
Remember that it's enough to change a single space to make that
translation of that string not work. To do "psql --help" and get half the
entries in swedish and half in english
> -Original Message-
> From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us]
> Sent: 26 October 2002 03:17
> To: PostgreSQL-development
> Cc: Thomas Lockhart; Tom Lane
> Subject: [HACKERS] Request for supported platforms
>
>
> Folks. start sending in those plaform reports, OS name and
> -Original Message-
> From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us]
> Sent: 26 October 2002 03:17
> To: PostgreSQL-development
> Cc: Thomas Lockhart; Tom Lane
> Subject: [HACKERS] Request for supported platforms
>
>
> Folks. start sending in those plaform reports, OS name and
>
65 matches
Mail list logo
