Re: [HACKERS] \dF wrt text search

Section 12.1.3. Configurations of the developer docs notes that "Fortunately,
PostgreSQL comes with predefined configurations for many languages. (psql's
\dF shows all predefined configurations.)" but alas it doesn't seem to.

Welcome to psql 8.3devel, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=# \dF
Did not find any relation named "F".
postgres=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.3devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3
(Ubuntu 4.0.3-1ubuntu5)
(1 row)

Is this information just wrong, or is it floating around on someone's TODO
list? If it needs to be I could take a whack at it (though perhaps things are
still to in flux to worry about this yet?)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Robert Treat wrote:
> Section 12.1.3. Configurations of the developer docs notes that "Fortunately,
> PostgreSQL comes with predefined configurations for many languages. (psql's
> \dF shows all predefined configurations.)" but alas it doesn't seem to.
>
> Welcome to psql 8.3devel, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> postgres=# \dF
> Did not find any relation named "F".
> postgres=# select version();
> version
> ---------------------------------------------------------------------------------------------------
> PostgreSQL 8.3devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3
> (Ubuntu 4.0.3-1ubuntu5)
> (1 row)
>
> Is this information just wrong, or is it floating around on someone's TODO
> list? If it needs to be I could take a whack at it (though perhaps things are
> still to in flux to worry about this yet?)

works for me(expect for tab complete support but I already posted a
patch for that):

postgres=# select version();
version
-------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.3devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
(1 row)

postgres=# \dF
List of text search configurations
Schema | Name | Description
------------+------------+---------------------------------------
pg_catalog | danish | Configuration for danish language
pg_catalog | dutch | Configuration for dutch language
pg_catalog | english | Configuration for english language
pg_catalog | finnish | Configuration for finnish language
pg_catalog | french | Configuration for french language
pg_catalog | german | Configuration for german language
pg_catalog | hungarian | Configuration for hungarian language
pg_catalog | italian | Configuration for italian language
pg_catalog | norwegian | Configuration for norwegian language
pg_catalog | portuguese | Configuration for portuguese language
pg_catalog | romanian | Configuration for romanian language
pg_catalog | russian | Configuration for russian language
pg_catalog | simple | simple configuration
pg_catalog | spanish | Configuration for spanish language
pg_catalog | swedish | Configuration for swedish language
pg_catalog | turkish | Configuration for turkish language
(16 rows)

Stefan

Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> postgres=# \dF
> Did not find any relation named "F".

Works for me. When did you last recompile psql?

regression=# \dF
List of text search configurations
Schema | Name | Description
------------+------------+---------------------------------------
pg_catalog | danish | Configuration for danish language
pg_catalog | dutch | Configuration for dutch language
pg_catalog | english | Configuration for english language
pg_catalog | finnish | Configuration for finnish language
pg_catalog | french | Configuration for french language
pg_catalog | german | Configuration for german language
pg_catalog | hungarian | Configuration for hungarian language
pg_catalog | italian | Configuration for italian language
pg_catalog | norwegian | Configuration for norwegian language
pg_catalog | portuguese | Configuration for portuguese language
pg_catalog | romanian | Configuration for romanian language
pg_catalog | russian | Configuration for russian language
pg_catalog | simple | simple configuration
pg_catalog | spanish | Configuration for spanish language
pg_catalog | swedish | Configuration for swedish language
pg_catalog | turkish | Configuration for turkish language
(16 rows)

regression=#

(BTW, now that I look at this: any objection to de-capitalizing
the descriptions? Most other built-in object descriptions don't
have any caps.)

regards, tom lane

On Sunday 02 September 2007 10:29, Tom Lane wrote:
> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> > postgres=# \dF
> > Did not find any relation named "F".
>
> Works for me. When did you last recompile psql?
>

Blah.... I compiled last night, using the latest snapshot in the
postgresql/dev/ directory in ftp, which, as I look now, has a date listed of
2007-08-10, and looking in the source the catversion is 200702251, which is
before the tsearch bits hit the tree. So, I think my problems lie in the
snapshot no longer being updated :-\ CCing www in case someone wants to fix
it.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> Blah.... I compiled last night, using the latest snapshot in the
> postgresql/dev/ directory in ftp, which, as I look now, has a date listed of
> 2007-08-10, and looking in the source the catversion is 200702251, which is
> before the tsearch bits hit the tree. So, I think my problems lie in the
> snapshot no longer being updated :-\ CCing www in case someone wants to fix
> it.

I'll bet a dollar it got broken in the master-CVS-server move.

regards, tom lane

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Should be fixed now, running a manual run of it right now, give it about 15
minutes or so ...

- --On Sunday, September 02, 2007 21:48:36 -0400 Robert Treat
<xzilla(at)users(dot)sourceforge(dot)net> wrote:

> On Sunday 02 September 2007 10:29, Tom Lane wrote:
>> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
>> > postgres=# \dF
>> > Did not find any relation named "F".
>>
>> Works for me. When did you last recompile psql?
>>
>
> Blah.... I compiled last night, using the latest snapshot in the
> postgresql/dev/ directory in ftp, which, as I look now, has a date listed of
> 2007-08-10, and looking in the source the catversion is 200702251, which is
> before the tsearch bits hit the tree. So, I think my problems lie in the
> snapshot no longer being updated :-\ CCing www in case someone wants to fix
> it.
>
> --
> Robert Treat
> Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

- ----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFG228F4QvfyHIvDvMRAoYrAJ0b3cg+Jp0lKI6dw2nkQuwoIpE6XwCfQYEG
6EZdIJghysELcvIrdtoisV8=
=EXzk
-----END PGP SIGNATURE-----

On Sun, Sep 02, 2007 at 09:57:16PM -0400, Tom Lane wrote:
> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> > Blah.... I compiled last night, using the latest snapshot in the
> > postgresql/dev/ directory in ftp, which, as I look now, has a date listed of
> > 2007-08-10, and looking in the source the catversion is 200702251, which is
> > before the tsearch bits hit the tree. So, I think my problems lie in the
> > snapshot no longer being updated :-\ CCing www in case someone wants to fix
> > it.
>
> I'll bet a dollar it got broken in the master-CVS-server move.

I thought it worked off the same cvs repo as the cvsweb stuff (on svr1),
which AFAIK isn't broken (since cvsweb works). But it's not documented
anywhere, and I do recall not being able to track down exactly how it
worked, so I won't be able to proove it to the point of being able to
collect that dollar ;-)

//Magnus

On Sun, Sep 02, 2007 at 11:18:45PM -0300, Marc G. Fournier wrote:
> Should be fixed now, running a manual run of it right now, give it about 15
> minutes or so ...

Is there now monitoring for it as well?
--
Decibel!, aka Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

Decibel! wrote:
> On Sun, Sep 02, 2007 at 11:18:45PM -0300, Marc G. Fournier wrote:
>> Should be fixed now, running a manual run of it right now, give it about 15
>> minutes or so ...
>
> Is there now monitoring for it as well?

yes

Stefan