Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group