From: | dmorgan(at)corpmedia(dot)com (Danny Morgan) |
---|---|
To: | bruno(at)wolff(dot)to |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Sequences |
Date: | 2002-10-28 21:51:31 |
Message-ID: | "H00000be0014168d.1035841891.cmg-mail-1.com*"@MHS |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks, worked like a charm.
Danny L. Morgan
-----Original Message-----
From: bruno [mailto:bruno(at)wolff(dot)to]
Sent: Monday, October 28, 2002 4:42 PM
To: dmorgan
Cc: pgsql-admin
Subject: Re: [ADMIN] Sequences
On Mon, Oct 28, 2002 at 14:00:44 -0500,
Danny Morgan <dmorgan(at)corpmedia(dot)com> wrote:
> I have a strange dilemma. I've created a couple sequences I can't
> remove.
>
> Here is an example
>
> I can
> CREATE SEQUENCE "count1" ..........;
> DROP SEQUENCE count1;
>
> I can't
> CREATE SEQUENCE "count1ListItems1" ..........;
> DROP SEQUENCE count1ListItems1;
Try:
DROP SEQUENCE "count1ListItems1";
(Quoting preserves capitalization.)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Devinder K Rajput | 2002-10-28 23:19:21 | views across databases |
Previous Message | David Bear | 2002-10-28 21:48:25 | pg_hba.conf on win32 |