Postgresql wrong syntax for marking column as not null

[expired user #9707]'s profile image [expired user #9707] posted 8 years ago in Feature discussion Permalink

e.g.

ALTER TABLE "user_shipment" ALTER COLUMN  "ship_cpl_id" VARCHAR(20) NULL;

should be

ALTER TABLE public.user_shipment ALTER COLUMN ship_cpl_id DROP NOT NULL;

One by one we will get to full PostgreSQL support :D

Thanks again for your help

Regards, Ben

[expired user #9707]'s profile image [expired user #9707] posted 8 years ago Permalink

BTW if Github is updated I am happy to submit these small tweaks as pull requests :)

It would also help if you can send the commit ID of one of the changes so I can see where the change needs to be implemented.

Please login to leave a reply, or register at first.