Problem with braces in CREATE FUNCTION
От | Dave Page |
---|---|
Тема | Problem with braces in CREATE FUNCTION |
Дата | |
Msg-id | 03AF4E498C591348A42FC93DEA9661B867BF@mail.vale-housing.co.uk обсуждение исходный текст |
Список | pgsql-odbc |
Hi, The new CREATE FUNCTION syntax looks like: CREATE FUNCTION public.autoinc1() RETURNS trigger AS 'autoinc' { LANGUAGE 'c' VOLATILE }; How do I execute such a statement through ADO/ODBC without the ODBC driver giving the following error (I've tried \{ and {{)?: STATEMENT ERROR: func=copy_statement_with_parameters, desc='', errnum=1, errmsg='ODBC escape convert error' ------------------------------------------------------------ hdbc=130904072, stmt=129337000, result=0 manual_result=0, prepare=0, internal=0 bindings=0, bindings_allocated=0 parameters=0, parameters_allocated=0 statement_type=4, statement='CREATE FUNCTION public.autoinc1() RETURNS trigger AS 'autoinc' { LANGUAGE 'c' VOLATILE };' stmt_with_params='(NULL)' data_at_exec=-1, current_exec_param=-1, put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 cursor_name='SQL_CUR07B586A8' ----------------QResult Info ------------------------------- CONN ERROR: func=copy_statement_with_parameters, desc='', errnum=0, errmsg='(NULL)' ------------------------------------------------------------ henv=129312544, conn=130904072, status=1, num_stmts=16 sock=129367224, stmts=129367832, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=1124, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in=130763568, buffer_out=130780304 buffer_filled_in=1, buffer_filled_out=0, buffer_read_in=1 Regards, Dave.
В списке pgsql-odbc по дате отправления: