Question : In Postgresql, when I try to run ALTER TYPE x ADD VALUE y; on a custom datatype I […]
Tag: postgresql-9.1
copy command in postgresql to append data
Question : I am executing copy command from a function execute ‘copy (select * from tableName) to ”/tmp/result.txt”’ It works […]
Very large btree index with few rows (openstreetmap gis data)
Question : I tried to import a subset of open street map data to a Postgres database using the standard […]
Granting access to all tables for a user
Question : I’m new to Postgres and trying to migrate our MySQL databases over. In MySQL I can grant SELECT, […]
timeline 2 of the primary does not match recovery target timeline 1
Question : I want to create a configuration with postgresql and pgpool to get height availability (HA). I want to […]
Adding nullable column to table costs more than 10 minutes
Question : I have problems to add a new column on a table. I tried to run it a couple […]
Howto disable Postgres listening on TCP?
Question : Simply to avoid many problems in the first place I do not want my postgres server program to […]
Postgres automatic insert time stamp with time zone (india) [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Trigger for removing group with no users left in
Question : I have three tables: USERS, GROUPS, and GROUP_MEMBERSHIP CREATE TABLE USERS ( ID BIGSERIAL NOT NULL, NICKNAME VARCHAR(20) […]
Cannot connect to server. Too many symbolic links. Postgres Error [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]