Skip site navigation (1) Skip section navigation (2)

Re: Could not open relation with OID (table partitioning issue?)

From: bakkiya <bakkiya(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Could not open relation with OID (table partitioning issue?)
Date: 2010-11-22 04:59:05
Message-ID: 1290401945180-3274944.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-novice
Here is the detailed description of the problem:
select version()
"PostgreSQL 8.3.8 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20070115 (prerelease) (SUSE Linux)"

Partition Creation Command:
 CREATE TABLE events_p_20100813100000
(
-- Inherited from table events_p_20100813100000:  evt_id uuid NOT NULL,
-- Inherited from table events_p_20100813100000:  evt_time timestamp with
time zone NOT NULL,
  CONSTRAINT events_p_20100813100000_dc CHECK (evt_time > '2010-08-12
10:43:51.901978+05:30'::timestamp with time zone AND evt_time <= '2010-08-13
10:43:51.901978+05:30'::timestamp with time zone)

)
INHERITS (events)
WITH (
  OIDS=FALSE
);

Drop command:
DROP TABLE events_p_20100813100000;

Select query:
SELECT
	*
FROM
	events
WHERE

	AND (events.evt_time >= '2010-10-11 00:00:00'
	AND events.evt_time <= '2010-10-11 23:59:00')

This table has 330 columns, though I have provided only 2 columns
here.Please let us know, if you need any more details:
-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/Could-not-open-relation-with-OID-table-partitioning-issue-tp3265708p3274944.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

pgsql-novice by date

Next:From: markDate: 2010-11-22 07:33:24
Subject: Re: Could not open relation with OID (table partitioning issue?)
Previous:From: richard terryDate: 2010-11-22 03:26:59
Subject: Help with date query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group