Обсуждение: Divergences in view source code - both servers 9.3.5
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,
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
Edson Richter <edsonrichter@hotmail.com> writes: > 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? You've not shown us the whole output, but is this the first select in a UNION (or INTERSECT or EXCEPT) nest? If so, I'll bet a nickel that that Ubuntu server is not actually running 9.3.5; try "select version()" to confirm. The CentOS server is returning what I'd expect after commit 0652d77fb067137be22dc3e42aa60bffa26726ac. regards, tom lane
Right, Tom! (again :-) ) Ubuntu is running 9.3.4 (I've installed 9.3.5 - but for some reason, it have not started). I suppose I'll uninstall 9.3.4 and then install 9.3.5. Since it is a development machine, I can do that safely. Thanks for your fast and precise answer, as always! Atenciosamente, Edson Carlos Ericksson Richter On 08-12-2014 16:53, Tom Lane wrote: > select version()
Edson Richter <edsonrichter@hotmail.com> writes: > Ubuntu is running 9.3.4 (I've installed 9.3.5 - but for some reason, it > have not started). You probably just didn't restart the server after updating the package. I know that on Red Hat it's not customary for package updates to forcibly restart daemons, and the same is likely true on Debian derivatives. regards, tom lane