Обсуждение: Handling the pg_global of tablespace.
Hi All. As for pg_global, handling became difficult for reasons of Ver 8.3 to security. http://archives.postgresql.org/pgsql-hackers/2007-10/msg00448.php Therefore, we have to do this change by this version. A method is considered as follows. 1. pg_global is removed by the handling of a tablespace objects. or 2. consideration of statistics and dependents is disregarded. I want to convert by 1. Is there any objection? or any idea? Regards, Hiroshi Saito
It should still work for superusers though shouldn't it? /D > ------- Original Message ------- > From: "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp> > To: pgadmin-hackers@postgresql.org > Sent: 11/10/07, 06:01:56 > Subject: [pgadmin-hackers] Handling the pg_global of tablespace. > > Hi All. > > As for pg_global, handling became difficult for reasons of Ver 8.3 to security. > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00448.php > Therefore, we have to do this change by this version. > > A method is considered as follows. > > 1. pg_global is removed by the handling of a tablespace objects. > or > 2. consideration of statistics and dependents is disregarded. > > I want to convert by 1. > Is there any objection? or any idea? > > Regards, > Hiroshi Saito > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >
From: "Dave Page" <dpage@postgresql.org> > It should still work for superusers though shouldn't it? > Eh?, Is it ACL bug of PostgreSQL ver 8.3b1? As for superuser, 2007-10-11 13:53:23 ERROR : ERROR: permission denied for tablespace pg_global 2007-10-11 15:31:16 ERROR : ERROR: permission denied for tablespace pg_global 2007-10-11 15:31:20 ERROR : fe_sendauth: no password supplied 2007-10-11 15:31:22 ERROR : ERROR: permission denied for tablespace pg_global 2007-10-11 15:31:27 ERROR : ERROR: permission denied for tablespace pg_global 2007-10-11 15:31:33 ERROR : fe_sendauth: no password supplied 2007-10-11 15:31:44 ERROR : fe_sendauth: no password supplied 2007-10-11 15:31:48 ERROR : fe_sendauth: no password supplied Regards, Hiroshi Saito
Hiroshi Saito wrote: > From: "Dave Page" <dpage@postgresql.org> > >> It should still work for superusers though shouldn't it? >> > > Eh?, Is it ACL bug of PostgreSQL ver 8.3b1? > > As for superuser, > 2007-10-11 13:53:23 ERROR : ERROR: permission denied for tablespace > pg_global Yes, I specifically asked Tom about the superuser case and he responded: http://archives.postgresql.org/pgsql-hackers/2007-08/msg01018.php I've reported the problem to pgsql-hackers with the relevant posts. /D