Hi folks!
I Have a question, in a database are a table with many files (bytea) stored
(I support this database a don't design it), but we need delete many rows
(38000 rows approx), but I when execute query:
BEGIN;
ALTER TABLE my_file_table DISABLE TRIGGER ALL;
DELETE FROM my_file_table WHERE
ta that's not there.
I had a little hope that this possibility will work, but I understand that
is impossible after 2 crashes like those.
Another option? to recover something?
Thanks!
DrakoRod
-
Dame un poco de fe, eso me bastarĂ¡.
Rozvo Ware Solutions
--
Sent from: http://www.p
Hi Tom
I reindex the pg_proc table and reindex finished correctly but I try read
the tables or make the dump and same error, reindexed the database and show
me this error:
ERROR: cache lookup failed for function 125999
Any suggestions, If I run pg_upgrade to 10, will these errors be
Yep!!
Today I tested with triggers instead rules and the sequence goings well.
Thanks for your help!!
-
Dame un poco de fe, eso me bastarĂ¡.
Rozvo Ware Solutions
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
Sorry, your right! The example is:
CREATE TABLE customers (
id serial PRIMARY KEY,
name TEXT,
other_data TEXT
);
CREATE TABLE customers_part1(
CHECK (id<1)
)INHERITS (customers);
CREATE TABLE customers_part2(
CHECK (id>=1 AND id<2)
)INHERITS (customers);
CREATE OR
Hi folks!!
I have a problem with a serial data type and partitioned table, I used rules
to insert in child tables. But the problem is that the some does'nt insert
and the sequence value jump sometimes 3 in 3 or 10 in 10.
The example is the next:
I don't understand why sequence jumps in this