"Vishnu S." wrote:
> I have created index on some of the tables in the custom
> tablespace. But the indexes resides in the default tablspace. Is
> there any issue in it?
No.
> Is there any chance for deleting the tablespace, if the crash
> recovery using WAL and fsync is failed?
I don't kn
failed?
Thanks & Regards,
Vishnu S
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Thursday, October 13, 2011 8:10 PM
To: Vishnu S.; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Tablespace files deleted in continuous run
"Vishnu S." w
On Fri, Oct 14, 2011 at 12:29 AM, Vishnu S. wrote:
> The application deletes the contents of tables in the tablespace using
> DELETE TABLE query.
There's no DELETE TABLE command. Do you mean DELETE, or DROP TABLE?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreS
ards,
Vishnu S
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Thursday, October 13, 2011 8:10 PM
To: Vishnu S.; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Tablespace files deleted in continuous run
"Vishnu S." wrote:
> I am using
7:53 AM
To: pgsql-bugs@postgresql.org
Subject: [BUGS] Tablespace files deleted in continuous run
HI,
I am using PostgreSQL 8.4 in windows. I have created a database and
some tables on it. Also created a table space and some tables in it. My
application inserts data into these tabl
"Vishnu S." wrote:
> I am using PostgreSQL 8.4 in windows. I have created a database
> and some tables on it. Also created a table space and some tables
> in it. My application inserts data into these tables in every
> second. The application is a continuous running application. My
> issue is
HI,
I am using PostgreSQL 8.4 in windows. I have created a database and
some tables on it. Also created a table space and some tables in it. My
application inserts data into these tables in every second. The
application is a continuous running application. My issue is that after
a 20-30
