Nick Barnes questions

Nick Barnes answers

• PostgreSQL timestamp/numeric precision ignored on function parameter?
• Postgres user can't select from public tables
• Are queries in the WITH statement executed in a single transaction in PostgreSQL?
• postgresql libpqxx: Several queries as one transaction
• Logging PostgreSQL interactive queries
• how to grant execute to pgcrypto digest function to user
• Can the foreign data wrapper fdw_postgres handle the GEOMETRY data type of PostGIS?
• In PostgreSQL, weird issue about citext performance?
• Is it safe to drop and then create the foreign key constraints inside a transaction?
• How to find if a function exists in PostgreSQL and where?