Re: [ADMIN] [JDBC] [PERFORM] is a good practice to create an index on the

[Edoardo Ceccarelli]

do you mean that, declaring an index serial, I'd never have to deal with 
incrementing its primary key? good to know!
anyway  in this particular situation I don't need such accurate 
behaviour: this table is filled up with a lot of data twice per week and 
it's used only to answer queries.
I could drop it whenever I want :)

Thanks again,
eddy
Christopher Kings-Lynne ha scritto:
I am going to use them as primary key of the table, so I'll surely 
need them unique :)

Eduoardo, I REALLY suggest you don't use them at all.  You should make 
a primary key like this:

CREATE TABLE blah (
  id SERIAL PRIMARY KEY,
  ...
);
Also note that by default, OIDs are NOT dumped by pg_dump.  You will 
need to add extra switches to your pg_dump backup to ensure that they 
are.

Chris
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html