-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Mar 17, 2008 at 01:23:46PM -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
Tom Lane wrote:
The idea that's becoming attractive to me while contemplating the
multiple-maps problem is that we should adopt something similar to
Am Dienstag, 18. März 2008 schrieb Dave Page:
On Mon, Mar 17, 2008 at 7:44 PM, Peter Eisentraut [EMAIL PROTECTED]
wrote:
Log Message:
---
Enable probes to work with Mac OS X Leopard and other OSes that will
support DTrace in the future.
Switch from using DTRACE_PROBEn
Tom Lane [EMAIL PROTECTED] writes:
Stephen Denne [EMAIL PROTECTED] writes:
However I'm not after a fast count(*) from table, but more like a fast
select grouping_id, count(*) from my_table group by grouping_id
You could apply the same technique across each group id, though this
On Tue, Mar 18, 2008 at 9:40 AM, Peter Eisentraut [EMAIL PROTECTED] wrote:
Do we need some support in the buildfarm to create the header file?
The Windows/MSVC build system needs some adjustments. I have no idea how it
works, but I'd be glad to explain the details to someone who does.
On Mon, Mar 17, 2008 at 7:44 PM, Peter Eisentraut [EMAIL PROTECTED] wrote:
Log Message:
---
Enable probes to work with Mac OS X Leopard and other OSes that will
support DTrace in the future.
Switch from using DTRACE_PROBEn macros to the dynamically generated macros.
Use dtrace
On Tue, Mar 18, 2008 at 11:48 AM, Peter Eisentraut [EMAIL PROTECTED] wrote:
Am Dienstag, 18. März 2008 schrieb Dave Page:
I was actually thinking of the OS X buildfarm member I setup to
exercise this. From your description it sounded like we need to
generate the probe header manually if
Hi.
Yesterday I downloaded source code from CVS following
developer.postgresql.org/docs/postgres/cvs.html
First of all it had problems downloading files, INSTALL text file has not
been downloaded, for example.
Today that web page isn't even available...
That's probably causing the problems I'm
Am Dienstag, 18. März 2008 schrieb Dave Page:
I was actually thinking of the OS X buildfarm member I setup to
exercise this. From your description it sounded like we need to
generate the probe header manually if we enable dtrace.
Nope.
--
Sent via pgsql-hackers mailing list
How about always adding the TID as last key when using qsort for
create
index ?
I think you misunderstood: that's what we do now. I'm proposing
removing it because I think it's probably useless.
Ah, sorry, I did not look at the code, and interpreted your comment as
some exceptional
Dave Page wrote:
Shouldn't there have been a doc patch with this as well? Last time I
read the docs they said only Solaris supports dtrace.
Well, it won't support anything else until somebody tries debugs it ;-)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
Manolo SupaMA escribió:
Hi.
Yesterday I downloaded source code from CVS following
developer.postgresql.org/docs/postgres/cvs.html
First of all it had problems downloading files, INSTALL text file has not
been downloaded, for example.
Today that web page isn't even available...
That
On Fri, Mar 7, 2008 at 9:40 PM, Bruce Momjian [EMAIL PROTECTED] wrote:
I assume don't want a TODO for this? (Suppress UPDATE no changed
columns)
I am starting to implement this. Do we want to have this trigger function in
the server, or in an external module?
Best regards,
Hi,
I want to create a custom function/query (using the C API?) that
collates records from a record set (takes multiple records as input)
and produces a set of records (returns multiple records).
The Postgres docs only give examples of how to create a custom
function that returns multiple
Gurjeet Singh wrote:
On Fri, Mar 7, 2008 at 9:40 PM, Bruce Momjian [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
I assume don't want a TODO for this? (Suppress UPDATE no changed
columns)
I am starting to implement this. Do we want to have this trigger
function in the
Alvaro Herrera [EMAIL PROTECTED] writes:
Dave Page wrote:
Shouldn't there have been a doc patch with this as well? Last time I
read the docs they said only Solaris supports dtrace.
Well, it won't support anything else until somebody tries debugs it ;-)
Well, I've got Leopard here, I'd be
Am Dienstag, 18. März 2008 schrieb Tom Lane:
Well, I've got Leopard here, I'd be happy to test it ... but the patch
has rendered
http://developer.postgresql.org/pgdocs/postgres/dynamic-trace.html
into a pack of lies quite independently of which OSes are supported,
so I'm not very sure what to
On Tue, Mar 18, 2008 at 7:46 PM, Andrew Dunstan [EMAIL PROTECTED] wrote:
Gurjeet Singh wrote:
On Fri, Mar 7, 2008 at 9:40 PM, Bruce Momjian [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
I assume don't want a TODO for this? (Suppress UPDATE no changed
columns)
I am pleased to report that the recently released flex 2.5.35 generates
code for our .l files that produces no gcc warnings whatsoever.
This is a first :-(, at least for versions of flex without any
downstream patches.
regards, tom lane
--
Sent via pgsql-hackers mailing
On Tue, 18 Mar 2008, Manolo SupaMA wrote:
Yesterday I downloaded source code from CVS following
developer.postgresql.org/docs/postgres/cvs.html
There is another tutorial that's got a lot more detail than this one at
http://wiki.postgresql.org/wiki/Working_with_CVS which uses rsync to make
KaiGai,
NSA and SUN announces a new project launched which tries to port FLASK
security architecture, it is named as FMAC.
It can be a good candidate to host multilevel database security.
(SELinux is also based on FLASK security architecture.)
SEBSD project is also known. It is a poring of
Josh,
I'm interested in selectivity functions for FTS, proposed by Jan Urbaski.
In case there will be no available mentors for him, I'd work with him.
Oleg
On Thu, 28 Feb 2008, Josh Berkus wrote:
Hackers,
Over the last 2 years, Google Summer of Code has been responsible for=20
several new
Oleg Bartunov wrote:
Josh,
I'm interested in selectivity functions for FTS, proposed by Jan Urbaski.
In case there will be no available mentors for him, I'd work with him.
Oleg
Thanks! Today I'll post a more detailed plan on -hackers explaining how
I think I could approach the problem.
Oleg Bartunov wrote:
Josh,
I'm interested in selectivity functions for FTS, proposed by Jan Urbaski.
In case there will be no available mentors for him, I'd work with him.
Oleg
Thanks! Today I'll post a more detailed plan on -hackers explaining how
I think I could approach the problem.
On Tue, 18 Mar 2008, Jan Urbaski wrote:
Oleg Bartunov wrote:
Josh,
I'm interested in selectivity functions for FTS, proposed by Jan Urbaski.
In case there will be no available mentors for him, I'd work with him.
Oleg
Thanks! Today I'll post a more detailed plan on -hackers explaining how I
Oleg Bartunov wrote:
On Tue, 18 Mar 2008, Jan Urbaski wrote:
Oleg Bartunov wrote:
Josh,
I'm interested in selectivity functions for FTS, proposed by Jan
Urbaski.
In case there will be no available mentors for him, I'd work with him.
Oleg
Thanks! Today I'll post a more detailed plan on
Jan,
Oleg, should I contact you personally to consult the application that
I'm going to submit through the Google web app, or should I just send it
to Google when the gates open and wait for the results?
Submit it to Google. We have the ability to update submissions if they need
to be
Peter Eisentraut wrote:
Log Message:
---
Don't need -Wno-error anymore, because flex is no longer producing warnings.
I see this patch only affects ecpg? Is this related to Tom's report
from trying the new flex? Are we assuming that all CVS build people
also have the new flex? Is
Am Dienstag, 18. März 2008 schrieb Tom Lane:
I am pleased to report that the recently released flex 2.5.35 generates
code for our .l files that produces no gcc warnings whatsoever.
This is a first :-(, at least for versions of flex without any
downstream patches.
Oh excellent! Now we can
Am Dienstag, 18. März 2008 schrieb Bruce Momjian:
Peter Eisentraut wrote:
Log Message:
---
Don't need -Wno-error anymore, because flex is no longer producing
warnings.
I see this patch only affects ecpg? Is this related to Tom's report
from trying the new flex?
Yes. There
Added to TODO:
* Consider not storing a NULL bitmap on disk if all the NULLs are
trailing
http://archives.postgresql.org/pgsql-hackers/2007-12/msg00624.php
http://archives.postgresql.org/pgsql-patches/2007-12/msg00109.php
Tom's comments are:
Am Dienstag, 18. März 2008 schrieb Tom Lane:
Or we could apply Peter's patch more or less as-is, but I don't like
that. I don't think it solves the stated problem: if you know that CASE
branches 3 and 5 don't match, that still doesn't help you in a monster
query with lots of CASEs. I think
Hi,
I am trying to create a kind of simple procedural language for PostgreSQL.
The first version was compiled with MinGW/gcc for PostgreSQL 8.2.6 and it
worked OK.
When PostgreSQL 8.3.0 was shipped, I tried to recompile all my code for this
version, but it
didn't work (almost every
Peter Eisentraut wrote:
Well, yes. I meant to say, a build system that can supply the functionality
of Gen_fmgrtab can surely implement this new thing. I see there is Perl
being used, so it should be simple.
I was thinking of using a Perl script to generate the dummy header file
but
Peter Eisentraut wrote:
Am Dienstag, 18. März 2008 schrieb Tom Lane:
Well, I've got Leopard here, I'd be happy to test it ... but the patch
has rendered
http://developer.postgresql.org/pgdocs/postgres/dynamic-trace.html
into a pack of lies quite independently of which OSes are supported,
so
Robert Lor wrote:
Peter Eisentraut wrote:
Well, yes. I meant to say, a build system that can supply the
functionality of Gen_fmgrtab can surely implement this new thing. I
see there is Perl being used, so it should be simple.
I was thinking of using a Perl script to generate the dummy
Zdenek Kotala schrieb:
Regarding to discussion about large segment size of table files a test
pathconf function (see
http://www.opengroup.org/onlinepubs/009695399/functions/pathconf.html).
You can see output there:
_PC_FILESIZEBITS - 3rd column
_PC_LINK_MAX - 4th column
_PC_NAME_MAX - 5th
Andrew Dunstan [EMAIL PROTECTED] writes:
Robert Lor wrote:
I was thinking of using a Perl script to generate the dummy header
file but decided against it to avoid disrupting the build on other
platforms. If sed doesn't work on Windows for some reason, we can use
a Perl script instead.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 18 Mar 2008 18:14:32 -0400
Tom Lane [EMAIL PROTECTED] wrote:
Perl is required for all MSVC builds, and for all builds from CVS
on any platform too, IIRC, so it's a fairly safe bet for any tool
you provide.
The key phrase in that is
Peter Eisentraut [EMAIL PROTECTED] writes:
I think it is reasonable to assume that those wanting to use -Werror should
use the new flex, because if they don't the build will fail anyway, at any of
the other lexers.
It's been true for quite a long time that only ecpg's lexer generated
any
Give the discussion on this. Is this small patch being considered for
inclusion? If not, what do I need to change to make it acceptable?
Thanks,
wt
On Sun, Mar 9, 2008 at 1:32 AM, Warren Turkal [EMAIL PROTECTED] wrote:
PosgreSQL hackers,
Here's an initial bit of my attempt at cleaning up the
I did checking of current head. There is some problems
test boolean ... ok
test char ... FAILED
test name ... ok
test varchar ... FAILED
test text ... ok
test int2 ... ok
test int4 ... ok
Joshua D. Drake wrote:
At some point, do we recognize that Perl is installed on every
reasonable platform in existence or can be easily? I mean, we already
require autoconf/make etc... What is adding Perl in practice?
For one thing, a moving target. If we rely on standard Unix tools, we have
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 19 Mar 2008 00:07:09 +0100
Peter Eisentraut [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
At some point, do we recognize that Perl is installed on every
reasonable platform in existence or can be easily? I mean, we
already require
I have commited a change to src/tools/find_typedef that should allow it
to run under Linux. The only difference I see is that some unused
typedefs do not appear in the Linux version.
---
Alvaro Herrera wrote:
Bruce
Bruce Momjian wrote:
I have commited a change to src/tools/find_typedef that should allow it
to run under Linux. The only difference I see is that some unused
typedefs do not appear in the Linux version.
However, I think pgindent only cares about the typedef references, not
the definitions,
(Sorry for the repeat email Tom, I forgot the cc's)
Tom Lane wrote:
Stephen Denne [EMAIL PROTECTED] writes:
I initially thought that what you meant by having
transactions enter delta entries was that I have a trigger
that would create a row each time it was called, writing how
many
I am not seeing a problem here. Can you show use regression.diff?
---
Pavel Stehule wrote:
I did checking of current head. There is some problems
test boolean ... ok
test char ... FAILED
lo_import_with_oid added.
Note that actually committed function signature is:
Oid lo_import_with_oid(PGconn *conn, const char *filename, Oid lobjId);
--
Tatsuo Ishii
SRA OSS, Inc. Japan
I have posted proposed patches to pgsql-patches.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
I would like to
Peter Eisentraut [EMAIL PROTECTED] writes:
Joshua D. Drake wrote:
What is adding Perl in practice?
For one thing, a moving target.
Well, if we were that afraid of Perl version discrepancies, we shouldn't
be using it at all anywhere. My point was just that we should not add
a new build tool
OK, here's a more detailed description of the FTS selectivity
improvement idea:
=== Write a typanalyze function for column type tsvector
The function would go through the tuples returned by the BlockSampler
and compute the number of times each distinct lexeme appears inside the
Hi hackers,
I'm novice in PostgreSQL codebase (and in English too :-)), but I'd be
glad to make a modest contribution to this great project.
By viewing this list, I see a lot of discussions on the problem of
fast count (*), but acceptable decision have not been formulated.
Well, I make
Is there anything I can do to help?
wt
On Tue, Mar 18, 2008 at 7:49 PM, Tom Lane [EMAIL PROTECTED] wrote:
Warren Turkal [EMAIL PROTECTED] writes:
Give the discussion on this. Is this small patch being considered for
inclusion? If not, what do I need to change to make it acceptable?
Tom Lane wrote
Stephen Denne [EMAIL PROTECTED] writes:
What I was asking about with those questions, is if a
single row is inserted in transaction A, and updated 1000
times still within transaction A, then transaction A
commits... does a single row version get written, or 1001,
1000
Stephen Denne [EMAIL PROTECTED] writes:
Tom Lane wrote
Umm ... AFAICS there is no need for an UPDATE to touch the count table
at all. You'd only need ON INSERT and ON DELETE triggers.
I'm not referring to updates of my base table... the single row inserted was
referring to the delta row...
Stephen Denne [EMAIL PROTECTED] writes:
What I was asking about with those questions, is if a single row is inserted
in transaction A, and updated 1000 times still within transaction A, then
transaction A commits... does a single row version get written, or 1001, 1000
of which are
Warren Turkal [EMAIL PROTECTED] writes:
Give the discussion on this. Is this small patch being considered for
inclusion? If not, what do I need to change to make it acceptable?
It's in the to-do queue for the current commit fest. The queue is kinda
long however :-(
Simon Riggs [EMAIL PROTECTED] writes:
It may surprise you but I didn't read Tom's words as being against
Simon's approach. Personally I read them as a generic warning, which I
agreed with. Maybe Tom can straighten that out.
AFAIR, I just said that I'd find it hard to trust any complex
Tom Lane wrote:
Stephen Denne [EMAIL PROTECTED] writes:
What I was asking about with those questions, is if a single row is inserted in
transaction A, and updated 1000 times still within transaction A, then
transaction A commits... does a single row version get written, or 1001, 1000
of
For easier reviewing, the most fundamental patch to implement PGACE (PostgreSQL
Access Control Extension) was separated into thress parts.
I want to start discussion about PGACE security framework at first.
Any comments are welcome.
[1/3] PGACE core features
59 matches
Mail list logo