Bruce Momjian writes:
> Why don't we just spin through all 255 locale values, and find the
> lowest value that is greater than comparison target.
The issue is not that the 255 extended ASCII characters have a different
ordering in various locales (although that's part of it). The real
problem l
>We have to assign PGSEMMAGIC small enough to ensure that it won't fall
>foul of SEMVMX, but that probably isn't a big problem. A more serious
>potential portability issue is that some implementations might not
>support the semctl(GETPID) operation (ie, get PID of last process that
>did a semop()
I've a problem with initdb on beos with the current tree. (The last one
running clean is one month old).
when I run initdb, I get the following :
$ initdb -d -n
Running with debug mode on.
Running with noclean mode on. Mistakes will not be cleaned up.
Initdb variables:
PGDATA=/boot/
[Cced to hackers list]
Jan,
I have checked in the fixes you suggested. Thanks for the advice.
--
Tatsuo Ishii
> > I tried this new feature in PostgreSQL. I found one bug.
> > Script UCS_to_8859.pl skips input lines which
> > 1. code <0x80 or
> > 2. ucs <0x100
> >
> > I think second one is not
> > Someone ought to backpatch to REL_7_0_PATCHES, as it's syslog also
> > looks bad...
>
> Not sure if we will have a 7.0.4, and I can't see it as a major bug
> problem anyway.
Thinking about 7.0.3 has a new option to enable syslog, we might have
more often complaints from users than before, no
Hi,
can anyone tell me when Postgresql 7.1 will be released?
thanks,
XuYifeng
Larry Rosenman writes:
> The output doesn't show the --with-includes directive directories
> ANYWHERE in the make output :-(
Fixed
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The real
> problem lies with multi-character collating elements, context dependent
> collation order, multi-pass sorting algorithms, etc. I'm almost convinced
> that it is not possible to do any such optimization as we had for the most
> general case
On Sun, 26 Nov 2000, Alain Toussaint wrote:
> > "I have all sorts of client apps, connecting in different ways, to
> > my server. Some of the clients are leaving their connections open,
> > but unused. How can I prevent running out of backends, and boot
> > the inactive users off?"
>
> how abou
On Sun, 26 Nov 2000, xuyifeng wrote:
> Hi,
>
> can anyone tell me when Postgresql 7.1 will be released?
about a month after it goes beta ... which should be over the next couple
of weeks ...
Larry Rosenman writes:
> > Fixed
> nope. Still dies in the same place in the same way. The configure
> input I gave was:
>
> ./configure --prefix=/home/ler/pg-test --enable-syslog \
> --with-CXX --with-perl --enable-multibyte --enable-cassert \
> --with-openssl \
> --with-inc
> The core problem is: given a string "foo", find a string "fop" that
> is greater than any possible extension "foobar" of "foo". We need
> not find the least such string (else it would indeed be a hard
> problem), just a reasonably close upper bound. The algorithm we have
> in 7.0.* increments
Tom Lane <[EMAIL PROTECTED]> writes:
> Also, since "LC_COLLATE=en_US" seems to misbehave rather spectacularly
> on recent RedHat releases, I propose that initdb change "en_US" to "C"
> if it finds that setting.
It does not misbehave in glibc (it's not Red Hat specific).
Basically, glibc is the
[EMAIL PROTECTED] (Trond Eivind GlomsrØd) writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > Also, since "LC_COLLATE=en_US" seems to misbehave rather spectacularly
> > on recent RedHat releases, I propose that initdb change "en_US" to "C"
> > if it finds that setting.
>
> It does not misbeh
* Peter Eisentraut <[EMAIL PROTECTED]> [001126 14:30]:
> Larry Rosenman writes:
>
> > > Fixed
> > nope. Still dies in the same place in the same way. The configure
> > input I gave was:
> >
> > ./configure --prefix=/home/ler/pg-test --enable-syslog \
> > --with-CXX --with-perl --enable-mul
Looks like what I would have done if I knew C.
The only issue remaining is a policy issue as to if psql should call an
editor in /tmp at all, considering the issues raised bye the recent joe
vulnerability, ie can we trust the editor not to do a crazy thing, like
not creating a similarly predictab
* Peter Eisentraut <[EMAIL PROTECTED]> [001126 12:16]:
> Larry Rosenman writes:
>
> > The output doesn't show the --with-includes directive directories
> > ANYWHERE in the make output :-(
>
> Fixed
nope. Still dies in the same place in the same way. The configure
input I gave was:
./configure
In terms of making constraints more declarative, I think it would be neat to
add an extra field to pg_relcheck that is a foreign key (or null) into the
pg_attribute table.
That way, it would be possible to recover column CHECK constraints. If the
field is NULL, you'd assume it was a table CHECK
Cyril VELTER <[EMAIL PROTECTED]> writes:
> FATAL 2: InitReopen(logfile 0 seg 0) failed: No such file or directory
Does BeOS not support link(2) ?
See XLogFileInit() in src/backend/access/transam/xlog.c.
regards, tom lane
I'm wondering about the intent of this snippet in xlog.c:
fd = BasicOpenFile(tpath, O_RDWR | O_CREAT | O_EXCL | PG_BINARY, S_IRUSR |
S_IWUSR);
if (fd < 0)
elog(STOP, "InitCreate(logfile %u seg %u) failed: %m",
logId, logSeg);
if (lseek(fd, XLogSegSize - 1, SEEK_
Don Baccus wrote:
> At 12:07 AM 11/26/00 -0500, Alain Toussaint wrote:
> >how about having a middle man between apache (or aolserver or any other
> >clients...) and PosgreSQL ??
> >that middleman could be configured to have 16 persistant connections,every
> >clients would deal with the middleman i
Tom Samplonius wrote:
> On Sun, 26 Nov 2000, Alain Toussaint wrote:
> > > "I have all sorts of client apps, connecting in different ways, to
> > > my server. Some of the clients are leaving their connections open,
> > > but unused. How can I prevent running out of backends, and boot
> > > the inac
Michael Ansley <[EMAIL PROTECTED]> writes:
> Remember also that the GiST library has been integrated into PG, (my brother
> is doing some thesis workon that at the moment),
Yeah? Does it still work?
Since the GIST code is not tested by any standard regress test, and is
so poorly documented that
It seems that your code is exactly what I want.
I have already created geographical objects which contains MBR(Minimum
Bounding Rectangle) in their structure, so it is a question of rewriting
your code to change the access to the cube structure to the MBR structure
inside my geoobject. (cf http:/
Title: RE: [HACKERS] Indexing for geographic objects?
Hi,
Remember also that the GiST library has been integrated into PG, (my brother is doing some thesis workon that at the moment), and you can create new index types relatively quickly (assuming that you understand the indexing theory ;-)
I'm also interested in GiST and would be happy if somebody could provide
workable example. I have an idea to use GiST indices for our fulltextsearch
system.
Regards,
Oleg
On Sun, 26 Nov 2000, Michael Ansley wrote:
> Date: Sun, 26 Nov 2000 11:34:16 -
> From: M
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
>
> I'm also interested in GiST and would be happy if somebody could provide
> workable example. I have an idea to use GiST indices for our fulltextsearch
> system.
>
I have recently replied to Franck Martin in regards to this indexing
question, but I di
27 matches
Mail list logo
