Re: [BUGS] Database Grants Bug

2003-08-18 Thread Marcus England
On Mon, 2003-08-18 at 10:31, Andreas Pflug wrote: > > > AFAIR pgAdmin2 does have a grant utility for this. pgAdmin3 has this on > the TODO for the next version. > > Regards, > Andreas > I just used pgAdmin2's security wizard for this. Very nice. Just what I needed. Thanks, Marcus -

Re: [BUGS] Database Grants Bug

2003-08-18 Thread Andreas Pflug
Marcus England wrote: On Mon, 2003-08-18 at 09:29, Joe Conway wrote: Marcus England wrote: Again, I don't know what your definition of "most, if not all other DBMS's" is, but a quick read through my MSSQL2000 manual indicates SQL Server is no different from Postgres in this regard. Sa

Re: [BUGS] Database Grants Bug

2003-08-18 Thread Joe Conway
Marcus England wrote: IMHO, this is confusing and limiting for Administrators who wish to grant privileges beyond CREATE, TEMPORARY, and TEMP across all tables in a database. Something I believe most, if not all other DBMS's do. "ALL" isn't very consistent. Again, I don't know what your definition

Re: [BUGS] Database Grants Bug

2003-08-18 Thread Marcus England
On Mon, 2003-08-18 at 09:29, Joe Conway wrote: > Marcus England wrote: > Again, I don't know what your definition of "most, if not all other > DBMS's" is, but a quick read through my MSSQL2000 manual indicates SQL > Server is no different from Postgres in this regard. Same for Oracle 9i. > I'd

Re: [BUGS] Database Grants Bug

2003-08-18 Thread Marcus England
Thank you Joe. IMHO, this is confusing and limiting for Administrators who wish to grant privileges beyond CREATE, TEMPORARY, and TEMP across all tables in a database. Something I believe most, if not all other DBMS's do. "ALL" isn't very consistent. Reading the comments in the documentation, app

Re: [BUGS] Deadlock in PostgreSQL 7.3.4

2003-08-18 Thread Tom Lane
Philipp Reisner <[EMAIL PROTECTED]> writes: > Now if the applications issues one delete statement concurrently on > two connections both block forever. > Please correct me if I am wrong, but should not one of the statements > succeed and the other simply fail ? > Aug 18 10:34:25 nut1 postgres[4

[BUGS] Deadlock in PostgreSQL 7.3.4

2003-08-18 Thread Philipp Reisner
Hi, In the meantime we were able to upgrade to PostgreSQL 7.3.4+Tom's patch to datetime.c [see 'Postgresql 7.3.3 crashing on query' thread]. Now if the applications issues one delete statement concurrently on two connections both block forever. Please correct me if I am wrong, but should not o