| 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: | Whole Thread | Raw Message | 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? |