Обсуждение: trouble with table creation

Hi, fellows!

I'm getting crazy with a stupid question. I have just created a Database
using pgadmin.exe, then I've created a table named "tabCliente" and, of
course, wanted to populate it. Everything was working fine since I tried to
use pgadmin's sql tool. An idiot sentence like "insert into tabCliente
(iCodCliente, nomCliente) values (NextVal('sqCliente'), 'Nome do Cliente')
resulted in an error message like this:

"Error: -2147467259
Error while executing the query (non-fatal);
ERROR: Relation 'tabcliente' does not exist

function: frmSQL, cmdExecute_Click"

Please! Anyone know what have I missed? Is that a problem with pgadmin?
Help me, please!

The user has total privileges over the database.

Thanks in advance for any advice.

Regards,


Paulo

pmiranda@vm.com.br writes:
> I'm getting crazy with a stupid question. I have just created a Database
> using pgadmin.exe, then I've created a table named "tabCliente"

If you want to use mixed-case table names, you have to be careful to
*always* double-quote the names.  You cannot quote them sometimes and
not other times, because when you don't quote 'em, they're folded to
lower case.

            regards, tom lane

Did you create the table as "tabCliente"?  If so,
you need to always refer to it in the double quotes.
Normally the names are lowercased (note the error
message says 'tabcliente') but if you place it
in double quotes it keeps the case.

On Mon, 30 Jul 2001 pmiranda@vm.com.br wrote:

> Hi, fellows!
>
> I'm getting crazy with a stupid question. I have just created a Database
> using pgadmin.exe, then I've created a table named "tabCliente" and, of
> course, wanted to populate it. Everything was working fine since I tried to
> use pgadmin's sql tool. An idiot sentence like "insert into tabCliente
> (iCodCliente, nomCliente) values (NextVal('sqCliente'), 'Nome do Cliente')
> resulted in an error message like this:
>
> "Error: -2147467259
> Error while executing the query (non-fatal);
> ERROR: Relation 'tabcliente' does not exist
>
> function: frmSQL, cmdExecute_Click"
>
> Please! Anyone know what have I missed? Is that a problem with pgadmin?
> Help me, please!
>
> The user has total privileges over the database.
>
> Thanks in advance for any advice.
>
> Regards,
>
>
> Paulo
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>