| From: | Olivier Hubaut <olivier(at)scmbb(dot)ulb(dot)ac(dot)be> | 
|---|---|
| To: | PgSQL SQL <pgsql-sql(at)postgresql(dot)org> | 
| Subject: | Bug in JDBC CREATE FUNCTION syntax? | 
| Date: | 2003-12-10 08:58:14 | 
| Message-ID: | 3FD6E026.6090001@scmbb.ulb.ac.be | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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(at)(dot)@igloo_login(at)_log_constraints_set ()
	RETURNS boolean
	LANGUAGE SQL
	AS '
	ALTER TABLE @user_schema(at)(dot)@igloo_login(at)_log_transaction
		ADD CONSTRAINT @user_schema(at)_@igloo_login(at)_log_transaction_pk PRIMARY KEY (batch)
	;
	ALTER TABLE @user_schema(at)(dot)@igloo_login(at)_log_object
		ADD CONSTRAINT @user_schema(at)_@igloo_login(at)_log_object_batch_id_uq UNIQUE (batch, id)
	;
	ALTER TABLE @user_schema(at)(dot)@igloo_login(at)_log_object
		ADD CONSTRAINT @user_schema(at)_@igloo_login(at)_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(at)(dot)@igloo_login(at)_log_constraints_set ()
	RETURNS boolean
	LANGUAGE SQL
	AS '
	ALTER TABLE @user_schema(at)(dot)@igloo_login(at)_log_transaction
		ADD CONSTRAINT @user_schema(at)_@igloo_login(at)_log_transaction_pk PRIMARY KEY (batch); ALTER TABLE @user_schema(at)(dot)@igloo_login(at)_log_object
		ADD CONSTRAINT @user_schema(at)_@igloo_login(at)_log_object_batch_id_uq UNIQUE (batch, id);
		ALTER TABLE @user_schema(at)(dot)@igloo_login(at)_log_object
		ADD CONSTRAINT @user_schema(at)_@igloo_login(at)_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,
-- 
Ci-git une signature avortee.
** RIP **
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Olivier Hubaut | 2003-12-10 09:17:24 | Re: Bug in JDBC CREATE FUNCTION syntax? | 
| Previous Message | sqllist | 2003-12-10 05:31:54 | Re: How to specify the beginning of the month in Postgres SQL syntax? |