Nick Barnes questions

Nick Barnes answers

• 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?
• postgres INSERT trigger fires even with ON CONFLICT DO NOTHING
• Postgresql COPY encoding, how to?
• Best way to delete large no of random rows in PostgreSQL
• Performance of NUMERIC type with high precisions and scales in PostgreSQL
• WAL archive: FAILED (please make sure WAL shipping is setup)
• SELECT where value in collection of ranges