[GENERAL] recursive query returning extra rows in 8.4

Hi all, Using postgres 8.4.13 (latest that redhat provides in rhel6) the query below returns an extra row compared to running the same thing in later versions (tried 9.0, 9.1, 9.2 - they don't return the extra row). Just wondering if anyone had thoughts on why, and/or how to remove the dupli

Re: [GENERAL] werid error"index row size 3040 exceeds btree maximum, 2712" occur randomly

Thanks Tomas! However, in the example I sent, I already did a vacuum full right after deleted the rows causing problem, before created the index and got an error even the table is vacuumed. Note, the table is I temporarily created using create table as select *... so no other people is access

Re: [GENERAL] Postgresql 9.0.13 core dump

Laurentius Purba wrote: > I did google this error message, "...signal 10: Bus error.." and > found the issue with hardware problem, memory. > > Do you have any other pointers or clues that I can look into? Well, the very first thing I would do is to make sure that the OS and jail software was up

Re: [GENERAL] what is BIND in OS log for Postgresql

On 10/14/2013 03:22 PM, AI Rumman wrote: Hi, I got in my OS log using ps command as follows: postgres 17087 2770 0 Sep30 ?00:07:49 postgres: myapp appname 10.0.0.1(35607) BIND postgres 32545 2770 1 Oct01 ?00:19:09 postgres: myapp appname 10.0.0.1(35783) SELECT postgres 32546

[GENERAL] what is BIND in OS log for Postgresql

Hi, I got in my OS log using ps command as follows: postgres 17087 2770 0 Sep30 ?00:07:49 postgres: myapp appname 10.0.0.1(35607) BIND postgres 32545 2770 1 Oct01 ?00:19:09 postgres: myapp appname 10.0.0.1(35783) SELECT postgres 32546 2770 1 Oct01 ?00:15:25 postgres:

Re: [GENERAL] Postgresql 9.0.13 core dump

Hi Kevin, Thanks for your response. I did google this error message, "...signal 10: Bus error.." and found the issue with hardware problem, memory. Do you have any other pointers or clues that I can look into? -Laurent On Mon, Oct 14, 2013 at 4:33 PM, Kevin Grittner wrote: > Laurentius Purb

Re: [GENERAL] mod_auth_pgsql and Apache 2.4

Back in Dec 2012, I asked whether anyone had already updated mod_auth_pgsql to work with the new authentication framework in Apache 2.3+ I didn't get any replies so went ahead and made sufficient changes to get it working in our environment. I approached the maintainer/author about adding my p

Re: [GENERAL] like & optimization

On Sat, Oct 12, 2013 at 4:28 PM, Torsten Förtsch wrote: > On 12/10/13 20:08, Scott Ribe wrote: >> select * from test where tz >= start and tz < end and colb like '%foobar%' > > I think you can use an index only for wildcard expressions that are > anchored at the beginning. So, > > select * from

Re: [GENERAL] Postgresql 9.0.13 core dump

Laurentius Purba wrote: > I am having core dump on Postgres 9.0.13 with the message "...was > terminated by signal 10: Bus error...". Every time I have seen this it has been a bug in VM or jail code; although a hardware problem could also cause it. -- Kevin Grittner EDB: http://www.enterprisedb

Re: [GENERAL] Postgresql 9.0.13 core dump

On 14.10.2013 22:18, Laurentius Purba wrote: > Hello all, > > I am having core dump on Postgres 9.0.13 with the message "...was > terminated by signal 10: Bus error...". > > So, I set a PID on the log file to capture specific PID that causing > this crash. After, several crashes, I finally got th

[GENERAL] Postgresql 9.0.13 core dump

Hello all, I am having core dump on Postgres 9.0.13 with the message "...was terminated by signal 10: Bus error...". So, I set a PID on the log file to capture specific PID that causing this crash. After, several crashes, I finally got the PID that causing this crash. But I am still not convinced

Re: [GENERAL] werid error"index row size 3040 exceeds btree maximum, 2712" occur randomly

Hi, On 14.10.2013 05:47, Huang, Suya wrote: > Hi, > > OK, first, I know the reason of this error “index row size 3040 > exceeds btree maximum, 2712” and know that we cannot create index on > certain columns with size larger than 1/3 buffer page size. > > The question is, no matter if I deleted r

Re: [GENERAL] trigger without trigger call

On Mon, Oct 14, 2013 at 6:02 AM, Philipp Kraus < philipp.kr...@tu-clausthal.de> wrote: > > Am 14.10.2013 um 11:49 schrieb Alban Hertroys : > > > On Oct 14, 2013, at 8:18, Philipp Kraus > wrote: > > > >> Hello, > >> > >> I have written a update & delete trigger of a table. > >> My delete trigger r

Re: [GENERAL] Forms for entering data into postgresql

On 10/12/2013 01:57 PM, Adrian Klaver wrote: ... In the text based systems I am familiar with their where keyboard shortcuts that took you directly to fields and coding conventions that allowed direct entry of data. For example at a plumbing supply house I went to the convention was something

Re: [GENERAL] trigger without trigger call

Am 14.10.2013 um 11:49 schrieb Alban Hertroys : > On Oct 14, 2013, at 8:18, Philipp Kraus wrote: > >> Hello, >> >> I have written a update & delete trigger of a table. >> My delete trigger runs an update statement but this create a (semantic) >> problem. >> How can I disable the update trigge

Re: [GENERAL] trigger without trigger call

On Oct 14, 2013, at 8:18, Philipp Kraus wrote: > Hello, > > I have written a update & delete trigger of a table. > My delete trigger runs an update statement but this create a (semantic) > problem. > How can I disable the update trigger for only this update call within the > delete trigger? >

Re: [GENERAL] Incorrect index being used

On 12/10/2013 01:45, BladeOfLight16 wrote: On Fri, Oct 11, 2013 at 9:32 AM, Jesse Long > wrote: explain select * from archive_document_index where node_id = 29 and value = 'BSH70002152'; QUERY PLAN -

Re: [GENERAL] trigger without trigger call

Hello you can disable trigger by ALTER TABLE tablename DISABLE TRIGGER triggername; but it should be executed with owner rights on table. This statement works perfect, but a fact, so you need it signalize so you do some wrong. Triggers should to be used primary for checking, logging, calculating