Re: [HACKERS] temp tables broken in CVS HEAD?

2004-05-28 Thread Sean Chittenden
test=> create temp table t2 (i integer); ERROR: permission denied for schema pg_temp_1 The immediate problem is a simple thinko (lack of attention to a function's return convention), but I'm gonna go back and review that whole patch. It obviously wasn't tested well at all. I know what's going on

Re: [HACKERS] temp tables broken in CVS HEAD?

2004-05-28 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Also, what is a "thinko"? When in doubt, consult the Hacker's Dictionary ... http://www.catb.org/~esr/jargon/html/T/thinko.html regards, tom lane ---(end of broadcast)--- TIP 7: d

Re: [HACKERS] temp tables broken in CVS HEAD?

2004-05-28 Thread Matthew T. O'Connor
On Fri, 2004-05-28 at 23:19, Bruce Momjian wrote: > Also, what is a "thinko"? A mental "typeo"... brain fart... of if you are old enough to qualify, "a senior moment". ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send a

Re: [HACKERS] temp tables broken in CVS HEAD?

2004-05-28 Thread Bruce Momjian
\Sean Chittenden wrote: > >> test=> create temp table t2 (i integer); > >> ERROR: permission denied for schema pg_temp_1 > > > > The immediate problem is a simple thinko (lack of attention to a > > function's return convention), but I'm gonna go back and review that > > whole patch. It obviously

Re: [HACKERS] temp tables broken in CVS HEAD?

2004-05-28 Thread Sean Chittenden
test=> create temp table t2 (i integer); ERROR: permission denied for schema pg_temp_1 The immediate problem is a simple thinko (lack of attention to a function's return convention), but I'm gonna go back and review that whole patch. It obviously wasn't tested well at all. I know what's going on

Re: [HACKERS] temp tables broken in CVS HEAD?

2004-05-28 Thread Tom Lane
Oliver Jowett <[EMAIL PROTECTED]> writes: > test=> create temp table t2 (i integer); > ERROR: permission denied for schema pg_temp_1 I think this is a side effect of Sean's recent permissions-hacking. I knew I should have objected more strongly ... The immediate problem is a simple thinko (lack

[HACKERS] temp tables broken in CVS HEAD?

2004-05-28 Thread Oliver Jowett
Against current CVS HEAD: $ ./createuser test Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) n CREATE USER $ ./createdb -O test test CREATE DATABASE $ ./psql -U test test Welcome to psql 7.5devel, the PostgreSQL interactive t