pgsql: Allow an optional alias for the target table to be specified for

From: neilc(at)postgresql(dot)org (Neil Conway)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow an optional alias for the target table to be specified for
Date: 2006-01-22 05:20:35
Message-ID: 20060122052035.646579DC82C@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Allow an optional alias for the target table to be specified for UPDATE
and DELETE. If specified, the alias must be used instead of the full
table name. Also, the alias currently cannot be used in the SET clause
of UPDATE.

Patch from Atsushi Ogawa, various editorialization by Neil Conway.
Along the way, make the rowtypes regression test pass if add_missing_from
is enabled, and add a new (skeletal) regression test for DELETE.

Modified Files:
--------------
pgsql/doc/src/sgml:
regress.sgml (r1.49 -> r1.50)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/regress.sgml.diff?r1=1.49&r2=1.50)
pgsql/doc/src/sgml/ref:
delete.sgml (r1.25 -> r1.26)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/delete.sgml.diff?r1=1.25&r2=1.26)
update.sgml (r1.34 -> r1.35)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/update.sgml.diff?r1=1.34&r2=1.35)
pgsql/src/backend/parser:
gram.y (r2.522 -> r2.523)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.522&r2=2.523)
parse_clause.c (r1.144 -> r1.145)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_clause.c.diff?r1=1.144&r2=1.145)
pgsql/src/test/regress:
parallel_schedule (r1.30 -> r1.31)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/parallel_schedule.diff?r1=1.30&r2=1.31)
serial_schedule (r1.29 -> r1.30)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/serial_schedule.diff?r1=1.29&r2=1.30)
pgsql/src/test/regress/expected:
rowtypes.out (r1.5 -> r1.6)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rowtypes.out.diff?r1=1.5&r2=1.6)
update.out (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/update.out.diff?r1=1.1&r2=1.2)
pgsql/src/test/regress/sql:
rowtypes.sql (r1.4 -> r1.5)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/rowtypes.sql.diff?r1=1.4&r2=1.5)
update.sql (r1.2 -> r1.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/update.sql.diff?r1=1.2&r2=1.3)

Added Files:
-----------
pgsql/src/test/regress/expected:
delete.out (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/delete.out?rev=1.1&content-type=text/x-cvsweb-markup)
pgsql/src/test/regress/sql:
delete.sql (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/delete.sql?rev=1.1&content-type=text/x-cvsweb-markup)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-01-22 20:03:17 pgsql: Fix alias-for-target-table-of-UPDATE-or-DELETE patch so that
Previous Message Neil Conway 2006-01-22 03:56:58 pgsql: Minor improvements to GEQO documentation.