Re: SQL update function faililed in Webmin Interface

#1

On Wed, 2004-10-20 at 01:03, Kathiravan Velusamy wrote:

Quote:

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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQL update function faililed in Webmin Interface

comp.databases.postgresql.general comp.databases.postgresql.general

Re: SQL update function faililed in Webmin Interface - 10-20-2004 , 02:49 AM