Re: [ADMIN] Memory exhausted errors

2001-08-03 Thread Tom Lane
"Chris Ruprecht" <[EMAIL PROTECTED]> writes: > on a daily basis, I load records from an external source into my database. = > During the load, the records go through a validation process during which I= > have to read anywhere between 2 and 15 records from the database. > The postmaster process w

[ADMIN] Modifying existing tables

2001-08-03 Thread Steve Doerr
Is this the only way to add attributes to an existing table, and add unique and a default(for example) to existing attributes? Just wondered if there are alternatives. I didn't really see this in the docs or mailing lists. Thanks for any input. Steve original table: CREATE TABLE table ( at

[ADMIN] large obejcts

2001-08-03 Thread Srinivasa R Chava
Hi, we are pl/pgsql as the procedural language for clinet interface. and we need to create some large objects within pl/pgsql. I did not get any clue about how to create large objects and access them within pl/pgsql, not from 'c' language interface. I don't know whether postgresql has the provisi