Bruce Momjian wrote:
> Here are my open 7.1 items.  Thanks for shrinking the list so far.
>
> ---------------------------------------------------------------------------
>
> FreeBSD locale bug
> Reorder INSERT firing in rules

    I  don't  recall  why this is wanted. AFAIK there's no reason
    NOT to do so, except for the actual state of beeing  far  too
    close to a release candidate.

> Philip Warner UPDATE crash
> JDBC LargeObject short read return value missing
> SELECT cash_out(1) crashes all backends
> LAZY VACUUM
> FOREIGN KEY INSERT & UPDATE/DELETE in transaction "change violation"

    A well known issue, and I've asked multiple times how exactly
    we want to define the behaviour for deferred constraints.  Do
    foreign keys reference just to a key value and are happy with
    it's existance, or do they refer to a particular row?

    Consider you have a deferred "ON DELETE  CASCADE"  constraint
    and  do  a  DELETE, INSERT of a PK. Do the FK rows need to be
    deleted or not?

    Consider you have a deferred "ON  DELETE  RESTRICT"  and  "ON
    UPDATE  CASCADE" constraint. If you DELETE PK1 and UPDATE PK2
    to PK1, the FK2 rows need to follow, but does PK2 inherit all
    FK1 rows now so it's the master of both groups?

    These  are  only two possible combinations. There are many to
    think of.  As said, I've asked before, but noone  voted  yet.
    Move  the item to 7.2 anyway, because changing this behaviour
    would require massive changes in the trigger queue *and*  the
    generic  RI triggers, which cannot be tested enough any more.


Jan

> Usernames limited in length
> Does pg_dump preserve COMMENTs?
> Failure of nested cursors in JDBC
> JDBC setMaxRows() is global variable affecting other objects
> Does JDBC Makefile need current dir?
> Fix for pg_dump of bad system tables
> Steve Howe failure query with rules
> ODBC/JDBC not disconnecting properly?
> Magnus Hagander ODBC issues?
> Merge MySQL/PgSQL translation scripts
> Fix ipcclean on Linux
> Merge global and template BKI files?
>
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>


--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


Fri, 26 Jan 2001 12:30:05 -0500 (EST)
Jan Wieck <janwieck@Yahoo.com>
Re: Open 7.1 items
Jan Wieck <janwieck@Yahoo.com> writes:
> Bruce Momjian wrote:
>> Reorder INSERT firing in rules

>     I  don't  recall  why this is wanted. AFAIK there's no reason
>     NOT to do so, except for the actual state of beeing  far  too
>     close to a release candidate.

I think I've been the main person arguing for this change, but I
agree with Jan that this late in the cycle is not the time to be
making such decisions.  Let's discuss it again during 7.2 cycle.

			regards, tom lane

Fri, 26 Jan 2001 13:54:40 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Open 7.1 items 