Обсуждение: creating groups (and list archives broken?)

I've been trying to create a group using postgres 6.5.3-23 (that's the
version reported by debian, I'm not sure how to ask postgres what
version it's running).

Here's the syntax that's in the administration manual:

  CREATE GROUP grpname

I guess that should really be:

   CREATE GROUP grpname;

Anyway, when I try and run that in psql (as user postgres) I get:

  ERROR:  parser: parse error at or near "group"



I have tried looking in the list archives for the answer but I don't
seem to be able to view them.

The link I'm following is:

  http://postgresql.lolix.org/mhonarc/pgsql-general

from this page:

   http://postgresql.lolix.org/users-lounge/index.html


The error I get is:

  Forbidden

  You don't have permission to access
  /mhonarc/pgsql-general/ on this server.


Can someone help me with either problem?


Nic Ferrier

Nic Ferrier writes:

> I've been trying to create a group using postgres 6.5.3-23 (that's the
> version reported by debian, I'm not sure how to ask postgres what
> version it's running).

SELECT version();

> Here's the syntax that's in the administration manual:
>
>   CREATE GROUP grpname

You must be reading the wrong manual.  There is no such command in 6.5.*
There is one in 7.0, however.

> I have tried looking in the list archives for the answer but I don't
> seem to be able to view them.

When in doubt, use www.geocrawler.com.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

>>> Peter Eisentraut <peter_e@gmx.net> 21-Jan-01 9:48:31 PM >>>

>You must be reading the wrong manual.  There is no
>such command in 6.5.* There is one in 7.0, however.

Doh!

Presumption is a dangerous thing. I had overlooked the different
versions coz I thought that what I got from Debian would be reasonably
current.

Many apologies and thanks for the version info.


Nic

"Nic Ferrier" wrote:
  >Presumption is a dangerous thing. I had overlooked the different
  >versions coz I thought that what I got from Debian would be reasonably
  >current.

Not if you track "stable".  That was frozen about a year ago.

There is a postgresql-doc package that matches the postgresql package.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "For we wrestle not against flesh and blood, but
      against principalities, against powers, against the
      rulers of the darkness of this world, against
      spiritual wickedness in high places. Wherefore take
      unto you the whole armour of God, that ye may be able
      to withstand in the evil day, and having done all, to
      stand."              Ephesians 6:12,13