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 do

[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...

[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] 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

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,

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] 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 to

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

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
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 invalidated.

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 that, we

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,

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] 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 CompayName