Re: [ADMIN] pg_class / missing tables

2004-09-13 Thread Tom Lane
Wim Kerkhoff <[EMAIL PROTECTED]> writes: > Short story: server was rebooted without being shut down properly, upon > bootup PostgreSQL (7.4.3) starts fine, but a couple of data tables > (along with their associated indexes and sequences) are gone. Other > tables are still there. Hmm. What *exa

Re: [ADMIN] Trigger set to backup to other table NOT FUNCTIONING...

2004-09-13 Thread Oliver Elphick
On Mon, 2004-09-13 at 11:05, Joepie Platteau wrote: > Hi, > I have a problem with my trigger... : > > my tables : > > CREATE TABLE public."T-Alumni" ( > "Id_Persoon" int8 DEFAULT nextval('"T-Alumni_Id_Persoon_seq"'::text) NOT > NULL, ... > CREATE FUNCTION public.f100() RETURNS tri

Re: [ADMIN] pg_class / missing tables

2004-09-13 Thread Chester Kustarz
On Mon, 13 Sep 2004, Wim Kerkhoff wrote: > Short story: server was rebooted without being shut down properly, upon > bootup PostgreSQL (7.4.3) starts fine, but a couple of data tables > (along with their associated indexes and sequences) are gone. Other > tables are still there. Perhaps you have I

[ADMIN] Database size

2004-09-13 Thread Andrew Janian
I have recently inherited a Postgres 7.2 DB. I noticed that the size of the database on the disk is about 100 times the size of the nightly dumps that get done. I looked into it and realized that after millions of rows are deleted each month there was no vacuum full performed on the DB. I als

[ADMIN]

2004-09-13 Thread Monica Libero
help me!I want see all field od this query:SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECTpg_stat_get_backend_idset() AS backendid) s; procpid | current_query-+---    6449 |    6397 |    7905

[ADMIN] Trigger set to backup to other table NOT FUNCTIONING...

2004-09-13 Thread Joepie Platteau
Hi, I have a problem with my trigger... : my tables : CREATE TABLE public."T-Alumni" ( "Id_Persoon" int8 DEFAULT nextval('"T-Alumni_Id_Persoon_seq"'::text) NOT NULL, "SteunendLid" bool, "Betaald" bool, "Stamnr" int4, "Alumninr" int4, "Acjaar" varchar(50), "Studiejaar" varchar(50), CONSTRAINT "T-Al

[ADMIN] pg_class / missing tables

2004-09-13 Thread Wim Kerkhoff
I'm trying to recover a database where some tables 'went missing'... Short story: server was rebooted without being shut down properly, upon bootup PostgreSQL (7.4.3) starts fine, but a couple of data tables (along with their associated indexes and sequences) are gone. Other tables are still the

Re: [ADMIN] dropping a table constraint

2004-09-13 Thread Lee Wu
Title: ___ Did you try:   alter table file_info drop constraint "$1";     -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jodi Kanter Sent: Monday, September 13, 2004 9:31 AM To: Postgres Admin List Subject: [ADMIN]

[ADMIN] dropping a table constraint

2004-09-13 Thread Jodi Kanter
I needed to add a FK constraint to a table where one was forgotten. I found an add constraint command and used it: ALTER TABLE file_info add foreign key (al_fk) references arraylayout(al_pk); However, I wanted to name the constraint. It now looks like this: $1 FOREIGN KEY (al_fk) REFERENCES

[ADMIN]

2004-09-13 Thread Edgars
unsubscribe pgsql-admin [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend