BUG #6376: Cannot prepare a "CREATE TABLE" statement, error message is unhelpful

From: agserm(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6376: Cannot prepare a "CREATE TABLE" statement, error message is unhelpful
Date: 2012-01-04 03:06:06
Message-ID: E1RiHB0-0003hL-8e@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6376
Logged by: Ansel Sermersheim
Email address: agserm(at)gmail(dot)com
PostgreSQL version: 9.1.2
Operating system: Linux & Win32
Description:

Attempting to prepare a CREATE TABLE statement fails with a syntax error:

postgres=# select version();
version

-------------------------------------------------------------------------------------------------------
PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.6.real
(Debian 4.6.2-5) 4.6.2, 64-bit
(1 row)

postgres=# prepare foo as create table bar (c integer);
ERROR: syntax error at or near "create"
LINE 1: prepare foo as create table bar (c integer);
^

This error message does not in any way indicate that one cannot prepare a
create table statement.

It appears that PostgreSQL does not support this operation, but I cannot
find any documentation that indicates why, or indeed if this is
intentional.

At the very least an error message indicating that CREATE TABLE is not
eligible for preparation would have been nice.

This behavior seems to be identical both on Linux and Win32.

Thanks for reading,

Ansel Sermersheim

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message moiseev.igor 2012-01-04 11:15:40 BUG #6377: some notice on the manual page
Previous Message Josh Kupershmidt 2012-01-03 23:08:45 Re: BUG #6370: manual does not discuss transactional DDL