Michael Fuhr <[EMAIL PROTECTED]> writes:
> CREATE TABLE foo (x integer);
> EXPLAIN
> SELECT CASE x = 1 WHEN true THEN 1 ELSE 0 END AS y
> FROM foo
> ORDER BY y;
Fixed, but this is a bit too late for 8.1.1. Meanwhile the easy way to
avoid the bug is to write the CASE in a less obtuse form, like
"wangshj" <[EMAIL PROTECTED]> wrote
>
> oidtest=# COPY oidtest (name) WITH OIDS FROM stdin;
> Enter data to be copied followed by a newline.
> End with a backslash and a period on a line by itself.
>>> 54513copyname
>>> \.
> oidtest=# INSERT INTO oidtest ( name ) VALUES( 'name2' ) ;
> INSE
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Sat, Dec 10, 2005 at 12:57:13PM -0500, Tom Lane wrote:
>> Could you provide a self-contained test case, please?
> Here's a test case:
Thanks, I'll fix this ... but I'm not certain it is the same problem the
OP is seeing. The OR join clauses he's got
On Sat, Dec 10, 2005 at 12:57:13PM -0500, Tom Lane wrote:
> "" <[EMAIL PROTECTED]> writes:
> > Description:EXPLAIN ANALYZE with SELECT query causes a single
> > backend server process to segfault
>
> Could you provide a self-contained test case, please?
Here's a test case:
CREATE TABLE f
On Fri, Dec 09, 2005 at 18:09:52 +,
alejandro ramirez <[EMAIL PROTECTED]> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2105
> Logged by: alejandro ramirez
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: PostgreSQL 8.1.
> Operating syste
"" <[EMAIL PROTECTED]> writes:
> Description:EXPLAIN ANALYZE with SELECT query causes a single
> backend server process to segfault
Could you provide a self-contained test case, please? Guessing at your
table schemas does not seem a productive use of time. See
http://www.postgresql.org/d
The following bug has been logged online:
Bug reference: 2105
Logged by: alejandro ramirez
Email address: [EMAIL PROTECTED]
PostgreSQL version: PostgreSQL 8.1.
Operating system: windows 2000 profesional
Description:ERROR: relation "comoma" does not exist
Details:
H
The following bug has been logged online:
Bug reference: 2106
Logged by:
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0, 8.2devel
Operating system: CentOS 4.2 with 2.6.13.4-SMP kernel
Description:EXPLAIN ANALYZE with SELECT query causes a single
backend s
Hi Tom,
Unfortunately, I had to rebuild the database pretty quickly
to get the app it supports back up,
and I wiped out the log files.
The postmaster would dump core on startup - so I
just wiped the database, and recreated the schema
(my app can rebuild its state).
I didn't save the core file eit
