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.
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 |