Port Bug Report: limited subquery length of CREATE VIEW command

[Unprivileged user <nobody>]

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		: Gyorgy Lendvary
Your email address	: gyurika(at)prolan(dot)hu

Category		: unknown
Severity		: serious

Summary: limited subquery length of CREATE VIEW command

System Configuration
- --------------------
  Operating System   : Linux

  PostgreSQL version : 6.3.2

  Compiler used      : 

Hardware:
- ---------
Pentium 200MMX, 64M RAM

Versions of other tools:
- ------------------------


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

Problem Description:
- --------------------
if I want to create a view from a table has many columns, 
and the select query is too long, postgres gives an error message.
For instance:
there is the table example, that has 10000 columns:
column1, column2, ..., column9999, column10000

I want to create a view from the first 9998 columns:
PQexec(conn, "create view v_e as select column1, column2, ..., column9998
  from example");
Postgres says, that this query is too long

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

Test Case:
- ----------


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

Solution:
- ---------


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