Acid : OUTER JOINRe: [Snort-users] CVS changes in ACID

Alexandre Dulaunoy adulau-snort at ...1558...
Sat May 5 12:56:54 EDT 2001


For the OUTER JOIN, it is now supported with postgres 7.1.0... so it's
working correctly except the error (with 'relation singature does not
exit').

Any idea ?

alx

 On Sat, 5 May 2001, Alexandre Dulaunoy wrote:

> Hello,
> 
> I have made a CVS checkout (it's version 0.9.6b8) but i run into trouble
> with postgresql 7.0.2. I got the error "OUTER JOIN is not supported" and
> Relation 'signature does not exist'. 
> What type of mistake, i'm currenlty doing with acid ? 
> 
> The adodb is the version 1.00 and contain a hack for a "false" OUTER
> JOIN. Is it the problem ? 
> 
> If you have any idea...
> 
> Thanks. 
> 
> alx
>  
>  On Fri, 4 May 2001 roman at ...438...
> wrote:
> 
> > I tar-ed up a check-out of the CVS code, 0.9.6b8, yesterday.
> > It contains a number of bug fixes and is a recommended upgrade
> > from 0.9.6b7.
> > 
> > A "db schema" is exactly what is sounds like.  It is the description
> > of the layout of a particular database.  Practically, the schema
> > is the tables, indexes, and their relationships. 
> > 
> > Since there now are so many different versions of Snort running,
> > schema versioning was introduced a little while back.  The most
> > current version is 101.  The most significant reason to upgrade
> > to at least version 100 is support for references and huge speed
> > increases in certain queries.  You can verify the schema you are
> > running by watching the output generated by Snort at startup,
> > or by checking the 'schema' table in the DB.  Databases which
> > are pre-schema version 100 (i.e. before there even existed the
> > notion of schemas) will not be able to be upgraded, but the
> > transition from 100->101 should be painless (actually the MySQL
> > schema for version 100 and 101 are identical, only the PostgreSQL
> > versions are different).
> > 
> > cheers,
> > Roman
> > 
> > > Hi!
> > > I have ACID on an internal machine, version 0.9.6b7. I know that
> > > there are some bugs in that version that are already fixed in CVS.
> > > Are there patches floating around specific for those bugs or should
> > > I upgrade to the CVS version? Specifically, the bug where an action
> > > on an entire query won't work. Are there design changes which would
> > > prevent me from upgrading smoothly? (see below)
> > > 
> > > And what is the "db schema"? Is it the organization of the tables on
> > > the SQL server? If yes, should I change the tables to this new schema
> > > manually or is there a script for it?
> > > 
> > > 
> > > _______________________________________________
> > > Snort-users mailing list
> > > Snort-users at lists.sourceforge.net
> > > Go to this URL to change user options or unsubscribe:
> > > http://lists.sourceforge.net/lists/listinfo/snort-users
> > > Snort-users list archive:
> > > http://www.geocrawler.com/redir-sf.php3?list=snort-users
> > > 
> > 
> > 
> > 
> > ---------------------------------------------
> > This message was sent using Voicenet WebMail.
> >       http://www.voicenet.com/webmail/
> > 
> > 
> > 
> > _______________________________________________
> > Snort-users mailing list
> > Snort-users at lists.sourceforge.net
> > Go to this URL to change user options or unsubscribe:
> > http://lists.sourceforge.net/lists/listinfo/snort-users
> > Snort-users list archive:
> > http://www.geocrawler.com/redir-sf.php3?list=snort-users
> > 
> 
> 
> _______________________________________________
> Snort-users mailing list
> Snort-users at lists.sourceforge.net
> Go to this URL to change user options or unsubscribe:
> http://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=snort-users
> 

-- 
---
Alexandre J.D. Dulaunoy  | "Engineering is the implementation of science;
AD993-RIPE               | Politics is the implementation of faith".
http://www.foo.be/       |                      Another usenet quote...






More information about the Snort-users mailing list