From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
---|---|
To: | daq <daq(at)ugyvitelszolgaltato(dot)hu>, kynn(at)panix(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Cannot insert a duplicate key into unique index |
Date: | 2004-02-19 14:33:02 |
Message-ID: | 200402190933.02767.terry@esc1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
It's amazing how much good information comes accross this list. Thanks for the
knowledge.
On Thursday 19 February 2004 09:12 am, daq saith:
>
>
> You can list all the sequences:
>
> select relname from pg_class where relkind='S';
>
> and list all their atributes:
>
> select * from sequence_name;
>
> See "System Catalogs" in the documentation!
>
> DAQ
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Quote: 3
"There is a rank due to the United States, among nations, which will be
withheld, if not absolutely lost, by the reputation of weakness. If we
desire to avoid insult, we must be able to repel it; if we desire to
secure peace, one of the most powerful instruments of our rising prosperity,
it must be known that we are at all times ready for war."
--George Washington
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry(at)esc1(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | kynn | 2004-02-19 14:43:17 | Re: Cannot insert a duplicate key into unique index |
Previous Message | daq | 2004-02-19 14:12:09 | Re: Cannot insert a duplicate key into unique index |