Thread: Re: nocreatetable for 7.1.2
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
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
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
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