Re: WIP Patch - Updateable Cursors

On Wed, 28 Feb 2007 09:48, Bruce Momjian wrote:

[Added a subejct line]

> FYI, I am not going to be comfortable accepting a final patch that
> contains this email signature:
>
> 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 s ender. Thank you.
>
> unless you provide additional details on your contribution of this code
> under a BSD license.

We are happy to provide that. If and when it comes to the final patch being
accepted, we can send a copyright waiver mail which will put our source code
contribution under the BSD license.

Rgds,
Arul Shaji

>
> ---------------------------------------------------------------------------
>
> John Bartlett wrote:
> > Hi,
> >
> >
> >
> > This is the first posting to the community of the WIP patch for the
> > Updatable Cursor implementation.
> >
> >
> >
> > I want to confirm that the community is satisfied that the effort to date
> > is in a suitable direction and to get comments on the development to
> > date.
> >
> >
> >
> > The patch is in the following state:
> >
> >
> >
> > The grammar definition is complete and 'yacc'ed to produce gram.y.c.
> >
> >
> >
> > The functions transformUpdateStmt and transformDeleteStmt have been
> > updated to process the cursor name and obtain the related portal.
> >
> >
> >
> > The change to save the current tuple id (ctid) into the portal, related
> > to the Fetch command has been done.
> >
> >
> >
> > The ctids relating to the Update/Delete statements' TidScan are being
> > extracted to be saved in the executor.
> >
> >
> >
> > The parts in progress are to complete the saving of the ctids from the
> > TidScan into a list stored in a file, plus related searching the list for
> > an individual ctid obtained from the Update/Delete statements.
> >
> >
> >
> > Unstarted as yet:
> >
> >
> >
> > 1) Correctly process, in the database, the Delete / Update of
> > the tuple from the cursor.
> >
> > 2) To enable the cursor name to be defined as a parameter in a
> > PREPARE statement and provided as part if an EXECUTE statement.
> >
> >
> >
> > The community may wish to comment on the following issue:
> >
> >
> >
> > 1) At present the file that will contain the list of ctids is going
> > into a new directory called pg_ctids, analogous to pg_twophase, and also
> > stored in the pg_data directory.
> >
> >
> >
> > Regards,
> > John Bartlett
> >
> > 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
>
> [ Attachment, skipping... ]
>
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
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