SEO

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Robert Treat <xzilla@users.sourceforge.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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Sunday 02 September 2007 10:29, Tom Lane wrote:
> Robert Treat <xzilla@users.sourceforge.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

Robert Treat <xzilla@users.sourceforge.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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

-----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@users.sourceforge.net> wrote:

> On Sunday 02 September 2007 10:29, Tom Lane wrote:
>> Robert Treat <xzilla@users.sourceforge.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@hub.org MSN . scrappy@hub.org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFG228F4QvfyHIvDvMRAoYrAJ0b3cg+Jp0lKI6dw2nkQu woIpE6XwCfQYEG
6EZdIJghysELcvIrdtoisV8=
=EXzk
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

On Sun, Sep 02, 2007 at 09:57:16PM -0400, Tom Lane wrote:
> Robert Treat <xzilla@users.sourceforge.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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

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@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.3 (FreeBSD)

iD8DBQFG29A9dO30qud8SkgRAnBuAJ9C45uxeegwxZv8nd/UlN/ce+flKgCeIDXY
GeuD+ZI+wt6Fg/r7UKtWbCU=
=nvx9
-----END PGP SIGNATURE-----

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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly