On Fri, Feb 15, 2008 at 12:19 PM, Decibel! <[EMAIL PROTECTED]> wrote:
> On Feb 14, 2008, at 7:27 AM, Alvaro Herrera wrote:
> > Attributes: S -- superuser
> > R -- create role
> > D -- create database
> > I -- inherit
>
>
> Can we add something similar to the bot
On Feb 14, 2008, at 5:50 PM, Tom Lane wrote:
"Brendan Jurd" <[EMAIL PROTECTED]> writes:
What about connection limit? I suppose we could combine it into the
privileges column, and refrain from displaying anything for "no
limit".
"5 connections" seems a bit odd for a "privilege". I'd be happy
On Feb 14, 2008, at 7:27 AM, Alvaro Herrera wrote:
Attributes: S -- superuser
R -- create role
D -- create database
I -- inherit
Can we add something similar to the bottom of \z?
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your
On Feb 14, 2008, at 10:06 AM, Tom Lane wrote:
=?UTF-8?B?UmFwaGHDq2wgSmFjcXVvdA==?= <[EMAIL PROTECTED]> writes:
so, I propose the use of
NEW[variable_containing_the_column_name]
(which can obviously be extended to any tuples)
to allow such access.
what do you experts think ?
Zero cha
On Fri, Feb 15, 2008 at 10:50 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Brendan Jurd" <[EMAIL PROTECTED]> writes:
> > What about connection limit? I suppose we could combine it into the
> > privileges column, and refrain from displaying anything for "no
> > limit".
>
> "5 connections" seems a
"Brendan Jurd" <[EMAIL PROTECTED]> writes:
> What about connection limit? I suppose we could combine it into the
> privileges column, and refrain from displaying anything for "no
> limit".
"5 connections" seems a bit odd for a "privilege". I'd be happy with
leaving that as a separate column. Or
On Fri, Feb 15, 2008 at 3:42 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Now that psql prints multiline field values nicely, maybe it'd work
> to fold all the boolean attributes into one column. I'm imagining
> something like
>
> Role name | Privileges | Member of
> --+-+--
Tom Lane escribió:
> Now that psql prints multiline field values nicely, maybe it'd work
> to fold all the boolean attributes into one column. I'm imagining
> something like
>
> Role name | Privileges | Member of
> --+-+---
> postgres | superuser | {}
>
Simon Riggs <[EMAIL PROTECTED]> writes:
> On Thu, 2008-02-14 at 13:52 -0500, Tom Lane wrote:
>> [ still staring at the code ... ] Something that might be interesting
>> though is to try to move some of the buffer control logic overhead out
>> of WALInsertLock's domain and into WALWriteLock's domai
On Thu, 2008-02-14 at 13:52 -0500, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > Paul van den Bogaard (Sun) suggested to me that we could use more than
> > two WAL locks to improve concurrency.
>
> After looking over the code I'm unconvinced that there's much win to be
> bought thi
Simon Riggs <[EMAIL PROTECTED]> writes:
> Paul van den Bogaard (Sun) suggested to me that we could use more than
> two WAL locks to improve concurrency.
After looking over the code I'm unconvinced that there's much win to be
bought this way. I had been thinking you could push a material amount
of
Alvaro Herrera a écrit :
[...]
For those that think that the \du output is currently OK because it
doesn't wrap, consider the french translation which is quite a bit wider
than the original:
alvherre=# \du
Liste des rôles
Nom du rôle | Superutilisateur | Cr
Simon Riggs <[EMAIL PROTECTED]> writes:
> LWLockAcquire(WALInsertLock, LW_EXCLUSIVE)
> Reserve space to write into.
> LSN = current Insert pointer
> Move pointer forward by length of data to be inserted, acquiring
> WALWriteLock if required to ensure space is available.
I think you've handwaved
Bernd Helmle <[EMAIL PROTECTED]> writes:
> --On Donnerstag, Februar 14, 2008 10:27:37 -0300 Alvaro Herrera
> <[EMAIL PROTECTED]> wrote:
>> I wonder if it's possible to create a more compact output -- say, a
>> fixed-width column, with a letter for each enabled attribute, or a space
>> in the respe
Naz Gassiep <[EMAIL PROTECTED]> writes:
> I think that it would be great if the pg_timezone_names and
> pg_timezone_abbrevs included a boolean field indicating if that item is
> in the Olsen DB
Huh? They're all in the Olsen DB.
regards, tom lane
---
=?UTF-8?B?UmFwaGHDq2wgSmFjcXVvdA==?= <[EMAIL PROTECTED]> writes:
> so, I propose the use of
> NEW[variable_containing_the_column_name]
> (which can obviously be extended to any tuples)
> to allow such access.
> what do you experts think ?
Zero chance. plplgsql is a strongly typed language,
--On Donnerstag, Februar 14, 2008 10:27:37 -0300 Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
I wonder if it's possible to create a more compact output -- say, a
fixed-width column, with a letter for each enabled attribute, or a space
in the respective position when the attribute is disabled. Leg
Paul van den Bogaard (Sun) suggested to me that we could use more than
two WAL locks to improve concurrency. I think its possible to introduce
such a scheme with some ease. All mods within xlog.c
The scheme below requires an extra LWlock per WAL buffer.
Locking within XLogInsert() would look lik
On Thu, Feb 14, 2008 at 07:51:31AM +0100, Raphaël Jacquot wrote:
> in fact, I got stuck in pl/pgsql with the fact that there's no way to
> access the NEW tuple in an indirect way, having the name of the column
> in some variable. (I found that it could be done in plperl, but that
> left me with
Brendan Jurd escribió:
> Hello hackers,
>
> psql's \du command currently does not list the INHERIT role attribute.
> It does show the other privilege attributes (superuser, create role,
> create db), and INHERIT seems like the kind of thing a user
> executing\du would want to know.
>
> I'd like
--On Donnerstag, Februar 14, 2008 15:52:31 +1100 Brendan Jurd
<[EMAIL PROTECTED]> wrote:
Hello hackers,
psql's \du command currently does not list the INHERIT role attribute.
It does show the other privilege attributes (superuser, create role,
create db), and INHERIT seems like the kind of th
21 matches
Mail list logo
