Field add error - Mailing list pgsql-bugs

From Jozsef Aron
Subject Field add error
Date
Msg-id 001201c58080$d16084e0$8e24a8c0@ontsz.hu
Whole thread Raw
Responses Re: Field add error  (Richard Huxton <dev@archonet.com>)
List pgsql-bugs
Hello Everybody!

Sorry, my English is very peer.

This is Database:

CREATE DATABASE TVGAR
WITH ENCODING='LATIN1'
OWNER=tvgaruser
TEMPLATE=template0
TABLESPACE=pg_default;
GRANT ALL ON DATABASE TVGAR TO GROUP "TVGAR";

This is Shema:

CREATE SCHEMA 'X' AUTHORIZATION postgres;
GRANT ALL ON SCHEMA 'X' TO postgres;
GRANT ALL ON SCHEMA 'X' TO public;
COMMENT ON SCHEMA 'X' IS 'abc';

X shema's table:

CREATE TABLE X.tabla (
razon bigserial,
2e00 varchar(11),
AS varchar(5)
...
..
.
PRIMARY KEY (razon)
) WITHOUT OIDS;

Fields name is not ok., denied : 'AS','1e00','2e00'

ERROR: Syntax error at to near "2e00" at character 1443

What is problem?

This support, very well thanks!

Áron József, Hungary

pgsql-bugs by date:

Previous
From: Jean-Max Reymond
Date:
Subject: Re: BUG #1739: memory leak in pl/perl with spi_exec_query
Next
From: Richard Huxton
Date:
Subject: Re: Field add error