On Thu, Jun 21, 2001 at 01:39:38PM +0200, RISKO Gergely wrote:
> Hello!
> 
> I saaw your patch for 7.0.2, but it is hard to port to 7.1.2 for me,
> because I haven't got any knowlendge in postgresql programming.
> Can you give me a nocreatetable patch for postgres 7.1.2?

 I'd like, but I unsure with my time -- may be later (3 weeks?).

> Will be the new permission system in 7.2?

 Probably not :-(

PS. ...may be someone in hackers list port it to 7.1 (see CC)

-- 
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

Thu, 21 Jun 2001 14:00:03 +0200
Karel Zak <zakkr@zf.jcu.cz>
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
Fri, 22 Jun 2001 13:13:50 +0200
RISKO Gergely <risko@atom.hu>
Re: nocreatetable for 7.1.2 [patch]
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

Fri, 22 Jun 2001 14:01:27 +0200
Karel Zak <zakkr@zf.jcu.cz>
Re: nocreatetable for 7.1.2 [patch]

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

Fri, 24 Aug 2001 16:05:57 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Re: nocreatetable for 7.1.2 [patch]
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

Mon, 27 Aug 2001 09:54:50 +0200
Karel Zak <zakkr@zf.jcu.cz>
Re: [PATCHES] Re: Re: nocreatetable for 7.1.2 [patch]

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

Fri, 22 Feb 2002 08:08:11 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [PATCHES] Re: nocreatetable for 7.1.2 [patch]