Обсуждение: Problem with braces in CREATE FUNCTION

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.

Please ignore my previous message on this subject - I was being a
plank...

Regards, Dave.

> -----Original Message-----
> From: Dave Page
> Sent: 09 September 2002 10:28
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Problem with braces in CREATE FUNCTION
>
>
> 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.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>