Hi All,
It would be helpful if someone tell me, how to verify the streaming
replication started in standby server successfully, just after the service
is started ?? Like knowing the exit code of the service started...
I know we can do it by verifying the below functions after the service is
start
From: Bruce Momjian [mailto:br...@momjian.us]
Sent: Saturday, August 04, 2012 8:06 PM
On Sat, Aug 4, 2012 at 05:21:06PM +0300, Heikki Linnakangas wrote:
On 04.08.2012 11:01, Amit Kapila wrote:
>>Missed one point which needs to be handled is pg_upgrade
>
> I don't think there's anything to do fo
2012/8/6 Tom Lane :
> Andrew Dunstan writes:
>> On 08/05/2012 05:58 PM, Tom Lane wrote:
>>> Currently the patch only implements the syntax called out in the standard,
>>> namely that you can put LATERAL in front of a , which is
>>> to say a parenthesized sub-SELECT in FROM. It strikes me that it
Hi Robert,
> From: Robert Haas [mailto:robertmh...@gmail.com]
> On Thu, Aug 2, 2012 at 7:01 AM, Etsuro Fujita
> wrote:
> > The following is a comment at fileGetForeignPaths() in contrib/file_fdw.c:
> >
> > /*
> > * If data file was sorted, and we knew it somehow, we could insert
> >
Andrew Dunstan writes:
> On 08/05/2012 05:58 PM, Tom Lane wrote:
>> Currently the patch only implements the syntax called out in the standard,
>> namely that you can put LATERAL in front of a , which is
>> to say a parenthesized sub-SELECT in FROM. It strikes me that it might be
>> worth allowing
I wrote:
> While fooling around in the planner I realized that I have no idea what
> outer-level aggregates mean in a LATERAL subquery, and neither does
> Postgres:
> regression=# select 1 from tenk1 a, lateral (select * from int4_tbl b where
> f1 = max(a.unique1)) x;
> ERROR: plan should not ref
On 08/05/2012 05:58 PM, Tom Lane wrote:
I've been idly amusing myself by trying to hack up support for
SQL-standard LATERAL subqueries. I've got something that turns over,
more or less:
Awesome!!
Currently the patch only implements the syntax called out in the standard,
namely that you ca
I've been idly amusing myself by trying to hack up support for
SQL-standard LATERAL subqueries. I've got something that turns over,
more or less:
regression=# select * from int4_tbl a, lateral (select unique1,unique2 from
tenk1 b where a.f1 = unique1) x;
f1 | unique1 | unique2
+-+-
