## ✅ Eugene lint report
Script name: `examples/E8/bad/1.sql`
This is a human readable SQL lint report generated by [eugene](https://github.com/kaaveland/eugene).
Keep in mind that lint rules can be ignored in the following two ways:
1. By appending comment directives like `-- eugene: ignore E123` to the SQL statement.
2. By passing `--ignore E123` on the command line.
### ✅ Statement number 1
```sql
-- 1.sql
create table authors (
id integer generated always as identity
primary key,
name text not null
)
```
## ❌ Eugene lint report
Script name: `examples/E8/bad/2.sql`
This is a human readable SQL lint report generated by [eugene](https://github.com/kaaveland/eugene).
Keep in mind that lint rules can be ignored in the following two ways:
1. By appending comment directives like `-- eugene: ignore E123` to the SQL statement.
2. By passing `--ignore E123` on the command line.
### ✅ Statement number 1
```sql
-- 2.sql
set local lock_timeout = '2s'
```
### ❌ Statement number 2
```sql
alter table authors
add constraint authors_name_excl
exclude (name with =)
```
#### Triggered rules
##### `E8`: [Creating a new exclusion constraint](https://kaveland.no/eugene/hints/E8/)
Statement takes `AccessExclusiveLock` on `public.authors`, blocking reads and writes until constraint `authors_name_excl` is validated and has created index.