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(at)sandia(dot)gov
> -----Original Message-----
> From: Rini Dutta [mailto:rinid(at)rocketmail(dot)com]
> Sent: February 20, 2001 9:35 AM
> To: pgsql-general(at)postgresql(dot)org; pgsql-sql(at)postgresql(dot)org
> Cc: pgsql-hackers(at)postgresql(dot)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/
>