Skip site navigation (1) Skip section navigation (2)

Re: bug in PG_VERSION_NUM patch

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: bug in PG_VERSION_NUM patch
Date: 2006-02-28 22:33:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > OK, I reread the manual page:
> >        As  each input record is read, gawk splits the record into
> >        fields, using the value of the FS variable  as  the  field
> >        separator.   If FS is a single character, fields are sepa-
> >        rated by that character.  If FS is the null  string,  then
> >        each  individual character becomes a separate field.  Oth-
> >        erwise, FS is expected to be a  full  regular  expression.
> Hpmh.  The HPUX man page for plain awk says
>           -F fs          Specify regular expression used to separate
>                          fields.  The default is to recognize space and tab
>                          characters, and to discard leading spaces and
>                          tabs.  If the -F option is used, leading input
>                          field separators are no longer discarded.
> which makes me think we are treading on mighty thin ice here --- there
> are lots of different versions of awk around, and some of them are
> probably going to treat -F '.' as a regexp.
> I'd suggest splitting the input with something more standardized.
> Perhaps
> sed 's/\./ /g' | $AWK '{printf ...

Good idea, new code applied:

	# Supply a numeric version string for use by 3rd party add-ons
	# awk -F is a regex on some platforms, and not on others, so make "." a tab
	PG_VERSION_NUM="`echo "$PACKAGE_VERSION" | sed 's/[A-Za-z].*$//' |
	tr '.' '	' |
	$AWK '{printf \"%d%02d%02d\", $1, $2, (NF >= 3) ? $3 : 0}'`"

  Bruce Momjian
  SRA OSS, Inc.

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-hackers by date

Next:From: Mark KirkwoodDate: 2006-02-28 22:42:37
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....
Previous:From: Tom LaneDate: 2006-02-28 22:29:08
Subject: Re: bug in PG_VERSION_NUM patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group