Hello,
I have codeigniter 4.18 installed and my model has the following settings
the database is postgresql 12
the fields in the database are timestamp without time zone data type
protected $table = 'news';
protected $primaryKey = 'id';
protected $useAutoIncrement = true;
protected $returnType = 'App\Entities\News\Article';
protected $useSoftDeletes = true;
protected $allowedFields = ['title', 'body','me_uid','record_status'];
protected $useTimestamps = true;
protected $dateFormat = 'datetime';
protected $createdField = 'created_at';
protected $updatedField = 'updated_at';
protected $deletedField = 'deleted_at';
protected $validationRules = [];
protected $validationMessages = [];
protected $skipValidation = false;
protected $record_status = 1;
I have the following method deleting a record in the model
$id = $record->id;
$this->delete($id);
according to the documentation the above code should update the deleted_at field with a timestamp and that is not happening
If I save / update a record the updated_at field gets set with the updated timestamp so that is working properly
when a record is saved the created_at field is getting set correctly
any advice or solution would be greatly appreciated