Обсуждение: Syntax changes in 7.2

Are syntax changes from 7.1.x to 7.2 documented anywhere?  I just 
noticed that 'time' as a column name does not work the same in 7.2 as 7.1.x.

Sorry if this shows up twice... I posted last night but it had not 
appeared this morning.

Tks
Dwayne

Dwayne Miller wrote:
> Are syntax changes from 7.1.x to 7.2 documented anywhere?  I just 
> noticed that 'time' as a column name does not work the same in 7.2 as 7.1.x.
> 
> Sorry if this shows up twice... I posted last night but it had not 
> appeared this morning.

Syntax changes are documented at the top of the HISTORY file and in the
release notes at:
http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-2


--  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,
Pennsylvania19026
 

Well, if it matters...  I did not see a change posted that would account 
for the difference in operation.  time has been a datatype in both, yet 
the 7.1.x versions would allow a column named time, with no quotes 
required.  7.2 does not.  Guess I'll change the name of that column.

Tks
Dwayne

Bruce Momjian wrote:

>Dwayne Miller wrote:
>
>>Are syntax changes from 7.1.x to 7.2 documented anywhere?  I just 
>>noticed that 'time' as a column name does not work the same in 7.2 as 7.1.x.
>>
>>Sorry if this shows up twice... I posted last night but it had not 
>>appeared this morning.
>>
>
>Syntax changes are documented at the top of the HISTORY file and in the
>release notes at:
>
>    http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-2
>
>

Here some hacky code to generate diffs of the grammar rules. Maybe it
appears to be usefull:

#! /bin/sh

# shell script to diff grammars
# usage:  $0 grammar-old.y grammar-new.y

TMPDIR="/tmp/diffgrammar.$$"

PWD=`pwd`

AWKCODE='
BEGIN { RULE=""; } 
/^rule/ {   if ( RULE != $3 ) { print $3" ->"; RULE = $3 };   match($0,/^rule[\ \t]*[0-9]+[\ \t]*[@A-Za-z_0-9]+[\
\t]*->[\\t]*/);   print "\t\t"substr($0,RLENGTH);
 
}
'
mkdir -p ${TMPDIR}/old ${TMPDIR}/new

cp $1 ${TMPDIR}/old
cp $2 ${TMPDIR}/new

cd ${TMPDIR}/old
bison -v `basename $1`

awk "${AWKCODE}" *.output > grammar.rules

cd ${TMPDIR}/new
bison -v `basename $2`

awk "${AWKCODE}" *.output > grammar.rules

cd ${TMPDIR}
diff -u old/grammar.rules new/grammar.rules

cd ${PWD}
rm -rf ${TMPDIR}

-- 
Holger Krug
hkrug@rationalizer.com