Re: trouble with table creation

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(at)vm(dot)com(dot)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
>