select * from depesz; » truncate

Posts Tagged ‘truncate’

Waiting for 8.4 - partial-match support in GIN, and sequence restart

2008-05-17 17:20:36 CEST | 1 Comment | Tags: bazy danych, gin, pg84, postgresql, prefix, sequence, truncate, tsearch

Today we have two interesting patches:

patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes
patch by Zoltan Boszormenyi, also committed by Tom, which adds “RESTART” option to ALTER SEQUENCE. With some interesting consequences

waiting for 8.4

2008-03-28 22:56:43 CET | 4 Comments | Tags: bazy danych, databases, pg84, plpgsql, postgresql, sql, triggers, truncate

another new, cool feature commited by tom lane: “Support statement-level ON TRUNCATE triggers.”

original patch was submitted by simon riggs, and tom commited it today/yesterday (depending on time zone).