On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> On Fri, Jul 09, 2004 at 11:28:23PM +0200, Dennis Bjorklund wrote:
> > On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> >
> > > Yes, we free some things. Granted it's not a lot, but we have stacks
> > > for several things that will be always be growing with s
On Fri, 9 Jul 2004, Mike Rylander wrote:
> Nested transactions and savepoints serve two different purposes. They have
> some overlap, but for the most part solve two distinct problems.
Then show some examples that illustrait the difference. So far all
examples shown that uses subtransactions co
this leads me to the first question I asked... do you want me to pull
the latest cvs and patch it... or distribute my patch for 7.4.3?
Tom Lane wrote:
[ catching up on this discussion a bit late... ]
Alvaro Herrera <[EMAIL PROTECTED]> writes:
You haven't shown us the patch, have you?
That was pr
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Do we want to add this to TODO:
> * Issue an extra message when COMMIT completes a failed transaction
No --- it's (a) wordy and (b) not responsive to the original complaint,
which was that a client that examines command completion tags will be
eas
On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> I mean this:
>
> begin;
> ... work ...;
> savepoint foo;
> ... more work ...;
> savepoint bar;
> ... yet more ... ;
> release foo;
>
>
> At this time I can't release savepoint foo because the implementation
> (nested) requires me to keep i
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> How come I default to Antartica in CVS?
You tell us ... what's your real timezone, and what do you get from
pushing up the log level to DEBUG4 during postmaster start?
regards, tom lane
---(end
[ catching up on this discussion a bit late... ]
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> You haven't shown us the patch, have you?
That was pretty much the point that leapt out at me. For a change of
this magnitude, there is absolutely zero chance that we'll accept an
implementation sight u
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> (We could talk about exception support in plpgsql or other language
> handlers but I don't think this is going to happen for 7.5.)
Au contraire ... I think it *must* happen, and indeed that
subtransaction support in plpgsql is not different from excepti
If there's something missing in the format, I'd be inclined to add it.
We've never promised to make dumps made by version X readable (or
usable) by version X-1. We *do* the opposite, however, so you will
probably still need to parse dump statements from old dump files. Unless
we can back-patch.
Andrew Piskorski <[EMAIL PROTECTED]> writes:
> Another thing I've been wondering about, but haven't been able to find
> any discussion of:
> Just how closely tied is PostgreSQL to its use of shared memory?
Pretty damn closely. You would not be happy with the performance of
anything that tried to
Hello,
I know there is a patch coming Monday with a great deal of bug fixes.
J
On Fri, 9 Jul 2004, Tom Lane wrote:
> Andrew Dunstan <[EMAIL PROTECTED]> writes:
> > OK, I have a setup that instead of refusing to load trusted functions if
> > the Safe version is not up to date, forces them to e
At 12:19 PM 29/06/2004, Christopher Kings-Lynne wrote:
It's hacky (although officially hacky :) ) in regards that it parses the
dropStmt on each object to get the objects name. This is necessary
because of an oversight in the initial design of the binary format.
If there's something missing in t
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> OK, I have a setup that instead of refusing to load trusted functions if
> the Safe version is not up to date, forces them to error out by calling
> elog(ERROR...), thus:
> andrew=# select tval();
> ERROR: trusted perl functions disabled - please upg
TODO item?
---
Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> > The other thing we need are these two commands:
>
> > ALTER DATABASE foo SET TABLESPACE spc;
> > ALTER SCHEMA foo SET TABLESPACE spc;
On Sat, Jul 10, 2004 at 09:46:56AM +1200, Oliver Jowett wrote:
> Alvaro Herrera wrote:
>
> >We can't actually release anything (commit the subtransactions), because
> >they may be savepoints established after that point, and they are
> >logically "inside" the previously established ones. At RELEA
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> The other thing we need are these two commands:
> ALTER DATABASE foo SET TABLESPACE spc;
> ALTER SCHEMA foo SET TABLESPACE spc;
> I think these should not be considered new features but essential
> functionality left out of the original patch
On Fri, Jul 09, 2004 at 11:28:23PM +0200, Dennis Bjorklund wrote:
> On Fri, 9 Jul 2004, Alvaro Herrera wrote:
>
> > Yes, we free some things. Granted it's not a lot, but we have stacks
> > for several things that will be always be growing with savepoints,
>
> They will not always be growing for
Where are we on this, 2x. :-)
---
Bruce Momjian wrote:
>
> Where are we on this?
>
> ---
>
> Tom Lane wrote:
> > Manfred Koizar <[EMAIL PROTECTED]>
Jan Wieck wrote:
> On 6/10/2004 2:11 AM, Tom Lane wrote:
>
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> Are people OK with requiring PGUSER, $USER, $LOGNAME, or the username to
> >> be supplied by the connection string in libpq on platforms that want
> >> threads and don't have getpwuid_r()
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> [shrug...] I'd counsel leaving this as-is.
> What information are we loosing by having START and BEGIN use the same
> nodes? Knowing what keyword they used to start the transaction?
Exactly.
> Seems that would only be important if
Jan Wieck wrote:
> > I looked over the code and the only place getpwuid_r (through
> > pqGetpwuid) is used is in libpq to look up the default username based on
> > the euid for the connection to the backend. Unfortunately, I can't find
> > any other way to do such a lookup in a thread-safe manner
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I also don't see LOG used much in the code at all. It seems to be used
> > mostly by VACUUM and ANALYZE. Seems something is wrong.
>
> There is nothing wrong except that you've forgotten how we designed
> VACUUM VERBOSE to work with
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I also don't see LOG used much in the code at all. It seems to be used
> mostly by VACUUM and ANALYZE. Seems something is wrong.
There is nothing wrong except that you've forgotten how we designed
VACUUM VERBOSE to work with the new logging-levels stuf
Jonah,
> I have seen some discussion about using OS-level quotas on a user or
> group level, however, like our Oracle system, not all database users
> have a system account. This is why I needed to implement user-specific
> quota functionality within the database itself.
Agreed. Also, imple
Have you read the developers FAQ?
http://developers.postgresql.org
---
[EMAIL PROTECTED] wrote:
> Dear Sir:
>
> I am a graduate student of computer science at University of Ottawa.
> Professor Kiringa is my super
Min Xu (Hsu) wrote:
> Dear all,
>
> I've being following the discussion of the nested transaction. I
> apologize for that I can't help asking my questions as I get more
> confused about what exactly are nested transactions, at least as far as
> the concurrency control goes.
>
> It seems to me
Stephen Frost wrote:
* Rod Taylor ([EMAIL PROTECTED]) wrote:
Simply setup a tablespace for a given user with permissions to allow
only that user to create new objects within it and make it the default
location) -- tie their schema to their tablespace? -- then set a kernel
level quota on their tabl
We have user-defined aggregates written in C running inside the server.
We are running into some memory management issues and wondering what
is the best way to solve the problem.
The state of the aggregates is a structure with a pointer to allocated
memory. The structure and memory are alloca
Hi,
I would like to knwo how to extends the storage manager to other device
( i try to add remote device to postgres engine).
I saw that i have to implement the interface f_smgr describe in smgr.c
, but I do not know how to tell to postgres to use my new device .
Is anyone could help me
Thanks
pi
Oliver Jowett wrote:
The 2003 draft claims that RELEASE SAVEPOINT invalidates savepoints
subsequent to the RELEASE:
"subsequent to the released savepoint" rather.
-O
---(end of broadcast)---
TIP 6: Have you searched our list archives?
h
On Thu, 8 Jul 2004, Simon Riggs wrote:
> We don't need to mention timelines in the docs, nor do we need to alter
> pg_controldata to display it...just a comment in the code to explain why
> we add a large number to the LogId after each recovery completes.
I'd disagree on that. Knowing what exactl
Hi,
while playing around with the tablespace stuff I noticed that on can't see
the tablespace a table is in when querying the pg_tables view.
I think the tablespace a table is in is a valuable information and should
be shown there. This also applies to any ohter related view (like
pg_indexes etc.
Dennis Bjorklund wrote:
> On Fri, 9 Jul 2004, Bruce Momjian wrote:
>
>> I think we agreed on BEGIN NESTED/COMMIT NESTED, and START NESTED
>> TRANSACTION and COMMIT NESTED TRANSACTION.
>
> Should I read this as pg will get its own implementation of sub
> transactions and not implement the almost
Hello
I have the same problem, discussed earlier in the groups, but not even
able to solve it and run psql/creatdb etc., of postgres. I have tried
uncommenting the TCPIP_SOCKET=True and port= lines in the
postgressql.conf inside my data directory.
I am not using cygwin too on windows environment.
Dear Sir:
I am a graduate student of computer science at University of Ottawa.
Professor Kiringa is my supervisor.
Currently, I am working on a group project. As part of the project, I
would like to implement a new feature for the trigger creation in
PostgreSQL, which defines aliases for the "o
Alvaro Herrera wrote:
We can't actually release anything (commit the subtransactions), because
they may be savepoints established after that point, and they are
logically "inside" the previously established ones. At RELEASE we can't
really release -- we just lose the name and thus the opportunity
Atached patch fix this bug
Serg
Andrew Dunstan wrote:
Can anyone suggest why I might be seeing this effect (each notice
comes out once per row plus once per function call)
thanks
andrew
andrew=# create function tstset() returns setof tst language plperl as $$
andrew$# elog(NOTICE,"tstset called")
I forgot to mention that in fact i will have an
ordered table of dates ( i mean by ordered i will do an order by before applying
the aggregate) for different users.
That's why i need an aggregate ( i have to do a
group by)
so i have something like this
01/01/2004 user1
08/01/2004
Atached patch fix the problem.
Serg
Andrew Dunstan wrote:
Can anyone suggest why I might be seeing this effect (each notice
comes out once per row plus once per function call)
thanks
andrew
andrew=# create function tstset() returns setof tst language plperl as $$
andrew$# elog(NOTICE,"tstset call
On Tue, 6 Jul 2004, Zeugswetter Andreas SB SD wrote:
> > Should we use a different datatype than time_t for the commit timestamp,
> > one that offers more fine grained differentiation between checkpoints?
>
> Imho seconds is really sufficient. If you know a more precise position
> you will probabl
On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> Yes, we free some things. Granted it's not a lot, but we have stacks
> for several things that will be always be growing with savepoints,
They will not always be growing for savepoints, you can free things when
using savepoints just as with subtransac
Dear all,
I've being following the discussion of the nested transaction. I
apologize for that I can't help asking my questions as I get more
confused about what exactly are nested transactions, at least as far as
the concurrency control goes.
It seems to me there are two different types of nest
Alvaro Herrera wrote:
On Fri, Jul 09, 2004 at 10:38:15AM -0500, Thomas Swan wrote:
visibility issue and how far do you unwind the depth of subtransactions
or transactions?
BEGIN
UPDATE A
SAVEPOINT X
BEGIN
BEGIN
UPDATE B
BEGIN
UPDATE C
ROLLBACK TO SAVEPOINT X
What hap
On Fri, Jul 09, 2004 at 04:07:19PM -0400, Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > We can't actually release anything (commit the subtransactions), because
> > they may be savepoints established after that point, and they are
> > logically "inside" the previously established ones. At RELE
Simon Riggs wrote:
> On Fri, 2004-07-09 at 21:18, Bruce Momjian wrote:
> > Simon Riggs wrote:
> > >
> > > Oracle uses ROLLBACK TO SAVEPOINT...identical pretty much.
> >
> > I thouht ROLLBACK was different from RELEASE, no? I see ROLLBACK used
> > in SQL99 for savepoints:
> >
> > ROLLBAC
On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> > Simon posted it. It is called RELEASE:
>
> We can't actually release anything (commit the subtransactions), because
> they may be savepoints established after that point, and they are
> logically "inside" the previously established ones. At RELEASE
On Fri, 2004-07-09 at 21:18, Bruce Momjian wrote:
> Simon Riggs wrote:
> >
> > Oracle uses ROLLBACK TO SAVEPOINT...identical pretty much.
>
> I thouht ROLLBACK was different from RELEASE, no? I see ROLLBACK used
> in SQL99 for savepoints:
>
> ROLLBACK [ WORK ] [ AND [ NO ] CHAIN ]
>
Simon Riggs wrote:
> On Fri, 2004-07-09 at 20:34, Bruce Momjian wrote:
> > Alvaro Herrera wrote:
> > > On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
> > > > On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> > > >
> > > > > Clearly savepoints do not allow for a snapshot to be released
Alvaro Herrera wrote:
> On Fri, Jul 09, 2004 at 03:34:47PM -0400, Bruce Momjian wrote:
> > Alvaro Herrera wrote:
> > > On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
> > > > On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> > > >
> > > > > Clearly savepoints do not allow for a snapsho
On Fri, 2004-07-09 at 20:34, Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
> > > On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> > >
> > > > Clearly savepoints do not allow for a snapshot to be released; nested
> > > > xacts do.
> >
On Fri, Jul 09, 2004 at 03:34:47PM -0400, Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
> > > On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> > >
> > > > Clearly savepoints do not allow for a snapshot to be released; nested
> > > > x
Alvaro Herrera wrote:
> On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
> > On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> >
> > > Clearly savepoints do not allow for a snapshot to be released; nested
> > > xacts do.
> >
> > Why not?
>
> What is it?
Simon posted it. It is called
OK.
---
Christopher Kings-Lynne wrote:
> Only if you commit my pg_dump patch that's in the queue.
>
> Chris
>
> Bruce Momjian wrote:
>
> > Is this fixed in 7.5?
> >
> > ---
While Alvarro, et al are messing with transaction syntax
this would be a good time to clarify this message.
--elein
On Fri, Jul 09, 2004 at 10:16:29AM -0400, Bruce Momjian wrote:
>
> Do we want to add this to TODO:
>
> * Issue an extra message when COMMIT completes a failed transaction
>
On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
> On Fri, 9 Jul 2004, Alvaro Herrera wrote:
>
> > Clearly savepoints do not allow for a snapshot to be released; nested
> > xacts do.
>
> Why not?
What is it?
--
Alvaro Herrera ()
"Pensar que el espectro que vemos es ilusorio no
On Fri, 2004-07-09 at 16:47, Alvaro Herrera wrote:
> On Fri, Jul 09, 2004 at 10:38:15AM -0500, Thomas Swan wrote:
>
> > visibility issue and how far do you unwind the depth of subtransactions
> > or transactions?
> >
> > BEGIN
> > UPDATE A
> > SAVEPOINT X
> > BEGIN
> >BEGIN
> > UPDAT
On Fri, 9 Jul 2004, Alvaro Herrera wrote:
> Clearly savepoints do not allow for a snapshot to be released; nested
> xacts do.
Why not?
> OTOH savepoints are trivial to implement once nested xacts are in place.
> They are only syntactic sugar.
Not only, but simple yes. I'm just opposed to having
On Fri, Jul 09, 2004 at 07:10:06PM +0200, Dennis Bjorklund wrote:
> On Fri, 9 Jul 2004, Bruce Momjian wrote:
>
> > I think we agreed on BEGIN NESTED/COMMIT NESTED, and START NESTED
> > TRANSACTION and COMMIT NESTED TRANSACTION.
>
> Should I read this as pg will get its own implementation of sub
>
On Thu, 2004-07-08 at 20:14, Alvaro Herrera wrote:
> On Thu, Jul 08, 2004 at 06:33:56PM +0100, Simon Riggs wrote:
> > On Thu, 2004-07-08 at 16:19, Alvaro Herrera wrote:
> > > On Thu, Jul 08, 2004 at 02:58:01PM +0100, Simon Riggs wrote:
> > >
> > > The correct solution would be to emit a XLog recor
On Fri, 2004-07-09 at 11:45, Andreas Pflug wrote:
> Simon Riggs wrote:
>
> >ISTM - my summary would be
> >1. We seem to agree we should support SAVEPOINTs
> >
> >2. We seem to agree that BEGIN/COMMIT should stay unchanged...
> >
> >
> >
> >>With savepoints, it looks pretty strange:
> >>
> >>
Only if you commit my pg_dump patch that's in the queue.
Chris
Bruce Momjian wrote:
Is this fixed in 7.5?
---
Christopher Kings-Lynne wrote:
If you do this sequence of events, you get a failure to restore:
1. As superuser, do t
On Fri, 9 Jul 2004, Jonah H. Harris wrote:
- Would anyone want to use a group quota in PGSQL (rather than user-only)?
Yes ... I could see this as being more useful, not less ... where you have
a dept working on a database, but individual logins for audit logging ...
- I assume that, based on disc
I have an intermittent problem with PostgreSQL 7.3.2 on Solaris 8.
The backend process crashes once in a while, with this in the database log:
... ...
2004-07-05 22:43:54 LOG: database system is ready
IpcSemaphoreInitialize: semctl(id=65615, 14, SETVAL, 0) failed:
Invalid argument
2004-07-06 09:1
On Fri, 9 Jul 2004, Bruce Momjian wrote:
> I think we agreed on BEGIN NESTED/COMMIT NESTED, and START NESTED
> TRANSACTION and COMMIT NESTED TRANSACTION.
Should I read this as pg will get its own implementation of sub
transactions and not implement the almost equivalent standard (sql99)
savepoint
Stephen Frost wrote:
* Rod Taylor ([EMAIL PROTECTED]) wrote:
On Fri, 2004-07-09 at 11:47, Stephen Frost wrote:
* Klaus Naumann ([EMAIL PROTECTED]) wrote:
On Thu, 8 Jul 2004, Jonah H. Harris wrote:
3. The maximum quota size is (currently) the maximum of int4*1024 bytes.
why is this? This is very li
* Rod Taylor ([EMAIL PROTECTED]) wrote:
> On Fri, 2004-07-09 at 11:47, Stephen Frost wrote:
> > * Klaus Naumann ([EMAIL PROTECTED]) wrote:
> > > On Thu, 8 Jul 2004, Jonah H. Harris wrote:
> > > > 3. The maximum quota size is (currently) the maximum of int4*1024 bytes.
> > >
> > > why is this? This
On Fri, Jul 09, 2004 at 10:22:49AM -0600, Jonah H. Harris wrote:
> Quota is currently enforced on commit. I've considered checking during
> insert/update/copy and throwing an abort but within a transaction they
> may be deleting data as well.
How do you do it? Do you add relblocks from all tab
James Robinson wrote:
On Jul 9, 2004, at 12:04 PM, Jonah H. Harris wrote:
- Quota acts on any object owned by the user. Is this adequate for
everyone?
Does changing owner also trigger new quota calculations on both the new
and old owner?
Quota calculations are performed per-owner at commit ti
* Rod Taylor ([EMAIL PROTECTED]) wrote:
> > > Group quotas should be sufficient. Create directory readable/writable to
> > > only the pgsql user, but have the group ownership be representative of
> > > the user in question.
> >
> > Rather ugly, and you'll run out of groups if you have alot of user
On Fri, Jul 09, 2004 at 10:04:01AM -0600, Jonah H. Harris wrote:
> I'd like to make the following changes... Let me know your thoughts.
>
> - userquota is stored in units of kilobytes... is this adequate? Would
> anyone ever use a quota < 1K other than for allowing a user no space?
> If the u
On Fri, 9 Jul 2004, Stephen Frost wrote:
Hi,
> > why is this? This is very limiting ...
>
> It's 2TB...
Yeah, you're right. I didn't take into account, that you multiply it with
1kb - my fault.
2TB is enough - at the moment at least. But implementing it in 64 from now
on could save a lot of work
On Fri, 2004-07-09 at 11:47, Stephen Frost wrote:
> * Klaus Naumann ([EMAIL PROTECTED]) wrote:
> > On Thu, 8 Jul 2004, Jonah H. Harris wrote:
> > > 3. The maximum quota size is (currently) the maximum of int4*1024 bytes.
> >
> > why is this? This is very limiting ...
>
> It's 2TB...
Okay.. that
On Jul 9, 2004, at 12:04 PM, Jonah H. Harris wrote:
- Quota acts on any object owned by the user. Is this adequate for
everyone?
Does changing owner also trigger new quota calculations on both the new
and old owner?
Is there any additional functionality you would like to see in a quota
implem
Quota is currently enforced on commit. I've considered checking during
insert/update/copy and throwing an abort but within a transaction they
may be deleting data as well.
However, even as a delete may take place before a massive insert/update,
a vacuum cannot be run within a transaction block
Pavel Stehule wrote:
> >
> > An 'END SUB' after a 'BEGIN SUB' in plpgsql could be required, and could
> > mean start/end block and subtx. I do not really see a downside.
> > But, it would imho only make sense if the 'END SUB' would commit sub
> > or abort sub iff subtx is in aborted state (see my
> > Group quotas should be sufficient. Create directory readable/writable to
> > only the pgsql user, but have the group ownership be representative of
> > the user in question.
>
> Rather ugly, and you'll run out of groups if you have alot of users (the
> postgres user can only be in so many grou
>
> An 'END SUB' after a 'BEGIN SUB' in plpgsql could be required, and could
> mean start/end block and subtx. I do not really see a downside.
> But, it would imho only make sense if the 'END SUB' would commit sub
> or abort sub iff subtx is in aborted state (see my prev posting)
>
> Andreas
>
H
There are a couple of modifications that I'd still like to make to user
quotas. Because 7.5 is locked, this may be a good time to discuss the
implementation (possibly for 7.6?)
I have seen some discussion about using OS-level quotas on a user or
group level, however, like our Oracle system, no
On Fri, Jul 09, 2004 at 10:38:15AM -0500, Thomas Swan wrote:
> visibility issue and how far do you unwind the depth of subtransactions
> or transactions?
>
> BEGIN
> UPDATE A
> SAVEPOINT X
> BEGIN
>BEGIN
> UPDATE B
> BEGIN
>UPDATE C
>ROLLBACK TO SAVEPOINT X
What
* Klaus Naumann ([EMAIL PROTECTED]) wrote:
> On Thu, 8 Jul 2004, Jonah H. Harris wrote:
> > 3. The maximum quota size is (currently) the maximum of int4*1024 bytes.
>
> why is this? This is very limiting ...
It's 2TB...
> Using a 64bit value would be a lot more straight foreward.
It sounded to
Andreas Pflug wrote:
Simon Riggs wrote:
ISTM - my summary would be
1. We seem to agree we should support SAVEPOINTs
2. We seem to agree that BEGIN/COMMIT should stay unchanged...
With savepoints, it looks pretty strange:
BEGIN;
SAVEPOINT x1;
INSERT INTO ...;
SAVEPOINT x2;
IN
On Thu, Jul 08, 2004 at 03:27:34PM -0600, Jonah H. Harris wrote:
> Out of necessity, I've implemented user quotas in 7.4.3. What would the
> process be for having this reviewed and combined? I have a patch for
> 7.4.3 ready, but wanted to know if you suggest that I patch the latest
> cvs inst
* Rod Taylor ([EMAIL PROTECTED]) wrote:
> > > > Since the user accessing/writing to the tablespaces would be the
> > > > postgres user I don't really think this 'solution' works in reality.
> > >
> > > I had assumed it would be a directory based quota rather than a user
> > > based one.
> >
> > I
> > > Since the user accessing/writing to the tablespaces would be the
> > > postgres user I don't really think this 'solution' works in reality.
> >
> > I had assumed it would be a directory based quota rather than a user
> > based one.
>
> It's been a while since I played with quotas but I don'
* Rod Taylor ([EMAIL PROTECTED]) wrote:
> > > Simply setup a tablespace for a given user with permissions to allow
> > > only that user to create new objects within it and make it the default
> > > location) -- tie their schema to their tablespace? -- then set a kernel
> > > level quota on their ta
Is this fixed in 7.5?
---
Christopher Kings-Lynne wrote:
> If you do this sequence of events, you get a failure to restore:
>
> 1. As superuser, do this:
>
> test2=# CREATE FUNCTION plpgsql_call_handler () RETURNS language
> > Simply setup a tablespace for a given user with permissions to allow
> > only that user to create new objects within it and make it the default
> > location) -- tie their schema to their tablespace? -- then set a kernel
> > level quota on their tablespace.
>
> Since the user accessing/writing
* Rod Taylor ([EMAIL PROTECTED]) wrote:
> I would think having would allow us to take advantage of all of the
> various kernel level filesystem features without needing to implement
> them directly within PostgreSQL (crypto, quotas, data mirror, etc.).
>
> Simply setup a tablespace for a given use
On Fri, 2004-07-09 at 10:14, Rod Taylor wrote:
> On Fri, 2004-07-09 at 09:29, Stephen Frost wrote:
> > * Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote:
> > > >Personally, I would love to see this in PostgreSQL. It'd be great if it
> > > >could get into 7.5. An issue I see with that is that (s
On Thu, 8 Jul 2004, Jonah H. Harris wrote:
Hi,
> 3. The maximum quota size is (currently) the maximum of int4*1024 bytes.
why is this? This is very limiting ...
Using a 64bit value would be a lot more straight foreward.
Greetings, Klaus
--
Full Name : Klaus Naumann | (http://www.mgnet.d
Do we want to add this to TODO:
* Issue an extra message when COMMIT completes a failed transaction
---
elein wrote:
>
>
>
> On Sun, Mar 28, 2004 at 10:23:26AM -0500, Tom Lane wrote:
> > Bruce Momjian <[EMAIL PR
On Fri, 2004-07-09 at 09:29, Stephen Frost wrote:
> * Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote:
> > >Personally, I would love to see this in PostgreSQL. It'd be great if it
> > >could get into 7.5. An issue I see with that is that (similar to
> > >Oracle...) I think people would want to
On Fri, 9 Jul 2004, Christopher Kings-Lynne wrote:
Personally, I would love to see this in PostgreSQL. It'd be great if it
could get into 7.5. An issue I see with that is that (similar to
Oracle...) I think people would want to be able to specify
per-tablespace quotas. Perhaps that wouldn't be t
On Fri, 9 Jul 2004, Stephen Frost wrote:
* Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote:
Personally, I would love to see this in PostgreSQL. It'd be great if it
could get into 7.5. An issue I see with that is that (similar to
Oracle...) I think people would want to be able to specify
per-tab
> >But 'BEGIN' in plpgsql does not start a [sub]transaction, it starts a
> >statement block. Are we intending to change that ? I think not.
> >
> >
> >
> There are two possibilities:
> Either BEGIN *does* start a subtransaction, or BEGIN does not. I don't
> see how two nesting level hierarchie
Le jeu 08/07/2004 à 14:22, Andrew Piskorski a écrit :
> You want to do clustering for failover/reliability reasons, for
> performance/scalability reasons, or for both?
for all that of course :)
> For some stuff to read, see the dozen or so links I posted here:
>
> http://openacs.org/forums/mess
* Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote:
> >Personally, I would love to see this in PostgreSQL. It'd be great if it
> >could get into 7.5. An issue I see with that is that (similar to
> >Oracle...) I think people would want to be able to specify
> >per-tablespace quotas. Perhaps that
Personally, I would love to see this in PostgreSQL. It'd be great if it
could get into 7.5. An issue I see with that is that (similar to
Oracle...) I think people would want to be able to specify
per-tablespace quotas. Perhaps that wouldn't be too hard to add?
7.5 is already closed for new featu
* Jonah H. Harris ([EMAIL PROTECTED]) wrote:
> Out of necessity, I've implemented user quotas in 7.4.3. What would the
> process be for having this reviewed and combined? I have a patch for
> 7.4.3 ready, but wanted to know if you suggest that I patch the latest
> cvs instead. Below if some i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I've prepared a patch(against CVS HEAD of today) to pg_dump.c to
make pg_dump understand multiple -t options for dumping multiple tables
in one command.
Eks:
pg_dump -t table1 -t table2 -t table3
The patch is here:
http://home.officenet.no/~andreak
1 - 100 of 105 matches
Mail list logo