-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, Jan 16, 2007 at 07:15:58PM +0100, Martijn van Oosterhout wrote:
On Tue, Jan 16, 2007 at 06:04:07PM +0100, Enrico wrote:
Hi,
I written an index to improve similarity search like images search, string
search etc...
My index code is
BTW: what happens on Windows if we're trying to do the equivalent
of rm -rf database-dir and someone is holding open one of the
files
in the directory? Or has the directory itself open for readdir()?
For the first definity and I think for the second, when doing it from the
commandline,
Ok it works, but we have to write a plpgsql function that takes the
table_name and the constraint name in parameters
It could be useful to have a : ALTER TABLE ... DISABLE CONSTRAINT ...
(as oracle does)
it could be good to add this to the TODO LIST...
Thanks
Le mardi 16 janvier 2007 à
You probably want to build a GiST index, check the docs.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
Many thanks
--
If Bill Gates had a penny for
There are two select statement with using Function chr(0), I don't know, are
they both right ? I think that they are inconsistent.
Thanks
[EMAIL PROTECTED] ~]$ psql
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with
Hello, Stefan-san
tom is talking about the postgresql distributed buildfarm:
http://buildfarm.postgresql.org/cgi-bin/show_status.pl
Thank you for telling me. This is a great system, isn't it?
- Original Message -
From: Stefan Kaltenbrunner [EMAIL PROTECTED]
To: Takayuki Tsunakawa
Hi,
Maybe added more further things to TODO list. Enabled / disabled other
objects like view/funtion. imagine a lot of views that referances a table and i
wanna drop a column on this table that used by these views. Postgres doesnt
allow this. First i must drop these views then
Am Mittwoch, 17. Januar 2007 08:54 schrieb Guillaume Lelarge:
It seems to me that the latest french .po files in pgtranslation are not
used in the 8.2.1 release and I wonder why.
Because those making the release failed to actually follow the release
procedure.
How do you synchronize
Hello All,
When I compile with gcc on Solaris with -m64 flags, all shared lbiraries fail.
Can someone fix the following in Makefile.shlib
ifeq ($(PORTNAME), solaris)
ifeq ($(GCC), yes)
LINK.shared = $(CC) -shared
else
LINK.shared = $(CC) -G $(CFLAGS)# CFLAGS
Wang Haiyong wrote:
There are two select statement with using Function chr(0), I don't know, are
they both right ? I think that they are inconsistent.
Off the top of my head I would have thought there was a good case for
raising an error on chr(0). Aren't null bytes forbidden in text
Tom Lane wrote:
Takayuki Tsunakawa [EMAIL PROTECTED] writes:
Still, I don't understand well why config files need to be placed
outside the data directory, except for daring conform to FHS.
The killer argument for it is that most of what is in $PGDATA should be
excluded from your
Andrew Dunstan [EMAIL PROTECTED] writes:
Off the top of my head I would have thought there was a good case for
raising an error on chr(0). Aren't null bytes forbidden in text values?
They're not supported, but we don't make any strenuous efforts to
prevent them. A watertight prohibition would
Jignesh K. Shah [EMAIL PROTECTED] writes:
It should be
LINK.shared = $(COMPILER) -shared
Why? What's the difference, and why is it appropriate to fix it that
way instead of by changing CFLAGS?
regards, tom lane
---(end of
Magnus Hagander [EMAIL PROTECTED] writes:
BTW: what happens on Windows if we're trying to do the equivalent
of rm -rf database-dir and someone is holding open one of the
files in the directory? Or has the directory itself open for readdir()?
For the first definity and I think for the second,
Hubert FONGARNAND wrote:
Ok it works, but we have to write a plpgsql function that takes the
table_name and the constraint name in parameters
It could be useful to have a : ALTER TABLE ... DISABLE CONSTRAINT ...
(as oracle does)
it could be good to add this to the TODO LIST...
Well,
Adnan DURSUN wrote:
Hi, Maybe added more further things to TODO list. Enabled /
disabled other objects like view/funtion. imagine a lot of
views that referances a table and i wanna drop a column on this
table that used by these views. Postgres doesnt allow this.
First i must
simple if I use -m64 for 64 bit then all end binaries are generated 64-bit and the shared libraries
are generated 32-bit and the compilation fails (ONLY ON SOLARIS) since that particular line is only
for the condition Solaris AND gcc.
If I use the COMPILER which is CC + CFLAGS it passes -m64
Jignesh K. Shah [EMAIL PROTECTED] writes:
simple if I use -m64 for 64 bit then all end binaries are generated 64-bit
and the shared libraries
are generated 32-bit and the compilation fails (ONLY ON SOLARIS) since that
particular line is only
for the condition Solaris AND gcc.
If I use
On Wed, 2007-01-17 at 08:51 +0100, Stefan Kaltenbrunner wrote:
this seems to require an alternative regression output file on windows
Hmm, right. Easiest fix seems to be just removing the platform-dependent
output from the regression test, since it wasn't necessary -- committed
to CVS HEAD. (I
Am Mittwoch, 17. Januar 2007 17:12 schrieb Tom Lane:
Jignesh K. Shah [EMAIL PROTECTED] writes:
simple if I use -m64 for 64 bit then all end binaries are generated
64-bit and the shared libraries are generated 32-bit and the compilation
fails (ONLY ON SOLARIS) since that particular line is
Peter Eisentraut a ecrit le 17/01/2007 10:16:
Am Mittwoch, 17. Januar 2007 08:54 schrieb Guillaume Lelarge:
It seems to me that the latest french .po files in pgtranslation are not
used in the 8.2.1 release and I wonder why.
Because those making the release failed to actually follow the
I tried that but it didn't work.
Also on Solaris it typically uses the ld in /usr/ccs/bin/ld which uses -64 as its flag for 64 bit
and if you put LDFLAGS out there it will fail as unrecognized unless gcc parses -64 to -m64.
Putting -m64 in CC will do the workaround but then I guess that's
Hello again Tom,
We have our upgrade to 8.2.1 scheduled for this weekend, and we noticed
your message regarding the vacuum patch being applied to 8.2 and
back-patched. I expect I know the answer to this next question :) but I
was wondering if the patch referenced below has also been bundled
Neil Conway wrote:
On Wed, 2007-01-17 at 08:51 +0100, Stefan Kaltenbrunner wrote:
this seems to require an alternative regression output file on windows
Hmm, right. Easiest fix seems to be just removing the platform-dependent
output from the regression test, since it wasn't necessary --
Takayuki Tsunakawa wrote:
Hello, Stefan-san
tom is talking about the postgresql distributed buildfarm:
http://buildfarm.postgresql.org/cgi-bin/show_status.pl
Thank you for telling me. This is a great system, isn't it?
yeah the buildfarm plays an important role in the development process
Matthew T. O'Connor wrote:
Alvaro Herrera wrote:
I'd like to hear other people's opinions on Darcy Buskermolen proposal
to have a log table, on which we'd register what did we run, at what
time, how long did it last, [...]
I think most people would just be happy if we could get autovacuum
[EMAIL PROTECTED] wrote:
On 1/12/07, Andrew Dunstan [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
What do you think about setting up the buildfarm clients
with the users they are willing to test patches for, as opposed to
having the patch system track who is are trusted users? My
Checkpoint command here reported an error yesterday. If Tom-san's
patch is effective, it should not fail and no messages are put in the
event log.
I can confirm that the latest set of patches from Tom as in anoncvs now
fixes this. Checkpoint command succeeds and no error is logged on the
Tom Lane wrote:
BTW, I'm thinking that a cost constant probably ought to be measured
in units of cpu_operator_cost. The default for built-in functions would
thus be 1, at least till such time as someone wants to refine the
estimates. We'd probably want the default for PL and SQL functions
Ron Mayer [EMAIL PROTECTED] writes:
Tom Lane wrote:
BTW, I'm thinking that a cost constant probably ought to be measured
in units of cpu_operator_cost.
Any chance that costs could eventually change to real-world units?
Define real world units.
If you like you can try to adjust things so
Attached is some material from an updated src/backend/optimizer/README
that describes the optimization principles that the EquivalenceClass
rewrite is depending on. Can anyone see any holes in the logic?
I'm particularly interested in the discussion of allowing
EquivalenceClasses to be deduced
Stefan Kaltenbrunner wrote:
Neil Conway wrote:
On Wed, 2007-01-17 at 08:51 +0100, Stefan Kaltenbrunner wrote:
this seems to require an alternative regression output file on windows
Hmm, right. Easiest fix seems to be just removing the platform-dependent
output from the regression test,
On Wed, 17 Jan 2007, Tom Lane wrote:
strict. However, we also allow equivalence clauses that appear below the
nullable side of an outer join to form EquivalenceClasses; for these
classes, the interpretation is that either all the values are equal, or
all (except pseudo-constants) have gone
On Mon, 2007-01-15 at 13:54 -0500, Neil Conway wrote:
On Mon, 2007-01-15 at 10:51 -0800, Richard Troy wrote:
I therefore propose that the engine evaluate -
benchmark, if you will - all functions as they are ingested, or
vacuum-like at some later date (when valid data for testing may exist),
Gavin Sherry [EMAIL PROTECTED] writes:
I was thinking about this, but in relation to hash joins. A hash join
cannot be guaranteed to produce output sorted according to the pathkey of
the outer relation (as explained in the existing README). I wonder,
however, if it might be useful for hash
Jeff Davis [EMAIL PROTECTED] writes:
Would any form of cost estimate have meaning if the function has side
effects? If it's a volatile function, doesn't that mean that the planner
can't avoid or favor executing it?
No, not really. If the function is down inside a sub-select or
something like
On Wed, 17 Jan 2007, Tom Lane wrote:
Gavin Sherry [EMAIL PROTECTED] writes:
I was thinking about this, but in relation to hash joins. A hash join
cannot be guaranteed to produce output sorted according to the pathkey of
the outer relation (as explained in the existing README). I wonder,
From: Tom Lane [EMAIL PROTECTED]
It's still not 100% bulletproof, because it's possible that some
other
backend is holding an open file in the database as a consequence of
having had to dump some shared buffer for itself, but that should be
pretty darn rare if the bgwriter is getting its job
Tom,
Is this a fix for security hole/vulnerability?
One of our engineer claimed that double free bug itself is a
vulnerability, thus 8.2.1 release should be called as security
release.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
Log Message:
---
Fix failure due to accessing an already-freed
On 1/17/07, Andrew Dunstan [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
On 1/12/07, Andrew Dunstan [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
What do you think about setting up the buildfarm clients
with the users they are willing to test patches for, as opposed to
having the
From: Andrew Dunstan [EMAIL PROTECTED]
Meeting FHS requirements is no bad thing, though. And the ability to
include a common configuration set in multiple instances is surely
useful to a number of people. After all, you aren't forced to use
these
facilities - I typically don't.
Thank you,
On 12/27/2006 01:15 PM, Tom Lane wrote:
I'm not convinced that you're fixing things so much as doing your best
to destroy IEEE-compliant float arithmetic behavior.
I think what we should probably consider is removing CheckFloat4Val
and CheckFloat8Val altogether, and just letting the float
42 matches
Mail list logo