Emmanuel, Many thanks for your reply - it is Postgres I am using and will get rid of the OR REPLACE and just include a DROP beforehand.
Easy, peasy. Cheerio, Nic -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Cecchet Sent: 30 September 2008 16:30 To: Sequoia general mailing list Subject: Re: [Sequoia] Unsupported CREATE statement error: CREATE or REPLACE FUNCTION Hi Nicholas, > > I am having some trouble creating stored procedures via Sequoia. > > > > Basically, the error in the console is as follows: > > Unsupported CREATE statement CREATE OR REPLACE FUNCTION schema.func() > CREATE OR REPLACE FUNCTION is not SQL standard and it is not supported. CREATE FUNCTION does work but the parser will fail if you have a 'OR REPLACE'. > > Am I attempting something that is possible or not or is there > something I need to be aware of when creating stored procedures? > Which database backend are you using? Is it Oracle? You can add a feature request in Jira to modify the create request parser to support 'or replace' options in create statements. Thanks for your feedback, Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: [EMAIL PROTECTED] Skype: emmanuel_cecchet _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia __________ Information from ESET Smart Security, version of virus signature database 3483 (20080930) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3483 (20080930) __________ The message was checked by ESET Smart Security. http://www.eset.com _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
