From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: create or replace rule/view (fwd) |
Date: | 2002-08-27 18:50:39 |
Message-ID: | 200208271850.g7RIod829150@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Can someone address Gavin's concern about UpdateAttributeTuples() so we
can get this patch into 7.3? I know a few people have been asking for
it.
---------------------------------------------------------------------------
Gavin Sherry wrote:
> Re-sent.
>
> No one else seems to have received it.
>
> Bruce: copied you in to make sure.
>
> Gavin
>
> ---------- Forwarded message ----------
> Date: Mon, 12 Aug 2002 03:22:08 +1000 (EST)
> From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
> To: pgsql-patches(at)postgresql(dot)org
> Subject: create or replace rule/view
>
> Attached is a patch implementing:
>
> create or replace rule ...
> create or replace view ...
>
> It passes all regression tests. There's only one really sketchy part of
> the patch: UpdateAttributeTuples(). This routine is fairly dangerous since
> it simply removes a given relid's pg_attribute entries and creates a new
> set basic on a given TupleDesc. Naturally, it is only useful for views.
>
> It is important to have this functionality so that you can do something
> like:
>
> template1=# create view abc as select 'test'::text as a;
> CREATE VIEW
> template1=# select * from abc;
> a
> ------
> test
> (1 row)
>
> template1=# create or replace view abc as select '1'::int2 as a;
> CREATE VIEW
> template1=# select * from abc;
> a
> ---
> 1
> (1 row)
>
> Regardless, the patch may need some cleaning up. Unfortunately, I don't
> have enough time on my hands over the coming week. Considering beta is
> coming up I thought it best to submit and see what happens.
>
> Gavin
Content-Description:
[ Attachment, skipping... ]
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Attachment | Content-Type | Size |
---|---|---|
/bjm/diff.gz | application/x-gzip | 5.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2002-08-27 18:56:52 | Re: create or replace rule/view (fwd) |
Previous Message | Neil Conway | 2002-08-27 17:19:15 | rules regression test fix |