Problem with braces in CREATE FUNCTION

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Problem with braces in CREATE FUNCTION
Date: 2002-09-09 09:27:39
Message-ID: 03AF4E498C591348A42FC93DEA9661B867BF@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-09-09 10:41:57 Re: Problem with braces in CREATE FUNCTION
Previous Message Dave Page 2002-09-09 07:16:38 Re: Thread Safety of ODBC Driver