Re: [HACKERS] how can i add my own procedural language?

2004-12-07 Thread Doug McNaught
Thomas Hallgren <[EMAIL PROTECTED]> writes: > Sibtay, > You normally don't deal with parsing, planning etc. at all from within > a language handler. Unless you're implementing a language from scratch rather than linking in an existing interpreter. In which case, the PL/pgSQL source is a good ex

Re: [HACKERS] Call for port reports

2004-12-07 Thread Bort, Paul
Title: RE: [HACKERS] Call for port reports Port report for Gentoo (www.gentoo.org) Linux: No errors. uname -a: Linux imgvmhost 2.4.26-gentoo-r3 #1 Tue Sep 7 14:20:02 EDT 2004 i686 Intel(R) Pentium(R) 4 CPU 2.40GHz GenuineIntel GNU/Linux gcc -v: gcc version 3.3.4 20040623 (Gentoo Linux 3.3.4

Re: [HACKERS] How can I recovery old Data from files and folders

2004-12-07 Thread Andrew Dunstan
Premsun Choltanwanich wrote: I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I

Re: [HACKERS] adding procedural languages

2004-12-07 Thread Andrew Dunstan
Sibtay Abbas wrote: hi everyone ok i ve tried to add my own procedural language using the call handler interface. I am doining nothing in the handler function except tyring to print a mess through errmsg function (plz correct me if i am wrong here, since i cant see the message which i am printing

Re: [HACKERS] apparent problem on linux/s390

2004-12-07 Thread Tom Lane
"Andrew Dunstan" <[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. > Maybe we should mark the buildfarm member as "s390 emulator" ? > Meanwhile, if anyone knows of

Re: [HACKERS] V8 Beta 5 on AIX

2004-12-07 Thread Andrew Sullivan
On Mon, Dec 06, 2004 at 10:17:53PM +, Simon Riggs wrote: > > > > To the extent AIX is popular :) 5.1 is one release behind the very > > latest. > > AIX 5.3 is out now... > > AIX 5.1 is still fully supported though... Oops, sorry, I meant "one behind the very latest supported by our provide

[HACKERS] adding procedural languages

2004-12-07 Thread Sibtay Abbas
hi everyone ok i ve tried to add my own procedural language using the call handler interface. I am doining nothing in the handler function except tyring to print a mess through errmsg function (plz correct me if i am wrong here, since i cant see the message which i am printing) Now my question

Re: [HACKERS] V8 Beta 5 on AIX

2004-12-07 Thread Bruce Momjian
Tom Lane wrote: > 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,

Re: [HACKERS] apparent problem on linux/s390

2004-12-07 Thread Nicolai Tufar
On Tue, 7 Dec 2004 06:38:25 -0600 (CST), Andrew Dunstan <[EMAIL PROTECTED]> wrote: > 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" or somethi

Re: [HACKERS] apparent problem on linux/s390

2004-12-07 Thread Andrew Dunstan
Nicolai Tufar said: > Hello, > > On Mon, 06 Dec 2004 19:15:23 -0500, Andrew Dunstan > <[EMAIL PROTECTED]> wrote: >> >> problems apparently with NaNs, infinities and negative zeros. > > I am the owner of this baby. It is not an actual mainframe, > it is Hercules emulator running on AthlonXP 2500+ pr

Re: [HACKERS] Call for port reports

2004-12-07 Thread Andrew Rawnsley
smallmouth:~/tmp ronz$ uname -a Darwin smallmouth.local 7.5.0 Darwin Kernel Version 7.5.0: Thu Aug 5 19:26:16 PDT 2004; root:xnu/xnu-517.7.21.obj~3/RELEASE_PPC Power Macintosh powerpc (or OS X 10.3.5) ./configure --prefix=/Users/ronz/tmp/pgsql8 --enable-thread-safety --with-tcl --with-perl

Re: [HACKERS] Call for port reports

2004-12-07 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Peter Eisentraut > Sent: 07 December 2004 00:01 > To: [EMAIL PROTECTED] > Subject: [HACKERS] Call for port reports > > I have started filling in the supported platform list for the > 8.0.0 relea

Re: [HACKERS] spi and other languages

2004-12-07 Thread Sibtay Abbas
i am still in my R&D phase so i ve not yet tried it. actually i chose the wrong example. 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.

[HACKERS] How can I recovery old Data from files and folders on windows?

2004-12-07 Thread Premsun Choltanwanich
I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of

Re: [HACKERS] V8 Beta 5 on AIX

2004-12-07 Thread Zeugswetter Andreas DAZ SD
> 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. AIX does not pull in any libraries that a shared lib depends upon, not even libc. You only specify t

Re: [Testperf-general] Re: [HACKERS] 8.0beta5 results w/ dbt2

2004-12-07 Thread Simon Riggs
On Mon, 2004-12-06 at 23:54, Mark Wong wrote: > 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-u

Re: [HACKERS] apparent problem on linux/s390

2004-12-07 Thread Nicolai Tufar
Hello, On Mon, 06 Dec 2004 19:15:23 -0500, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > problems apparently with NaNs, infinities and negative zeros. I am the owner of this baby. It is not an actual mainframe, it is Hercules emulator running on AthlonXP 2500+ producing 20-25 MIPS of pure mainfr

Re: [HACKERS] spi and other languages

2004-12-07 Thread Michael Fuhr
On Mon, Dec 06, 2004 at 11:05:28PM -0800, Sibtay Abbas wrote: > 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 > ."