Adam, * Tom Lane (t...@sss.pgh.pa.us) wrote: > "Brightwell, Adam" <adam.brightw...@crunchydatasolutions.com> writes: > >> ALTER TABLE table_name ADD POLICY policy_name (quals); > >> ALTER TABLE table_name POLICY FOR role_name IS policy_name; > >> ALTER TABLE table_name DROP POLICY policy_name; [...] > This actually isn't just bison being stupid: in fact, you simply > cannot tell whether > > ALTER TABLE tab ADD POLICY varchar(42); > > is an attempt to add a column named "policy" of type varchar(42), or an > attempt to add a policy named "varchar" with quals "42". > > Pick a different syntax.
Yeah, now that we're trying to bake this into ALTER TABLE we need to be a bit more cautious. I'd think: ALTER TABLE tab POLICY ADD ... Would work though? (note: haven't looked/tested myself) Thanks! Stephen
Description: Digital signature