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

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)

Marty
--
Random Farscape Quote #8:
Ka'Dargo - Believe me, this plan is so bad, it just has to be ours.

.

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
    ... > Hi Roy, ... >> Sweet! ... > Having installed the commit, the connection to the database is okay. ...
    (comp.databases.ingres)
  • Re: Route messages
    ... is the commit? ... If I revert to the prev version, ... lookup in ip_input.c when there was an EMSGSIZE error returned by ...
    (freebsd-net)
  • Re: Donating Collections to Libraries
    ... Ask yourself why a library would commit to care of your ... David Ames ... Prev by Date: ...
    (rec.collecting.books)
  • Re: Manhunter 15-Really good.
    ... Thanks for the recommendation, guys! ... I avoided it because I didn't want to commit to another series only to ... Tom ... Prev by Date: ...
    (rec.arts.comics.dc.universe)