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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to