grant still broken
От | Peter T Mount |
---|---|
Тема | grant still broken |
Дата | |
Msg-id | Pine.LNX.3.95.980113192207.3570B-100000@maidast обсуждение исходный текст |
Ответы |
Re: [HACKERS] grant still broken
|
Список | pgsql-hackers |
Well, I've rebuilt postgres again, using a fresh cvs snapshot, and grant is still broken. Infact, it gets worse. Once you try to use the grant statement, then any other connection that was active at that time - even on different databases, will die with the same message, hinting it may be something in shared memory that's breaking. Heres the output of psql, first as user postgres: [postgres@maidast pgsql]$ psql -h localhost db1 Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: db1 db1=> create table a (id int4,url text); CREATE db1=> insert into a values (1,'http://www.demon.co.uk/finder'); INSERT 18250 1 db1=> grant all on a to public; PQexec() -- Request was sent to backend, but backend closed the channel before responding. This probably means the backend terminated abnormally before or while processing the request. And as user pmount: [pmount@maidast pmount]$ psql -h localhost Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: pmount pmount=> create table a (id int4,url text); CREATE pmount=> insert into a values (1,'http://www.demon.co.uk/finder'); INSERT 18314 1 pmount=> select * from a; id|url --+----------------------------- 1|http://www.demon.co.uk/finder (1 row) pmount=> select * from a; PQexec() -- Request was sent to backend, but backend closed the channel before responding. This probably means the backend terminated abnormally before or while processing the request. NB: the select done as pmount was after the postgres user tried to grant rights, while the other statements were before. -- Peter T Mount petermount@earthling.net or pmount@maidast.demon.co.uk Main Homepage: http://www.demon.co.uk/finder Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk
В списке pgsql-hackers по дате отправления: