Bug in JDBC CREATE FUNCTION syntax?

Поиск
Список
Период
Сортировка
От Olivier Hubaut
Тема Bug in JDBC CREATE FUNCTION syntax?
Дата
Msg-id 3FD6E711.2070601@scmbb.ulb.ac.be
обсуждение исходный текст
Ответы Re: Bug in JDBC CREATE FUNCTION syntax?  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
I'm trying to do a create function using JDBC 3,0 in Eclipse IDE with
JFaceDBC plugin.

This function doesn't work:

CREATE FUNCTION @user_schema@.@igloo_login@_log_constraints_set ()
     RETURNS boolean
     LANGUAGE SQL
     AS '
     ALTER TABLE @user_schema@.@igloo_login@_log_transaction
         ADD CONSTRAINT @user_schema@_@igloo_login@_log_transaction_pk
PRIMARY KEY (batch)
     ;
     ALTER TABLE @user_schema@.@igloo_login@_log_object
         ADD CONSTRAINT
@user_schema@_@igloo_login@_log_object_batch_id_uq UNIQUE (batch, id)
     ;
     ALTER TABLE @user_schema@.@igloo_login@_log_object
         ADD CONSTRAINT
@user_schema@_@igloo_login@_log_object_batch_id_class_pk PRIMARY KEY
(batch, id, class)
     ;
     SELECT true;'
;


But the same, written using a different indetation protocol, works:

CREATE FUNCTION @user_schema@.@igloo_login@_log_constraints_set ()
     RETURNS boolean
     LANGUAGE SQL
     AS '
     ALTER TABLE @user_schema@.@igloo_login@_log_transaction
         ADD CONSTRAINT @user_schema@_@igloo_login@_log_transaction_pk
PRIMARY KEY (batch); ALTER TABLE @user_schema@.@igloo_login@_log_object
         ADD CONSTRAINT
@user_schema@_@igloo_login@_log_object_batch_id_uq UNIQUE (batch, id);
         ALTER TABLE @user_schema@.@igloo_login@_log_object
         ADD CONSTRAINT
@user_schema@_@igloo_login@_log_object_batch_id_class_pk PRIMARY KEY
(batch, id, class)
     ; SELECT true;'
;


It seem's that the problem is about the semi-colon position. The
following query MUST be on the same line to make it works...

Does anyone else notice the same thing?

Thanks,


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Multi column foreign keys.
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Bug in JDBC CREATE FUNCTION syntax?