BUG #14200: Cannot create a table named 'user'

From: liveloveprosper(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14200: Cannot create a table named 'user'
Date: 2016-06-19 02:58:54
Message-ID: 20160619025854.5798.82044@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14200
Logged by: Matthew Di Pasquale
Email address: liveloveprosper(at)gmail(dot)com
PostgreSQL version: 9.5.3
Operating system: OS X 10.11.5
Description:

Problem:
http://stackoverflow.com/q/22256124

Why doesn't the user table have the pg_ prefix or some other prefix?

What if I want to create a user table for my application? Shouldn't I be
able to call that table user?

Would the only reason to use table name prefixes be to avoid this
conflict?
http://stackoverflow.com/questions/324163/should-we-use-prefixes-in-our-database-table-naming-conventions#comment61629636_324183

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2016-06-19 04:01:38 Re: BUG #14200: Cannot create a table named 'user'
Previous Message Tom Lane 2016-06-18 15:51:10 Re: [BUGS] BUG #14199: The pg_ctl status check on server start is not compatible with the silent_mode=on