[Bug]: Not able to convert Table for columnar access

[shah-manthan9]

What's wrong?

When I am trying set the access method to columnar I am getting following error.

SQL Error [22P02]: ERROR: invalid input syntax for type boolean: "2"
  Where: PL/pgSQL function columnar.alter_table_set_access_method(text,text) line 57 at IF

Table Definition

CREATE TABLE public.master_country (
	id uuid NOT NULL,
	country_name varchar(100) NOT NULL,
	country_code varchar(5) NOT NULL,
	numeric_code int4 NOT NULL,
	status int4 NOT NULL,
	created_at timestamptz NOT NULL,
	modified_at timestamptz NOT NULL,
	created_by_id uuid NULL,
	modified_by_id uuid NULL,
	latitude varchar(35) NULL,
	longitude varchar(35) NULL,
	CONSTRAINT master_country_country_code_key UNIQUE (country_code),
	CONSTRAINT master_country_country_name_key UNIQUE (country_name),
	CONSTRAINT master_country_pkey PRIMARY KEY (id),
	CONSTRAINT master_country_created_by_id_61f003bf_fk_account_user_id FOREIGN KEY (created_by_id) REFERENCES public.account_user(id) DEFERRABLE INITIALLY DEFERRED,
	CONSTRAINT master_country_modified_by_id_23d8e1a8_fk_account_user_id FOREIGN KEY (modified_by_id) REFERENCES public.account_user(id) DEFERRABLE INITIALLY DEFERRED
);
CREATE INDEX master_country_country_code_60ea7291_like ON public.master_country USING btree (country_code varchar_pattern_ops);
CREATE INDEX master_country_country_name_f78e10e8_like ON public.master_country USING btree (country_name varchar_pattern_ops);
CREATE INDEX master_country_created_by_id_61f003bf ON public.master_country USING btree (created_by_id);
CREATE INDEX master_country_modified_by_id_23d8e1a8 ON public.master_country USING btree (modified_by_id);

Query I am using to change access method

SELECT columnar.alter_table_set_access_method('master_country', 'columnar');

[mkaruza]

Hi @shah-manthan9

Thank you for reporting bug, this is going to be fixed in #136. Just for quick information, conversion doesn't work if table has foreign keys or is referenced by other table.