X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FParser%2FPostgreSQL.pm;h=dfe69972d14bfe5987e114db5a6003bd4ac47d25;hb=6f28e7ac29dd1f3fd9b51bca6abaf32f6c7d1537;hp=09a881577cbf8588a512a44c1425da9f81b43d77;hpb=a20abbda86ddc2117f815ac62867bfa3de6a0ab4;p=dbsrgits%2FSQL-Translator.git diff --git a/lib/SQL/Translator/Parser/PostgreSQL.pm b/lib/SQL/Translator/Parser/PostgreSQL.pm index 09a8815..dfe6997 100644 --- a/lib/SQL/Translator/Parser/PostgreSQL.pm +++ b/lib/SQL/Translator/Parser/PostgreSQL.pm @@ -765,6 +765,9 @@ alter : alter_table table_name DROP /constraint/i NAME restrict_or_cascade ';' alter : alter_table table_name /owner/i /to/i NAME ';' { 1 } +alter : alter_sequence NAME /owned/i /by/i column_name ';' + { 1 } + storage_type : /(plain|external|extended|main)/i alter_default_val : SET default_val @@ -832,6 +835,8 @@ add_column : ADD COLUMN(?) alter_table : ALTER TABLE ONLY(?) +alter_sequence : ALTER SEQUENCE + drop_column : DROP COLUMN(?) alter_column : ALTER COLUMN(?) @@ -903,6 +908,8 @@ TABLE : /table/i SEMICOLON : /\s*;\n?/ +SEQUENCE : /sequence/i + INTEGER : /\d+/ WORD : /\w+/