#18 Pub/Sub creation problems on PostgreSQL 7.4

[Vladimirs Kuzmins]

For a Daffodil Replicator testing purpose I am using
TikiWiki CMS 1.9.0 on PostgreSQL 7.4.8 on SLES 9.0.

In postgresql if column name is in quotes it is case
sensetive. In the process of creating shadow tables first
problem was with column name "user", witch is reserved
word is postgre SQL syntax. After selecting for
replication tables without such a column, there is another
type of error - no such a column name, becouse of case
sansetivity.

Sub problem is lack of exception handling - sub/pub
creation is succesfull even without shadow tables or
functions/triggers creation.

Btw. log4j is shows a creation of functions triggers witch
actualy are not created.

After some little studing of code I noticed that many
SQLException are just ignored, witch is quite unlikely
style of coding.

If You provide some directions where contibution is need
to be done, I could help.

Also if any testing or debug info is needed, just let me
know.

Thank You for the great tool!

[subesingh]

Logged In: YES
user_id=1125145

Daffodil Replicator does not support the quoted identifiers. It
give the unexpected error if column name or table names are
quoted.

To through the proper error we will add the check with
errorcode. Error will throw to user if it is not error of "table
already exit".

Sube Singh