-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 cod
> 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
command
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 à 22
> You probably want to build a GiST index, check the docs.
>
> Have a nice day,
> --
> Martijn van Oosterhout 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 everytime Window
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 SQL
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 Tsuna
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 dr
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
> bet
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 add
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 val
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 no
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 wo
"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 broa
"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
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...
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 mus
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 pr
"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.
> I
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 p
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
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 releas
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 wh
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 in
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 p
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 aut
[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 th
> 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
se
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 func
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 th
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 fr
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 regre
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 gon
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 e
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 has
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 l
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 wo
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 it
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-fre
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
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 y
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 arithm
42 matches
Mail list logo