Re: nocreatetable for 7.1.2

Hello!

I continued to port your patch, and now it works,only one error,
if I create ANY table in ANY database:
NOTICE: Cache reference leak: cache pg_shadow (24), tuple 17201 has
count 1

But everything work nice (the nocreatetable thing also :))) ).
Oh, and the help isn't fixed to show nocreatetable and nolocktable for
\h create user.

So I attach my patch.

Gergely

On Fri, Jun 22, 2001 at 01:13:50PM +0200, RISKO Gergely wrote:

Hi,

I continued to port your patch, and now it works,only one error,

You are clever, I knew that is better wait sometime :-)

So I attach my patch.

I try see it next week. Thanks.

Karel

PS. This solution isn't acceptable for standard and official sources.
Probably is better no send this patch to pgsql-patches@postgresql.org,
somebody could be foggy from it.

--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

Were are we on this? We keep talking about NOCREATETABLE permission for
every release but can't seem to get it in there because people want a
redesign of permissions. My feeling is that it should be added to 7.2.

Hello!

I continued to port your patch, and now it works,only one error,
if I create ANY table in ANY database:
NOTICE: Cache reference leak: cache pg_shadow (24), tuple 17201 has
count 1

But everything work nice (the nocreatetable thing also :))) ).
Oh, and the help isn't fixed to show nocreatetable and nolocktable for
\h create user.

So I attach my patch.

Gergely

[ Attachment, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Fri, Aug 24, 2001 at 04:05:57PM -0400, Bruce Momjian wrote:

Were are we on this? We keep talking about NOCREATETABLE permission for
every release but can't seem to get it in there because people want a
redesign of permissions. My feeling is that it should be added to 7.2.

I know very well it:-) It was 1day in official CVS, but we remove it
after discussion with Peter and me. The result was that we need new
privilege system that handle it. If good remember Peter has some
(IMHO good) proposal about it (and Jan has an own proposal
about it too).

Karel

PS. L. Ellison has still better GRANT/REVOKE stuff than PG:-(

--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

Can I assume we will have schemas in 7.3 and will not need this patch?

---------------------------------------------------------------------------

Karel Zak wrote:

On Fri, Jun 22, 2001 at 01:13:50PM +0200, RISKO Gergely wrote:

Hi,

I continued to port your patch, and now it works,only one error,

You are clever, I knew that is better wait sometime :-)

So I attach my patch.

I try see it next week. Thanks.

Karel

PS. This solution isn't acceptable for standard and official sources.
Probably is better no send this patch to pgsql-patches@postgresql.org,
somebody could be foggy from it.

--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026