[SQL] strange error message

Hi, I've got a strange error message in our java application. the only reference to this message i find in http://mingo.info-science.uiowa.edu/eichmann/courses/database/Postgres/programmer.pdf

Re: [SQL] Does anyone know of any issues around ARRAY UNNEST

Hello This is not known bug - there should be bug in PostgreSQL or your database (data files) can be broken. 2011/11/24 Belinda Cussen > Hi there, > We're having segmentation faults on our postgres 9.1.1 db. It seems to > happen when we use ARRAY unnesting eg: > > UPDATE activity SET activity_

[SQL] Does anyone know of any issues around ARRAY UNNEST

Hi there, We're having segmentation faults on our postgres 9.1.1 db. It seems to happen when we use ARRAY unnesting eg: UPDATE activity SET activity_recency_timestamp = CURRENT_TIMESTAMP WHERE venue_id IN (SELECT venue_id FROM UNNEST(v_venue_id_list) venue_id); We are working on a getting a core