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?
|
| Список | 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 по дате отправления: