All,
Is there a way to determine cardinality (size) of an
index? In general how to you query the 'attributes'
(for lack of a better word) of an index.
thanks,
Bill
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
not specify 'evt_id' values directly. Does
anybody have any ideas about how this could have
gotten out of sync?
thanks,
Bill
--- Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 12, 2005 at 08:48:15AM -0700, Bill
> Chandler wrote:
>
> > How does one find ou
Is that not correct?
Bill
--- Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 12, 2005 at 07:59:55AM -0700, Bill
> Chandler wrote:
> > I'm sorry, was working on little sleep yesterday.
> You
> > are right, the table was created with the columns
> i
the pg_dump output conatins explicit
evt_id values for each row added so after creating the
database from the pg_dump output the sequence is still
at 1 when it should really be at 23040.
How does one find out the current sequence value? Is
there a way to change it?
Bill
--- Bill Chandler
;10.25', 1, 739950991)
Bill
--- Ragnar Hafstað <[EMAIL PROTECTED]> wrote:
> On Mon, 2005-04-11 at 11:03 -0700, Bill Chandler
> wrote:
>
> > ERROR: duplicate key violates unique constraint
> > event_tbl_evt_id_key
>
> > EVENT_TBL
> > evt_id
For what its worth, the command is being issued via
JDBC app.
If the exact command is important I could have them
turn on logging and I could get that for you.
Bill
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Bill Chandler <[EMAIL PROTECTED]> writes:
> > Client is getting the
Hello,
Client is getting the following error when attempting
to do an insert on a table:
ERROR: duplicate key violates unique constraint
event_tbl_evt_id_key
Client is using PostgreSQL 7.4.2 on Sparcv9 running
Solaris.
We have the following tables:
EVENT_TBL
evt_id bigserial, unique
d1
