MySQL Forums
Forum List  »  PostgreSQL

Re: How can I convert this Postgres stored procedure to MYSQL
Posted by: Jon Bowlas
Date: February 17, 2006 05:44AM

Ok, a slight change is required when creating the delta table, where it says:
PRIMARY pk_objectdelta (object_id, version) this should read , PRIMARY KEY pk_objectdelta (object_id, version)

Next up, the trigger, trg_ins_dept, doesn't appear to be valid SQL syntax or so the response from the query window states:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO object_deltas (object_id, version, orig_DEPTCODE, new_DEPTCOD....

Which all looks good to me, so I'd appreciate if could somebody explain what is incorrect with this.

Cheers

Jon



Edited 1 time(s). Last edit at 02/17/2006 06:06AM by Jon Bowlas.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.