Gavin,
> > c) any company which sponsored a major add-on which was significantly
> > improved/created in the last year.
>
> What would you say falls under this category?
Slony-I courtesy of Afilias
Command Prompt's PL/PHP
as examples.
--
Josh Berkus
Aglio Database Solutions
San Francisco
-
On Tue, 2004-09-21 at 17:13, Neil Conway wrote:
> Should this be documented in the installation instructions?
I think so.
I figure just a mention should be enough.
(Also add some productname tags around 'Python'.)
--
Regards,
James William Pye
Index: installation.sgml
==
Neil Conway <[EMAIL PROTECTED]> writes:
> On Fri, 2004-09-17 at 01:43, Tom Lane wrote:
>> PS: this points up once again that the regression tests do not do very
>> well at testing concurrent behavior. We need to think about some sort
>> of parallel-test harness that would let us write tests that h
Kind people,
I've figured out something that many others probably have, but I
thought I'd put it out there anyhow.
As PL/PgSQL doesn't allow assignment of singleton SELECTs and dynamic
queries to variables, as mentioned in the docs.
Here's a working hack that gets around this.
DECLARE foo_rec R
On Wed, 22 Sep 2004, Neil Conway wrote:
> On Fri, 2004-09-17 at 01:43, Tom Lane wrote:
> > PS: this points up once again that the regression tests do not do very
> > well at testing concurrent behavior. We need to think about some sort
> > of parallel-test harness that would let us write tests th
Dear Hackers,
(B
(BI would like to implement and contribute two TODO items:
(B"Have views on temporary tables exist in the temporary namespace" and
(B"Allow temporary views on non-temporary tables".
(B
(BI would like to discuss several points with community.
(B
(B*Synopsis
(B
(BCREATE [ O
On Fri, 2004-09-17 at 01:43, Tom Lane wrote:
> PS: this points up once again that the regression tests do not do very
> well at testing concurrent behavior. We need to think about some sort
> of parallel-test harness that would let us write tests that have better
> odds of catching bugs like this.
On Wed, 2004-09-22 at 00:16, Bruce Momjian wrote:
> So distutils is now required to build python? If that is intended, I
> will just skip building python. I didn't realize we had new
> requirements for python, but that is fine.
Should this be documented in the installation instructions?
-Neil
On Tue, 21 Sep 2004, Josh Berkus wrote:
> c) any company which sponsored a major add-on which was significantly
> improved/created in the last year.
What would you say falls under this category?
Gavin
---(end of broadcast)---
TIP 6: Have you searc
Alvaro Herrera wrote:
> On Tue, Sep 21, 2004 at 10:22:57AM -0400, Bruce Momjian wrote:
>
> > Added to open items list:
> >
> > * adjust bgwriter defaults, allow disabling
>
> Now that the oid2name patch has been applied, you can remove the
> oid2name item from the open items list.
Done.
>
Folks,
We will be listing some of the companies who made major contributions to
PostgreSQL 8.0 in the press release. I'd like to make sure I don't leave
anyone out just because I don't know about them. What we're covering is:
a) any company that under-wrote a feature for 8.0 (such as Fujitsu
Piyush Porwal wrote:
> I am trying to implement Compression/Decompression techniques in
> PostgreSQL, I am not able to figure out where and how to integrate
> it. Did anybody worked on it.
Compression already happens automatically. There is nothing left to do
on the storage side.
--
Peter Eise
Tom Lane wrote:
[EMAIL PROTECTED] (Dominic Mitchell) writes:
On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote:
Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass
in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT
On Tue, 21 Sep 2004 11:00:33 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes:
> > I had previously mentioned that queries run much different depending
> > on whether a VACUUM ANALYZE is done or just a plain ANALYZE.
>
> The problem appears to be that it's
hello
I am a student of MTech at IIT Bombay, India.
I am trying to implement Compression/Decompression techniques in
PostgreSQL, I am not able to figure out where and how to integrate it.
Did anybody worked on it.
Please help me !!
--
~~
Piyush Porwal
CSE - Mtech1
IIT Bomabay
On Tue, Sep 21, 2004 at 01:00:18PM -0300, Fx wrote:
> I tried to do this using the heap_modifytuple function , and
> returning a "newSlot with a newTuple" instead the "resultSlot" but as
> i suppose im missing something , can anyone help me ? or give me a
> clue
You need to provide more in
Joe Conway <[EMAIL PROTECTED]> writes:
> Bruce Momjian wrote:
>> So distutils is now required to build python?
> Yes, the python docs imply that it is a reasonable expectation.
FWIW, CVS tip still builds --with-python on my pretty-nearly-stock
RHL 8.0 box, so distutils was standard a couple years
Dear Andrew,
Thanks a LOT!!
It is working:
[D:\]psql -U postgres sosWelcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execut
try
host all all 127.0.0.1/32 trust
restart the server, then try to connect.
Sudhakar Kurumella wrote:
Is there any alternative for me ?...Any suggestinons would be highly
appreciated.
thanks,
kuru
*/Andrew Dunstan <[EMAIL PROTECTED]>/* wrote:
The "local" line has no effect on Windows - it
Is there any alternative for me ?...Any suggestinons would be highly appreciated.
thanks,
kuruAndrew Dunstan <[EMAIL PROTECTED]> wrote:
The "local" line has no effect on Windows - it only has relevance for Unix domain socket connections, which Windows does not support.The line that affects local
-- Forwarded message --
From: Fx <[EMAIL PROTECTED]>
Date: Mon, 20 Sep 2004 14:32:09 -0300
Subject: How to change/replace an in-memory palloced tuple- tuple data
To: [EMAIL PROTECTED]
Hi there ,
i have this scenario :
- postgresql 7.5 ( with modified heap_* functions
On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
> Dear Laszlo,
>
> Indeed that is tough, It is highly appreciated if you could explain a bit in detail.
> I tried with option "password no need" in my server, and also tried remove md5 from
> pg_hba.conf :
>
> # TYPE DATABASEUSERCIDR-
The "local" line has no effect on Windows - it only has relevance for
Unix domain socket connections, which Windows does not support.
The line that affects local connections on Windows is "host all all
127.0.0.1/32 ..."
(We really need to make that crystal clear in the pg_hba.conf ...)
cheers
a
Bruce Momjian wrote:
So distutils is now required to build python? If that is intended, I
will just skip building python. I didn't realize we had new
requirements for python, but that is fine.
Yes, the python docs imply that it is a reasonable expectation. Here's a
snippet from the thread a week
That doesn't answer the question of why he isn't even asked for a password.
cheers
andrew
Laszlo Hornyak wrote:
You could enable local connections with no password, then connect with
your postgres user, change pwd, and then re-enable security.
use pg_ctl reload for reloading security settings.
Not
Dear Laszlo,
Indeed that is tough, It is highly appreciated if you could explain a bit in detail. I tried with option "password no need" in my server, and also tried remove md5 from pg_hba.conf :
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all postgres
On Tue, Sep 21, 2004 at 10:22:57AM -0400, Bruce Momjian wrote:
> Added to open items list:
>
> * adjust bgwriter defaults, allow disabling
Now that the oid2name patch has been applied, you can remove the
oid2name item from the open items list.
Additionaly, there's a patch in the patch que
You could enable local connections with no password, then connect with
your postgres user, change pwd, and then re-enable security.
use pg_ctl reload for reloading security settings.
Not nice, but quick :)
On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
> I am trying to connect to database call
"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes:
> I had previously mentioned that queries run much different depending on
> whether a VACUUM ANALYZE is done or just a plain ANALYZE.
The problem appears to be that it's picking the wrong index to use for
the second part of the query (the certrans_act
Added to open items list:
* adjust bgwriter defaults, allow disabling
---
Tom Lane wrote:
> "Michael Paesold" <[EMAIL PROTECTED]> writes:
> > Setting the delay to the same value as checkpoint_timeout would effectiv
I am trying to connect to database called "sos", i tried as you said:
[D:\]psql -U postgres template1psql: FATAL: Password authentication failed for user "postgres"
[D:\]psql -U postgres -W template1psql: FATAL: Password authentication failed for user "postgres"
[D:\]
I got the above error ag
Gaetano Mendola wrote:
> Bruce Momjian wrote:
> > I get this failure on current CVS running configure --with-python:
> >
> > checking for python... /usr/local/bin/python
> > checking for Python distutils module... no
> > configure: error: distutils module not found
> > gmake: *
[EMAIL PROTECTED] (Dominic Mitchell) writes:
> On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote:
>> Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
>>> In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass
>>> in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT fla
Which database are you trying to connect to?
try:
psql -U postgres template1
or
psql -U postgres -W template1
and see what happens
cheers
andrew
Sudhakar Kurumella wrote:
I tried that, the error is the same but with user "postgres"
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres
psql: FATAL:
"Michael Paesold" <[EMAIL PROTECTED]> writes:
> Setting the delay to the same value as checkpoint_timeout would effectivly
> disable bgwriter between checkpoints. This is what I wanted.
> The problem is that this is currently not possible, since bgwriter_delay has
> an upper limit of 5 seconds. Tom
On Tue, Sep 21, 2004 at 10:35:56AM +0100, Dominic Mitchell wrote:
> I think it's misleading to talk about SSL being supported without these
> options. I've used SSL in other places (apache/mod_ssl, curl, stunnel)
> and I came to expect this sort of verification as standard behaviour.
> What's mor
Laszlo Hornyak <[EMAIL PROTECTED]> writes:
> I am implementing a java language handler. If unrecoverable error occurs,
> it needs to send a signal to the java process, so it can stop the
> execution of the stored procedure, otherwise it would stay in inconsystent
> state.
Well, an elog callback is
I tried that, the error is the same but with user "postgres"
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgrespsql: FATAL: Password authentication failed for user "postgres"
It is not taking my password if i give option with "-W" as well.
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres -
Use psql -U postgres
Dave
On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
> Hi,
>
> I am using postgresql windows based "8.0-beta2-dev3". I have provided
> default user and password while installing. When i am trying to
> connecto to psql through dos command prompt, i am getting following
[I sent this 24 hours ago and it hasn't shown up yet. I may have used
the wrong address. If not apologies for the dup.]
I had previously mentioned that queries run much different depending on
whether a VACUUM ANALYZE is done or just a plain ANALYZE. At the time I
was told that that couldn't be
Hi,
I am using postgresql windows based "8.0-beta2-dev3". I have provided default user and password while installing. When i am trying to connecto to psql through dos command prompt, i am getting following error:
[D:\Postgresql\8.0-beta2-dev3\bin]psqlpsql: FATAL: Password authentication failed
Bruce Momjian wrote:
I get this failure on current CVS running configure --with-python:
checking for python... /usr/local/bin/python
checking for Python distutils module... no
configure: error: distutils module not found
gmake: *** [config.status] Error 1
I
Harald Fuchs wrote:
The first problem with this approach is that it requires libpq to be all
things to all people. We've already had some discussion in this thread
about the tension between supporting application programs written in C,
which want one set of features, and drivers, which need some o
Bruce Momjian wrote:
> I get this failure on current CVS running configure --with-python:
>
>checking for python... /usr/local/bin/python
>checking for Python distutils module... no
>configure: error: distutils module not found
>gmake: *** [config.status] Error 1
>
> I have pyth
In article <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> writes:
> David Wheeler <[EMAIL PROTECTED]> writes:
>> On Sep 20, 2004, at 12:34 AM, Bruce Momjian wrote:
>>> I think we should favor libpq usage wherever possible and only
>>> re-implement it in the native language when required, like f
On Tue, Sep 21, 2004 at 10:44:22AM +0200, Kaare Rasmussen wrote:
> > I think verification of the server certificates is not supported either.
> > SSL only serves for encryption, not authentication or integrity checking
> > (which is probably a stupid idea).
>
> I have this feeling that SSL in Pos
On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote:
> Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
> > I am also unsure of the
> > procedures for submitting patches; is it ok to just send to hackers?
>
> [EMAIL PROTECTED]
Thanks, I'll send it along there.
> > I
Bruce Momjian wrote:
> What about the original request to turn off the bgwriter? Would setting
> the delay to a very high value do that?
Setting the delay to the same value as checkpoint_timeout would effectivly
disable bgwriter between checkpoints. This is what I wanted.
The problem is that thi
Hi
> I think verification of the server certificates is not supported either.
> SSL only serves for encryption, not authentication or integrity checking
> (which is probably a stupid idea).
I have this feeling that SSL in PostgreSQL isn't category 1 supported if you
can put it that way. Maybe I
Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
> I am also unsure of the
> procedures for submitting patches; is it ok to just send to hackers?
[EMAIL PROTECTED]
> In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass
> in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT fl
I've just spent a while this afternoon attempting to get SSL support
working. It appears to be lacking in a few areas, foremost
documentation. I've got a patch filling in the missing pieces for the
server side, but I am unsure where I should document the client side
bits (~/.postgresql/root.crt a
51 matches
Mail list logo