Re: [BUGS] BUG #4106: WHERE - clause in view works only sometimes

2008-04-12 Thread Tom Lane
Alexander Strotmann <[EMAIL PROTECTED]> writes: > Ok, sorry, here it is all: [ Please keep the mailing list cc'd ] I couldn't reproduce a problem with these table definitions and some simple dummy data. Can you see any pattern to when it fails for you and when it doesn't? What plan do you get f

Re: [BUGS] BUG #4106: WHERE - clause in view works only sometimes

2008-04-12 Thread Tom Lane
"Alexander Strotmann" <[EMAIL PROTECTED]> writes: > we have this table: > ... > and this view: > ... > So the view joins the upper table with another view Another view? Don't you think you've left out a lot of information that would be needed for anyone trying to reproduce this failure? Please s

Re: [BUGS] BUG #4106: WHERE - clause in view works only sometimes

2008-04-12 Thread Heikki Linnakangas
Alexander Strotmann wrote: PostgreSQL version: 8.2 Which version, exactly? Though I don't remember any changes that would explain this, make sure you run the latest minor version, which is 8.2.7 at the moment. we get sometimes results where 'bis' is not NULL! But it is not deterministic be

[BUGS] BUG #4106: WHERE - clause in view works only sometimes

2008-04-12 Thread Alexander Strotmann
The following bug has been logged online: Bug reference: 4106 Logged by: Alexander Strotmann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP / Windows 2003 Server Description:WHERE - clause in view works only sometimes Details:

Re: [BUGS] BUG #3953: No PostGIS option in installer

2008-04-12 Thread Dave Page
On Sat, Apr 12, 2008 at 2:24 PM, ChrisWebster <[EMAIL PROTECTED]> wrote: > > Anybody got a meaningful response from EnterpriseDB on this one? I'm unclear why you think this would get a response from EnterpriseDB? The reported bug was that there is no PostGIS option in the PostgreSQL 8.3 installer,

Re: [BUGS] BUG #3953: No PostGIS option in installer

2008-04-12 Thread ChrisWebster
Anybody got a meaningful response from EnterpriseDB on this one? I just installed EnterpriseDB Advanced Server 8.3 on Windows using EDB;s MSI installer. Despite all the claims on the EDB website about built-in PostGIS support, PostGIS does not appear to be installed by default with EDB 8.3, unl

Re: [BUGS] error php - postgresql

2008-04-12 Thread Guillaume Smet
On Fri, Apr 11, 2008 at 5:31 PM, jalvarez <[EMAIL PROTECTED]> wrote: > i have that error where execute page > > server closed the connection unexpectedly This probably means the server > terminated abnormally before or while processing the request postgres linux Please dig a bit further before co

Re: [BUGS] operator does not exist: timestamp w/out timezone (similar to bug 3807)

2008-04-12 Thread Guillaume Smet
On Sat, Apr 12, 2008 at 4:53 AM, philwalk <[EMAIL PROTECTED]> wrote: > CREATE TABLE > psql:pg83bug.sql:16: ERROR: operator does not exist: timestamp without > time zone ~~ unknown > LINE 3: where date like '2007-01-19%'; >^ > HINT: No operator matches the given na

[BUGS] error php - postgresql

2008-04-12 Thread jalvarez
i have that error where execute page server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request postgres linux i need help -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscr

[BUGS] operator does not exist: timestamp w/out timezone (similar to bug 3807)

2008-04-12 Thread philwalk
-- Easy to duplicate on 3 different operating systems, by executing the -- following script via psql -f pg83bug.sql -- begin script pg83bug.sql \set VERBOSITY verbose; drop table if exists bugtab; select version(); create table bugtab ( date timestamp without time zone not null ,pnum