Re: configure datatype name > 31?

Tom Lane wrote:
> "Mark McEahern" <marklists(at)mceahern(dot)com> writes:
> > Tom, thanks for your reply. I am now able to create databases and users
> > with longer names, but I am unable to login with the long username.
>
> I think you're stuck on that, unless you want to be *really*
> incompatible with the rest of the world. The startup packet format has
> hard-wired field sizes --- see src/include/libpq/pqcomm.h:
>
> #define SM_DATABASE 64
> #define SM_USER 32
> #define SM_OPTIONS 64
> #define SM_UNUSED 64
> #define SM_TTY 64
>
> Don't ask me why SM_USER is different from the rest :-(
>
> If you change these I'd strongly advise bumping the protocol minor
> version number, so that you don't have weird behavior should you try
> to interoperate with standard code.
>
> This is another thing that should be on the list of stuff to fix when
> we next change the FE/BE protocol ...

Comment added to source that SM_USER length should match the others.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026