RE: [GENERAL] Internal limitation of the CREATE VIEW statement - Mailing list pgsql-general

From Daniel Péder
Subject RE: [GENERAL] Internal limitation of the CREATE VIEW statement
Date
Msg-id 01BEF4A4.54362100@Dan
Whole thread Raw
List pgsql-general
probably because the use of reserved word "name" ?
recently I faced similar problem using the word "user" as column name with some of newer PSQL 6.5.xxx
the solution was enclosing it by double quotes like this: select "user", "name", "title" from sometablename;


-----Original Message-----
From:    marten@feki.toppoint.de [SMTP:marten@feki.toppoint.de]
Sent:    Thursday, September 02, 1999 2:05 AM
To:    pgsql-general@postgreSQL.org
Subject:    [GENERAL] Internal limitation of the CREATE VIEW statement

I've trouble when creating a view using the following statement:


create view VPHOBJECT as select PHID, BIRTHDAY, COMPANYID, CONTACT,
EMPLOYERID, FEMSALUTATION, HOLDINGID, INTFLGS, MASTERREFERENCEID,
SUPERCOMPANYID, TECHNICALGROUP, CREDITNR, DEBITNR, EMAIL, EMAIL2,
ENTRYSTRING, FAX, FAX2, KUNDNR, NAME, POPLOGIN, POPPASSWORD, TELEFON,
TELEFON2,TELEX, WWW, CUSTOMERNUMBER, TURNOVERTAXNUMBER, REMARK,
LOGINACCOUNT, PASSWD, SURNAME, TITLE, USERFUNCTION from TPHOBJECT


I get an error message:

ERROR: DefineQueryRewrite: rule plain string too long


Even if I do a


create view VPHOBJECT AS SELECT * FROM TPHOBJECT


I get the same error message.


All the other error I receive when creating the database can be
solved by myself - but I've no chance changing this statement.

The other errors I've received:

 * errors when creating an index ('asc' and 'desc' are unknown).
 * several columns have names which are predefined tokens like
   when, interval and so on ...




Marten





************


pgsql-general by date:

Previous
From: marten@feki.toppoint.de
Date:
Subject: Internal limitation of the CREATE VIEW statement
Next
From: Robert Wagner
Date:
Subject: subscribe