Re: [ADMIN] Postgres problem with partition queries

2010-12-01 Thread Tom Lane
bakkiya writes: > We are having a partition table and we are querying some rows in the > partition. > select * from events where >events.evt_time >= '2010-11-29 00:00:00' > AND events.evt_time <= '2010-11-30 23:59:59' > While this query is in running state, I am issuing a drop stat

[ADMIN] Postgres problem with partition queries

2010-11-30 Thread bakkiya
Hi All, We are having a partition table and we are querying some rows in the partition. select * from events where events.evt_time >= '2010-11-29 00:00:00' AND events.evt_time <= '2010-11-30 23:59:59' While this query is in running state, I am issuing a drop statement on a parti

Re: [ADMIN] Postgres Problem

2000-08-20 Thread m . malicky
On 18 Aug 00, at 16:28, Nataraj wrote: > Hi, > > I am using postgres 7.0.2 in a web application with Perl and CGI. I had > created a database for the web application. I had to modify the database > by adding few new tables. I created the new tables using the "create > table" command. When I quer

[ADMIN] Postgres Problem

2000-08-18 Thread Nataraj
Hi, I am using postgres 7.0.2 in a web application with Perl and CGI. I had created a database for the web application. I had to modify the database by adding few new tables. I created the new tables using the "create table" command. When I query the database for the data in the new tables from t