The parser seems to have changed from 7.1.3->7.2B2 in a bad way:

  test=# create table test(timestamp timestamp);
  ERROR:  parser: parse error at or near "timestamp"

Don't-ever-say-I-didn't-test-B2,
-Kevin

PS:  CC me on the results, and let me know if there is a better place to
     submit bugs.  There didn't seem to be anything obvious on the developer
     site.

--
Kevin Jacobs
The OPAL Group - Enterprise Systems Architect
Voice: (216) 986-0710 x 19         E-mail: jacobs@theopalgroup.com
Fax:   (216) 986-0714              WWW:    http://www.theopalgroup.com



Wed, 7 Nov 2001 17:39:27 -0500 (EST)
Kevin Jacobs <jacobs@penguin.theopalgroup.com>
7.2 Beta2 bug report
Kevin Jacobs <jacobs@penguin.theopalgroup.com> writes:
> The parser seems to have changed from 7.1.3->7.2B2 in a bad way:
>   test=# create table test(timestamp timestamp);
>   ERROR:  parser: parse error at or near "timestamp"

Unfortunately, this isn't a bug.

Unless we can figure out some way to accept SQL92 timestamp type
declarations without requiring TIMESTAMP to be a reserved word.
Hmm...

			regards, tom lane

Thu, 08 Nov 2001 09:04:07 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.2 Beta2 bug report 
On Wed, Nov 07, 2001 at 05:39:27PM -0500, Kevin Jacobs wrote:
> The parser seems to have changed from 7.1.3->7.2B2 in a bad way:
> 
>   test=# create table test(timestamp timestamp);
>   ERROR:  parser: parse error at or near "timestamp"
> 
> Don't-ever-say-I-didn't-test-B2,

(or even from 7.2devel -> 7.2b2) however

test=# create table test("timestamp" timestamp);
CREATE

=> I presume that timestamp has become reserved whereas before it wasn't?

Patrick

Thu, 8 Nov 2001 14:08:57 +0000
Patrick Welche <prlw1@newn.cam.ac.uk>
Re: 7.2 Beta2 bug report
On Thu, 8 Nov 2001, Tom Lane wrote:
> Kevin Jacobs <jacobs@penguin.theopalgroup.com> writes:
> > The parser seems to have changed from 7.1.3->7.2B2 in a bad way:
> >   test=# create table test(timestamp timestamp);
> >   ERROR:  parser: parse error at or near "timestamp"
>
> Unfortunately, this isn't a bug.
>
> Unless we can figure out some way to accept SQL92 timestamp type
> declarations without requiring TIMESTAMP to be a reserved word.
> Hmm...

I'm not very familiar with the grammar, but it seems strange that this works
when timestamp does not:

   test=# create table test (date date);

-Kevin

--
Kevin Jacobs
The OPAL Group - Enterprise Systems Architect
Voice: (216) 986-0710 x 19         E-mail: jacobs@theopalgroup.com
Fax:   (216) 986-0714              WWW:    http://www.theopalgroup.com



Thu, 8 Nov 2001 09:11:23 -0500 (EST)
Kevin Jacobs <jacobs@penguin.theopalgroup.com>
Re: 7.2 Beta2 bug report 
Kevin Jacobs <jacobs@penguin.theopalgroup.com> writes:
> I'm not very familiar with the grammar, but it seems strange that this works
> when timestamp does not:

>    test=# create table test (date date);

Type "date" hasn't got all those gnarly SQL92-isms that we support now:

	TIMESTAMP
	TIMESTAMP(precision)
	TIMESTAMP WITH TIME ZONE
	TIMESTAMP(precision) WITH TIME ZONE
	TIMESTAMP WITHOUT TIME ZONE
	TIMESTAMP(precision) WITHOUT TIME ZONE

However, I'm wondering if something could be done by not having an
explicit production for the first of these, only the other ones.
Off to experiment with bison ...

			regards, tom lane

Thu, 08 Nov 2001 09:16:28 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.2 Beta2 bug report 
On Wed, 7 Nov 2001, Kevin Jacobs wrote:

> The parser seems to have changed from 7.1.3->7.2B2 in a bad way:
> 
>   test=# create table test(timestamp timestamp);
>   ERROR:  parser: parse error at or near "timestamp"

I believe timestamp is now a reserved word. To name a column timestamp
you must double-quote it - during creation and anytime you want to use
it later - as in a query etc.


Cheers,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler


Thu, 8 Nov 2001 06:41:32 -0800 (PST)
"Roderick A. Anderson" <raanders@tincan.org>
Re: 7.2 Beta2 bug report

Timestamp is a reserved word.  You are a naughty person for using it
:).  However, I think that you will find that:

CREATE TABLE test ("timestamp" timestamp);

Works just fine.

Jason

Kevin Jacobs <jacobs@penguin.theopalgroup.com> writes:

> The parser seems to have changed from 7.1.3->7.2B2 in a bad way:
> 
>   test=# create table test(timestamp timestamp);
>   ERROR:  parser: parse error at or near "timestamp"
> 
> Don't-ever-say-I-didn't-test-B2,
> -Kevin
> 
> PS:  CC me on the results, and let me know if there is a better place to
>      submit bugs.  There didn't seem to be anything obvious on the developer
>      site.
> 
> --
> Kevin Jacobs
> The OPAL Group - Enterprise Systems Architect
> Voice: (216) 986-0710 x 19         E-mail: jacobs@theopalgroup.com
> Fax:   (216) 986-0714              WWW:    http://www.theopalgroup.com
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

08 Nov 2001 07:57:01 -0700
Jason Earl <jason.earl@simplot.com>
Re: 7.2 Beta2 bug report