KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have PostgreSQL 9.2.0. On clicking create database it shows following error: SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... ^ In statement: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname
Tags (comma-separated)
Save Edits
Cancel