So I have had an issue with Joomla that seems to have been fixed in version 3.4. Whenever I tried to create an article that would never expire it would mess up the dates. I tried different tricks but I could not make it work right. Finally the issue has been resolved and I can continue my learning experience with Joomla.
I am trying to get started with Joomla. So far I have had quite a bit of issues with Joomla and Postgresql. Maybe I am stubborn for wanting to use Postgresql and not MySQL but I prefer to keep as much as possible in Postgresql. The primary problem seems to be with the insert statements Joomla uses on tables that have sequences attached. Upon initialization Joomla inserts with specific IDs in the sequence fields but does does not update the sequence. This results in the next insert trying to insert with an already used ID as Postgresql used the nextval from the sequences.