[HACKERS] Port Reports: UnixWare/Failure/Priviledge Test

2003-10-24 Thread Larry Rosenman
In addition to the -g issue, I get the following failure: *** ./expected/privileges.out Thu Oct 9 20:49:31 2003 --- ./results/privileges.outFri Oct 24 14:07:18 2003 *** *** 247,253 (1 row) CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE sql; -- fa

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian writes: > > > It is time for people to report their port testing. Please test against > > current CVS or beta5 and report your 'uname -a'. > > This one is OK after the recent pthread.h patch: > > NetBSD 1.6 (GENERIC) i386 > > However, the compile pointed

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Christopher Browne wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > It is time for people to report their port

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread James Rogers
On Mon, 2003-10-20 at 13:50, Anthony W. Youngman wrote: > Note I didn't say relational is *incorrect* - the ideas of > "mathematically correct" and "scientifically provable" are orthogonal, > and have nothing to say about each other. Eh? "Mathematical" and "Scientific" reasoning (more correctly:

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Kevin Brown
Dawn M. Wolthuis wrote: > So, nope, I'm not trolling. I've been doing some research the past > couple of years and I'm convinced that it is time to do something new > (and yet old) with data persistence. Perhaps. But before you go down that road, you have to answer the following simple, yet pos

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Marsh Ray
Lauri Pietarinen wrote: The theory, indeed, does not say anything about buffer pools, but by decoupling logic from implementation we leave the implementor (DBMS) to do as it feels fit to do. As DBMS technology advances, we get faster systems without having to change our programs. I think you'

Re: [HACKERS] 7.4 compatibility question

2003-10-24 Thread Tatsuo Ishii
> I've been pushing this agenda for a few releases now, but some people have > been, er, boycotting it. I think, too, that release notes *must* be > written incrementally at the same time that the feature change is made. > This is the only way we can get accurate and complete release notes, and >

Re: [HACKERS] Call for port reports

2003-10-24 Thread Noèl Köthe
Am Sa, den 25.10.2003 schrieb Noèl Köthe um 01:17: > reports of these slower systems will follow but they need a bit more time: > > Linux casals 2.4.19-r4k-ip22 #1 Tue Mar 18 15:38:10 CET 2003 mips unknown polymorphism ... ok stats... ok == shutting

Re: [HACKERS] Call for port reports

2003-10-24 Thread Kurt Roeckx
On Sat, Oct 25, 2003 at 12:46:39AM +0200, Peter Eisentraut wrote: > Kurt Roeckx writes: > > > I need this small patch so it properly detects I have unix domain > > sockets. Otherwise no problems. > > What system? What happens without the patch? Details, please. It's a Linux system with libc5.

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > Thanks, fixed. Please retest. I get farther, but I'm getting failures in the stats test that were reported by earlier posters as well. In the server log I see: LOG: could not bind socket for statistics collector: Can't assign requested address What could be the cause

Re: [HACKERS] Call for port reports

2003-10-24 Thread Noèl Köthe
> It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. > > The current list is at: > > http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html here are some build reports. Its all on Debian GNU/Linux w

Re: [HACKERS] Call for port reports

2003-10-24 Thread Alvaro Herrera
On Fri, Oct 24, 2003 at 06:07:40PM -0400, Christopher Browne wrote: > In the last exciting episode, [EMAIL PROTECTED] (Bruce Momjian) wrote: > > It is time for people to report their port testing. Please test against > > current CVS or beta5 and report your 'uname -a'. > > > > The current list is

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Kurt Roeckx writes: > On Fri, Oct 24, 2003 at 11:37:32AM -0400, Bruce Momjian wrote: > > It is time for people to report their port testing. Please test against > > current CVS or beta5 and report your 'uname -a'. > > I need this small patch so it properly detects I have unix domain > sockets. O

Re: [HACKERS] Call for port reports

2003-10-24 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Bruce Momjian) wrote: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. > > The current list is at: > > http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platf

Re: [HACKERS] Call for port reports

2003-10-24 Thread Kurt Roeckx
On Fri, Oct 24, 2003 at 11:37:32AM -0400, Bruce Momjian wrote: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. I need this small patch so it properly detects I have unix domain sockets. Otherwise no problems. Kurt In

Re: [HACKERS] Call for port reports

2003-10-24 Thread Christopher Browne
[EMAIL PROTECTED] (Bruce Momjian) writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. > > The current list is at: > > http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html ... Much omitted .

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > Does -O0 override an earlier -O2? I wonder if it is just complaining > when it sees -O2 and is actually using -O for the compile. We still > need to fix that, but I am curious. If you specify -O2 anywhere and the compile step is invoked (for example, you're not just pre

Re: [HACKERS] Call for port reports -- Failure on Linux

2003-10-24 Thread Robert Treat
worked fine on slackware: == All 93 tests passed. == Linux phppgadmin 2.4.18 #2 Fri May 31 01:21:23 PDT 2002 i586 unknown oh... different kernel, different filesystem Robert Treat On Fri, 2003-10-24 at 16:37, Rod Taylor wrote: > Linux ns2 2.4.20-x

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. This one is OK after the recent pthread.h patch: NetBSD 1.6 (GENERIC) i386 However, the compile pointed out that in src/interfaces/libpq/fe-auth.c

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian writes: > > > > BUT: The default CFLAGS are set by configure to -O2, although the template > > > wants -O. I manually modified the CFLAGS to -O after configure. > > > > template/alpha has: > > > > case $host_cpu in > > alpha*) CFLAGS="$CFLAGS -O

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > > BUT: The default CFLAGS are set by configure to -O2, although the template > > wants -O. I manually modified the CFLAGS to -O after configure. > > template/alpha has: > > case $host_cpu in > alpha*) CFLAGS="$CFLAGS -O";; # alpha has problems with -O2 >

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > It is time for people to report their port testing. Please tes

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. This one is OK: OpenBSD 3.2 GENERIC#25 i386 -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)---

Re: [HACKERS] round() function wrong?

2003-10-24 Thread scott.marlowe
On Fri, 24 Oct 2003, Michael Brusser wrote: > But this seems to work correctly on 7.3.2 and 7.3.4: > psql -c "select round (2.5)" > Password: > round > --- > 3 > (1 row) > > = > > > > I just tried that on my 7.2.4 and 7.4 beta 4 machines and I get 2 for > > round(2.5) A

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian writes: > > > It is time for people to report their port testing. Please test against > > current CVS or beta5 and report your 'uname -a'. > > This one is OK: > > FreeBSD 4.8-RELEASE alpha > > BUT: The default CFLAGS are set by configure to -O2, although

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Thanks, fixed. Please retest. --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > It is time for people to report their port testing. Please test against > > current CVS or beta5 and report your 'uname -a'. > > On

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html I saw in your diff: ! psql: could not fork new process for connection: Resource temporarily unavailable so I figured it was something related to resources. -

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Heading updated too. Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > It is time for people to report their po

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > It is time for people to report their port testing. Please te

Re: [HACKERS] Call for port reports -- Failure on Linux

2003-10-24 Thread Rod Taylor
Linux ns2 2.4.20-xfs #2 Tue Apr 15 10:04:43 EDT 2003 i686 unknown <-- SNIP --> stats... FAILED == shutting down postmaster == === 1 of 93 tests failed. === *** ./expected/stats.outSat Se

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. This one is OK: FreeBSD 4.8-RELEASE alpha BUT: The default CFLAGS are set by configure to -O2, although the template wants -O. I manually modified

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. On True64 5.1 (no "thread safety" enabled) with gcc: In file included from postgresql-7.4beta5/src/port/thread.c:17: /usr/include/pthread.h:290:3: #

Re: [HACKERS] PostgreSQL on Novell Netware 6.5.

2003-10-24 Thread Hannu Krosing
Eduardo D Piovesam kirjutas E, 20.10.2003 kell 16:35: > They stopped at 7.2.4 because "they're finishing some usefull APIs, > which'll make the port much more "easy"." Will this involve using a Linux kernel ;) > When this part is done, a new port will be made with 7.4. With much > less "NetWare s

Re: [HACKERS] round() function wrong?

2003-10-24 Thread Hannu Krosing
Peter Eisentraut kirjutas R, 24.10.2003 kell 22:16: > Jochen Westland [invigo] writes: > > > In my version > > select round(2.5); returns 2; > > select round(2.501) returns 3; > > > > refering to my math professor thats wrong, at least in germany. > > select round(2.5); should return 3 > > Th

Re: [HACKERS] round() function wrong?

2003-10-24 Thread Peter Eisentraut
Jochen Westland [invigo] writes: > In my version > select round(2.5); returns 2; > select round(2.501) returns 3; > > refering to my math professor thats wrong, at least in germany. > select round(2.5); should return 3 The convention that .5 values should be rounded up is just that, a convent

Re: [HACKERS] Call for port reports

2003-10-24 Thread Marko Karppinen
I'm just being an idiot, it's obviously a limits problem on the platform. It has a default max user processes limit of 100, which I was hitting. I shut down a bunch of desktop apps, and it's now passing: 92 of 93 tests passed, 1 failed test(s) ignored. (random was the one failing). So I guess yo

Re: [HACKERS] round() function wrong?

2003-10-24 Thread Robert Treat
On Fri, 2003-10-24 at 13:53, scott.marlowe wrote: > On Wed, 22 Oct 2003, Jochen Westland [invigo] wrote: > > > Hi All, > > i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting > > is already fixed > > in newer versions or not. > > > > In my version > > select round

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Mike Mascari
Darren King wrote: >>"Bob" <[EMAIL PROTECTED]> spewed forth... >> >>We achieved 8 times the performance with exactly the same >>hardware. What the hell is this idiot talking about us >>relying on hardware? He is a moron. You will do everyone >>a favour if you just bounce him off the bottom of you

Re: [HACKERS] Call for port reports

2003-10-24 Thread Marko Karppinen
Looking a bit further into this, it looks like random tests are failing. Seems like an issue with the test harness on this platform. Does someone want a shell account to debug? mk On Oct 24, 2003, at 21:39, Marko Karppinen wrote: 6 out of 93 tests failed: date ... FAILED

Re: [HACKERS] Call for port reports

2003-10-24 Thread Marko Karppinen
On Oct 24, 2003, at 18:37, Bruce Momjian wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. This is with beta 5. Darwin marko.karppinen.fi 7.0.0 Darwin Kernel Version 7.0.0: Wed Sep 24 15:48:39 PDT 2003; root:xnu/xnu-5

Re: [HACKERS] -:-about the nls files

2003-10-24 Thread Peter Eisentraut
Hemanthakumar R Dondolu writes: > Is ther any way to open the nls files of windows and rewrite our own file and use. > Wht software is required or how can i write do can i get the source from you for this Please see this page for information about suggested tools and other things: http://develop

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. CYGWIN_NT-5.1 krusty 1.3.22(0.78/3/2) 2003-03-18 09:20 i686 unknown unknown Cygwin I suggest that we change the operating system column for this pla

Re: [HACKERS] round() function wrong?

2003-10-24 Thread Michael Brusser
But this seems to work correctly on 7.3.2 and 7.3.4: psql -c "select round (2.5)" Password: round --- 3 (1 row) = > > I just tried that on my 7.2.4 and 7.4 beta 4 machines and I get 2 for > round(2.5) > > ---(end of broadcast)-

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Darren King
> "Bob" <[EMAIL PROTECTED]> spewed forth... > > We achieved 8 times the performance with exactly the same > hardware. What the hell is this idiot talking about us > relying on hardware? He is a moron. You will do everyone > a favour if you just bounce him off the bottom of your > killfile. > ... >

Re: [HACKERS] round() function wrong?

2003-10-24 Thread scott.marlowe
On Wed, 22 Oct 2003, Jochen Westland [invigo] wrote: > Hi All, > i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting > is already fixed > in newer versions or not. > > In my version > select round(2.5); returns 2; > select round(2.501) returns 3; > > refering

Re: [HACKERS] Complex/elaborate user-defined base types

2003-10-24 Thread Jean-Henry Berevoescu
For some strange reason this message only came from the mailing list 3 days after I sent it. I managed to figure it out on my own (how to do what I asked in the original mail), but I still have a little problem with accessing objects of user-defined base types from Java. I definitely miss something

[HACKERS] round() function wrong?

2003-10-24 Thread Jochen Westland [invigo]
Hi All, i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting is already fixed in newer versions or not. In my version select round(2.5); returns 2; select round(2.501) returns 3; refering to my math professor thats wrong, at least in germany. select round(2.5);

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Anthony W. Youngman wrote: > > >In article <[EMAIL PROTECTED]>, Lauri Pietarinen > ><[EMAIL PROTECTED]> writes > > > > > >>>Okay. Give me a FORMULA that returns a time in seconds for your query. > >>> > >>>Let's assume

[HACKERS] help

2003-10-24 Thread dedy setiawan
hello,... I'm using postgreSQL 7.4 beta for windows, and i use them in my project with delphi and i use DBexpress for connecting to then Postgres, but in other case my postgres runs very slowly ,I compare it with mySQL is faster than mine, By the way my computer spesification is : Intel PIII 600B

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Lauri Pietarinen
Anthony W. Youngman wrote: In article <[EMAIL PROTECTED]>, Lauri Pietarinen <[EMAIL PROTECTED]> writes Okay. Give me a FORMULA that returns a time in seconds for your query. Let's assume I want to print a statement of how many invoices were sent to a customer, along with various details of tho

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Anthony W. Youngman
In article <[EMAIL PROTECTED]>, Lauri Pietarinen <[EMAIL PROTECTED]> writes >>Okay. Give me a FORMULA that returns a time in seconds for your query. >> >>Let's assume I want to print a statement of how many invoices were sent >>to a customer, along with various details of those invoices. My invoice

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Mike Preece
"Bob Badour" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... [snip] > > Actually, Bob pointed out ... [snip] > Why don't you go and bang your heads together Bob. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, p

Re: [HACKERS] Timestamp docs weirdness

2003-10-24 Thread Marcus Börger
Hello Christopher, Wednesday, October 22, 2003, 10:21:02 AM, you wrote: >>>What in the heck is 'zulu', 'allballs' or 'z'??? >> >> >> 'allballs' probably alludes to the visual appearance of '00:00:00'. 'z' >> and 'zulu' should be time zones equivalent (or similar?) to UTC or GMT >> ((US?) milit

[HACKERS] -:-about the nls files

2003-10-24 Thread Hemanthakumar R Dondolu
Hi pgsql-hackers, Is ther any way to open the nls files of windows and rewrite our own file and use. Wht software is required or how can i write do can i get the source from you for this thank you heman - Click here to find your dream partner! Know

Re: [HACKERS] Broken links in postgreSQL.org ads

2003-10-24 Thread Marc G. Fournier
'K, just tried Konqueror, and I get the same behaviour ... Firebird 0.7, though, works fine for me ... Just looked in Konqueror's settings for Cookies, and default is to accept from originating server ... IE6 has similar 'defaults', but you can setup P3P to get around it, do you know if Konqueror

Re: [HACKERS] Can't not load libpq.so.3

2003-10-24 Thread Jeroen T. Vermeulen
On Mon, Oct 20, 2003 at 10:12:28AM +0200, Fabien DAUMEN wrote: > > I link my program with this link option ?L/usr/local/pgsql/lib. That's good, but it only deals with the compile-time linking. The actual loading of a shared library happens at run-time, and since there's no special reason to ass

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. FreeBSD svr1.postgresql.org 4.9-PRERELEASE FreeBSD 4.9-PRERELEASE #4: Sat Sep 20 14:41:58 ADT 2003 i386 -- Peter Eisentraut [EMAIL PROTECTED]

Re: [HACKERS] Broken links in postgreSQL.org ads

2003-10-24 Thread Richard Huxton
On Friday 24 October 2003 16:45, Marc G. Fournier wrote: > how broken? I just tested it from here, using Mozilla Firebird, and they > work fine, no errors ... there are issues with IE6 that we are aware of, > but again, nothing that should generate error messages ... I always assumed it was my se

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > It is time for people to report their port testing. Please tes

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > It is time for people to report their port testing. Please te

Re: [HACKERS] Dump error

2003-10-24 Thread Jochem van Dieten
ivan wrote: pg_dump: handler procedure for procedural language "plpgsql" not found pg_dumpall: pg_dump failed on database "db", exiting why ? Perhaps the pg_dump bug with procedural language handlers which have been created in the pg_catalog schema: http://archives.postgresql.org/pgsql-general/200

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. Linux sparc-sid 2.4.22-ctx17a #1 SMP Sam Okt 11 23:39:04 CEST 2003 sparc64 GNU/Linux (32-bit build) -- Peter Eisentraut [EMAIL PROTECTED]

Re: [HACKERS] Call for port reports

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. Linux bell 2.4.22-1-k7 #5 Sat Oct 4 14:11:12 EST 2003 i686 GNU/Linux -- Peter Eisentraut [EMAIL PROTECTED] ---(end of b

Re: [HACKERS] Complex/elaborate user-defined base types

2003-10-24 Thread Jean-Henry Berevoescu
For some strange reason this message only came from the mailing list 3 days after I sent it. I managed to figure it out on my own (how to do what I asked in the original mail), but I still have a little problem with accessing objects of user-defined base types from Java. I definitely miss something

[HACKERS] pg_user

2003-10-24 Thread ivan
hi can we change initdb when view pg_user is createing to : CREATE VIEW pg_user AS \ SELECT \ usename, \ usesysid, \ usecreatedb, \ usesuper, \ usecatupd, \ ''::text as passwd, \ valuntil, \ useconfig \ FROM pg_shado

[HACKERS] Why do I get -g with this config?

2003-10-24 Thread Larry Rosenman
With B4, I didn't get the -g switch with the below config, with B5, I do. This is BAD on UnixWare, as our compiler doesn't do -O with -g. CC=cc CXX=CC ./configure --prefix=/usr/local/pgsql --enable-syslog \ --with-CXX --enable-multibyte --enable-cassert \ --with-includes=/usr/loca

Re: [HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
Updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Adam Witney wrote: > On 24/10/03 4:37 pm, "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > > > It is time for people to report thei

Re: [HACKERS] Call for port reports

2003-10-24 Thread Adam Witney
On 24/10/03 4:37 pm, "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. > > The current list is at: > > http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html

Re: [HACKERS] Semaphores

2003-10-24 Thread Bruce Momjian
Nailah Ogeer wrote: > Hi all, > Just wanted to know how postgres handles semaphores. Was hoping that i can > can use the locks defined in lwlock.h and lwlock.c . If i create a new > lock and then use LockAcquire and > LockRelease when I want a process to start and stop will this work? Uh, well, we

Re: [HACKERS] Broken links in postgreSQL.org ads

2003-10-24 Thread Marc G. Fournier
how broken? I just tested it from here, using Mozilla Firebird, and they work fine, no errors ... there are issues with IE6 that we are aware of, but again, nothing that should generate error messages ... On Mon, 20 Oct 2003, Stephen wrote: > Dear webmaster, > > I tried contacting [EMAIL PROTEC

[HACKERS] Semaphores

2003-10-24 Thread Nailah Ogeer
Hi all, Just wanted to know how postgres handles semaphores. Was hoping that i can can use the locks defined in lwlock.h and lwlock.c . If i create a new lock and then use LockAcquire and LockRelease when I want a process to start and stop will this work? Nailah ---(end

[HACKERS] Dump error

2003-10-24 Thread ivan
pg_dump: handler procedure for procedural language "plpgsql" not found pg_dumpall: pg_dump failed on database "db", exiting why ? i create this language by script createlang as superuser for this database so, ? :) ---(end of broadcast)--- TIP 7:

[HACKERS] Call for port reports

2003-10-24 Thread Bruce Momjian
It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. The current list is at: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html -- Bruce Momjian| http://candle.pha.pa.u

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Paul Vernon
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Anthony W. Youngman wrote: > > >Well, as far as we MV'ers are concerned, performance IS a problem with > >the relational approach. The attitude (as far as I can tell) with > >relational is to hide the actual DB implem

Re: [HACKERS] 2-phase commit

2003-10-24 Thread Heikki Linnakangas
On Fri, 10 Oct 2003, Heikki Linnakangas wrote: > On Thu, 9 Oct 2003, Bruce Momjian wrote: > > > Agreed. Let's get it into 7.5 and see it in action. If we need to > > adjust it, we can, but right now, we need something for distributed > > transactions, and this seems like the logical direction. >

[HACKERS] Broken links in postgreSQL.org ads

2003-10-24 Thread Stephen
Dear webmaster, I tried contacting [EMAIL PROTECTED] twice about broken links on all the top corner square ads at http://www.postgresql.org web site, but no one seemed fix them for a very very long time. Hopefully this post will get to the right channel. Regards, Stephen -

Re: [HACKERS] PostgreSQL on Novell Netware 6.5.

2003-10-24 Thread Eduardo D Piovesam
They stopped at 7.2.4 because "they're finishing some usefull APIs, which'll make the port much more"easy"."   When this part is done, a new port will be made with 7.4. With much less "NetWare specific code" and maybe, it'll be "accepted" by the PostgreSQL community.   Regards, Eduardo  

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Anthony W. Youngman
In article <[EMAIL PROTECTED]>, Lauri Pietarinen <[EMAIL PROTECTED]> writes >Anthony W. Youngman wrote: > >>Well, as far as we MV'ers are concerned, performance IS a problem with >>the relational approach. The attitude (as far as I can tell) with >>relational is to hide the actual DB implementation

[HACKERS] Complex/elaborate user-defined base types

2003-10-24 Thread Jean-Henry Berevoescu
Hi, I am trying to create complex user-defined base types and have some difficulties. I started with the examples (complex, point, path) and I had no problem at all creating similar user-defined types, with fixed or variable length. They perform very good in all my tests (inserts, selects and s

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Lauri Pietarinen
Bob Badour wrote: "Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Bob Badour wrote: "Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I could now denormalise OrderDetail so that it contains cust_id also and cluster by cust

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Anthony W. Youngman wrote: > > >In article <[EMAIL PROTECTED]>, Lauri Pietarinen > ><[EMAIL PROTECTED]> writes > > > > > >>So in your opinion, is the problem > >> > >>1) SQL is so hard that the average programmer will

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Lauri Pietarinen
Bob Badour wrote: "Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I could now denormalise OrderDetail so that it contains cust_id also and cluster by cust_id (might cause you trouble down the road, if you can change the customer of an order), in which case, with 3

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Lauri Pietarinen
Anthony W. Youngman wrote: In article <[EMAIL PROTECTED]>, Lauri Pietarinen <[EMAIL PROTECTED]> writes So in your opinion, is the problem 1) SQL is so hard that the average programmer will not know how to use it efficiently Nope or 2) Relational (or SQL-) DBMS'es are just too slow

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Bob Badour wrote: > > >"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message > >news:[EMAIL PROTECTED] > > > >>I could now denormalise OrderDetail so that it contains cust_id also > >>and cluster by cust_id > >>(migh

[HACKERS] Help!!! FreeSpaceMap hashtalble out of memory.

2003-10-24 Thread Yurgis Baykshtis
Cygwin, 7.3.4 This thing is really KILLING us and our customers. In pgerr.log this always go together: WARNING: ShmemAlloc: out of memory ERROR: FreeSpaceMap hashtable out of memory Theses errors usually take place on INSERT statements like this one: INSERT INTO params (param_id,map_id,param_

[HACKERS] Can't not load libpq.so.3

2003-10-24 Thread Fabien DAUMEN
I have install postgresql 7.3.4. I want to use C++ program to update my database. I link my program with this link option –L/usr/local/pgsql/lib. The program is linked, but when I run it. I have this problem My_program: error while loading shared libraries: libpq.so.3: cannot open share

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Anthony W. Youngman
In article <[EMAIL PROTECTED]>, Paul Vernon <[EMAIL PROTECTED]> writes >No, I think Anthony is just saying that he doesn't "believe" in science/the >scientific method. Or maybe he believes that engineering is not based on >scientific knowledge! Actually, I *DO* believe in the Scientific Method. I

Re: [HACKERS] 7.4 compatibility question

2003-10-24 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian writes: > > > If they _must_ be done the way you suggest, why have we been able to > > generate reliable release notes all these years? > > With all respect for your work and your enthusiasm for this approach, but > personally, I have absolutely no confiden

Re: [HACKERS] 7.4 compatibility question

2003-10-24 Thread Peter Eisentraut
Bruce Momjian writes: > If they _must_ be done the way you suggest, why have we been able to > generate reliable release notes all these years? With all respect for your work and your enthusiasm for this approach, but personally, I have absolutely no confidence that the release notes are complete

Re: [HACKERS] pg_ctl reports succes when start fails

2003-10-24 Thread Andrew Dunstan
Peter Eisentraut wrote: Tom Lane writes: I also wonder why -w isn't the default. Because it is not sufficiently reliable in start mode. See source code and archives. I think we can improve -w, though. Here's what the code says about the section where it tries to use psql to determine

Re: [HACKERS] 7.4 compatibility question

2003-10-24 Thread Bruce Momjian
Alvaro Herrera wrote: > On Fri, Oct 24, 2003 at 03:11:25PM +0200, Peter Eisentraut wrote: > > Peter Eisentraut writes: > > > > > Heck, ECPG has a full Informix compatibility mode and there is no > > > mention of that anywhere, because there was no commit "Add Informix > > > mode." > > I still won

Re: [HACKERS] 7.4 compatibility question

2003-10-24 Thread Bruce Momjian
Peter Eisentraut wrote: > Neil Conway writes: > > > So I think we could make the release notes more useful if we provided a > > bit more detail in each entry, and documented changes more extensively. > > We could also make better use of SGML, for example by adding s to > > the release notes where

Re: [HACKERS] Still a few flaws in configure's default CFLAGS selection

2003-10-24 Thread Bruce Momjian
Peter Eisentraut wrote: > Tom Lane writes: > > > What Peter was advocating in that thread was that we enable -g by > > default *when building with gcc*. I have no problem with that, since > > there is (allegedly) no performance penalty for -g with gcc. However, > > the actual present behavior of

Re: [HACKERS] 7.4 compatibility question

2003-10-24 Thread Alvaro Herrera
On Fri, Oct 24, 2003 at 03:11:25PM +0200, Peter Eisentraut wrote: > Peter Eisentraut writes: > > > Heck, ECPG has a full Informix compatibility mode and there is no > > mention of that anywhere, because there was no commit "Add Informix > > mode." I still wonder what "Informix compatibility mode"

Re: [HACKERS] 7.4 compatibility question

2003-10-24 Thread Peter Eisentraut
Peter Eisentraut writes: > Heck, ECPG has a full Informix compatibility mode and there is no > mention of that anywhere, because there was no commit "Add Informix > mode." Sorry, inconsistent spelling tripped me up on this one. But the theoretical point stands. -- Peter Eisentraut [EMAIL PRO

Re: [HACKERS] 7.4 compatibility question

2003-10-24 Thread Peter Eisentraut
Neil Conway writes: > So I think we could make the release notes more useful if we provided a > bit more detail in each entry, and documented changes more extensively. > We could also make better use of SGML, for example by adding s to > the release notes where applicable. I think we also need to

Re: [HACKERS] Still a few flaws in configure's default CFLAGS

2003-10-24 Thread Peter Eisentraut
Tom Lane writes: > What Peter was advocating in that thread was that we enable -g by > default *when building with gcc*. I have no problem with that, since > there is (allegedly) no performance penalty for -g with gcc. However, > the actual present behavior of our configure script is to default

Re: [HACKERS] pg_ctl reports succes when start fails

2003-10-24 Thread Peter Eisentraut
Tom Lane writes: > I also wonder why -w isn't the default. Because it is not sufficiently reliable in start mode. See source code and archives. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your frie