From kathiravan_velusamy@yahoo.com Wed Oct  20 07:04:13 2004
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 802DB32A9F8
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Oct 2004 08:04:13 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 17620-03
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Oct 2004 07:04:03 +0000 (GMT)
Received: from web60709.mail.yahoo.com (web60709.mail.yahoo.com
	[216.109.117.232])
	by svr1.postgresql.org (Postfix) with SMTP id 07E79329F1F
	for <pgsql-general@postgresql.org>;
	Wed, 20 Oct 2004 08:04:01 +0100 (BST)
Message-ID: <20041020070359.58088.qmail@web60709.mail.yahoo.com>
Received: from [203.193.157.82] by web60709.mail.yahoo.com via HTTP;
	Wed, 20 Oct 2004 00:03:59 PDT
Date: Wed, 20 Oct 2004 00:03:59 -0700 (PDT)
From: Kathiravan Velusamy <kathiravan_velusamy@yahoo.com>
Subject: SQL update function faililed in Webmin Interface
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1595668036-1098255839=:57800"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_20_30,
	HTML_FONTCOLOR_BLUE, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200410/879
X-Sequence-Number: 67402

--0-1595668036-1098255839=:57800
Content-Type: text/plain; charset=us-ascii

Hello All,

           I am a newbie to PostgreSQL. I am using postgreSQL 7.4.5 in HP-Unix 11.11 PA , and 11.23 PA.

          I have a problem with postgreSQL Webmin (Webmin Version 1.070) testing in update function.

          This problem exists only when i create a new data base through webmin interface, 
          and insert some values,and modify those values afterwards. 
 
For E.g :

    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.

   I inserted values for two rows as first and second, it can be viewed perfectly. 
But when i select second row (Which contains string "second" as value) to edit, 
and change it value as "second1" instead of "second", it throws me following error when i saved it : 
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
"SQL update "one" set Name = 'Second1' where oid = 25349 failed : column "name" of relation "one" does not exist".

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
But when i created the database without using this Webmin interface
 ($ echo "create table one(Name varchar(10))"|psql test ), 
and then edit with webmin interface means it works well and get updated.

Is there any problem with postgreSQL or with Webmin interface ?
Any idea to solve this issue ?
 
Thanks in Advance,
Kathir

 
 



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.778 / Virus Database: 525 - Release Date: 10/15/2004


		
---------------------------------
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!
--0-1595668036-1098255839=:57800
Content-Type: text/html; charset=us-ascii

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><FONT face=Arial color=#000080 size=2>Hello All,</FONT></DIV><FONT 
face=Arial color=#000080 size=2>
<DIV><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am a 
newbie to PostgreSQL. I am using postgreSQL 7.4.5 in HP-Unix 11.11 PA , and 
11.23 PA.</DIV>
<DIV><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have a problem 
with postgreSQL Webmin (Webmin Version 1.070) testing in update function.</DIV>
<DIV><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This problem 
exists only when i create a new data base through webmin interface, </DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and insert some 
values,and modify those values afterwards. </DIV>
<DIV>&nbsp;</DIV>
<DIV>For E.g :</DIV>
<DIV><BR>&nbsp;&nbsp;&nbsp; I created database called "test" and created table 
name called "one" for that DB,</DIV>
<DIV>&nbsp;which contains filed name "Name" with varchar(10) as a type and 
allows Null values.</DIV>
<DIV><BR>&nbsp;&nbsp; I inserted values for two rows as first and second, it can 
be viewed perfectly. </DIV>
<DIV>But when i select second row (Which contains string "second" as value) to 
edit, </DIV>
<DIV>and change it value as "second1" instead of "second", it throws me 
following error when i saved it :&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</DIV>
<DIV>&nbsp;</DIV>
<DIV>"SQL update "one" set Name = 'Second1' where oid = 25349 failed : column 
"name" of relation "one" does not exist".</DIV>
<DIV><BR>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</DIV>
<DIV>&nbsp;</DIV>
<DIV>But when i created the database without using this Webmin interface</DIV>
<DIV>&nbsp;($ echo "create table one(Name varchar(10))"|psql test ), </DIV>
<DIV>and then edit with webmin interface means it works well and get 
updated.</DIV>
<DIV><BR>Is there any problem with postgreSQL or with Webmin interface ?<BR>Any 
idea to solve this issue ?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks in Advance,</DIV>
<DIV>Kathir<BR></DIV></FONT>
<DIV><FONT face=Arial color=#000080 size=2>
<H3><TT>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV><FONT face=Arial size=2>
<DIV><BR></DIV></FONT></TT></H3>
<H3><TT><FONT face=Arial size=2><BR>---<BR>Outgoing mail is certified Virus 
Free.<BR>Checked by AVG anti-virus system (<A 
href="http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: 6.0.778 / 
Virus Database: 525 - Release Date: 
10/15/2004</FONT></TT></FONT></H3></DIV></DIV></BODY></HTML>
<p>
		<hr size=1>Do you Yahoo!?<br><a
href="http://vote.yahoo.com">vote.yahoo.com</a> - Register online to vote today!
--0-1595668036-1098255839=:57800--



From dev@archonet.com Wed Oct  20 07:37:13 2004
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E90D932AC06;
	Wed, 20 Oct 2004 08:37:13 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 27892-03; Wed, 20 Oct 2004 07:37:06 +0000 (GMT)
Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net
	[194.217.242.85])
	by svr1.postgresql.org (Postfix) with ESMTP id 4348132AC5C;
	Wed, 20 Oct 2004 08:37:05 +0100 (BST)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-35.mail.demon.net with esmtp (Exim 4.42)
	id 1CKByB-000OzN-I4; Wed, 20 Oct 2004 08:37:19 +0000
Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id CDAB31628A; Wed, 20 Oct 2004 08:37:02 +0100 (BST)
Message-ID: <4176159D.8050101@archonet.com>
Date: Wed, 20 Oct 2004 08:37:01 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 0.7 (X11/20040615)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Kathiravan Velusamy <kathiravan_velusamy@yahoo.com>
Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Subject: Re: [SQL] SQL update function faililed in Webmin Interface
References: <20041020070359.58088.qmail@web60709.mail.yahoo.com>
In-Reply-To: <20041020070359.58088.qmail@web60709.mail.yahoo.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/881
X-Sequence-Number: 67404

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



From smarlowe@qwest.net Wed Oct  20 07:47:05 2004
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 8769F32AC1B
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Oct 2004 08:47:05 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 31042-01
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Oct 2004 07:46:57 +0000 (GMT)
Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net
	[63.231.195.115])
	by svr1.postgresql.org (Postfix) with SMTP id 4AD0932A8B1
	for <pgsql-general@postgresql.org>;
	Wed, 20 Oct 2004 08:46:56 +0100 (BST)
Received: (qmail 76322 invoked by uid 0); 20 Oct 2004 07:46:55 -0000
Received: from mpls-pop-04.inet.qwest.net (63.231.195.4)
	by mpls-qmqp-04.inet.qwest.net with QMQP; 20 Oct 2004 07:46:55 -0000
Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37)
	by mpls-pop-04.inet.qwest.net with SMTP; 20 Oct 2004 07:46:55 -0000
Date: Wed, 20 Oct 2004 01:49:09 -0600
Message-Id: <1098258549.21035.39.camel@localhost.localdomain>
From: "Scott Marlowe" <smarlowe@qwest.net>
To: "Kathiravan Velusamy" <kathiravan_velusamy@yahoo.com>
Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Subject: Re: SQL update function faililed in Webmin Interface
In-Reply-To: <20041020070359.58088.qmail@web60709.mail.yahoo.com>
References: <20041020070359.58088.qmail@web60709.mail.yahoo.com>
Content-Type: text/plain
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/883
X-Sequence-Number: 67406

On Wed, 2004-10-20 at 01:03, Kathiravan Velusamy wrote:
> Hello All,
>            I am a newbie to PostgreSQL. I am using postgreSQL 7.4.5 in
> HP-Unix 11.11 PA , and 11.23 PA.
>           I have a problem with postgreSQL Webmin (Webmin Version
> 1.070) testing in update function.
>           This problem exists only when i create a new data base
> through webmin interface, 
>           and insert some values,and modify those values afterwards. 
>  
> For E.g :
>     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.
>    I inserted values for two rows as first and second, it can be
> viewed perfectly. 
> But when i select second row (Which contains string "second" as value)
> to edit, 
> and change it value as "second1" instead of "second", it throws me
> following error when i saved it : 
>  
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>  
> "SQL update "one" set Name = 'Second1' where oid = 25349 failed :
> column "name" of relation "one" does not exist".
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>  
> But when i created the database without using this Webmin interface
>  ($ echo "create table one(Name varchar(10))"|psql test ), 
> and then edit with webmin interface means it works well and get
> updated.
> Is there any problem with postgreSQL or with Webmin interface ?
> Any idea to solve this issue ?
>  

It looks like the table is being defined with the column quoted, like
this:

create table one ("Name" text, moredefshere...)

but accessed without quotes, like above.  Whether a database folds to
upper or lower case, the columns need to be accessed consistenly, either
all quoted or never quoted.  An application that mixes quoting and not
quoting identifiers is going to have problems.