Divergences in view source code - both servers 9.3.5

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

Responses

Browse pgsql-general by date

  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?