Re: aaagh... postgres is segfaulting? -- fix

From: Richard Huxton <dev(at)archonet(dot)com>
To: Joshua Moore-Oliva <josh(at)chatgris(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: aaagh... postgres is segfaulting? -- fix
Date: 2003-04-09 13:35:13
Message-ID: 200304091435.13058.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 09 Apr 2003 12:25 pm, Joshua Moore-Oliva wrote:
> I needed to apply this... for some reason when I do timetamp related
> queries without executing that a segfault occurs.
>
> UPDATE pg_proc SET prorettype = 1114 WHERE prosrc = 'timestamptz_izone';

Hmm - mine reads 1186 (interval). Two questions:

1. Did you notice what value it had before?
2. Have you made the same change in template0/1 (and what values did they
have)?

Actually, a third question: how did you ever figure that out?

--
Richard Huxton

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Pradier 2003-04-09 13:38:28 Re: Error: heap_mark4update: (am)invalid tid
Previous Message Richard Huxton 2003-04-09 11:39:14 Re: aaagh... postgres is segfaulting?