Rules on Views patch for psql

Started by ...Paulover 24 years ago3 messagespatches
Jump to latest
#1...Paul
cleggp@megadodo.com

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/ **

Attachments:

describe.c.difftext/plain; charset=US-ASCII; name=describe.c.diffDownload+47-27
#2Bruce Momjian
bruce@momjian.us
In reply to: ...Paul (#1)
Re: Rules on Views patch for psql

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
#3Bruce Momjian
bruce@momjian.us
In reply to: ...Paul (#1)
Re: Rules on Views patch for psql

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