So I'd like to add a GUC variable called something like
"scratch_tablespace". If undefined (the default), temporary files for
Should be called 'work_tablesapce' to match 'work_mem' :)
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands
I'd like to provide a way for DBAs to specify that the temporary files
needed to for sorting, holdable cursors and similar operations should be
created in a particular tablespace. (Right now these files are created
in the tablespace associated with the current database.)
Two ways to do this come t
Gavin Sherry <[EMAIL PROTECTED]> writes:
> On Thu, 28 Oct 2004, Alvaro Herrera wrote:
>> Ok, so no opinions? Nobody objects to me creating two new shared
>> catalogs to keep track of dependency on global objects, one for
>> user/groups and other for tablespaces?
> Perhaps we could (gulp) reenable
Neil,
> pg_functions might be useful, but what would pg_users offer that pg_user
> does not already do?
Show a list of groups that the user belongs to? Same thing with pg_groups;
showing the list of users in the group.
> A pg_sequences view might also be handy.
Yes. Anything else? So far I
psql's slash commands for schemas seem a little weird to me. For
example:
neilc=# \d nonexistent
Did not find any relation named "nonexistent".
neilc=# \dt nonexistent
No matching relations found.
neilc=# \dn nonexistent
List of schemas
Name | Owner
--+---
(0 rows)
-- Is there a good re
Right. From a bare-functionality point of view there's nothing wrong
with it, it just seems inconsistent and therefore likely to trip someone
up in future.
But it seems no one else cares, so I'll shut up about it ...
I'm happy to have it fixed or changed :) I was just pointing out why it
was lik
On Fri, 2004-10-29 at 07:35, Josh Berkus wrote:
> Is there any reason that we don't have pg_functions, pg_users, pg_groups and
> other system views?pg_tables and pg_views is really useful, but it would
> be good to cover the other items as well.
pg_functions might be useful, but what would p
> Hi Tatsuo,
>
> I've made a new release:
> http://prdownloads.sourceforge.net/osdldbt/dbt3-v1.5.tar.gz?download
>
> Let me know if there are any problems.
Thanks!
> On Tue, Oct 26, 2004 at 12:44:49PM +0900, Tatsuo Ishii wrote:
> > Hi,
> >
> > Thanks for the info. Would you give me the t
On Thu, 28 Oct 2004, Alvaro Herrera wrote:
> On Thu, Oct 28, 2004 at 01:30:31AM -0300, Alvaro Herrera wrote:
>
> Hi,
>
> > So the first obvious question: should I create two separate catalogs,
> > one for users and other for tablespaces?
>
> Ok, so no opinions? Nobody objects to me creating two n
On October 28, 2004 03:32 pm, Tom Lane wrote:
> Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> > On October 20, 2004 10:26 am, you wrote:
> >> The buildfarm has identified yet another failure under SPARC/Solaris 8
> >> as outlined in.
>
> Most likely this is fixed by Kris Jurka's just-applied patc
On Thu, Oct 28, 2004 at 01:30:31AM -0300, Alvaro Herrera wrote:
Hi,
> So the first obvious question: should I create two separate catalogs,
> one for users and other for tablespaces?
Ok, so no opinions? Nobody objects to me creating two new shared
catalogs to keep track of dependency on global
[EMAIL PROTECTED] wrote:
> I agree with all that you say Tom, I'm just asking for some help to debug
> this, Now that Larry is a litle off the list, I'm feeling really lonely on
> UW.
> SCO won't do anything until I come up with a test program that fails. All
> my tries did work until then.
>
> I
Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> >> pg_get_serial_sequence() does dequoting/downcasing on its relation-name
> >> argument, but not on its column-name argument.
>
> > I presume the reason for that is that the first paramater can be qualified:
>
> Right. From
Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> On October 20, 2004 10:26 am, you wrote:
>> The buildfarm has identified yet another failure under SPARC/Solaris 8 as
>> outlined in.
Most likely this is fixed by Kris Jurka's just-applied patch.
regards, tom lane
--
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > On Thu, 28 Oct 2004, Tom Lane wrote:
> >> No. Why should the signal handler need re-arming?
>
> > My impression was that once caught, signal handler for a particular signal
> > is reset to SIG-DFL.
>
> No. If your signal support is POSIX-compatibl
Folks,
Is there any reason that we don't have pg_functions, pg_users, pg_groups and
other system views?pg_tables and pg_views is really useful, but it would
be good to cover the other items as well.
Is there a reason not to have these other than that they're not coded? If
not, I'll get w
On October 20, 2004 10:26 am, you wrote:
> The buildfarm has identified yet another failure under SPARC/Solaris 8 as
> outlined in.
>
This is an update to the build failure the log can now be seen at
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=potorooo&dt=2004-10-26%2020:30:01
and it's proba
Darcy,
I have been working on it all day. Not the fastest systems. Jusy an FYI, I have
started on a Debian PKG file for
the pg build system. My plan is to get ALL of the dependencies worked out and let APT
fix my system.
Jim
-- Original Message ---
From: Darcy Buskermo
I agree with all that you say Tom, I'm just asking for some help to debug
this, Now that Larry is a litle off the list, I'm feeling really lonely on
UW.
SCO won't do anything until I come up with a test program that fails. All
my tries did work until then.
I use other threaded progs like postfix o
[EMAIL PROTECTED] writes:
> On Thu, 28 Oct 2004, Tom Lane wrote:
>> No. Why should the signal handler need re-arming?
> My impression was that once caught, signal handler for a particular signal
> is reset to SIG-DFL.
No. If your signal support is POSIX-compatible, it should not do that
because
On Thu, 28 Oct 2004, Tom Lane wrote:
> Date: Thu, 28 Oct 2004 12:11:12 -0400
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Unixware 714 pthreads
>
> [EMAIL PROTECTED] writes:
> > if i do it a second time in the same session, blockme()
On October 27, 2004 05:57 pm, Jim Buttafuoco wrote:
> Hackers,
>
> just an fyi, Beta 4 passed ALL tests on Debian Sarge for both MIPS (Indy)
> and MIPSEL (Cobalt RAQ)
>
> I can test Debian Sarge Sparc, Alpha, PowerPC, PA-RISC and M68K if no one
> else has reported on these systems yet.
>
> Also, wi
Tom Lane wrote:
[EMAIL PROTECTED] writes:
if i do it a second time in the same session, blockme() never returns
I wonder if handle_sig_alarm is re-armed after being used
No. Why should the signal handler need re-arming?
or if sleep is used anywhere in the backend.
Nope.
[EMAIL PROTECTED] writes:
> if i do it a second time in the same session, blockme() never returns
> I wonder if handle_sig_alarm is re-armed after being used
No. Why should the signal handler need re-arming?
> or if sleep is used anywhere in the backend.
Nope.
regards,
Hi Tatsuo,
I've made a new release:
http://prdownloads.sourceforge.net/osdldbt/dbt3-v1.5.tar.gz?download
Let me know if there are any problems.
On Tue, Oct 26, 2004 at 12:44:49PM +0900, Tatsuo Ishii wrote:
> Hi,
>
> Thanks for the info. Would you give me the tarball?
-
Sorry to follow up my own post.
I made some more tests:
create table foo (f1 int) -- for it not to be removed if if kill the
process
each time I do:
psql template1
template1# set statement_timeout=1000;
SET
template1 select block_me();
it works ok
if i do it a second time in the same session, b
--On Dienstag, Oktober 26, 2004 23:44:10 +0300 Hannu Krosing <[EMAIL PROTECTED]>
wrote:
Thus I think that reserved keyword is what it is meant to be in the
first place ;)
Yes, that was my intention, too. That's because i went straight forward and
put it in the reserved keyword list and didn't sp
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> pg_get_serial_sequence() does dequoting/downcasing on its relation-name
>> argument, but not on its column-name argument.
> I presume the reason for that is that the first paramater can be qualified:
Right. From a bare-functionality point of
28 matches
Mail list logo