Looking further I just found that, if we don't want query to scan through
child table then we should use ONLY during CREATE VIEW.
So if I replaced my create view query with:
CREATE view view_tp_sales as SELECT * FROM ONLY tp_sales;
Then INSERT stmt working find.
So when you create VIEW on top o
Dear All,
I succeed to find some Postgres note where similar issue is related to
NFS mount option 'intr'. It was recommended to use 'hard,nointr' on
Solaris NFS or do not use NFS at all. The default on SUN is 'intr' and
on Linux is 'nointr', even not specified. Surprisingly the issue doesn't
happe
On 2 July 2013 08:44, Rushabh Lathia wrote:
> Looking further I just found that, if we don't want query to scan through
> child table then we should use ONLY during CREATE VIEW.
>
> So if I replaced my create view query with:
>
> CREATE view view_tp_sales as SELECT * FROM ONLY tp_sales;
>
> Then I
On 26.06.2013 17:15, Tom Lane wrote:
Heikki Linnakangas writes:
We've discussed retrying short writes before, and IIRC Tom has argued
that it shouldn't be necessary when writing to disk. Nevertheless, I
think we should retry in XLogWrite(). It can write much bigger chunks
than most write() call
On 2 July 2013 09:30, Dean Rasheed wrote:
> I think the rewritten query should only use inheritance if inheritance
> was requested in the original query, *and* if inheritance was enabled
> in the view's query, per attached patch against HEAD.
On second thoughts, I think this should only apply to
The following bug has been logged on the website:
Bug reference: 8276
Logged by: Valery
Email address: valeriy.smir...@itv.ru
PostgreSQL version: 9.2.2
Operating system: Windows 7
Description:
I have russian letters in operating system user name.
During default Postgr
The following bug has been logged on the website:
Bug reference: 8277
Logged by: Nuno Carvalho
Email address: nuno...@hotmail.com
PostgreSQL version: 9.2.4
Operating system: windows 8 64 bit
Description:
good night, I can not install postgres on windows 8 64 bit whene
The following bug has been logged on the website:
Bug reference: 8278
Logged by: rostap
Email address: ros...@wdcarea.com
PostgreSQL version: 9.2.4
Operating system: mac os x
Description:
describe table does not list tables with the same names in different
schemas. on
Hello
2013/7/3 :
> The following bug has been logged on the website:
>
> Bug reference: 8278
> Logged by: rostap
> Email address: ros...@wdcarea.com
> PostgreSQL version: 9.2.4
> Operating system: mac os x
> Description:
>
> describe table does not list tables with the same n
