Definitely something getting link'd between each other ... according to
show, this user is no on hackers:
Majordomo>show john_oshea@wordbank.co.uk
Address: john_oshea@wordbank.co.uk
Address is valid.
Address is registered as:
"John O'Shea" <john_oshea@wordbank.co.uk>
Registered at Wed Aug 16 10:52:26 2000 GMT.
Registration data last changed at Wed Aug 16 11:19:13 2000 GMT.
Address is subscribed to 2 lists:
pgsql-general:
Subscribed as "John O'Shea" <john_oshea@wordbank.co.uk>.
Subscribed at Wed Aug 16 11:19:13 2000 GMT.
Receiving each message as it is posted.
Subscriber flags:
noeliminatecc
nohide
prefix
replyto
selfcopy
norewritefrom
noackstall
noackdeny
noackpost
noackreject
Data last changed at Wed Aug 16 11:19:13 2000 GMT.
pgsql-sql:
Subscribed as "John O'Shea" <john_oshea@wordbank.co.uk>.
Subscribed at Wed Aug 16 10:52:25 2000 GMT.
Receiving each message as it is posted.
Subscriber flags:
noeliminatecc
nohide
prefix
replyto
selfcopy
norewritefrom
noackstall
noackdeny
noackpost
noackreject
Data last changed at Wed Aug 16 10:52:25 2000 GMT.
Thoughts?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
---------- Forwarded message ----------
Date: Thu, 14 Sep 2000 13:16:08 +0100
From: John O'Shea <john_oshea@wordbank.co.uk>
To: The Hermit Hacker <scrappy@hub.org>
Subject: [HACKERS] Re: [GENERAL] List funnies ?
>can you forward me a copy of the next 'hackers' message you receive, along
>with its *full* headers? Just to make sure, pgsql-general@postgresql.org
>hasn't been inadvertently subscribed to hackers, so we aren't getting a
>cross there:
Here's one sent to me (also not on HACKERS) - hope that helps:
-----
Received: from 216.126.84.1 by mailserver ([10.1.1.10] running VPOP3)
with ESMTP for <john_oshea@wordbank.co.uk>; Thu, 14 Sep 2000 12:20:41
+0100
Received: from hub.org (localhost [127.0.0.1]) by hub.org
(8.10.1/8.10.1) with SMTP id e8EBGss57302; Thu, 14 Sep 2000 07:16:55
-0400 (EDT)
Received: from acheron.rime.com.au (root@albatr.lnk.telstra.net
[139.130.54.222]) by hub.org (8.10.1/8.10.1) with ESMTP id
e8EBFks56807 for <pgsql-hackers@postgresql.org>; Thu, 14 Sep 2000
07:15:47 -0400 (EDT)
Received: from oberon (Oberon.rime.com.au [203.8.195.100]) by
acheron.rime.com.au (8.9.3/8.9.3) with SMTP id VAA30677; Thu, 14 Sep
2000 21:15:39 +1000
Message-Id: <3.0.5.32.20000914221655.037d4290@mail.rhyme.com.au>
X-Sender: pjw@mail.rhyme.com.au
X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32)
Date: Thu, 14 Sep 2000 22:16:55 +1000
To: pgsql-hackers@postgresql.org
From: Philip Warner <pjw@rhyme.com.au>
Cc: Mark Hollomon <mhh@mindspring.com>
In-Reply-To: <20000831125603.B26005@mindspring.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Mailing-List: pgsql-hackers@postgresql.org
Precedence: bulk
Sender: pgsql-hackers-owner@hub.org
X-Server: VPOP3 V1.4.1 - Registered to: Wordbank Ltd
Subject: [HACKERS] Dumping views as views?
In a continuing effort to make pg_dump produce valid SQL where possible, I
would like to move away from the 'Create Table'/'Create Rule' method of
defining views, and actually dump the 'Create View' command.
This seems quite do-able, but before I start I thought I would ask if there
were any reasons people could think of for not doing this?
The approach will be:
- when getting table info, also call pg_get_viewdef (which returns 'not a
view' for non-view relations).
- When dumping rules, ignore all 'view rules'.
- Dump the 'Create View' statement in oid order as per normal.
It would be really nice if there was a simple way of detecting view rules
that was analagous to relkind. Is there a reason why this has not been
done? Has it been done?
Maybe the code that checks the rule name to see if it is a view could be
put in the backend?
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
--
John O'Shea <mailto:john_oshea@wordbank.co.uk>
PGP fingerprint: 9A0A 47F7 A822 813E FFD4 B7B9 4194 C3F8 E610 F7C4
|
|
