I happen to know this very well...  It handles things very gracefully as far
as I can tell.  I complains that it can't extend the table and bails out of
the transaction.  I just wish it didn't happen so often... <grin>

Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl@sandia.gov


> -----Original Message-----
> From: Rini Dutta [mailto:rinid@rocketmail.com]
> Sent: February 20, 2001 9:35 AM
> To: pgsql-general@postgresql.org; pgsql-sql@postgresql.org
> Cc: pgsql-hackers@postgresql.org
> Subject: [SQL] handling of database size exceeding physical disk space
> 
> 
> Hi,
> 
> Does anyone know how postgres/ postmaster handles the
> situation where the physical hard disk space is full ?
> Does it crash / corrupt the database, or does it
> cleanly exit with appopriate message so that relevant
> tables can be pruned (by the user) to free up disk
> space and get it working again ?
> 
> Thanks,
> Rini
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> 


Tue, 20 Feb 2001 09:53:14 -0700
"Diehl, Jeffrey" <jdiehl@sandia.gov>
RE: [SQL] handling of database size exceeding physical disk
 space
Thanks ! I'm using JDBC to insert into the tables.
Would it throw an SQLException in such a situation ?

Rini

--- "Diehl, Jeffrey" <jdiehl@sandia.gov> wrote:
> I happen to know this very well...  It handles
> things very gracefully as far
> as I can tell.  I complains that it can't extend the
> table and bails out of
> the transaction.  I just wish it didn't happen so
> often... <grin>
> 
> Mike Diehl,
> Network Monitoring Tool Devl.
> 284-3137
> jdiehl@sandia.gov
> 
> 
> > -----Original Message-----
> > From: Rini Dutta [mailto:rinid@rocketmail.com]
> > Sent: February 20, 2001 9:35 AM
> > To: pgsql-general@postgresql.org;
> pgsql-sql@postgresql.org
> > Cc: pgsql-hackers@postgresql.org
> > Subject: [SQL] handling of database size exceeding
> physical disk space
> > 
> > 
> > Hi,
> > 
> > Does anyone know how postgres/ postmaster handles
> the
> > situation where the physical hard disk space is
> full ?
> > Does it crash / corrupt the database, or does it
> > cleanly exit with appopriate message so that
> relevant
> > tables can be pruned (by the user) to free up disk
> > space and get it working again ?
> > 
> > Thanks,
> > Rini
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> - only $35 
> > a year!  http://personal.mail.yahoo.com/
> > 
> 


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Tue, 20 Feb 2001 11:11:34 -0800 (PST)
Rini Dutta <rinid@rocketmail.com>
RE: [SQL] handling of database size exceeding physical disk space