Hello All,
I've recently moved JBCS over to PostgreSQL per the advice of Andy, and am wondering where the Message bodies are being stored.
In MySQL, they were stored in the two tables starting with "paged_mail_store...".
In Postgres, it looks like they should be in the same tables. However, when I browse postgres "paged_mail_store" and "paged_mail_store_pages" tables, there's absolutley nothing in them. However, I'm able to browse through my messages correctly in the webmail client, so I know the bodies are being stored somewhere.
I've got mySql completely shut down (so I'm not mixing up my databases). Also, I'm using the Postgres Admin III, which is a sql browser that I downloaded from postgres.
It could be that the Postgres Admin III is simply messing up when trying to view these tables, I guess. Or, maybe the message bodies are stored somewhere else in Postgres? I haven't been able to find anything in my entire tablespace.
Any pointers?
David
