Field add error

From: "Jozsef Aron" <jaron(at)ar(dot)hu>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Field add error
Date: 2005-07-04 10:11:52
Message-ID: 001201c58080$d16084e0$8e24a8c0@ontsz.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Huxton 2005-07-04 10:36:24 Re: Field add error
Previous Message Bartomiej Rychtarski 2005-07-04 09:17:08 BUG #1750: recurrentive views terminates connection