Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Unanswered: error while creating a database table

    Im new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4 database. Im getting the following error when tried to create a table. Please let me know the steps (with queries) that I should take care to resolve this issue.

    cms=# create table test(id character varying(80));

    ERROR: could not create relation "test": Permission denied

    Please help me resolve this as it is very critical.

    thanks,
    Abhijit

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    That is a really old version of Postgres.

    Your account doesn't have permission to create database objects. Log in as a superuser (postgres is default) and grant your account those permissions or create the table under that user.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •