Skip to main content

Browse the archive

https://github.com/postgres/postgres
07 April 2024, 13:56:23 UTC
Revision eb6af646becfe94f38d08d4765d5faf9123944d0 authored by Tom Lane on 04 June 2011, 19:48:41 UTC, committed by Tom Lane on 04 June 2011, 19:48:41 UTC 
Expose the "*VALUES*" alias that we generate for a stand-alone VALUES list.
 
We were trying to make that strictly an internal implementation detail,
but it turns out that it's exposed anyway when dumping a view defined
like
	CREATE VIEW test_view AS VALUES (1), (2), (3) ORDER BY 1;
This comes out as
	CREATE VIEW ... ORDER BY "*VALUES*".column1;
which fails to parse when reloading the dump.

Hacking ruleutils.c to suppress the column qualification looks like it'd
be a risky business, so instead promote the RTE alias to full-fledged
usability.

Per bug #6049 from Dylan Adams.  Back-patch to all supported branches.
1 parent f0d72ef
History
Tip revision: eb6af646becfe94f38d08d4765d5faf9123944d0 authored by Tom Lane on 04 June 2011, 19:48:41 UTC
Expose the "*VALUES*" alias that we generate for a stand-alone VALUES list.
Tip revision: eb6af64
File Mode Size
config
contrib
doc
src
.gitignore -rw-r--r-- 233 bytes
COPYRIGHT -rw-r--r-- 1.2 KB
GNUmakefile.in -rw-r--r-- 3.7 KB
Makefile -rw-r--r-- 1.4 KB
README -rw-r--r-- 2.0 KB
README.git -rw-r--r-- 820 bytes
aclocal.m4 -rw-r--r-- 445 bytes
configure -rwxr-xr-x 694.3 KB
configure.in -rw-r--r-- 47.2 KB

README

back to top