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
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 to
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 xrefs to
the release notes where applicable. I think we also need to
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
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 xrefs to
the release notes where
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 wonder what Informix
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
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,
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 confidence that
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 just
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
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
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
(might cause you trouble down
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
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
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_id
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 not know how to use
it
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
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 from the
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
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
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.
I've
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 implementation
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|
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:
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
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
All
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 their port
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 \
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
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
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
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]
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:
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 test
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 test
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
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]
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
'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
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!
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?) military jargon).
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, please
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
file is
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
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 I want to print a statement
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
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
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 to my
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.
...
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
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
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:
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;
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
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(2.5); returns
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
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
The convention
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 specific
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:
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
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 test
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 port
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 True64
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 the
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)
Ackkk. I
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
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 test
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
esac
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;; # alpha has
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
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
[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 ...
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 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:
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.
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 at:
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 with
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
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.
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
the
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
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: axiomatic
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
84 matches
Mail list logo