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
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
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
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 this
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 uses
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 happened to
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 (by
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-r-
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 certificates is
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
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
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 see
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
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
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.
Bruce Momjian pgman@candle.pha.pa.us 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
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 you
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
www.codeproject.com.
|
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 beta2.
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 */
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
28 matches
Mail list logo
