Обсуждение: Port Bug Report: Can not create table with a number as first character

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


Your name        : Michael Kraus
Your email address    : magnum3171@aol.com

Category        : unknown
Severity        : non-critical

Summary: Can not create table with a number as first character

System Configuration
--------------------
  Operating System   : Linux 2.0.36 redhat 5.2

  PostgreSQL version : 6.4.2

  Compiler used      : gcc 2.7.0

Hardware:
---------
Pentium 48M RAM.

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


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

Problem Description:
--------------------
I can not creat a table with a name that contains a number as its first character.  I can not create a table with a
namethat contains a hyphen. 

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

Test Case:
----------
create table 622 (etc char(25)) or create table v-22 (etc char(10))

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

Solution:
---------


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

> Summary: Can not create table with a number as first character
>   PostgreSQL version : 6.4.2
> create table 622 (etc char(25));
> create table v-22 (etc char(10));

You must use the SQL92 conventions to accomplish this:

postgres=> create table "622" (etc char(25));
CREATE
postgres=> insert into "622" values ('hi there');
INSERT 144982 1
postgres=> select * from "622";
etc
-------------------------
hi there
(1 row)

Same with your hyphen example. Good luck.

                   - Tom