Bug in JDBC CREATE FUNCTION syntax?

Поиск
Список
Период
Сортировка
От Olivier Hubaut
Тема Bug in JDBC CREATE FUNCTION syntax?
Дата
Msg-id 3FD6E026.6090001@scmbb.ulb.ac.be
обсуждение исходный текст
Ответы Re: Bug in JDBC CREATE FUNCTION syntax?  (Olivier Hubaut <olivier@scmbb.ulb.ac.be>)
Список pgsql-sql
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 booleanLANGUAGE SQLAS 'ALTER TABLE
@user_schema@.@igloo_login@_log_transaction   ADD CONSTRAINT @user_schema@_@igloo_login@_log_transaction_pk PRIMARY KEY
(batch);ALTERTABLE @user_schema@.@igloo_login@_log_object    ADD CONSTRAINT
@user_schema@_@igloo_login@_log_object_batch_id_uqUNIQUE (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 booleanLANGUAGE SQLAS '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_uqUNIQUE (batch, id);    ALTER TABLE
@user_schema@.@igloo_login@_log_object   ADD CONSTRAINT @user_schema@_@igloo_login@_log_object_batch_id_class_pk
PRIMARYKEY (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,

-- 
Ci-git une signature avortee.
** RIP **


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

Предыдущее
От: "sqllist"
Дата:
Сообщение: Re: How to specify the beginning of the month in Postgres SQL syntax?
Следующее
От: Olivier Hubaut
Дата:
Сообщение: Re: Bug in JDBC CREATE FUNCTION syntax?