Christian Rank wrote:
create table a (n integer);
create table b (n integer);
alter table a add primary key (n);
alter table b add foreign key (n) references a(n);
Have you considered using "on delete cascade" in table b?
--
jimoe at sohnen-moe dot com
-
Augusto Cesar Castoldi wrote:
How can I configure postgreSQL to search without acents?
Table “test”
Clumns: name , values:
Test
Test
tést
Tést
Since those are actually different characters that only look the
same, you would have to use another approach:
select * from test where name like '