NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit9310075

Thomas G. Lockhart

committed

Accept an INTERVAL argument for SET TIME ZONE per SQL99.

Modified the parser and the SET handlers to use full Node structures rather than simply a character string argument.Implement INTERVAL() YEAR TO MONTH (etc) syntax per SQL99. Does not yet accept the goofy string format that goes along with, but this should be fairly straight forward to fix now as a bug or later as a feature.Implement precision for the INTERVAL() type. Use the typmod mechanism for both of INTERVAL features.Fix the INTERVAL syntax in the parser: opt_interval was in the wrong place.INTERVAL is now a reserved word, otherwise we get reduce/reduce errors.Implement an explicit date_part() function for TIMETZ. Should fix coersion problem with INTERVAL reported by Peter E.Fix up some error messages for date/time types. Use all caps for type names within message.Fix recently introduced side-effect bug disabling 'epoch' as a recognized field for date_part() etc. Reported by Peter E. (??)Bump catalog version number.Rename "microseconds" current transaction time field from ...Msec to ...Usec. Duh!date/time regression tests updated for reference platform, but a few changes will be necessary for others.

1 parent6254465 commit9310075Copy full SHA for 9310075

File tree

23 files changed

+942

-370

lines changed

src
- backend
  - access/transam
    - xact.c
  - commands
    - variable.c
  - nodes
    - copyfuncs.c
    - equalfuncs.c
  - parser
    - gram.y
  - tcop
    - utility.c
  - utils/adt
- include
  - access
    - xact.h
  - catalog
    - catversion.h
    - pg_proc.h
  - commands
    - variable.h
  - nodes
    - parsenodes.h
  - utils
- interfaces/odbc
  - convert.c
- test/regress
  - expected
  - sql
    - horology.sql

23 files changed

+942

-370

lines changed

`‎src/backend/access/transam/xact.c`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/access/transam/xact.c,v 1.111 2001/09/29 04:02:21 tgl Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/access/transam/xact.c,v 1.112 2001/10/18 17:30:03 thomas Exp $`
`12`	`12`	`*`
`13`	`13`	`* NOTES`
`14`	`14`	`*Transaction aborts can now occur two ways:`
`@@ -378,7 +378,7 @@ GetCurrentTransactionStartTimeUsec(int *msec)`
`378`	`378`	`{`
`379`	`379`	`TransactionStates=CurrentTransactionState;`
`380`	`380`
`381`		`-*msec=s->startTimeMsec;`
	`381`	`+*msec=s->startTimeUsec;`
`382`	`382`
`383`	`383`	`returns->startTime;`
`384`	`384`	`}`
`@@ -877,7 +877,7 @@ StartTransaction(void)`
`877`	`877`	`#ifNOT_USED`
`878`	`878`	`s->startTime=GetCurrentAbsoluteTime();`
`879`	`879`	`#endif`
`880`		`-s->startTime=GetCurrentAbsoluteTimeUsec(&(s->startTimeMsec));`
	`880`	`+s->startTime=GetCurrentAbsoluteTimeUsec(&(s->startTimeUsec));`
`881`	`881`
`882`	`882`	`/*`
`883`	`883`	`* initialize the various transaction subsystems`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit9310075

File tree

23 files changed

23 files changed

`‎src/backend/access/transam/xact.c`

0 commit comments