search

pavanvd / postgres-xl

Public Postgres-XL repository
Mozilla Public License 2.0
4 stars 3 forks source link

DISCARD SEQUENCES fails to discard sequence value #11

Open pavanvd opened 9 years ago

pavanvd commented 9 years ago

Issue by pavanvd Monday Jun 29, 2015 at 12:58 GMT Originally opened as https://github.com/pavanvd/Postgres-XL-Private/issues/11

*** a/src/test/regress/expected/sequence.out    Tue Jun  2 17:01:55 2015
--- b/src/test/regress/results/sequence.out Mon Jun 29 13:01:14 2015
***************
*** 167,173 ****

  DISCARD SEQUENCES;
  SELECT currval('sequence_test'::regclass);
! ERROR:  currval of sequence "sequence_test" is not yet defined in this session
  DROP SEQUENCE sequence_test;
  -- renaming sequences
  CREATE SEQUENCE foo_seq;
--- 167,177 ----

  DISCARD SEQUENCES;
  SELECT currval('sequence_test'::regclass);
!  currval 
! ---------
!       99
! (1 row)
! 
  DROP SEQUENCE sequence_test;
  -- renaming sequences
  CREATE SEQUENCE foo_seq;