From: | Gerard Mason <gerardmason(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_dump dumps views as tables??? |
Date: | 2001-06-21 23:43:21 |
Message-ID: | 3B328699.4080205@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you both *very* much!
Ross J. Reedstrom wrote:
> If you look farther down that same dump, you'll see a CREATE RULE
> that looks something like:
>
> CREATE RULE AS ON SELECT
>
>
> CREATE RULE "_RETincluded_works" AS ON SELECT TO "included_works" DO
> INSTEAD SELECT "works"."uuid", "works"."title" as "lhs" [...]
>
> In other words, pg_dump, especially before 7.1, exposes the details of
> how views are implemented, rather than recreating the SQL you wrote to
> create the schema.
>
> Ross
>
>
> On Tue, Jun 19, 2001 at 09:12:32AM +0100, Gerard Mason wrote:
>
>>Anybody?
>>
>>
>>"Gerard Mason" <gerardmason(at)hotmail(dot)com> wrote in message
>>news:9gbd3s$2d6$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
>>
>>>I am running postgresql-server-7.0.3-12mdk (Mandrake 8.0). The relevant
>>>
>>part
>>
>>>of my build script looks like this:
>>>
>>>create view included_works
>>>as
>>> select uuid, title as lhs
>>> , trim(to_char(cast(year_of_publication as int), '0000')) as rhs
>>> from works
>>> where include=true
>>>;
>>>
>>>What pg_dump actually outputs is this:
>>>
>>>CREATE TABLE "included_works" (
>>> "uuid" character(36),
>>> "lhs" character varying(80),
>>> "rhs" text
>>>);
>>>
>>>
>>>I would be more appalled if I was less gobsmacked. Surely I'm doing
>>>something wrong? But I can't find any reference to this in either the
>>>
>>Admin
>>
>>>Guide or the Reference Manual (though admittedly I'm looking at the 7.1
>>>ones -- the 7.0 ones didn't have any info on it at all, I think).
>>>
>>>Help.
>>>
>>>
>>>
>>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>http://www.postgresql.org/users-lounge/docs/faq.html
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-06-22 00:33:59 | Re: Re: [ADMIN] High memory usage [PATCH] |
Previous Message | Gerard Mason | 2001-06-21 23:40:09 | Re: pg_dump dumps views as tables??? |