pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Olivier Hubaut <olivier@scmbb.ulb.ac.be>
To: PgSQL SQL <pgsql-sql@postgresql.org>
Subject: Bug in JDBC CREATE FUNCTION syntax?
Date: Wed, 10 Dec 2003 09:58:14 +0100
Message-ID: <3FD6E026.6090001@scmbb.ulb.ac.be> (raw)

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,

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



view thread (2+ messages)  latest in thread

Message-ID: <3FD6E026.6090001@scmbb.ulb.ac.be>
Permalink:  ../3FD6E026.6090001@scmbb.ulb.ac.be/
Also on:    postgresql.org/message-id/3FD6E026.6090001@scmbb.ulb.ac.be

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: olivier@scmbb.ulb.ac.be
  Subject: Re: Bug in JDBC CREATE FUNCTION syntax?
  In-Reply-To: <3FD6E026.6090001@scmbb.ulb.ac.be>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox