Hi.
Using postgres 6.5.3-1 i meet a feature:
any (authenticated) user can create table in any
database and it does not matter who is owner of database.
But (and it's right) he can't access existing tables if ones
was not 'granted'.
Max Vashenko
Nizhny Novgorod
Information Networks
Hi.
i have some table (in work ~ 5000 records)
{
mo varchar(6)
se varchar(128)
lo varchar(128)
su float8
nd int4
as float8
sk float8
}
delete from it. -> 0 records.
vacuum it -> OK
then run a program (c,libpq):
{
begin work
delete from table where ...
loop { insert ... }
in continue to my previous message.
version: postgres 6.5.3-1
Problem was fixed:
1. all indexes of bugged table was dropped
2. all records from bugged table was selected into temp
table
3. bugged table was dropped
4. temp table was renamed to right name
5. neccessary indexes was created
-
