Peter Eisentraut wrote: > Am Montag, 25. Juli 2005 18:31 schrieb Tom Lane: > > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > > The new syntax for this command is CREATE/ALTER DATABASE/USER: > > > | MAX CONNECTIONS Iconst > > > > > > This adds 'max' as a keyword, though at a fairly unreserved level, I > > > think. Should we use the syntax LIMIT CONNECTIONS so we don't have to > > > add MAX as a keyword at all? > > > > I didn't like that either. I was thinking of just CONNECTIONS. > > LIMIT CONNECTIONS sort of works grammatically, I guess. > > Would this not work in the context of the general user-specific ALTER USER > ... > SET something = something?
No because it isn't a GUC variable, it is per-user/db value. We could have used that syntax, but it might confuse people. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (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 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq