From: | "Koju Iijima" <koju(at)fast(dot)fujitsu(dot)com(dot)au> |
---|---|
To: | "hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | temporary view from TODO list |
Date: | 2004-09-22 01:35:15 |
Message-ID: | 0e0201c4a044$69d566f0$b44bac89@maheshs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Dear Hackers,
I would like to implement and contribute two TODO items:
"Have views on temporary tables exist in the temporary namespace" and
"Allow temporary views on non-temporary tables".
I would like to discuss several points with community.
*Synopsis
CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW ..........
*Description
If [TEMP | TEMPORARY] is specified, the view is created in a temporary
namespace.
If any of the base tables referenced by the view are temporary, the view is
created in a temporary namespace, even if the [TEMP | TEMPORARY] is not
specified (in this case, I'm planning to give "NOTICE" to the client).
*test items for RT
I would like to know amount of test items and what the intention of those
items should be.
1. few items that should test only all the codes we modified or added, to
find any errors from those codes.
2. various items, possibly all the cases that CREATE VIEW operation
involves, to find any errors from temporary view related operations.
Look forward to your comments.
Thanks
koju
----------------------------------------------------------------------------
---
Koju Iijima
Software Engineer
Fujitsu Australia Software Technology
Address: 14 Rodborough Road, Frenchs Forest NSW 2086
Tel: +61 2 9452 9076
Fax: +61 2 9975 2899
Email: koju(at)fast(dot)fujitsu(dot)com(dot)au
Web site: www.fastware.com
----------------------------------------------------------------------------
---
This is an email from Fujitsu Australia Software Technology Pty Ltd, ABN 27 003 693 481. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you.
If you do not wish to receive commercial email messages from Fujitsu Australia Software Technology Pty Ltd, please email unsubscribe(at)fast(dot)fujitsu(dot)com(dot)au
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2004-09-22 03:28:05 | Variable assignment from dynamic SQL in PL/PgSQL |
Previous Message | Gavin Sherry | 2004-09-22 01:28:46 | Re: testing concurrency (was Re: subtransaction assert |
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2004-09-22 01:44:23 | Re: pg_controldata usage |
Previous Message | Andrew Dunstan | 2004-09-21 22:53:41 | Re: pg_hba.conf additional comment re local line |