Re: [BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-14 Thread Tom Lane
"Sergey N. Yatskevich" <[EMAIL PROTECTED]> writes: > ÷ ðÎÄ, 14/02/2005 × 01:52 -0500, Tom Lane ÐÉÛÅÔ: >> BTW, is there a security issue here? > I think this is not good but not so bad because: > 1) ALTER LANGUAGE can be used only users with superuser privilegies Right --- that check is made befor

Re: [BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-14 Thread Bruce Momjian
Patch applied by Tom. Thanks. --- Sergey N. Yatskevich wrote: > RenameLanguage procedure in src/backend/commands/proclang.c open > and update pg_catalog.pg_shadow table instead pg_catalog.pg_language. > > -- > Sergey N.

Re: [BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-13 Thread Tom Lane
> "Sergey N. Yatskevich" <[EMAIL PROTECTED]> writes: >> RenameLanguage procedure in src/backend/commands/proclang.c open >> and update pg_catalog.pg_shadow table instead pg_catalog.pg_language. > Wow. Apparently this has been broken since it was written, and > nobody ever tested it. Thanks! BTW

Re: [BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-13 Thread Tom Lane
"Sergey N. Yatskevich" <[EMAIL PROTECTED]> writes: > RenameLanguage procedure in src/backend/commands/proclang.c open > and update pg_catalog.pg_shadow table instead pg_catalog.pg_language. Wow. Apparently this has been broken since it was written, and nobody ever tested it. Thanks!

Re: [BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-13 Thread Bruce Momjian
Oh, good catch. We will fix that. Thanks. Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. ---