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--