Hi all
We run sequoia 2.10 postgresql 8.1.4
I have a table named poolmanager
I can see that table when I do show tables
I can run selects against that table,
jdbc:sequoia://172.20.21.130/mydb (postgres) > select * from poolmanager
+---------------------------+--+---------------------------+-------------+
| gamename | xml | datemodified | modifiedby~ |
+---------------------------+--+---------------------------+-------------+
| FACILITO | <pool-manager class="com~ | 2008-01-24
14:54:41.822 | 0 |
+---------------------------+--+---------------------------+-------------+
Query executed in 0 s 4 ms .
But when I try to do an update or an Insert I got this error messages
jdbc:sequoia://172.20.21.130/mydb (postgres) > update poolmanager set
gamename = 'x'
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unknown table 'poolmanager' in this UPDATE statement:
'update poolmanager set gamename = 'x'')
jdbc:sequoia://172.20.21.130/abrazo (postgres) > insert into
poolmanagers (gamename, xml, datemodified, modifiedbyuser) values
('a','b',now(), 0)
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unknown table 'poolmanagers' in this INSERT statement:
'insert into poolmanagers (gamename, xml, datemodified, modifiedbyuser)
values ('a','b',now(), 0)')
Any other table no problem....like this one
jdbc:sequoia://172.20.21.130/abrazo (postgres) > update validcurrencies set
description='testing3' where currencyid='xyz'
Affected rows: 1
Query executed in 0 s 4 ms
I've tried directly and it worked.
I really appreciate any help on this.
Thanks in advance
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
