On 2012-09-22 23:47, Ryan Kelly wrote:
On Sat, Sep 22, 2012 at 11:35:00PM +0300, Condor wrote:
Hello,
I wanna ask: is there a short way to giver permission to one user to
select/insert (all privileges) on whole database ?
Im create a user and try to give him all permission on existing
database,
On Sat, Sep 22, 2012 at 12:23 AM, Jasen Betts wrote:
> On 2012-09-18, Rafal Pietrak wrote:
> >
> > Actual Tom's example(1):
> > SELECT 1/x AS inverse FROM data WHERE x <> 0;
> > extended to (2):
> > SELECT 1/x AS inverse FROM data WHERE x <> 0 AND 1/x > 20;
> > could be written by us
On 2012-09-06, Kobus Wolvaardt wrote:
> Something that is curios is that if a DB takes long, it really takes
> horribly long like some kind of a lock is holding it. It would sit at a few
> kb dump size for 20 minutes en then run a bit and get stuck again (as far
> as we can tell), what we do know
On 2012-09-18, Rafal Pietrak wrote:
>
> Actual Tom's example(1):
> SELECT 1/x AS inverse FROM data WHERE x <> 0;
> extended to (2):
> SELECT 1/x AS inverse FROM data WHERE x <> 0 AND 1/x > 20;
> could be written by user as (3):
> SELECT 1/x AS inverse FROM data WHERE x <> 0 AND i
On 2012-09-18, Raymond O'Donnell wrote:
> On 18/09/2012 16:10, Yvon Thoraval wrote:
>> I've found the prob.
>> In my postgresql.conf file the default port is setup to 5433 instead of
>> 5432 as previously...
>
> OK - you probably had two versions of PG installed at some point - when
> you install
On 09/23/2012 04:35 AM, Condor wrote:
I look at documentation and remained less scarred about how many grants
I should do for tables, for sequences, execution.
You probably need to read this:
http://stackoverflow.com/questions/11599533/postgresql-8-4-grant-dml-privileges-on-all-tables-to-a-rol
On Sun, Sep 23, 2012 at 6:47 AM, Ryan Kelly wrote:
> On Sat, Sep 22, 2012 at 11:35:00PM +0300, Condor wrote:
>> Hello,
>> I wanna ask: is there a short way to giver permission to one user to
>> select/insert (all privileges) on whole database ?
>> Im create a user and try to give him all permissio
On Sep 22, 2012, at 16:35, Condor wrote:
> Hello,
> I wanna ask: is there a short way to giver permission to one user to
> select/insert (all privileges) on whole database ?
> Im create a user and try to give him all permission on existing database, but
> when I try to select always got:
> ERRO
On Sat, Sep 22, 2012 at 11:35:00PM +0300, Condor wrote:
> Hello,
> I wanna ask: is there a short way to giver permission to one user to
> select/insert (all privileges) on whole database ?
> Im create a user and try to give him all permission on existing
> database, but when I try to select always
Hello,
I wanna ask: is there a short way to giver permission to one user to
select/insert (all privileges) on whole database ?
Im create a user and try to give him all permission on existing
database, but when I try to select always got:
ERROR: permission denied for relation table_name
I simp
Is there link to download pldbgapi.dll on postgresql 9.2 x64 on windows
Thanks in advance
Tuan Hoang Anh
On Fri, Sep 14, 2012 at 9:29 PM, Albe Laurenz wrote:
> Fabrízio de Royes Mello wrote:
> >> Has it moved somewhere else?
>
> > Look at the pldebugger git repository in [1].
>
> Thanks!
>
> La
On 22 September 2012 05:08, John R Pierce wrote:
> On 09/21/12 7:43 PM, David Johnston wrote:
>>
>> Has there been any discussion regarding adding a time-limited version of
>> NOWAIT, say: “WAITONLY 50” (milliseconds), when dealing the explicit LOCK
>> TABLE or the SELECT…FOR(SHARE|UPDATE) command
On 09/21/2012 10:32 PM, salah jubeh wrote:
I am running queries sequentially on each machine using a database
dumped from a life server , and 9.1 server is much slower than 8.4.
https://wiki.postgresql.org/wiki/Slow_Query_Questions
More detail needed.
--
Craig Ringer
--
Sent via pgsql-gen
2012-09-22 06:08 keltezéssel, John R Pierce írta:
On 09/21/12 7:43 PM, David Johnston wrote:
Has there been any discussion regarding adding a time-limited version of NOWAIT, say:
“WAITONLY 50” (milliseconds), when dealing the explicit LOCK TABLE or the
SELECT…FOR(SHARE|UPDATE) commands?
is th
2012-09-22 07:55 keltezéssel, Josh Kupershmidt írta:
On Fri, Sep 21, 2012 at 7:43 PM, David Johnston wrote:
Has there been any discussion regarding adding a time-limited version of
NOWAIT, say: “WAITONLY 50” (milliseconds), when dealing the explicit LOCK
TABLE or the SELECT…FOR(SHARE|UPDATE) co
Hi,
2012-09-22 04:43 keltezéssel, David Johnston írta:
Has there been any discussion regarding adding a time-limited version of NOWAIT, say:
"WAITONLY 50" (milliseconds), when dealing the explicit LOCK TABLE or the
SELECT...FOR(SHARE|UPDATE) commands?
David J.
we have a proposed patch fo
16 matches
Mail list logo
