From: Kathiravan Velusamy <kathiravan_velusamy@yahoo.com>
To: pgsql-sql@postgresql.org
To: pgsql-general@postgresql.org
Subject: SQL update function faililed in Webmin Interface
Date: Wed, 20 Oct 2004 00:03:59 -0700 (PDT)
Message-ID: <20041020070359.58088.qmail@web60709.mail.yahoo.com> (raw)
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!
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: kathiravan_velusamy@yahoo.com, pgsql-general@postgresql.org
Subject: Re: SQL update function faililed in Webmin Interface
In-Reply-To: <20041020070359.58088.qmail@web60709.mail.yahoo.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