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
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
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
"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
""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
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
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
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
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
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
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
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
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
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
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
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)
> +
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-
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
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
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
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
> 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
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 +
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
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
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
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
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
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
29 matches
Mail list logo