Skip site navigation (1) Skip section navigation (2)

Re:

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: John Bartlett <johnb(at)fast(dot)fujitsu(dot)com(dot)au>
Cc: pgsql-patches(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re:
Date: 2007-02-27 22:48:52
Message-ID: 200702272248.l1RMmqa21275@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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.

---------------------------------------------------------------------------

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

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2007-02-27 22:52:42
Subject: Re: [HACKERS]
Previous:From: Joshua D. DrakeDate: 2007-02-27 22:45:18
Subject: Re: conversion efforts (Re: SCMS question)

pgsql-patches by date

Next:From: Joshua D. DrakeDate: 2007-02-27 22:52:42
Subject: Re: [HACKERS]
Previous:From: Bruce MomjianDate: 2007-02-27 21:07:26
Subject: Re: FAQ_DEV Update: Fix Answer for Q 1.19, add Q on SCMS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group