From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Divergences in view source code - both servers 9.3.5 |
Date: | 2014-12-08 18:13:50 |
Message-ID: | BLU436-SMTP2163E20F949E44CE92FAF2FCF640@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I do have two servers running 9.3.5.
One server is CentOS 6.5 x64 with all updates.
The other server is Ubuntu 14.04-1 x64 with all updates.
Both run PostgreSQL 9.3.5 x64 - one installed using YUM, other with APT.
When I compare source code of the same view, I get the following
differences:
*_On "Ubuntu" server:_*
( ( ( ( select
e.id,
e.nome as "empresa",
'1. nfe'::text as "tipo",
( select sum(arquivosimportados.contasucesso) as sum
_*On CentOS server:*_
select
e.id,
e.nome as "empresa",
'1. nfe'::text as "tipo",
( select sum(arquivosimportados.contasucesso) as sum
Why does the same CREATE VIEW statement result in different source codes
in the server side?
Regards,
--
Atenciosamente,
Edson Carlos Ericksson Richter
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2014-12-08 18:17:37 | Re: Speeding up an in-progress wraparound-preventing vacuum |
Previous Message | Jeff Janes | 2014-12-08 17:55:39 | Re: Will modifications to unlogged tables also be flused to disk? |