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 langa
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 64
-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;
...m
> > 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 ex
> > 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
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
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 a
>> 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 th
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 cert
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
> w
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
or pgadmin3 -ch \pg_hba.conf
or pgadmin3 -cm \postgresql.conf
handles the configuration files. If pginstaller shoul
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
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
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?
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 we
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
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 pa
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 options
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 di
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 down
./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=herring&dt=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 broa
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
