From: Richard Huxton <dev@archonet.com>
To: Kathiravan Velusamy <kathiravan_velusamy@yahoo.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [SQL] SQL update function faililed in Webmin Interface
Date: Wed, 20 Oct 2004 08:37:01 +0100
Message-ID: <4176159D.8050101@archonet.com> (raw)
In-Reply-To: <20041020070359.58088.qmail@web60709.mail.yahoo.com>
References: <20041020070359.58088.qmail@web60709.mail.yahoo.com>
Kathiravan Velusamy wrote:
> I created database called "test" and created table name called "one"
> for that DB, which contains filed name "Name" with varchar(10) as a
> type and allows Null values.
The issue here is that you have created a column "Name" with quotes,
which means it is case-sensitive.
> "SQL update "one" set Name = 'Second1' where oid = 25349 failed :
> column "name" of relation "one" does not exist".
You are then trying to access it without quotes which means it gets
folded to lower-case "name" (look carefully at the error message).
If you quote the name when you create it, ALWAYS quote it. If you never
quote names then you won't have any problems.
It might be that the webmin module quoted the column-name for you
without your knowledge. You'll need to consult your webmin documentation
for details.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, kathiravan_velusamy@yahoo.com, pgsql-general@postgresql.org
Subject: Re: [SQL] SQL update function faililed in Webmin Interface
In-Reply-To: <4176159D.8050101@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox