hi everyone
i see an attribute 'oid_value' with 'Oid' type in
the ListCell union.
can anyone tell me what does it represents?
Thank you
__
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.
On Mon, 2004-12-06 at 00:29 -0800, Sibtay Abbas wrote:
> i see an attribute 'oid_value' with 'Oid' type in
> the ListCell union.
>
> can anyone tell me what does it represents?
Given a linked list of type T_OidList, oid_value holds the data in a
node of the list. Although int_value and oid_value
hello
i am trying to understand the source code of
postgresql.
Whenever a user enters a query, whether from the
Socket end or the interactive back end, which function
is always invoked that would start manipulation of
that query...
i ve noticed that the primitive parsing is done by the
raw_parse
On Mon, 6 Dec 2004, ElayaRaja S wrote:
> I am using postgresql-7.4.5. I nee to use the jdbc connection So i
> downloaded 4 versions of driver( pg74.215.jdbc1.jar,
> pg74.215.jdbc2.jar, pg74.215.jdbc2ee.jar, pg74.215.jdbc3.jar). I am
> uanble to connect it. Please let me know which version of
On Mon, 6 Dec 2004 00:27:18 -0500 (EST), [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> A short note that I've updated DBD::PgSPI version 0.02 to CPAN.
>
> There are no new features - but the code now expects (and works with)
> reasonably decent versions of perl (5.8.x) and pgsql (8.x)
On Mon, 6 Dec 2004, Mike Rylander wrote:
> Just so that you have some info, I've been using DBD::PgSPI with Pg 8.0
> since beta 1. The only restriction I've run into with the old code is
> that it doesn't like the DBD 'do' method. I have to use execute/fetchX
> or selectX, but other than that it
On Mon, 6 Dec 2004 08:17:29 -0500 (EST), [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> On Mon, 6 Dec 2004, Mike Rylander wrote:
>
> > Just so that you have some info, I've been using DBD::PgSPI with Pg 8.0
> > since beta 1. The only restriction I've run into with the old code is
> > that it does
On Mon, 6 Dec 2004, Mike Rylander wrote:
> With v. 0.01 the statement just doesn't seem to execute. I know that's
> odd, because it's supposed to be doing a prepare/execute internally, but
> nothing happens.
Wierd - the testsuite (make test) has some 'dos' in the code and it works
(and it checks
OSDL provides hardware. You have to sign up for a login here:
https://www.osdl.org/join_form
And submit a project proposal here:
https://www.osdl.org/lab_activities/lab_projects/a_propose_project/propose_a_project.html
Mark
---(end of broadcast)
I tried compliling v8 beta 5 (grabbed from cvs on Friday) on AIX 5.1.
It fails during the make
make[4]: Entering directory
`/opt/OXRS/Sources/pgsql-HEAD/src/interfaces/libpq'
make[4]: Nothing to be done for `all'.
make[4]: Leaving directory
`/opt/OXRS/Sources/pgsql-HEAD/src/interfaces/libpq'
m
Brad Nicholson wrote:
> I tried compliling v8 beta 5 (grabbed from cvs on Friday) on AIX 5.1.
> It fails during the make
>
> make[4]: Entering directory
> `/opt/OXRS/Sources/pgsql-HEAD/src/interfaces/libpq'
> make[4]: Nothing to be done for `all'.
> make[4]: Leaving directory
> `/opt/OXRS/Sour
Just compiled RC1 on a netwinder ARM system running Debian Linux (sarge). All
tests passed except "point" with the
following in results/point
Jim
--
-- POINT
--
CREATE TABLE POINT_TBL(f1 point);
INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)');
INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)');
Would you send us regression.diff? That should show the differences.
---
Jim Buttafuoco wrote:
> Just compiled RC1 on a netwinder ARM system running Debian Linux (sarge).
> All tests passed except "point" with the
> foll
Bruce Momjian wrote:
Brad Nicholson wrote:
I tried compliling v8 beta 5 (grabbed from cvs on Friday) on AIX 5.1.
It fails during the make
make[4]: Entering directory
`/opt/OXRS/Sources/pgsql-HEAD/src/interfaces/libpq'
make[4]: Nothing to be done for `all'.
make[4]: Leaving directory
`/opt/O
See attached
-- Original Message ---
From: Bruce Momjian <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: pgsql-hackers <[EMAIL PROTECTED]>
Sent: Mon, 6 Dec 2004 12:24:18 -0500 (EST)
Subject: Re: [HACKERS] arm rc1 regression failures
> Would you send us regression.diff? That shoul
On Tue, Nov 30, 2004 at 10:51:42PM +, Simon Riggs wrote:
> My suggestion: increase checkpoint_timeout to 600 secs, increase
> bgwriter parameters also, to reduce how frequently it is called, as well
> as increase the number of blocks per cycle.
Ok, here are a series of three tests varying the
Mark,
> Ok, here are a series of three tests varying the bgwriter_delay at 1,
> 50, and 100:
> http://www.osdl.org/projects/dbt2dev/results/pgsql/bgwriter_delay/
Hmmm. Looks inconclusive. The differences between the runs are < 0.3%,
which is a margin of error by anyone's definition.
Brad Nicholson wrote:
> >OK, I assume you used --enable-thread-safety in configure.
> >
> Correct.
>
> >This should
> >have added some PTHREAD link flags to your libpq build, and those
> >settings should have followed the libpq library into your pg_ctl link
> >line.
> >
> >Would you look in your
Brad Nicholson wrote:
> I tried compliling v8 beta 5 (grabbed from cvs on Friday) on AIX 5.1.
I see now you are running AIX 5.1. Is that a fairly modern/popular
version of AIX?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-
On Mon, Dec 06, 2004 at 08:17:29AM -0500, [EMAIL PROTECTED] wrote:
> I put a version of code with a bit more fixes from comments onlist to
> www.pilosoft.com/PgSPI/DBD-PgSPI-0.03pre.tar.gz
After correcting the path (no directory) I downloaded this and it
built without changes on FreeBSD 4.10-STA
Jim Buttafuoco wrote:
> See attached
Well, that test passed for the last release, so what changed in between?
I don't think we changed the floating-point output again, did we?
--
Peter Eisentraut
http://learn.to/quote
---(end of broadcast)---
TI
BTW, I would like to get these capabilities into core plperl.
There are some obstacles to overcome. For example:
. not every perl installation has DBI
. how to turn it on for trusted plperl
. DBD::PgSPI is covered by GPL, which means it can't be used in the core
distribution of postgres - we'd hav
On Mon, 6 Dec 2004, Andrew Dunstan wrote:
> BTW, I would like to get these capabilities into core plperl.
There is already spi_exec_query in pl/perl for quick and dirty DB access
for this purpose, no?
> There are some obstacles to overcome. For example:
>
> . not every perl installation has DBI
On Mon, Dec 06, 2004 at 11:44:20AM -0700, Michael Fuhr wrote:
>
> After correcting the path (no directory) I downloaded this and it
> built without changes on FreeBSD 4.10-STABLE and Solaris 9, both
> running PostgreSQL 8.0.0rc1 and Perl 5.8.6. However, something
> changed since 0.02 that broke q
[EMAIL PROTECTED] writes:
> On Mon, 6 Dec 2004, Andrew Dunstan wrote:
>> . how to turn it on for trusted plperl
> Eh, you don't turn it on. You install the package and it works ;)
Really? If the plperl Safe opmask allows that, we've got some problems.
regards, tom lane
On Mon, 6 Dec 2004, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > On Mon, 6 Dec 2004, Andrew Dunstan wrote:
> >> . how to turn it on for trusted plperl
>
> > Eh, you don't turn it on. You install the package and it works ;)
>
> Really? If the plperl Safe opmask allows that, we've got some pro
On Mon, 2004-12-06 at 17:43, Josh Berkus wrote:
> Mark,
>
> > Ok, here are a series of three tests varying the bgwriter_delay at 1,
> > 50, and 100:
> > http://www.osdl.org/projects/dbt2dev/results/pgsql/bgwriter_delay/
>
> Hmmm. Looks inconclusive. The differences between the runs are
[EMAIL PROTECTED] wrote:
. DBD::PgSPI is covered by GPL, which means it can't be used in the core
distribution of postgres - we'd have to reinvent it in a clean room fashion.
Actually, its both GPL and Artistic license - identical to DBD::Pg (where
most of the code is taken from).
I don't
On Mon, 6 Dec 2004, Andrew Dunstan wrote:
> I disagree. The crucial difference is that DBD::Pg is a client side
> library and plperl is not.
>
> I would like all perl programmers to be able to use the same (or
> similar) idioms on both the client side and the server side. (Just as
> one can use J
Hi Tom + *,
Am 03.12.2004 um 23:58 schrieb Tom Lane:
schmidtm <[EMAIL PROTECTED]> writes:
is somebody working on these two issues on the TODO-List?
1) Prevent default re-use of sysids for dropped users and groups
I don't know of anyone actively working on it, but if you check the
archives you'll f
On Mon, Dec 06, 2004 at 02:34:33PM -0500, [EMAIL PROTECTED] wrote:
>
> For quick access from trusted code, spi_exec should just do fine.
BTW, does stock PL/Perl have functions for escaping identifiers,
strings, and binary strings?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---
On Mon, 6 Dec 2004, Michael Fuhr wrote:
> On Mon, Dec 06, 2004 at 02:34:33PM -0500, [EMAIL PROTECTED] wrote:
> >
> > For quick access from trusted code, spi_exec should just do fine.
>
> BTW, does stock PL/Perl have functions for escaping identifiers,
> strings, and binary strings?
non-DBI? no.
On Mon, Dec 06, 2004 at 03:02:45PM -0500, [EMAIL PROTECTED] wrote:
> On Mon, 6 Dec 2004, Michael Fuhr wrote:
>
> > On Mon, Dec 06, 2004 at 02:34:33PM -0500, [EMAIL PROTECTED] wrote:
> > >
> > > For quick access from trusted code, spi_exec should just do fine.
> >
> > BTW, does stock PL/Perl have
Michael Fuhr wrote:
DBI? yes, $pg_dbh->quote('foo')
Yeah, I know about DBI, but since we currently can't use it in
trusted code I was wondering what we *could* use. With DBI I'd be
using placeholders wherever possible, but unless I've missed something
spi_exec_query() requires values to be i
On Sun, Dec 05, 2004 at 04:06:57PM -0500, Andrew Dunstan wrote:
>
> Amen, brother! That would never be tolerated in any commercial setting
> that I am aware of, and should not be here either, IMNSHO. Silence does
I don't know what commercial settings you're familiar with, but I can
think of so
On Mon, Dec 06, 2004 at 04:00:30PM -0500, Andrew Sullivan wrote:
> however, certainly explains a number of really crappy pieces of
> software I've had to work with.
Uh, that's not a swipe at Bruce -- rather praise for everyone
involved for being frank enough to discuss this.
A
--
Andrew Sulli
Bruce Momjian wrote:
Brad Nicholson wrote:
OK, I assume you used --enable-thread-safety in configure.
Correct.
This should
have added some PTHREAD link flags to your libpq build, and those
settings should have followed the libpq library into your pg_ctl link
line.
Would you look i
On Mon, 2004-12-06 at 17:42, Mark Wong wrote:
> On Tue, Nov 30, 2004 at 10:51:42PM +, Simon Riggs wrote:
> > My suggestion: increase checkpoint_timeout to 600 secs, increase
> > bgwriter parameters also, to reduce how frequently it is called, as well
> > as increase the number of blocks per cyc
On Mon, Dec 06, 2004 at 01:07:11PM -0500, Bruce Momjian wrote:
>
> I see now you are running AIX 5.1. Is that a fairly modern/popular
> version of AIX?
To the extent AIX is popular :) 5.1 is one release behind the very
latest.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote
[EMAIL PROTECTED] writes:
> On Mon, 6 Dec 2004, Andrew Dunstan wrote:
>>> . how to turn it on for trusted plperl
>> [ snip ]
> Errr my bad. I keep confusing trusted/untrusted. It does not allow it, nor
> should it.
> The purpose of PgSPI is to write 'middleware' solutions in perl - the idea
> i
On Mon, 2004-12-06 at 21:59, Andrew Sullivan wrote:
> On Mon, Dec 06, 2004 at 01:07:11PM -0500, Bruce Momjian wrote:
> >
> > I see now you are running AIX 5.1. Is that a fairly modern/popular
> > version of AIX?
>
> To the extent AIX is popular :) 5.1 is one release behind the very
> latest.
A
On Mon, 6 Dec 2004, Tom Lane wrote:
> Sure. But you don't run your middleware as root (I hope ;-)) and you
> shouldn't run it in untrusted server-side languages either. I agree
Actually - I don't practically care, and in fact I'm doing things that are
unsafe...But, I agree, others may think dif
schmidtm <[EMAIL PROTECTED]> writes:
> Do I get that right: the only reason to do max(sysid) or a
> user-supplied ID in CreateUser() (commands/user.c) is that we don't
> have the ability to get sequences over the *.BKI/initdb mechanism?
No, that's not quite the direction of the problem. The real
There was some talk of branching REL8_0_STABLE after 8.0.0rc1 was
released. Is that still the plan?
TIA,
Neil
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Mon, Dec 06, 2004 at 09:28:15PM +, Simon Riggs wrote:
> Mark,
>
> Few questions:
>
> - can we put the logging to DEBUG1 please, so we can see the
> checkpoints? ...and set debug_shared_buffers = 10
Ok, will do.
> I don't understand why the checkpoints are so regular at 300 seconds if
> t
Simon Riggs wrote:
> On Mon, 2004-12-06 at 21:59, Andrew Sullivan wrote:
> > On Mon, Dec 06, 2004 at 01:07:11PM -0500, Bruce Momjian wrote:
> > >
> > > I see now you are running AIX 5.1. Is that a fairly modern/popular
> > > version of AIX?
> >
> > To the extent AIX is popular :) 5.1 is one rel
On Mon, 2004-12-06 at 23:18, Mark Wong wrote:
> On Mon, Dec 06, 2004 at 09:28:15PM +, Simon Riggs wrote:
> > Mark,
> >
> > Few questions:
> >
Thanks.
On the graphs... why do the graphs for Proc Utilisation, Index Scans
etc, only show first 300 secs of a 3600 sec long run? Are those axes
cor
Bruce Momjian <[EMAIL PROTECTED]> writes:
> OK, so does someone want to suggest why a library used to link libpq
> would also be needed to link binaries that use libpq?
No doubt because it's one of those platforms where shared libraries
don't carry their own dependency information. AFAICS, PTHREA
On Mon, Dec 06, 2004 at 11:44:22PM +, Simon Riggs wrote:
> On the graphs... why do the graphs for Proc Utilisation, Index Scans
> etc, only show first 300 secs of a 3600 sec long run? Are those axes
> correct? (I understand seeing the ramp-up is important, I just want to
> check the time axis).
I have started filling in the supported platform list for the 8.0.0
release with the information from the build farm:
http://developer.postgresql.org/docs/postgres/supported-platforms.html
It's now time to fill the holes. Briefly, I'm looking for exit status 0
on
./configure --prefix=SOMEWHER
Bruce Momjian wrote:
> OK, so does someone want to suggest why a library used to link libpq
> would also be needed to link binaries that use libpq? And with no
> cc_r it seems I have no idea how to get this working.
We didn't get this working for 7.4, for reasons that we are again
becoming aware
Neil Conway <[EMAIL PROTECTED]> writes:
> There was some talk of branching REL8_0_STABLE after 8.0.0rc1 was
> released. Is that still the plan?
I'm up for it, personally --- is everybody else ready? Should we wait
another day or three?
regards, tom lane
-
headsup courtesy of buildfarm.
problems apparently with NaNs, infinities and negative zeros.
see:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=fantail&dt=2004-12-06%2011:05:24
cheers
---(end of broadcast)---
TIP 9: the planner will ignore your
Peter Eisentraut wrote:
I have started filling in the supported platform list for the 8.0.0
release with the information from the build farm:
http://developer.postgresql.org/docs/postgres/supported-platforms.html
It's now time to fill the holes. Briefly, I'm looking for exit status 0
on
./con
On Mon, Dec 06, 2004 at 12:53:52PM -0500, Bruce Momjian wrote:
> Brad Nicholson wrote:
> > >OK, I assume you used --enable-thread-safety in configure.
> > >
> > Correct.
> >
> > >This should
> > >have added some PTHREAD link flags to your libpq build, and those
> > >settings should have followed
On Mon, 6 Dec 2004, Tom Lane wrote:
Neil Conway <[EMAIL PROTECTED]> writes:
There was some talk of branching REL8_0_STABLE after 8.0.0rc1 was
released. Is that still the plan?
I'm up for it, personally --- is everybody else ready? Should we wait
another day or three?
Let's say Friday I branch her
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > OK, so does someone want to suggest why a library used to link libpq
> > would also be needed to link binaries that use libpq? And with no
> > cc_r it seems I have no idea how to get this working.
>
> We didn't get this working for 7.4, for reaso
Kenneth Marshall wrote:
> > Let me ask --- if you change the CC line in Makefile.global to cc_r,
> > does everything build OK? That might be a clean solution because the
> > change could be made in one place. Of course this would mean the
> > backend would also be compiled using cc_r and I have n
Sorry, here is select version();
PostgreSQL 8.0.0rc1 on i386-pc-bsdi4.3.1, compiled by GCC 2.95.3
---
Peter Eisentraut wrote:
> I have started filling in the supported platform list for the 8.0.0
> release with
==
All 96 tests passed.
==
version
PostgreSQL 8.0.0rc1 on i386-unknown-freebsd5.3, compiled by GCC gcc (GCC)
Bruce Momjian <[EMAIL PROTECTED]> writes:
> However, one thing we can do is to try this in Makefile.aix:
> # AIX needs threads for everything that uses libpq
> LIBS += $(PTHREAD_LIBS)
> That is going to enable thread libs for all linking including the
> backend, but it might work.
That
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Peter Eisentraut wrote:
>> ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \
>> --with-perl --with-python --with-krb5 --with-pam -with-openssl
>> make
>> make install
>> make check
> buildfarm actually runs in this order:
> make
> mak
hi
is "Procedural language handler function" the
interface for adding your own procedural languages to
postgres?
I ve read the documentation but i am not able to
understand where do we deal with stuff like parse
trees, query trees, plan trees etc.
Ofcourse any procedural language should pass th
Sibtay,
hi
is "Procedural language handler function" the
interface for adding your own procedural languages to
postgres?
I ve read the documentation but i am not able to
understand where do we deal with stuff like parse
trees, query trees, plan trees etc.
Ofcourse any procedural language should pas
Tom Lane said:
> Andrew Dunstan <[EMAIL PROTECTED]> writes:
>> Peter Eisentraut wrote:
>>> ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \
>>> --with-perl --with-python --with-krb5 --with-pam -with-openssl
>>> make
>>> make install
>>> make check
>
>> buildfarm actually runs in t
i guess the answer to my previous question was spi...i
ve got another question, can we call pgsql or plpgsql
functions using spi?
like can we do something like
SPI_execute("CREATE FUNCTION blah() RETURNS Integer
."
__
Do you Yahoo!?
66 matches
Mail list logo
