Skip site navigation (1) Skip section navigation (2)

Port Bug Report: Postgres backend crashes on certain CREATE VIEW

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: Postgres backend crashes on certain CREATE VIEW
Date: 1999-03-12 18:46:49
Message-ID: 199903121846.NAA33413@hub.org (view raw or flat)
Thread:
Lists: pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		: David Secret
Your email address	: secret(at)kearneydev(dot)com

Category		: runtime: back-end
Severity		: serious

Summary: Postgres backend crashes on certain CREATE VIEW

System Configuration
--------------------
  Operating System   : Linux 2.0.36 ELF Redhat 5.2

  PostgreSQL version : 6.4.2

  Compiler used      : 

Hardware:
---------
Pentium-II 266MHz 196M RAM
Linux tau.kearneydev.com 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i686 unknown

Versions of other tools:
------------------------
GNU Make version 3.75, by Richard Stallman and Roland McGrath.
gcc 2.7.2.1


--------------------------------------------------------------------------

Problem Description:
--------------------
When using a specific CREATE VIEW on a specific schema the
backend dies with return code 127, I have a -d 3 log,
schema dump, and SQL to reproduce the problem at
http://www.kearneydev.com/~secret/pg/pgbug.html

--------------------------------------------------------------------------

Test Case:
----------
There are complete instructions at: http://www.kearneydev.com/~secret/pg/pgbug.html
I could include the SQL Schema dump & CREATE VIEW here, but I thought it would be far too
bulky.  If you'd like me to re-submit with full details
I will, but it's 3 files.

--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date

Next:From: Database AdminDate: 1999-03-13 20:46:09
Subject: Problem compiling
Previous:From: Unprivileged userDate: 1999-03-11 15:14:21
Subject: Port Bug Report: Problem in starting postmaster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group