temporary view from TODO list

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

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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