Oh, I remembered another of my personal feature requests for 8.2 :D
* Fix planning and execution of set operations so that they're not
tragically slow. eg. rewriting into outer joins, etc.
Chris
---(end of broadcast)---
TIP 1: if posting/readin
Hello,
I have the following question about the Postgres optimizer.
I have two functions:
CREATE OR REPLACE FUNCTION test_func(float, OUT a bigint, OUT b bigint)
RETURNS record AS 'select test_func1($1)[1],test_func1($1)[2]
'LANGUAGE SQL IMMUTABLE;
and
CREATE OR REPLACE FUNCTION test_func1
Am Freitag, 26. August 2005 01:13 schrieb Alvaro Herrera:
> Or, slightly different, what are people's most wanted features?
For entertainment, here is a summary the most requested features:
1. MERGE command
2. Table partitioning
2. Materialized views
2. Updatable views
5. Index-organized tabl
Ilya Kovalenko posted some code at in a thread starting at
http://archives.postgresql.org/pgsql-hackers/2005-04/msg00417.php
which lead to the TODO item:
* Allow INET + INT4 to increment the host part of the address, or
throw an error on overflow
I think that the naively coded function atta
On Mon, Sep 05, 2005 at 01:52:45AM +0200, Petr Jelinek wrote:
> Tom Lane wrote:
> >
> >The hole in that argument is the assumption that there *is* a freely
> >available library that can be used (where freely == BSD license).
> >We wouldn't be having this discussion if we knew of one.
>
> I see thi
Patrick Welche <[EMAIL PROTECTED]> writes:
> * Allow INET + INT4 to increment the host part of the address, or
> throw an error on overflow
> I think that the naively coded function attached does what is needed, e.g.,
What happened to the IPv6 case? Also, I think you need to reject CIDR
inputs
Hi,
I tried sending this mail to pgadmin, but nobody could find a solution
to my problem. So I changed my problem into a suggestion and I was
hoping I am at the right place for it here :-)
Original Message
Subject: Postgres using SSL connections
Date: Thu, 25 Aug 2005 20:27:18 +
> Oliver Jowett wrote:
> > 8.1-beta1 produces some odd results with statement logging enabled when
> > the extended query protocol is used (e.g. when using the JDBC driver).
> > Repeatedly running a simple query with log_statement = 'all' produces this:
...
> > Secondly, running a query that use
On Mon, Sep 05, 2005 at 03:02:55PM -0400, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > * Allow INET + INT4 to increment the host part of the address, or
> > throw an error on overflow
>
> > I think that the naively coded function attached does what is needed, e.g.,
>
> What
Simon de Hartog <[EMAIL PROTECTED]> writes:
> I have added all the users these applications run as to a group called
> "ssl". Permissions on the private key are owned by root, group ssl,
> protection rw-r- (640). When I tell PostgreSQL to use this key with
> certificate (by using symlinks from
Chris Traylor <[EMAIL PROTECTED]> writes:
> 1.) Is anyone else currently working on this?
No, and AFAIR no one has ever even asked for it. I'm a little dubious
about doubling the storage requirements for geometry data and likely
creating backwards-compatibility issues to implement a feature that
On Mon, Sep 05, 2005 at 09:03:06PM +0200, Simon de Hartog wrote:
> I have added all the users these applications run as to a group called
> "ssl". Permissions on the private key are owned by root, group ssl,
> protection rw-r- (640). When I tell PostgreSQL to use this key with
> certificate (b
On Mon, Sep 05, 2005 at 03:27:01PM -0400, Alvaro Herrera wrote:
> On Mon, Sep 05, 2005 at 09:03:06PM +0200, Simon de Hartog wrote:
>
> > I have added all the users these applications run as to a group called
> > "ssl". Permissions on the private key are owned by root, group ssl,
> > protection rw-
Simon Riggs <[EMAIL PROTECTED]> writes:
> + /*
> + * If we re-issue an Execute protocol request against an existing
> + * portal, then we are only fetching more rows rather than
> + * completely re-executing the query from the start
> + */
> + if (!portal->atEnd)
> +
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Mon, Sep 05, 2005 at 09:03:06PM +0200, Simon de Hartog wrote:
>> How can I use this certificate and key for PostgreSQL (without copying
>> the key and changing owner and permissions etc, because then the whole
>> idea of centrally coordinated certific
On Mon, 2005-09-05 at 15:27 -0400, Tom Lane wrote:
Chris Traylor <[EMAIL PROTECTED]> writes:
> 1.) Is anyone else currently working on this?
No, and AFAIR no one has ever even asked for it. I'm a little dubious
about doubling the storage requirements for geometry data and likely
creating ba
Well, it was pointed out the other day that the Darwin C library
supports the non-standard extensions to the POSIX locale interface and
that this might be ported to other systems so PostgreSQL could use it.
So, I have written a few scripts which download the libc and locale
library from darwinsour
Simon Riggs wrote:
> Subsequent calls to the same portal are described as FETCHes rather than
> as EXECUTEs. The portal name is still given and number of rows is
> provided also.
I wonder if it might be better to only log the first Execute.. It's not
immediately clear to me that it's useful to se
I've committed changes to implement the cut-down form of this proposal:
http://archives.postgresql.org/pgsql-hackers/2005-08/msg01185.php
discussed here:
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00138.php
Barring further changes, we'll have a hard-wired template list for 8.1
and a r
Beta1 has gone very well so far. There have been very few bug reports,
though I know that many people are testing it because it is mentioned on
our home page. I know Tom is working on a patch for procedural
languages, but other than that, there are not many other open issues.
Perhaps we should s
Chris Traylor <[EMAIL PROTECTED]> writes:
> On Mon, 2005-09-05 at 15:27 -0400, Tom Lane wrote:
>> I'd suggest keeping these as separate private types rather
>> than expecting that a patch to replace the 2D types will be accepted.
> What do you think about making it a configure option, i.e.
> --ena
Bruce Momjian writes:
> Perhaps we should start thinking about Beta2.
There are some open items with roles and triggers that would be nice
to fix first, but I agree beta2 should be soon. End of the week or so,
maybe?
regards, tom lane
---(end o
On Mon, 2005-09-05 at 20:40 -0400, Tom Lane wrote:
Chris Traylor <[EMAIL PROTECTED]> writes:
> On Mon, 2005-09-05 at 15:27 -0400, Tom Lane wrote:
>> I'd suggest keeping these as separate private types rather
>> than expecting that a patch to replace the 2D types will be accepted.
> What do y
You usually post a list of Open Items during Beta ... other then that, end
of the week sounds cool to me ...
On Mon, 5 Sep 2005, Bruce Momjian wrote:
Beta1 has gone very well so far. There have been very few bug reports,
though I know that many people are testing it because it is mentioned
""Merlin Moncure"" <[EMAIL PROTECTED]> wrote
> > > > And I think VC++ 6.0 is ok, it is power enough and not so big for
> > pgsql's
> > > development. And latter versions of VC++ can automatically convert
> > 6.0's
> > > project files. There are also a "VC++7 to VC++6 project converter"
> on
> > > w
"Bruce Momjian" wrote
>> William ZHANG wrote:
> > - Original Message -
> > > From: "Dave Page"
> > > To: "Andrew Dunstan" <[EMAIL PROTECTED]>; "William ZHANG"
<[EMAIL PROTECTED]>
> > > Cc:
> > > Sent: Thursday, September 01, 2005 3:21 PM
> > > Subject: RE: [HACKERS] Call for 7.5 featur
On Tue, Sep 06, 2005 at 12:23:59AM -0300, Marc G. Fournier wrote:
>
> You usually post a list of Open Items during Beta ... other then that, end
> of the week sounds cool to me ...
One important item on that list is "add documentation for autovacuum."
I'll try to come up with something before be
Tom Lane wrote:
If you want to be listed, let me know. What I need to know to list you
is values for this table:
typedef struct
{
char *lanname; /* PL name */
boollantrusted; /* trusted? */
char *lanhandler; /* name of handler function */
ch
Hello can any one tell me how can I add a new cloumn in pg_class
Currently I am doing : In pg_class.h * In CATALOG(pg_class) BOOTSTRAP define the variable [var-name] * define a variable for [var-name] as #define Anum_pg_class_[var-name] [value] * And pass default value to DATA macro fo
29 matches
Mail list logo
