Euler Taveira de Oliveira <[EMAIL PROTECTED]> writes:
> What's Role? A set of relations with their respective privileges and
> a set of users and/or roles.
Huh? How did relations get into it?
> What do we do with 'groups'? Well, we can have three categories of
> object owners: users, groups and
Stephen Frost <[EMAIL PROTECTED]> writes:
> Here's a proof-of-concept pretty much untested (it compiles) patch
> against HEAD for review of the general approach I'm taking to
> merging pg_shadow and pg_group. This is in order to support group
> ownership and eventually roles. This patch
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> If we're dropping the pg_, maybe call the new schema just 'catalog'?
Any new schemas introduced by PG itself will be named pg_something.
This is not open to negotiation --- it's what we've promised to users
to avoid tromping on their schema namespace.
On Sat, 22 Jan 2005 17:05:22 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> > src/port/snprintf.c is not not a particularly pretty. And
> > after my rework it got even uglier. I have looked at
> > FreeBDS's one and it is not *that* complicated.
>
> If you can get it to work then it'd be a better
On Sat, Jan 22, 2005 at 05:21:32PM -0600, Jim C. Nasby wrote:
> Out of curiosity, what's the relation between the tables in pg_catalog
> and the 'actual system objects'? I ass-u-me'd that these tables were the
> backing store for the real information, but maybe that's not the case.
They are.
>
In <[EMAIL PROTECTED]>, on 01/22/05
at 05:21 PM, "Jim C. Nasby" <[EMAIL PROTECTED]> said:
>On Sat, Jan 22, 2005 at 01:36:54PM -0800, Josh Berkus wrote: > Jim,
>>
>> > Just to be clear, I'm not suggesting renaming anything in any of the
>> > existing pg_catalog objects. I'm suggesting creating
On Sat, Jan 22, 2005 at 01:36:54PM -0800, Josh Berkus wrote:
> Jim,
>
> > Just to be clear, I'm not suggesting renaming anything in any of the
> > existing pg_catalog objects. I'm suggesting creating a new, easier to
> > use set of views that would sit on top of pg_catalog.
>
> I have no objectio
Dawid Kuroczko <[EMAIL PROTECTED]> writes:
> So... I thoght, why not use this unitext to sort texts?
> So I've created functions, operators and operator class,
> This time setlocale() was needed to get the behaviour
> I needed (database initdb'ed to 'C', my order set to 'pl_PL',
> or whatever local
Nicolai Tufar <[EMAIL PROTECTED]> writes:
> On Sat, 22 Jan 2005 15:31:39 +0100, Peter Eisentraut <[EMAIL PROTECTED]>
> wrote:
>> Nicolai Tufar wrote:
>>> 2. Why would we not just take FreeBSD's vfprintf() and use it
>>> instead?
>>
>> Try it. It's painful.
> src/port/snprintf.c is not not a par
Jim,
> Just to be clear, I'm not suggesting renaming anything in any of the
> existing pg_catalog objects. I'm suggesting creating a new, easier to
> use set of views that would sit on top of pg_catalog.
I have no objection to using easier to read names for the system views.
(This is the user-fr
"Josh Berkus" writes:
> I might suggest simply "tables" "triggers" "types" etc. The plurals
> of these reserved words are no, AFAIK, reserved. And if users are
> creating identically named objects in public, they just need to
> remember to use the schema.
Only if you put them in some other sch
Tom Lane wrote:
> Tom Lane <[EMAIL PROTECTED]> writes:
> > Manfred Koizar <[EMAIL PROTECTED]> writes:
> >> Last time we discussed this, didn't we come to the conclusion, that
> >> resetting status bits is not a good idea because of possible race
> >> conditions?
>
> > There's no race condition,
>
Simon Riggs <[EMAIL PROTECTED]> writes:
> Each transaction commit gets the current time(NULL) immediately before
> it commits.
time() has 1 second resolution and ergo is utterly useless for this.
gettimeofday() may have sufficient resolution, but the resolution is
not specified anywhere.
"Jonah H. Harris" <[EMAIL PROTECTED]> writes:
> I have a couple aquaintances at IBM that I can try to contact about it.
> Rather than assume what IBM will do, why not just ask them? If they
> don't respond, they don't respond. If they do respond, it's better than
> us guessing.
People seem t
Hi Stephen,
> > I have to disagree with your model. Roles are not so simple like
> you
> > try to describe in your patch. I'm suposing this because your using
> > role* in all of the 'pg_shadow'.
>
> The particular name isn't really important- and don't take it to mean
> very much...
>
OK. So le
On Sat, 22 Jan 2005 15:31:39 +0100, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Nicolai Tufar wrote:
> > 1. I renamed snprintf() to pg_snprintf(), vsnprintf() to
> > pg_vsnprintf() and introduced pg_printf() that calls pg_vsnprintf().
>
> This is not necessary. You will notice that we already h
Added to TODO based on this discusion:
---
* Speed up COUNT(*)
We could use a fixed row count and a +/- count to follow MVCC
visibility rules, or a single cached value could be used and
invalidated if anyone modifies
* Euler Taveira de Oliveira ([EMAIL PROTECTED]) wrote:
> > Here's a proof-of-concept pretty much untested (it compiles) patch
> > against HEAD for review of the general approach I'm taking to
> > merging pg_shadow and pg_group. This is in order to support group
> > ownership and eventual
I was able to copy the table over to a temp table and truncate it with only a
little loss. I will be able to recover
the lost data from backup so no big deal. I will have to schedule downtime to
do the memory test with the "big" snow
storm it will not be until monday night.
thanks for the he
Hi Stephen and Hackers,
Moved to -hackers.
> Here's a proof-of-concept pretty much untested (it compiles) patch
> against HEAD for review of the general approach I'm taking to
> merging pg_shadow and pg_group. This is in order to support group
> ownership and eventually roles.
I have
"Jim Buttafuoco" <[EMAIL PROTECTED]> writes:
> Thanks for the reply. here is an "ls" of my pg_clog directory. The 0402
> file, I created as per Joshua's directions.
> I might have created one too small. If so, what size do you think I should
> use.
> bda1:/usr/local/pgsql/data# ls -l pg_clog
Alvaro,
Thanks for the reply. here is an "ls" of my pg_clog directory. The 0402 file,
I created as per Joshua's directions.
I might have created one too small. If so, what size do you think I should use.
Jim
bda1:/usr/local/pgsql/data# ls -l pg_clog
total 992
-rw--- 1 postgres dba 262
On Sat, Jan 22, 2005 at 12:06:46PM -0500, Jim Buttafuoco wrote:
> didn't work.
>
>
> ERROR: could not access status of transaction 1076101119
> DETAIL: could not read from file "/usr/local/pgsql/data/pg_clog/0402" at
> offset 57344: Success
>
> any more ideas?
You need to extend the file f
Some french guy on IRC showed the site http://www.postgresql.fr/ that does
not contain anything about postgresql. I don't speak french so I can't
tell what the page is about. It looks linux related.
This doesn't really belong on the -hackers list but I don't know where to
send the info or even i
On Sat, Jan 22, 2005 at 08:47:37AM +, Simon Riggs wrote:
> On Sat, 2005-01-22 at 00:18 -0600, Jim C. Nasby wrote:
> > 1) I'm in favor of autotuning anything possible.
> > 2) In addition to turning group_commit on and off, what about also
> > adjusting the commit delay, based on statistics of re
didn't work.
ERROR: could not access status of transaction 1076101119
DETAIL: could not read from file "/usr/local/pgsql/data/pg_clog/0402" at
offset 57344: Success
any more ideas?
-- Original Message ---
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc
On Sat, Jan 22, 2005 at 08:46:21PM +1100, Neil Conway wrote:
> Jim C. Nasby wrote:
> >On another naming note; the naming convention for system stuff has
> >always driven me nuts. Some the letter prefix (ie: tab for tables) in
> >front of every field name, with no underscores or anything. Extensive
Jim Buttafuoco wrote:
hackers,
I am having a problem with table (identified by pg_dump). I get the follow error when I try to COPY the table to
stdout (or /dev/null).
DB=# copy rnk to '/dev/null';
ERROR: could not access status of transaction 1076101119
DETAIL: could not open file "/usr/local/
I just upgraded to 7.4.6 and have the same error message.
-- Original Message ---
From: "Jim Buttafuoco" <[EMAIL PROTECTED]>
To: "pgsql-hackers"
Sent: Sat, 22 Jan 2005 09:35:02 -0500
Subject: [HACKERS] pg_clog problem (PG version 7.4.5)
> hackers,
>
> I am having a problem
Nicolai Tufar wrote:
> 1. I renamed snprintf() to pg_snprintf(), vsnprintf() to
> pg_vsnprintf() and introduced pg_printf() that calls pg_vsnprintf().
This is not necessary. You will notice that we already have configure
tests of snprintf format specifiers (%lld etc.), so using the original
fun
hackers,
I am having a problem with table (identified by pg_dump). I get the follow
error when I try to COPY the table to
stdout (or /dev/null).
DB=# copy rnk to '/dev/null';
ERROR: could not access status of transaction 1076101119
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0
Greetings,
for a couple of days I have been hacking on src/port/snprintf.c.
With Magnus' help I have managed to implement argument replacement
in snprintf(). The code is very crude and not quite optimised,
any suggestions will be more than welcome.
Here is what I did:
1. I renamed snprintf() to p
On Fri, 21 Jan 2005 12:17:08 -0800, Josh Berkus wrote:
> I'm proposing to expand both the coverage and number of "system views".
Generally: Nice. But have you considered if the INFORMATION_SCHEMA could
be used? Unfortunately, the INFORMATION_SCHEMA currently has a major
problem in its usefulness
Jim C. Nasby wrote:
On another naming note; the naming convention for system stuff has
always driven me nuts. Some the letter prefix (ie: tab for tables) in
front of every field name, with no underscores or anything. Extensive
use of abbreviations that you need to remember (ie: indnatts, indexprs,
On Sat, 2005-01-22 at 00:18 -0600, Jim C. Nasby wrote:
> 1) I'm in favor of autotuning anything possible.
> 2) In addition to turning group_commit on and off, what about also
> adjusting the commit delay, based on statistics of recent commits? It
> might require a slightly larger sample set (maybe
35 matches
Mail list logo
