now() default values are all showing same timestamp

by

That is expected and documented behaviour:

From the manual:

Since these functions return the start time of the current transaction, their values do not change during the transaction. This is considered a feature: the intent is to allow a single transaction to have a consistent notion of the “current” time, so that multiple modifications within the same transaction bear the same time stamp.

If you want something that changes each time you run a statement, you need to use statement_timestamp() or even clock_timestamp() (again see the description in the manual)

More Related Contents:

  1. Generate series of dates – using date type as input
  2. How to exit from PostgreSQL command line utility: psql
  3. Generating time series between two dates in PostgreSQL
  4. I forgot the password I entered during postgres installation
  5. How do I do large non-blocking updates in PostgreSQL?
  6. Test for null in function with varying parameters
  7. Postgres query optimization (forcing an index scan)
  8. Sequences not affected by transactions?
  9. Difference between timestamps with/without time zone in PostgreSQL
  10. Dynamically generate columns for crosstab in PostgreSQL
  11. I forgot the password I entered during PostgreSQL installation
  12. PostgreSQL ERROR: canceling statement due to conflict with recovery
  13. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  14. Update timestamp when row is updated in PostgreSQL
  15. Postgresql insert trigger to set value
  16. How to add column if not exists on PostgreSQL?
  17. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  18. Convert escaped Unicode character back to actual character in PostgreSQL
  19. Are PostgreSQL functions transactional?
  20. Insert, on duplicate update in PostgreSQL?
  21. invalid byte sequence for encoding “UTF8”
  22. Cannot create a database table named ‘user’ in PostgreSQL
  23. Postgresql Truncation speed
  24. Buffers (Circle) in PostGIS
  25. Heroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  26. Docker – How can run the psql command in the postgres container?
  27. How do I change a Crystal Report’s ODBC database connection at runtime?
  28. PostgreSQL via SSH Tunnel
  29. Loop on tables with PL/pgSQL in Postgres 9.0+
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment