I understand, yep is a 9.5 version, Can I use query like this to execute
smaller batches?:
DELETE FROM my_table
WHERE id IN (
SELECT id
FROM logtable
LIMIT 10
);
Thanks
-
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
Sent from: https://www.postgresql-archive.org
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 i
ally restore data 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
--
Sen
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 corrected?
Hi folks!
I've a big problem with a database, is a PostgreSQL 9.6 version on Ubuntu.
When a tried read some tables (approximately 7 of 1073) show this error:
*ERROR: cache lookup failed for function 125940*
So, I was reading this like data corruption specially the postgresql's
system catalog .
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 R
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
