Fork me on GitHub
#off-topic
<
2016-08-08
>
agi_underground10:08:43

hi, someone can help me with postgres triggers? i`m trying to execute trigger after 24 hours after record insertion, for each row, how to do this? please help

agi_underground10:08:39

you know, if user doesn`t verificate his email, his account will be deleted

niwinz11:08:22

@agi_underground: as far as I know it can't be done directly in postgresql

niwinz11:08:38

postgresql does not have support to anything related to async tasks

niwinz11:08:56

A cron job that checks the users registred and not verified in certain period of time

niwinz11:08:13

and deactivates that user accounts...

agi_underground11:08:16

niwinz, ok, thank you, got it