Would it be feasible for you to install a copy of postgresql for each
user, as that user? This might allow you to set up a quota per user.
Should they run out of space, postgresql will just start throwing errors
with references to no space left on the device (the specific errors will
be dependent
Hmm i did'nt know its already there.
in anycase it does not tells abt the simplification
that has been introduced in 7.3.x regarding SRFs.
regds
mallah.
4.25) How do I return multiple rows or columns from a function?
You can return result sets from PL/pgSQL functions using refcursors. See
Is there a way to do
pg_dump -h host1 -d db1 -t tbl1 -Fc | pg_restore -d db1 -h host2
selectively, when there are multiple tables named tbl1 in db1 on host1?
The following scenario clarifies the question:
I have two tables named exmpl_tbl, one in the schema "public" and the other
in the schema
You can't in 7.3, though you can in CVS thanks to Neil Conway.
Robert Treat
On Wed, 2003-02-26 at 01:09, Michael Weaver wrote:
> How can I conduct a dump of only selected schemas,
> I can dump a DB, I can dump a single table, but dump a schema?
>
> ,
>
> Mike Weaver
> Software Developer
>
You mean like http://www.postgresql.org/docs/faqs/FAQ.html#4.25 ?
Robert Treat
On Wed, 2003-02-26 at 02:13, Rajesh Kumar Mallah wrote:
>
> Hmmm Looks like this has become a FAQ :-)
>
> reds
> mallah.
>
> On Tuesday 25 February 2003 09:24 pm, Robert Treat wrote:
> > In version 7.3 they can do s
"Gaetano Mendola" <[EMAIL PROTECTED]> writes:
> select * from pg_locks where mode = 'ExclusiveLock';
> relation | database | transaction | pid | mode | granted
> --+--+-+---+---+-
> | | 2560899 | 20404 | Exclusi
Hi!
I'm working on an ISP, and we're testing Postgres to offer Database
Services to our clients.
We like to limit the maximum database size for each client (1 database
for client), but as far as I know postgres hasn't this functionality.
I've also tried to limit this size using system quotas b
