From: | Rajni Baliyan <rajni(dot)baliyan(at)ashnik(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Lonni J Friedman <netllama(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: postgres FDW cost estimation options unrecognized in 9.3-beta1 |
Date: | 2014-02-03 12:59:32 |
Message-ID: | CAFQAmHR0899AfgvuwJfb7S5xHdLnPNDV_cYZ1ivYsT9y9W271A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi All,
Is there any way to automate the archive deletion process. Any script or
command in HA setup using pgpool
Thanks in advance
Best Regards,
*Rajni Baliyan | Database - Consultant*
*ASHNIK PTE. LTD.*101 Cecil Street, #11-11 Tong Eng Building, Singapore
069533
M : +65 83858518 T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz
[image: email patch]
This email may contain confidential, privileged or copyright material and
is solely for the use of the intended recipient(s).
On Fri, Jan 31, 2014 at 11:22 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> On Fri, Jul 26, 2013 at 06:28:05PM -0400, Tom Lane wrote:
> > Our documentation appears not to disclose this fine point, but a look
> > at the SQL-MED standard says it's operating per spec. The standard also
> > says that ADD is an error if the option is already defined, which is a
> > bit more defensible, but still not exactly what I'd call user-friendly.
> > And the error we issue for that case is pretty misleading too:
> >
> > regression=# ALTER SERVER cuda_db10 OPTIONS (use_remote_estimate 'true')
> ;
> > ALTER SERVER
> > regression=# ALTER SERVER cuda_db10 OPTIONS (use_remote_estimate
> 'false') ;
> > ERROR: option "use_remote_estimate" provided more than once
> >
> > I think we could do with both more documentation, and better error
> > messages for these cases. In the SET-where-you-should-use-ADD case,
> > perhaps
> >
> > ERROR: option "use_remote_estimate" has not been set
> > HINT: Use ADD not SET to define an option that wasn't already set.
> >
> > In the ADD-where-you-should-use-SET case, perhaps
> >
> > ERROR: option "use_remote_estimate" is already set
> > HINT: Use SET not ADD to change an option's value.
> >
> > The "provided more than once" wording would be appropriate if the same
> > option is specified more than once in the command text, but I'm not sure
> > that it's worth the trouble to detect that case.
>
> Where are on this?
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Florian Weimer | 2014-02-03 13:44:01 | Re: 9.3.2 server creates hundreds of thousands of temporary files |
Previous Message | Andreas Lubensky | 2014-02-03 09:14:00 | Re: Large objects and savepoints - Snapshot reference leak |
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Krogh | 2014-02-03 13:59:29 | Re: GIN improvements part2: fast scan |
Previous Message | Robert Haas | 2014-02-03 12:36:15 | Re: narwhal and PGDLLIMPORT |