Re: [GENERAL] Missing SQL Syntax & Problem with Create Table

On Mon, 8 Jun 1998, Fredrick Meunier wrote:

> Hi,
>     I have a database design tool under windows, and it has a
> feature where you can store varoius metadata about your database
> in an ODBC database. I would like to use PostgreSQL as the
> repository. The product goes and creates it's own schema in a
> datasource, but has problems with the following DDL:
>
> CREATE VIEW ALL_TEXT (TEXTIDTF,TEXTNSEG)
> AS SELECT B.BLBJ,B.NSEG FROM BLBJ B WHERE B.BTYP = 1
> ERROR from backend during send_query: 'ERROR:  parser: parse error at or
> near "("'
PostgreSQL doesn't support the above syntax. Try this instead:

CREATE VIEW ALL_TEXT
AS SELECT B.BLBJ AS TEXTIDTF, B.NSEG AS TEXTNSEG
FROM BLBJ B WHERE B.BTYP = 1
>
>
> What are the chances of getting view creation syntax like the above
> accepted?
>
> The other problem is:
> CREATE TABLE MPDREFR
> ( REFR int4 NOT NULL,
>   SRCE int4 NOT NULL,
>   TRGT int4 NOT NULL,
>   LABL varchar(254) ,
>   URUL int2 ,
>   DRUL int2 ,
>   MAND int2 ,
>   CPRT int2 ,
>   TOBJ int2 ,
>   COBJ varchar(80) ,
>   SOID int4 ,
>   FKCN varchar(64) ,
>   CMIN varchar(10) ,
>   CMAX varchar(10) ,
>   NGEN int2 )'
> ERROR from backend during send_query: 'ERROR:  create: system attribute
> named "cmin"'

cmin and cmax are reserved words, try to rename to C_MIN C_MAX for example.

>
> Can the system attribute limitation be removed, or can the system
> attributes be renamed to not conflict with legal SQL92 column names?
>
> Thanks for any help you can offer,
> Fred
> --
> To have no errors
> Would be life without meaning
> No struggle, no joy            -- Brian M. Porter

                                                            Ciao, Jose'