[SQL] Re: START for SERIAL type?

read the doc section datatype!!! serial just create a sequence on a standard way, if you dont like it you'll have to create your sequence. bye -- -- "L'idea di base è estremamente semplice..." ©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900) ---(end

[SQL] Re: INSERT value of type table

> exemple: > CRETAE TABLE Address (Number integer, Street varchar, city varchar, contry > varchar); > CREATE TABLE Person (Name varchar, addr Address); > INSERT INTO addrerss VALUES ( 5, 'rue du pont', 'Lyon', 'France'); > The question is : > How we can insert a new person whose address is that i

[SQL] Re: Is it possible to defer triggers?

read this: http://www.postgresql.org/idocs/index.php?sql-createtrigger.html bye -- -- "L'idea di base è estremamente semplice..." ©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900) ---(end of broadcast)--- TIP 4: Don't 'kill -9

[SQL] Re: Slow inserts/deletes

If you use index on this table it's better to: 1) drop all index on the table 2) do the insert 3) (re)create the indexes -- -- "L'idea di base è estremamente semplice..." ©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900) ---(end of broadcast)---