Обсуждение: Rules on Views patch for psql
Uh, hi. I was tinkering with creating rules on views (so, for instance, one could insert on a view), and noticed that psql wouldn't show the list of rules set up on a view, like it does for tables. The fix was extremely simple, so I figured I'd share it. Not sure what the standard is for communicating these things, so I've attached the diff file for /src/bin/psql/describe.c. Enjoy. ...Paul ** Have a question that reality just can't answer? ** ** Visit Project Galactic Guide http://www.galactic-guide.com/ **
Вложения
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --------------------------------------------------------------------------- ...Paul wrote: > Uh, hi. > > I was tinkering with creating rules on views (so, for instance, one could > insert on a view), and noticed that psql wouldn't show the list of rules > set up on a view, like it does for tables. > > The fix was extremely simple, so I figured I'd share it. Not sure what > the standard is for communicating these things, so I've attached the diff > file for /src/bin/psql/describe.c. > > Enjoy. > > ...Paul > > ** Have a question that reality just can't answer? ** > ** Visit Project Galactic Guide http://www.galactic-guide.com/ ** > Content-Description: [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Patch applied. Thanks. --------------------------------------------------------------------------- ...Paul wrote: > Uh, hi. > > I was tinkering with creating rules on views (so, for instance, one could > insert on a view), and noticed that psql wouldn't show the list of rules > set up on a view, like it does for tables. > > The fix was extremely simple, so I figured I'd share it. Not sure what > the standard is for communicating these things, so I've attached the diff > file for /src/bin/psql/describe.c. > > Enjoy. > > ...Paul > > ** Have a question that reality just can't answer? ** > ** Visit Project Galactic Guide http://www.galactic-guide.com/ ** > Content-Description: [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026