pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Roberto Mello <rmello@cc.usu.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3
Date: Wed, 26 Feb 2003 09:08:14 -0800
Message-ID: <200302260908.14180.josh@agliodbs.com> (raw)
In-Reply-To: <20030226044826.GC8564@cc.usu.edu>
References: <20030225192043.GA30324@cc.usu.edu>
	<12893.1046207414@sss.pgh.pa.us>
	<20030226044826.GC8564@cc.usu.edu>

Roberto,

> No, that was not what I was suggesting. I was suggesting (based on my
> assumption that 'create function ... returns opaque' would convert the
> return type to trigger), that its behaviour be made consistent with
> 'create or replace function' and throw an error if the type is opaque.

I can't see any way to do that without making it very difficult to upgrade to 
7.3.

> For our next release, our plan was to have both 7.2 and 7.3
> compatibility. For the release after that, 7.2 compatibility would
> probably be dumped in favor of 7.3, where we could make use of 7.3-specific
> features. We wanted it to be a gradual path.

Where does OpenACS do its object creation?  Just at setup/install time, or 
through the life of the program?   If the former, I'd suggest having two 
seperate database install scripts ... one for 7.2.and one for 7.3.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



view thread (6+ messages)

Message-ID: <200302260908.14180.josh@agliodbs.com>
Permalink:  ../200302260908.14180.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200302260908.14180.josh@agliodbs.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: josh@agliodbs.com, rmello@cc.usu.edu, tgl@sss.pgh.pa.us
  Subject: Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3
  In-Reply-To: <200302260908.14180.josh@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox