Hi, We have been getting this error "cache lookup failed for relation: oid" on unpredictable intervals. (our situation uses functions that use temp...

Frank Miverk

04-04-2007 01:59 PM
Frank Miverk

I am trying to restore a dump from 7.4.1 to 8.0. I am using the pg_dump in 8.0 to dump the database. I am getting the following error message. I...

Prasanth

01-25-2005 04:05 AM
Rafal Pietrak

Hi All, This is the first time I tried to use Postgres object inheritance... and it failed for me! I do: CREATE TABLE a (id serial, into text,...

Rafal Pietrak

01-23-2005 12:26 PM
Rafal Pietrak

David Schweikert <dws (AT) ee (DOT) ethz.ch> writes: I'm not entirely convinced this is a bug. I get the right answer from regression=# select...

Tom Lane

11-23-2004 10:21 AM
David Schweikert

Folks, Two possible bugs. #1 Loading unicode data. #2 Doing count of data based on substring(1,1) of a col. -------------------------- #1 Loading...

David B

11-23-2004 09:14 AM
Tom Lane

The following bug has been logged online: Bug reference: 1320 Logged by: Simon Riggs Email address: simon (AT) 2ndquadrant (DOT)...

PostgreSQL Bugs List

11-23-2004 03:02 AM
Devrim GUNDUZ

On occasion, it seems the psql history file gets truncated. Unable to replicate, it just seems to happen every now and then. .......

John Hansen

11-22-2004 06:39 PM
Peter Eisentraut

This is my third attempt at posting to the list ... hopefully it will make it this time ---------- Forwarded message ---------- Date: Mon, 22 Nov...

Nicola Pero

11-22-2004 03:56 PM
Michael Fuhr

The following bug has been logged online: Bug reference: 1327 Logged by: yychen Email address: yychen (AT) mail (DOT)...

PostgreSQL Bugs List

11-22-2004 06:50 AM
PostgreSQL Bugs List

I've been experiencing data corruption/loss in Postgresql 7.4.2. I tracked this down to altering tables. After I alter a table, I get data loss...

Nicola Pero

11-21-2004 10:34 PM
Nicola Pero

I've found another plperl bug in the most recent CVS sources (see end of message for file versions). Sorry if this is a known issue but I don't...

Michael Fuhr

11-21-2004 02:32 AM
Michael Fuhr

Your name : Aaron Hillegass Your email address : aaron (AT) bignerdranch (DOT) com System Configuration --------------------- Architecture...

Aaron Hillegass

11-20-2004 01:22 PM
Aaron Hillegass

The following bug has been logged online: Bug reference: 1326 Logged by: Fernando Kasten Peinado Email address: fernandopeinado...

PostgreSQL Bugs List

11-19-2004 09:52 AM
Richard Huxton

The following function: create function text_to_words(text) returns setof text as $_$ my %stopwords = ( 'i' => 'i','me' => 'me','my' =>...

John Hansen

11-18-2004 10:55 PM
Michael Fuhr

hi, I created this table: CREATE TABLE public.stresslog( "AbfrageId" int8 NOT NULL...

Cao Duy

11-18-2004 09:22 AM
Michael Fuhr

The following bug has been logged online: Bug reference: 1325 Logged by: gregory Email address: gperuch (AT) citer (DOT)...

PostgreSQL Bugs List

11-18-2004 08:18 AM
Stephan Szabo

Karl, This isn't isolated to the "public" schema. In fact, anything which is in the template database (usually template1) will be in the...

Josh Berkus

11-17-2004 09:17 PM
Bruno Wolff III

Michael Fuhr <mike (AT) fuhr (DOT) org> writes: Yeah, I know. I had just done that in the slight hope that more warnings would pinpoint the error. ...

Tom Lane

11-17-2004 08:08 PM
Michael Fuhr

John Hansen <john (AT) geeknet (DOT) com.au> writes: Works fine for me. What encoding/locale are you using? regards, tom...

Tom Lane

11-17-2004 03:58 PM
Tom Lane

P: Um, did you run configure before running gmake? Please post: 1) How you obtained 8.0b4 and in in what format. 2) what platform you are on, and...

Josh Berkus

11-17-2004 01:34 PM
Josh Berkus

The following bug has been logged online: Bug reference: 1324 Logged by: Tzvetan Tzankov Email address: tzankov (AT) noxis (DOT)...

PostgreSQL Bugs List

11-17-2004 09:44 AM
Tom Lane

Peter Eisentraut <peter_e (AT) gmx (DOT) net> writes: OK, so the problem case is where perl was built with a different compiler than we're...

David Walker

11-16-2004 11:24 PM
Tom Lane

I've run across a bug with order by: select 1 as a order by a; -- works select 1 as a, 2 as b order by a; -- works select 1 as a, 2 as b order by...

Jeffrey Melloy

11-16-2004 11:14 PM
Tom Lane

The following bug has been logged online: Bug reference: 1321 Logged by: T.J. Ferraro Email address: tjtoocool (AT) phreaker...

PostgreSQL Bugs List

11-16-2004 10:05 PM
Neil Conway

Hi, Went to upgrade from postgresql (RedHat's postgresql rh-postgresql-7.3.6-7) to Fedora core 3 postgresql 7.4.6-1 and encountered a problem. If...

Karl O. Pinc

11-16-2004 05:05 PM
Karl O. Pinc

Hi, Went to upgrade from postgresql (RedHat's postgresql rh-postgresql-7.3.6-7) to Fedora core 3 postgresql 7.4.6-1 and encountered a problem. If...

Karl O. Pinc

11-16-2004 04:29 PM
Tom Lane

Stefanos Harhalakis <v13 (AT) priest (DOT) com> writes: Changing the order of the tests wouldn't change the message, though, 'cause there's just one...

Tom Lane

11-16-2004 02:43 PM
Stefanos Harhalakis

The following bug has been logged online: Bug reference: 1323 Logged by: Sandro Votre Email address: sandro_votre (AT) ig (DOT)...

PostgreSQL Bugs List

11-16-2004 10:36 AM
PostgreSQL Bugs List

Greetings. I am very new to PostgreSQL so apologies in advance if this bug report is a waste of time for some reason. Summary: I have been...

John Kennedy

11-16-2004 10:35 AM
Tom Lane

The following bug has been logged online: Bug reference: 1322 Logged by: Bahadur Singh Email address: bahadursingh (AT) yahoo...

PostgreSQL Bugs List

11-16-2004 09:18 AM
Tom Lane

On Fri, 12 Nov 2004 13:28:02 +0100, franciscojavier.solis (AT) sainsel (DOT) abengoa.com wrote: this has been replaced with cygserver make sure the...

Klint Gore

11-15-2004 11:47 PM
Klint Gore

This one gave me grief also. The fix turns out to be pretty simple. libeay32.dll is located in System32 and can be installed by any number...

Tillman

11-15-2004 04:44 PM
Tillman

The following bug has been logged online: Bug reference: 1319 Logged by: Tom O'Connell Email address: toconnell (AT) bphnx (DOT)...

PostgreSQL Bugs List

11-15-2004 10:03 AM
PostgreSQL Bugs List

The following bug has been logged online: Bug reference: 1312 Logged by: Amie Email address: amien (AT) freightdynamics (DOT)...

PostgreSQL Bugs List

11-15-2004 07:06 AM
Roland

The following bug has been logged online: Bug reference: 1318 Logged by: christian kindler Email address: christian.kindler (AT)...

PostgreSQL Bugs List

11-15-2004 06:15 AM
PostgreSQL Bugs List

Dear Sir/Madam: I encounter some error while trying to build postgresql-8.0.0beta4. When I run gmake, it reports that some macros used in path.c are...

p_zyh@sohu.com

11-15-2004 12:37 AM
p_zyh@sohu.com

Hmm. it installs just fine on my XP Pro (SP2) with Finnish locale. What does the log show for these issues? (It's in the PGDATA directory, in the...

Magnus Hagander

11-14-2004 07:12 AM
Magnus Hagander

On Tue, 9 Nov 2004, Abaco informática s.a. wrote: Yes, because PostgreSQL adds defined behavior for such queries beyond that of the spec for...

Stephan Szabo

11-13-2004 03:41 PM
Stephan Szabo

On Sat, 13 Nov 2004 04:05 pm, Tom Lane wrote: I had discussed with Neil if this should be implement and proposed I have a go at it. I have since...

Russell Smith

11-13-2004 04:47 AM
Russell Smith

The following bug has been logged online: Bug reference: 1317 Logged by: Tom Katt Email address: tonny (AT) yahoo (DOT)...

PostgreSQL Bugs List

11-12-2004 01:57 PM
Peter Eisentraut

The following bug has been logged online: Bug reference: 1316 Logged by: Hongyi Gao Email address: admin (AT) listfusion (DOT)...

PostgreSQL Bugs List

11-12-2004 11:19 AM
Tom Lane

Dear debuggers, I'd like to report the following "strange" behavior that I encountered while trying (a bad idea, I know) to use a rule as a "poor...

Fabien COELHO

11-12-2004 10:57 AM
Fabien COELHO

As been said, in 7.4.5 CIDR data type has been accepted values with non-zero bits to the right of >24-bit...

Alexander M. Pravking

11-12-2004 10:49 AM
Alexander M. Pravking

The following bug has been logged online: Bug reference: 1313 Logged by: Pascal Pochet Email address: postgresql (AT)...

PostgreSQL Bugs List

11-12-2004 10:42 AM
Joe Conway

The following bug has been logged online: Bug reference: 1315 Logged by: CN Email address: cnliou9 (AT) fastmail (DOT)...

PostgreSQL Bugs List

11-11-2004 07:16 PM
Tatsuo Ishii

Andrea, Well, we actually roped in the pg_locks view to do a "SELECT the first row not already locked for update". Then added some code on the...

Josh Berkus

11-11-2004 05:42 PM
Andrea Suisani

The following bug has been logged online: Bug reference: 1314 Logged by: Adnan DURSUN Email address: adursun (AT) hvkk (DOT)...

PostgreSQL Bugs List

11-11-2004 04:53 PM
Tom Lane

I've got a particular database account that connects/disconnects hundreds of times a second, literally (email delivery agent). Being the ever ready...

Sean Chittenden

11-10-2004 08:24 PM
Bruce Momjian

Hello All Both server and psql are 7.4.5 and both running linux. I have a table with a primary key as follow -------- Column | Type ...

zohn_ming wu

11-10-2004 06:26 PM
Tom Lane

If, by some quirk of fate, you manage to delete the logical link to a tablespace in pg_tblspc, then you try to access a table in that tablespace, you...

Simon Riggs

11-10-2004 03:34 PM
Simon Riggs