Let's imagine following situation: create table test (id int4 primary key, priority int4); insert into test (id) select distinct (random() * 100000000)::int4 from generate_series(1,1000); Table test will now contain some (up to 1000) records, with random ids. Now, we want to ...
On 15th of July, Bruce Momjian commited patch written by Dickson S. Guedes, which: Have psql \d show the value of sequence columns.
May 17th, 2008 by depesz | Tags: gin, pg84, postgresql, prefix, sequence, truncate, tsearch | 1 comment »
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 ...
