Steps to reproduce the issue

With POSTGRES as the database create a new banner client and then create a second banner client
or
With POSTGRES as the database create a new articke and then create a second article

Expected result

Two clients created or two articles

Actual result

First client created
Attempt to create a second client produces the following error

Error
Save failed with the following error: ERROR: duplicate key value violates unique constraint "#__banner_clients_pkey" DETAIL: Key (id)=(0) already exists.SQL=INSERT INTO "#__banner_clients" ("checked_out_time","id","name","contact","email","extrainfo","state","metakey","own_prefix","metakey_prefix","purchase_type","track_clicks","track_impressions") VALUES ('1970-01-01 00:00:00',0,'b','ab','ab@example.com','',1,'',0,'',-1,0,0) RETURNING id

First article created
Attempt to create a second article produces the following error

Error
Save failed with the following error: ERROR: duplicate key value violates unique constraint "#__content_pkey" DETAIL: Key (id)=(0) already exists.SQL=INSERT INTO "#__content" ("id","title","alias","introtext","fulltext","state","catid","created","created_by","created_by_alias","modified","publish_up","publish_down","images","urls","attribs","version","metakey","metadesc","access","metadata","featured","language","xreference") VALUES (0,'affafaf','affafaf','','',1,2,'2015-12-20 13:51:33',722,'','2015-12-20 13:51:33','2015-12-20 13:51:33','1970-01-01 00:00:00','{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}','{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}','{"show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}',1,'','',1,'{"robots":"","author":"","rights":"","xreference":""}',0,'*','') RETURNING id

System information (as much as possible)

Current staging environment

Additional comments

Works perfectly with mysqli