Neil Conway wrote: > On Mon, 2003-10-06 at 16:21, Joshua D. Drake wrote: > > postgres=# create user with encrypted password '98wq7912a'; > > CREATE USER > > postgres=# create user with encrypted password '98wq7912a'; > > ERROR: CREATE USER: user name "with" already exists > > So, what are we doing about this? If we're considering it a bug, one way > to fix it is to move WITH from unreserved_keywords to reserved_keywords. > Any other suggestions?
I think the code is fine as it is now, seeing how WITH is optional: CREATE USER username [ [ WITH ] option [ ... ] ] I don't see a huge problem with allowing "with" as a user name. Of course, we could require them to write: CREATE USER with WITH ... but then WITH isn't optional anymore, at least for a user named 'with'. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]