[GENERAL] Can PostgreSQL be a mail backend?

2001-02-27 Thread Morten W. Petersen
Hi people, I'm wondering if postgres could be capable of acting as a mail storage. This would imply storing messages, from 1KB to > 100MB in size. The expected volume is 4000 messages a day, and the database may store up to, lets say, 50 messages. Could postgres cope with this? (How is th

Re: [GENERAL]

2000-08-07 Thread Morten W. Petersen
NOTICE: Rel inmail: Uninitialized page 433 - fixing I got this message trying to vacuum the DB. Can this be the problem? If so, does anyone know why this may be happening? -Morten

Re: [GENERAL]

2000-08-07 Thread Morten W. Petersen
> It'll help if you provide more info, like what version of PostgreSQL, > what OS and version, example queries, etc.. Woop. The database that's working is a PostgreSQL 6.5 on Debian 2.1, the database that isn't is a PostgreSQL 6.5 on Suse 6.4, both x86 architecture machines. The PostgreSQL on

[GENERAL]

2000-08-07 Thread Morten W. Petersen
Hiya guys I'm having a problem with a PostgreSQL backend, the problem being that the backend can die, from the simplest queries. I'm wondering if this can be the sympthom of a corrupted database, or just a buggy version of Postgre. -Morten

[GENERAL] Is level a reserved keyword?

2000-07-09 Thread Morten W. Petersen
We've been running a customer telephone service, and we've been storing the customers subscription as levels; ie, we have a table, named customer with the column "level". INSERT and SELECT have worked on this table, just as they should; but now, after moving between two databases of the same versi

[GENERAL] How to lock a table

2000-07-05 Thread Morten W. Petersen
We're trying to use a unique-identifier scheme in a database; and therefore we need to put a lock on a table. Is there some way to do this using the PyGres (python) adapter? -Morten - How to reply to email: http://home.sol.no/~vidaan

Re: [GENERAL] How to dump from Postgre

2000-06-27 Thread Morten W. Petersen
> The PostgreSQL documentation is invisible? Yeah, it just vanished. Not my fault. The bitbucket ate it. -Morten =)

[GENERAL] How to dump from Postgre

2000-06-27 Thread Morten W. Petersen
How do you dump from the Postgre database? (i.e. as with MySQL, where you have mysqldump) -Morten

Re: [GENERAL] Migrating from mysql.

2000-05-24 Thread Morten W. Petersen
> Hi there, > > I'm migrating from MySQL to PostgreSQL and I was wondering whether someone > could help me match some datatypes. I'm also migrating, and would appreciate any thoughts on how to do it. Spesifically, if there could be any problems with functions not supported on the PostgreSQL and