bangh wrote:
> Hi steve,
>
> Your command should be like:
> iosdb=>drop sequence "classtable serials";
>
> Use the real name of the sequence, you cannot use serial to imply your sequence
> name. Your sequence seems having space. this is why you need to use the double
> quotation. Your can name your sequence like classtable_serials, later if you
> want to drop, can use
> drop sequence classtable_serials;
Hi Bangh, thanks for your help. I got rid of the sequences, but it told me I had
to use the command "drop table". Unfortunately, the problem is a little deeper
than I thought. I hope you have an idea here. I need to get rid of everything in
the iosdb.
1. I can't have the serials relation or the procedure plpgsql_call_handler.
2. The first thing I did was drop the procedure plpgsql_call_handler:
iosdb=> select * from pg_proc where proname like 'che%' order by
iosdb-> proname ;
proname
|proowner|prolang|proisinh|proistrusted|proiscachable|pronargs|proretset|prorettype|
proargtypes|probyte_pct|properbyte_cpu|propercall_cpu|prooutin_ratio|prosrc|probin
-----------------+--------+-------+--------+------------+-------------+--------+---------+----------+---------------+-----------+--------------+--------------+--------------+------+-------------------------------------
check_foreign_key| 2| 13|f |t |t |
0|f | 0|0 0 0 0 0 0 0 0| 100| 0|
0| 100|- |/usr/lib/postgresql/modules/refint.so
check_primary_key| 2| 13|f |t |t |
0|f | 0|0 0 0 0 0 0 0 0| 100| 0|
0| 100|- |/usr/lib/postgresql/modules/refint.so
(2 rows)
iosdb=> delete from pg_proc where proname like 'che%' ;
DELETE 2
3. Then I drop the classtables and serials relations:
iosdb=> drop table "classtables";
DROP
and to drop the serials relations:
iosdb=> drop table "serials";
DROP
But dropping the classtables and serials recreated the procedure call handler.
Dropping the procedure call handler again recreated the classtables and serials
relations.
Do you know how I can clear all of this out at once?
I really appreciate your assistance.
Thanks again,
Steve
