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
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
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
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
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
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
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
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]
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
unsubscribe pgsql-admin [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
10 matches
Mail list logo