Sibtay Abbas [EMAIL PROTECTED] writes:
We can call SQL statements like SPI_Execute(SELECT *
FROM sometable) from the spi interface. My question
is that can we enter other procedural languages as
well, like pgplsql statements.
You can call a function written in another procedural langauge by
Nicolai Tufar [EMAIL PROTECTED] writes:
Hercules is a tested and proved emulator but I have a vague doubt
that it's IEEE FPU emulation may be slightly different from the
real iron's one.
FWIW, I get clean regression test passes on a real z900 at Red Hat,
in both s390 and s390x (32- and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Heh heh heh :-)
- -- Forwarded message --
Date: Wed, 08 Dec 2004 12:33:48 -0500
From: Tom Lane [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [SECURITY] Fedora Core 2 Update: mysql-3.23.58-9.1
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
While trying to build 7.2.6 FC1 RPMs due to a request from Pierlugi today,
I saw an error in contrib/seg. This small patch fixed the typo and we can
build the RPMs now. Could you please apply it to 7.2?
hi everyone
i ve added my own pl language in postgresql. i ve
followed the process mentioned in the documentation.
for the handler function i ve followed the following
template
PG_FUNCTION_INFO_V1(myhandler);
Datum
plsample_call_handler(PG_FUNCTION_ARGS)
{
Datum rv;
Meanwhile, if anyone knows of real big iron that could join
the buildfarm
that would also be good.
I can't put it in the buildfarm ;-) but I have access to real s390
hardware inside Red Hat. I'll try to run a test build and see whether
the regression tests pass.
I would expect that
Maybe we should mark the buildfarm member as s390 emulator ?
It could be. But we'd rather use the full specification,
Hercules 2.37, ESAME S390 architecture, 31 bit mode, running Debian
Linux Woody
Full support for IEEE float number instructions was added into Hercules
during last weeks of
Peter Eisentraut [EMAIL PROTECTED] writes:
I'm in favor of waiting until the release.
Well, if we can hold to the Dec 15 release date, it's only a week's
difference ... so I don't care much either way. Are you concerned
about having to double-patch the last-minute translation updates?
On E, 2004-11-29 at 02:22, David Garamond wrote:
Joe Conway wrote:
Not if the column is storage type EXTERNAL. See a past discussion here:
http://archives.postgresql.org/pgsql-general/2003-07/msg01447.php
what is the reasoning behind this syntax?
ALTER TABLE [ ONLY ] table [ * ]
On Tue, 07 Dec 2004 13:51:36 -0500, Tom Lane [EMAIL PROTECTED] wrote:
FWIW, I get clean regression test passes on a real z900 at Red Hat,
in both s390 and s390x (32- and 64-bit) modes. I'm not sure what that
means --- it could be that Red Hat Linux doesn't use the hardware
floating point, or
On Mon, Dec 06, 2004 at 07:52:37PM +, Simon Riggs wrote:
Varying bgwriter_maxpages upwards should take performance higher.
I have 2 runs now. I for both tests, I have bgwriter_percent=100,
checkpoint_segments=8192, checkpoint_timout=600,
debug_shared_buffers=10, log_min_messages=debug1
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 is certainly wrong. The correct thing is to
On Mon, Dec 06, 2004 at 08:07:00PM -0500, Bruce Momjian wrote:
Yea, we needed this problem report during beta, not RC.
For the record, there _was_ such a problem report, for b3:
http://archives.postgresql.org/pgsql-hackers/2004-10/msg00046.php
A
--
Andrew Sullivan | [EMAIL PROTECTED]
A
Peter Eisentraut [EMAIL PROTECTED] writes:
It's now time to fill the holes. Briefly, I'm looking for exit status 0
on
./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \
--with-perl --with-python --with-krb5 --with-pam -with-openssl
make
make install
make check
with
On Tue, Dec 07, 2004 at 09:12:18AM +, Simon Riggs wrote:
Not sure, as yet, what is causing effect 2. It's not related to the
kernel, but is related to user CPU and I/O waits and effects all tables
in proportion to their overall I/O usage. Some evidence that it becomes
more pronounced as
Am 07.12.2004 um 19:24 schrieb Tom Lane:
Matthias Schmidt [EMAIL PROTECTED] writes:
By the way: Do you have an idea about a small or
medium sized task from the TODO-List for a newbee, which gets me up to
speed?(!Win32)
A lot of the tasks listed under DATA TYPES are fairly self-contained
problems
At this very moment, the first snapshot of pgAdmin III 1.3 is uploading,
which includes the pgsql configuration file editor.
For pginstaller purposes, the command line
pgadmin3 -c pgsql-datadir
or pgadmin3 -ch pgsql-dir\pg_hba.conf
or pgadmin3 -cm pgsql-dir\postgresql.conf
handles the
I already reinstall old version of PostgreSQL. However I still cannot
run PostgreSQL service after I reinstall on many time. I think that I
cannot use pg_dump or all command without PostgreSQL service running. So
What thing I can do now?
Andrew Dunstan [EMAIL PROTECTED] 7/12/2004 10:18:19 pm
On Tue, Dec 07, 2004 at 10:37:36AM +0200, Nicolai Tufar wrote:
On Mon, 06 Dec 2004 19:15:23 -0500, Andrew Dunstan [EMAIL PROTECTED] wrote:
problems apparently with NaNs, infinities and negative zeros.
Sure smells more like an IEEE issue than a postgresql issue (built for
IBM FP rather than
Sorry - please ignore.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
I wrote:
The cause of this failure is that parse_coerce.c thinks that a child
table's rowtype is binary-compatible with its parent's rowtype:
...
The Really Clean And Correct fix to this, IMHO, would be to invent a new
expression node type that represents coercing a rowtype expression to a
Matthias Schmidt [EMAIL PROTECTED] writes:
By the way: Do you have an idea about a small or
medium sized task from the TODO-List for a newbee, which gets me up to
speed?(!Win32)
A lot of the tasks listed under DATA TYPES are fairly self-contained
problems ... but what draws your interest? I
Further investigation has shown that the exit/trap idiom used in
pg_regress.sh is less than 100% portable.
The following shell script has been seen to produce incorrect output on
both Cygwin and FreeBSD:
#!/bin/sh
trap '
st=$?
echo status = $st
exit $st
' 0
(exit 9); exit
I'm not sure how
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?
I'm in favor of waiting until the release.
Hackers,
There are a bunch of error messages saying something like
cannot foo because bar
For example,
errmsg(cannot assign to field \%s\ of column \%s\ because its type %s is
not a composite type)
What do you think of changing those to use errdetail in addition to
errmsg? So this
Peter Eisentraut wrote:
Briefly, I'm looking for exit status 0
on
./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \
--with-perl --with-python --with-krb5 --with-pam -with-openssl
(I would like the build farm members for Windows and Cygwin to use more
feature-enabling
Am 06.12.2004 um 23:27 schrieb Tom Lane:
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
On Thu, Dec 09, 2004 at 12:17:58AM +0200, Devrim GUNDUZ wrote:
Heh heh heh :-)
- -- Forwarded message --
Date: Wed, 08 Dec 2004 12:33:48 -0500
From: Tom Lane [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Well, working for Red Hat has the downside of
./configure \
--prefix=/usr/local/pgsql/8.0rc1 \
--enable-thread-safety \
--with-tcl \
--with-perl \
--with-python \
--with-krb5 \
--with-pam \
--with-openssl \
--with-includes=/sw/include/ \
--with-libraries=/sw/lib
I have seen several cases where either pg_regress appears not to exit
with the expected non-zero exit status or make check does not
apparently exit with the expected non-zero status.
In particular, I've seen it on cygwin, windows, and have at least a
suspicion of it happening on FreeBSD.
The
It looks like --enable-cassert isn't handled properly under icc7
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herringdt=2004-12-07%2016:30:44
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
---(end of
i have added my own pocedural language in postgresql.
by using the Create function command i ve also written
a procedure in that language.
now when invoke that function with
SELECT (func_name) i receive the following error
message
ERROR: language 17254 has old-style handler.
32 matches
Mail list logo