Sep 24 10:22:37 snafu postgres: LOG: database system was interrupted while in recovery at 2004-09-24 10:21:41 MST Sep 24 10:22:37 snafu postgres: ...

Cott Lang

09-24-2004 01:16 PM
Matthew T. O'Connor

Hi! I run pg_autovacuum: ../pg_autovacuum -D but then I cannot find pg_autovacuum.log file. Where shoud I look for it? Thank...

Iulia Pacurar

09-24-2004 10:59 AM
Matthew T. O'Connor

Its been almost a month now, since Beta2, and commit activity has quite busy, so we're aiming for Monday, September 28th, for Beta3. Starting with...

Marc G. Fournier

09-24-2004 10:35 AM
Dave Page

Hi, I am confused about an internal point of the planner. Consider a select query and the output target list at the root of the tree. This target...

Hicham G. Elmongui

09-24-2004 09:54 AM
Tom Lane

There's a bunch of very ugly code in backend/main/main.c that involves the preprocessor constants "NOFIXADE" and "NOPRINTADE". The code seems to be...

Neil Conway

09-24-2004 01:34 AM
Neil Conway

When I first log in to psql as a superuser, the first time I try to use lo_export (), I get a reference leak warning. This does not happen...

Casey Allen Shobe

09-24-2004 12:10 AM
Tom Lane

Folks, Just noticed -- the hard way -- that running ALTER TABLE ... SET STATISTICS requires a full table lock. I can't think of any practical...

Josh Berkus

09-23-2004 01:59 PM
Josh Berkus

Laszlo, src/C/pljava.h. The exception handling in versions prior to 8.0 is very rudimentary though. There's (as you already discovered) no way to...

Tom Lane

09-23-2004 06:10 AM
Thomas Hallgren

On Wed, 2004-09-22 at 15:29, James William Pye wrote: Patch applied with some additional fixes -- the patch as I applied it is attached....

Bruce Momjian

09-22-2004 07:30 PM
Neil Conway

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...

David Fetter

09-22-2004 12:19 PM
Robert Treat

Oleg, Absolutely. Provided the contrib modules are *new* for 8.0. -- Josh Berkus Aglio Database Solutions San Francisco

Josh Berkus

09-22-2004 11:03 AM
Josh Berkus

Hi all, I succesfull compiled postgres 8.0beta2 with a recent gcc 4.0 snapshot: gcc (GCC) 4.0.0 20040911 (experimental) Copyright (C) 2004 Free...

Gaetano Mendola

09-22-2004 10:06 AM
Gaetano Mendola

Dear developers, As I'm managing accounts for students... I noticed that there does not seem to be a proper way to keep a comment about a postgresql...

Fabien COELHO

09-22-2004 09:44 AM
Rod Taylor

I'm seeing an intermittent assertion failure while running "make check" with current sources. I can usually reproduce the problem at least once out...

Neil Conway

09-21-2004 11:01 PM
Tom Lane

Dear Hackers, I would like to implement and contribute two TODO items: "Have views on temporary tables exist in the temporary namespace" and "Allow...

Koju Iijima

09-21-2004 08:35 PM
Koju Iijima

Reposted, I did not see the mail come through... (Lists working ok?) Hi everybody, I have started testing PostgreSQL on windows. Now that I have...

Michael Paesold

09-21-2004 06:42 PM
Bruce Momjian

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...

Piyush Porwal

09-21-2004 01:51 PM
Peter Eisentraut

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...

D'Arcy J.M. Cain

09-21-2004 12:13 PM
D'Arcy J.M. Cain

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...

Sudhakar Kurumella

09-21-2004 11:27 AM
Sudhakar Kurumella

Hi there , i have this scenario : - postgresql 7.5 ( with modified heap_* functions to retrieve data from another dbms) - the tuple's data is...

Fx

09-21-2004 11:16 AM
Alvaro Herrera

That doesn't answer the question of why he isn't even asked for a password. cheers andrew Laszlo Hornyak wrote: ---------------------------(end...

Sudhakar Kurumella

09-21-2004 10:18 AM
Andrew Dunstan

Hi list, When I try to create a user using the "create user" SQL command, where the command is being executed using the PQexecParams function...

Shachar Shemesh

09-21-2004 01:55 AM
Shachar Shemesh

sorry my last mail went incomplete please read through this and ignore my last mail paraM ----- Forwarded by Paramveer Singh/Trilogy on 20/09/2004...

Paramveer.Singh@trilogy.com

09-20-2004 01:11 PM
Andrew Dunstan

Hi, I have recently downloaded, PostgreSql 8.0-beta2-dev3 windows version. I am a newbie to postgresql, i have one question, How can i import or...

Sudhakar Kurumella

09-20-2004 11:54 AM
Andrew Dunstan

On Fri, Sep 17, 2004 at 08:47:02AM +0200, Szima G?bor wrote: It sounds interesting to me (for use in libpqxx, the C++ API), but perhaps for a...

Jeroen T. Vermeulen

09-20-2004 07:41 AM
Andreas Pflug

hi! I apologize for mailing on the hackers list but I posted on the general list and did not get a good answer. I have two independent issues, but am...

Paramveer.Singh@trilogy.com

09-20-2004 06:26 AM
Paramveer.Singh@trilogy.com

Hi, I'm working on running postgresql in a chrooted filesystem. /src/backend/commands/dbcommands.c makes use of system(3): as far as I can see,...

Tom F

09-20-2004 03:42 AM
Andrew Dunstan

Developer docs have this (in SAVEPOINT command reference): "SQL requires a savepoint to be destroyed automatically when another savepoint with the...

Michael Paesold

09-19-2004 08:42 AM
Michael Paesold

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres (AT) cybertec (DOT) at> writes: You were never supposed to do that, although prior releases did...

Tom Lane

09-18-2004 10:13 AM
Tom Lane

Kind people, I'm writing up a pg_top. The first cut will be for 8.0, as it relies on (I know, I know) set-returning functions in plperlu. To make...

David Fetter

09-17-2004 05:46 PM
Tom Lane

Hi all, I'm having some problem with permissions on views, I spoke with Josh on IRC about it and I'm reposting it: I found a not simmetrical...

Gaetano Mendola

09-17-2004 05:25 PM
Gaetano Mendola

I have installed the latest config.guess and config.sub, which was supposed to be done at the start of beta. I have reviewed their changelog; there...

Peter Eisentraut

09-17-2004 05:11 PM
Peter Eisentraut

I don't understand what overlap_{left,right} are supposed to mean. In general what seems to be missing from the documentation of operator strategies...

Greg Stark

09-17-2004 04:51 PM
Tom Lane

Hello ! I've written a small description of the project I would like to work on, and since it involves Postgres , decided to ask for a feedback from...

Konstantin Besch

09-17-2004 10:46 AM
Mikhail Terekhov

Hi everybody, I have started testing PostgreSQL on windows. Now that I have managed to import a dump of one of our production databases to postgres...

Michael Paesold

09-17-2004 08:36 AM
Michael Paesold

Hi! I posted the following message to the general list but no answer.Could you please help? I have some problems with the SPI memory management (at...

Katsaros Kwn/nos

09-17-2004 03:50 AM
Katsaros Kwn/nos

We have discovered an interesting locking scenario with Slony-I that is pointing to a use for the ability to exclude certain schemas...

Chris Browne

09-16-2004 11:25 PM
Christopher Browne

I'd like to make it possible to perform function calls in PL/PgSQL without needing to use PERFORM. I think this would be useful because (a) it is...

Neil Conway

09-16-2004 10:37 PM
Tom Lane

In recognition of his role as lead developer on the internationalization front, as well as his invaluble work in both the build and...

Marc G. Fournier

09-16-2004 09:16 AM
Lamar Owen

Hello folks, I have an idea, to break pg_dump into functions within PostgreSQL. We currently have some functions like pg_get_viewdef, but it...

Mark Gibson

09-16-2004 08:54 AM
Mark Gibson

G'day, There seems to be a kind of statement parsing problem in 7.4.5 (from debian postgresql-7.4.5-3, i386). Either that, or I'm missing...

Chris Dunlop

09-15-2004 06:46 PM
Chris Dunlop

On an x86_64 machine I'm finding that I cannot configure --with-python without the attached patch. Undoubtedly there is a better way to fix this --...

Joe Conway

09-15-2004 06:07 PM
Peter Eisentraut

After looking over the state machine in xact.c, I'm thinking of removing the TBLOCK_SUBENDABORT_ALL and TBLOCK_SUBENDABORT_RELEASE states in favor of...

Tom Lane

09-15-2004 05:33 PM
Alvaro Herrera

Hi Simon, Sorry it has taken so long. Among other things, I doubled the controllers and drives on the system I was testing this on. But now I have...

Mark Wong

09-15-2004 05:16 PM
Mark Wong

$ psql template1 Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL...

G u i d o B a r o s i o

09-15-2004 11:48 AM
James William Pye

Didn't find a solution for this on the lists, and I am not a yet-brand-new-guru, so... I ask :) What about this? I've found a box (dual Intel(R)...

G u i d o B a r o s i o

09-15-2004 11:38 AM
Tom Lane

Some people have requested to add WIN1250 as an allowed server encoding. So far, the order of the encoding numbers determined which ones...

Peter Eisentraut

09-15-2004 11:28 AM
Peter Eisentraut

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, AFAIR there was a thread about "SELECT FOR UPDATE NOWAIT" availability in {7.5,8.0}, 7-8 months...

Devrim GUNDUZ

09-15-2004 08:24 AM
Bruce Momjian

I ran the postmaster under valgrind, and ran the regression tests ("make installcheck") against it. Curiously, this resulted in an...

Neil Conway

09-15-2004 06:49 AM
Neil Conway

Is select a transaction starting statement according to the the sql specification? In the specification (sql99) there is a list of things that are...

Dennis Bjorklund

09-15-2004 12:14 AM
Dennis Bjorklund