PHP and PostgreSQL

[nazariah]

hello.....
i've trouble with my codes... can you help me....

i want to connect my PosgreSQL by PHP and want to insert data into the database but i've got error..

<?php
$db = pg_connect("host=redhat dbname=dbEAMS user=naz password=zan") or die("Connection die!!!!");
$query = "INSERT INTO tfeedback (idfeedback, phone, email, problem, typeofprob) values (nextval('tfeedback_idfeedback_seq'), '$phone', '$email', '$problem', '$typeofprob')";
$result = pg_exec($db, $query);
if (!$result) {echo ("ERROR"); exit;}
echo ("done");?>

and this the warning
Warning: PostgreSQL query failed: ERROR: tfeedback_idfeedback is an index relation in /var/www/naz/insert.php on line 12
ERROR

pls help me....
thank you...

[Anon]

I'm seeing the same problem here with PostgreSQL 7.2. I think it's a PostgreSQL bug, as it only happens with one table for me - I use nextval extensively, but have only seen this for a table with definition:

mydb=# \d tbl_productpriceproperties ;
Table "tbl_productpriceproperties"
Column | Type | Modifiers

----------------+---------+---------------------------------------------------------------------
pkey | integer | not null default nextval('"tbl_productpriceproper_pkey_seq"'::text)
id | bigint | not null
uid | bigint | not null default 0
suid | bigint | not null default 0
epoch | bigint | not null default 0
status | boolean | not null default '1'
productpriceid | bigint | not null default 0
propertyid | bigint | not null default 0
Primary key: tbl_productpriceproperties_pkey

Suggestions anyone?

Bye for now,
Ward.