</para>

<para>

Previously, stripped lexemes got a default location and could be

Previously stripped lexemes got a default location and could be

considered if mixed with non-stripped lexemes.

</para>

</listitem>

</para>

<para>

Previously, <option>-u</> was used to specify the user name.

Previously <option>-u</> was used to specify the user name.

Also spell the long option as <option>--username</>, again for

consistency with other tools.

</para>

<listitem>

<para>

Allow the updating of <link

linkend="SQL-CREATEVIEW-updatable-views">views</link>

where only some columns are auto-updateable (Dean Rasheed)

Allow views to be <link

linkend="SQL-CREATEVIEW-updatable-views">automatically

updated</link> even if they contain some non-updatable columns

(Dean Rasheed)

</para>

<para>

Previously the presence of a non-auto-updateable column prevented

all columns from being auto-updated. Deletes are now supported

on suitable views even if no auto-updateable columns are present.

Previously the presence of non-updatable columns such as

expressions, literals, and function cals prevented automatic

updates. Now <command>INSERT</>s, <command>UPDATE</>s and

<command>DELETE</>s are supported, provided that they do not

attempt to assign new values to any of the non-updatable columns.

</para>

</listitem>

<listitem>

<para>

Allow control over whether <command>INSERT</>s and

<command>UPDATE</>s can add rows to an auto-updateable view that

<command>UPDATE</>s can add rows to an auto-updatable view that

would no longer appear in the view (Dean Rasheed)

</para>

<listitem>

<para>

Allow <link linkend="rules-privileges">security barrier views</>

to be automaticallyupdateable (Dean Rasheed)

to be automaticallyupdatable (Dean Rasheed)

</para>

</listitem>