Re: table name - TypeCreate error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Felipe Nievinski" <fnievinski(at)terra(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: table name - TypeCreate error
Date: 2002-01-24 15:00:00
Message-ID: 12624.1011884400@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Felipe Nievinski" <fnievinski(at)terra(dot)com(dot)br> writes:
> I would expect to be able to create a table with any name different
> than others tables' name.

A table also implies a type (for its rowtype) in Postgres. Sorry.

In 7.3 this will be less of a problem since user tables will live in
a different schema than system types do. For now, there's nothing
you can do except name your table something else.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Unnikrishnan Menon 2002-01-24 15:32:18 Re: PGACCESS installation
Previous Message Radu-Adrian Popescu 2002-01-24 13:37:43 Re: table name - TypeCreate error