You're running in auto-commit, mode. An implicit commit happens after this statement. Which clears the table.
> Looks right to me. Oops, I see
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
