------=_Part_43097_15567026.1194539941932
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
2007/11/8, Andreas Ericsson :
>
> Antonio Grassi wrote:
> >>>> turn everything up, I see that there are also hardcoded queries with
> >>>> MySQL SQL format.
> >>> I thought most queries were in ANSI SQL. In what way are the queries
> >>> incompatible with PostgreSQL (or any other sql-engine, for that
> matter)?
> >>>
> >> I should check the queries again.
> >
> >
> > In particular, I've seen the query in src/db.c, line 317:
> >
> > "INSERT INTO %s SET instance_name='%s'"
> >
> > The INSERT INTO table SET column = value ... is a MySQL extension, as
> > described in
> > http://dev.mysql.com/doc/refman/6.0/en/ ... -ansi.html
> >
> > I don't know if there are other non standard queries.
> >
>
> UPDATE %s SET column='%s'
>
> is ANSI though, so that should work pretty much everywhere. So long as
> it doesn't overly complicate things, I'm all for following standards.
>
> Were there any complicated cases, or was this all?
After a quick overview of the queries, I don't think there are any
complicated cases, but I haven't even tryed to replace those queries and see
what happens afterwards.
I just wanted to know the status of PostgreSQL support, if the intention to
add it persisted, and give a hand if it could be useful and there was work
going on (which I understand is not the case, as there is a standby till the
database schema stabilizes).
I will check the nagios exchange version that Michael mentions.
Thanks very much,
Antonio
------=_Part_43097_15567026.1194539941932
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
2007/11/8, Andreas Ericsson <[email protected]>:
Antonio Grassi wrote:>>>> turn everything up, I see that there are also hardcoded queries with>>>> MySQL SQL format.>>> I thought most queries were in ANSI SQL. In what way are the queries
>>> incompatible with PostgreSQL (or any other sql-engine, for that matter)?>>>>> I should check the queries again.>>> In particular, I've seen the query in src/db.c, line 317:
>> "INSERT INTO %s SET instance_name='%s'">> The INSERT INTO table SET column = value ... is a MySQL extension, as> described in>
http://dev.mysql.com/doc/refman/6.0/en/ ... -ansi.html>> I don't know if there are other non standard queries.>UPDATE %s SET column='%s'is ANSI though, so that should work pretty much everywhere. So long as
it doesn't overly complicate things, I'm all for following standards.Were there any complicated cases, or was this all?After a quick overview of the queries, I don't think there are any complicated cases, but I haven't even tryed to replace those queries and see what happens afterwards.
I just wanted to know the status of PostgreSQL support, if the intention to add it persisted, and give a hand if it could be useful and there was work going on (which I understand is not the case, as there is a standby till the database schema stabilizes).
I will check the nagios exchange version that Michael mentions.Thanks very much,Antonio
------=_Part_43097_15567026.1194539941932--
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]