Re: Why does this not work? (keyword 'TEXT') - Mailing list pgsql-general

"Johann Zuschlag" <zuschlag@online.de> writes:
> If I look thru the keywords table, I don't find 'TEXT', but:

That's because it's not a keyword.

> all-test=# create table text (textid varchar(10));
> ERROR:  type named text already exists

Every table has an associated datatype of the same name (to wit,
its row type).  So there's a naming conflict when the system tries
to create the row type for your table.

            regards, tom lane