Thread: 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