Re: [HACKERS] Bug in new buffer freelist code

2003-12-23 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > Yeah, looks like ... but I actually want to have a clean reproduction of > the error before I attempt to fix it. Well, I can tell you that just running "make check" over and over isn't a real efficient way to reproduce the problem. It might work to do some

Re: [HACKERS] Permissions and PGSQL

2003-12-23 Thread Bruno Wolff III
On Tue, Dec 16, 2003 at 13:41:32 +0500, Jean-Eric Cuendet <[EMAIL PROTECTED]> wrote: > Hi, > I use PgSql for a lot of our company's need and I lack some features. > I would like to know if there is plans to implement: > - User permissions based on columns? (Ex: User1 has Select on Column "CompayN

Re: [HACKERS] Bug in new buffer freelist code

2003-12-23 Thread Jan Wieck
Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: It seems to me that buffers that are thrown away via StrategyInvalidateBuffer() do not get their relnode and blocknum cleaned out. Mmmm. They definitely should be; if you look at the prior version of buf_table.c, BufTableDelete did this:

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-23 Thread Joshua D. Drake
Jean-Michel POURE wrote: Le Mardi 09 Décembre 2003 16:15, Ivelin Ivanov a écrit : I think that a co-bundle between an open source J2EE container like JBoss and a scalable database like PostgreSQL will be a blast. Why not cut all trees on earth and replace them with plastic? Before that, we

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-23 Thread Andrew Dunstan
Jean-Michel POURE said: > Le Mardi 09 Décembre 2003 16:15, Ivelin Ivanov a écrit : >> I think that a co-bundle between an open source J2EE >> container like JBoss and a scalable database like >> PostgreSQL will be a blast. > > Why not cut all trees on earth and replace them with plastic? Before > t

Re: [HACKERS] Bug in new buffer freelist code

2003-12-23 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: >> Let me know if there's any test I could run to confirm your theory, >> assuming I can make it happen again after I finish rebuilding. > You could add another assertion that checks that the CDB found is > actually pointing to the buffer that is being invali

Re: [HACKERS] Bug in new buffer freelist code

2003-12-23 Thread Jan Wieck
Tom Lane wrote: BTW, I just managed to reproduce the hang, after a whole afternoon of trying ... only it was with a non-debug build. Sigh. Anyway, it seems my HP machine has a significantly higher probability of showing the problem than my Linux machine --- I have been unable to see the problem

Re: [HACKERS] Bug in new buffer freelist code

2003-12-23 Thread Tom Lane
BTW, I just managed to reproduce the hang, after a whole afternoon of trying ... only it was with a non-debug build. Sigh. Anyway, it seems my HP machine has a significantly higher probability of showing the problem than my Linux machine --- I have been unable to see the problem in thirty or fort

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-23 Thread Jean-Michel POURE
Le Mardi 09 Décembre 2003 16:15, Ivelin Ivanov a écrit : > I think that a co-bundle between an open source J2EE > container like JBoss and a scalable database like > PostgreSQL will be a blast. Why not cut all trees on earth and replace them with plastic? Before that, we need to port mankind DNA

Re: [HACKERS] Bug in new buffer freelist code

2003-12-23 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > It seems to me that buffers that are thrown away via > StrategyInvalidateBuffer() do not get their relnode and blocknum cleaned > out. Mmmm. They definitely should be; if you look at the prior version of buf_table.c, BufTableDelete did this: /*

Re: [HACKERS] Bug in new buffer freelist code

2003-12-23 Thread Jan Wieck
Tom Lane wrote: I just had the parallel regression tests hang up due to what appears to be a bug in the new ARC code. The CLUSTER test gets into an infinite loop trying to do "CLUSTER clstr_1;". The loop is in StrategyInvalidateBuffer's check that the buffer is already in the freelist; it isn't,

[HACKERS] One regression failure with 7.4.1 on Debian 3.0r2

2003-12-23 Thread Adam Witney
I have one regression failure on 7.4.1, which does not occur with 7.4 [EMAIL PROTECTED] more src/test/regress/regression.diffs *** ./expected/random.out Thu Feb 13 05:24:04 2003 --- ./results/random.outTue Dec 23 20:19:40 2003 *** *** 25,31 GROUP BY random HAVIN

[HACKERS] Bug in new buffer freelist code

2003-12-23 Thread Tom Lane
I just had the parallel regression tests hang up due to what appears to be a bug in the new ARC code. The CLUSTER test gets into an infinite loop trying to do "CLUSTER clstr_1;". The loop is in StrategyInvalidateBuffer's check that the buffer is already in the freelist; it isn't, and the freelist

[HACKERS] (Mis?)Behavior of \copy with -f and \i

2003-12-23 Thread Mark Feit
Greetings... I've run into a problem with the way \copy behaves when psql is reading its input from a file using either the -f command line option or the \i command. (Not that it matters in this case, but this is PostgreSQL 7.4 on i686-pc-linux-gnu, compiled with gcc.) The following... ---8<--S

Re: [HACKERS] Permissions and PGSQL

2003-12-23 Thread Christopher Kings-Lynne
I use PgSql for a lot of our company's need and I lack some features. I would like to know if there is plans to implement: - User permissions based on columns? (Ex: User1 has Select on Column "CompayName" but User2 has update on column "CompanyName" while User3 has create new row on table). These d