grant still broken

From: Peter T Mount <psqlhack(at)maidast(dot)demon(dot)co(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: grant still broken
Date: 1998-01-13 19:53:44
Message-ID: Pine.LNX.3.95.980113192207.3570B-100000@maidast
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)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(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Keith Parks 1998-01-13 23:36:18 how about a "bugs" regression test?
Previous Message De Clarke 1998-01-13 18:55:48 Re: [HACKERS] access control