Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
- To: <simon(at)2ndquadrant(dot)com>
- Cc: <pgman(at)candle(dot)pha(dot)pa(dot)us>, <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <kleptog(at)svana(dot)org>, <gsstark(at)mit(dot)edu>, <pg(at)rbt(dot)ca>, <zhouqq(at)cs(dot)toronto(dot)edu>, <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Date: Fri, 30 Dec 2005 08:53:33 -0600 (CST)
- Message-id: <56737.68.143.134.146.1135954413.squirrel@www.dunslane.net> <text/plain>
Simon Riggs said: > > Following Andrew's concerns, I'd also note that ALTER TABLE requires a > much higher level of privilege to operate than does COPY. That sounds > like it will make things more secure, but all it does is open up the > administrative rights, since full ownership rights must be obtained > merely to load data. > Yeah. And since a role can own a table you could have a role and add lots of users to it .... My concern is more about making plain that this is for special operations, not normal operations. Or maybe I have misunderstood the purpose. cheers andrew
- Follow-Ups:
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- From: Tom Lane
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- References:
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- From: Simon Riggs
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Prev by Date: Re: [DOCS] Online backup vs Continuous backup
- Next by Date: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Previous by thread: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Next by thread: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Indexes: