Re: [SQL] How Do I Hide Trigger ??
> > Dear Milist,=20 > For the security reason, i'd like=20 > to Hide or Encrypting some Function, > triggers or procedure on tables pg_proc,=20 > So If I have many user on my database, > there will be one user could see the > "prosrc" on pg_proc or could do select=20 > the pg_proc without encrypted. > > Any advice will be helpfull. > Would this help? revoke all privileges on pg_proc from public; Regards, Christoph ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] fast case-insensitive sort
"Sigi Jekabsons" <[EMAIL PROTECTED]> writes: > 'surname' is varchar(255), indexed in the manner shown on my > previous post. You're quite right, though, I just tried indexing and > sorting by a column of type text and that worked just fine, it used the > index in the order by. Why is that? I would have said that the presence of the implicit varchar-to-text cast prevented the system from detecting that the expression matches the index value. But if it's able to detect the match in one case and not the other, that might be a garden-variety bug. Will look at it ... regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
