Re: [Info-ingres] Ingres/STAR, ING_SYSTEM_SET and set lockmode

<martin.bowes@xxxxxxxxxxxxx> wrote in message
news:mailman.1132839961.18773.info-ingres@xxxxxxxxxxxxxxxxxx
> Hi Roy,
> > >
> > >
> > > Anyway, try changing ING_SYSTEM_SET to "commit; set lockmode session
> > > where maxlocks=100". It is documented as only taking SET statements
> > > but in fact it will take pretty much anything and the COMMIT will
> > > ensure you are not mid-transaction.
> >
> > Sweet! That seems to work!
>
> Actually, I have to take that back.
> Having installed the commit, the connection to the database is okay.
> But when I do something else like a createdb I get...
> createdb thaju02
> Creating database 'thaju02' . . .
>
> E_US0A28 Syntax error on line 1. Last symbol read was: commit.
> (Thu Nov 24 13:38:32 2005)

Rats.

Roy


.

Relevant Pages

  • Re: ot SHANA TOV
    ... What ways do diabetics have to avoid eating these sweet things? ... An interesting note is that if you commit ... a sin again another person you must ask forgivness form that person beore ...
    (alt.support.diabetes)
  • Re: [Info-ingres] Ingres/STAR, ING_SYSTEM_SET and set lockmode
    ... >> ensure you are not mid-transaction. ... Having installed the commit, the connection to the database is okay. ... Prev by Date: ...
    (comp.databases.ingres)