Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
3286 Zobrazení

hello guys. i want to ask some questions about SQL constraints when importing data in odoo

let's say i have 1 field (name) and I've added SQL constraints unique to that field.. what happens if we importing 2 rows with the same name?


for example:
rows 1: test123
rows 2: test123


do the validation sql constraints pop up shows or we keep importing the data but only the last row (row 2)? thanks


Avatar
Zrušit
Nejlepší odpověď

Hi,
The SQL constraints do work while importing data.
Regards

Avatar
Zrušit
Nejlepší odpověď

You can check importing with sample date.

I think import will fail due to constraint error. Once remove duplicate row, then only import success.

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
pro 23
3424
0
čvn 21
2728
1
lis 20
4539
2
bře 24
5770
1
čvc 23
1742