Re: [GENERAL] Database reverse engineering

2007-09-10 Thread RC Gobeille
Or this one: http://schemaspy.sourceforge.net/ On Sep 8, 2007, at 4:43 AM, A. Kretschmer wrote: am Sat, dem 08.09.2007, um 11:44:17 +0200 mailte Thorsten Kraus folgendes: Hello, I am looking for a tool which is able to generate a database diagramm including the relationships from an existi

Re: [GENERAL] tsearch2 anomoly?

2007-09-06 Thread RC Gobeille
s is how default parser works. See output from > select * from ts_debug('gallery2-httpd-conf'); > and > select * from ts_debug('httpd-2.2.3-5.src.rpm'); > > All token type: > > select * from token_type(); > > > On Thu, 6 Sep 2007, RC G

[GENERAL] tsearch2 anomoly?

2007-09-06 Thread RC Gobeille
I'm having trouble understanding to_tsvector. (PostreSQL 8.1.9 contrib) In this first case converting 'gallery2-httpd-conf' makes sense to me and is exactly what I want. It looks like the entire string is indexed plus the substrings broken by '-' are indexed. ossdb=# select to_tsvector('