Re: Why does this not work? (keyword 'TEXT')

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Johann Zuschlag" <zuschlag(at)online(dot)de>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why does this not work? (keyword 'TEXT')
Date: 2002-04-09 20:53:16
Message-ID: 16263.1018385596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Johann Zuschlag" <zuschlag(at)online(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-04-09 20:54:21 Re: table alias nor valid for delete
Previous Message Tom Lane 2002-04-09 20:50:26 Re: table alias nor valid for delete