Dynamic Pivot Table Generator with Variable Columns

Create a flexible PostgreSQL function that can dynamically generate pivot tables from any input table, supporting an arbitrary number of grouping and aggregation columns. The function should accept parameters for source table, pivot column, value column, and aggregation method. Implement error handling for edge cases like non-existent columns, and include a mechanism to automatically detect column types and handle type conversions during pivoting.