I deleted all the rows, approximately 3 million, in a table earlier in
the day, so during the nightly routine vacuum, I received the following:
dbname=# vacuum verbose analyze table;
INFO: vacuuming "public.table"
INFO: index "table_attempt_idx" now contains 3895682 row versions in 103829
pages
I'm using PostgreSQL 7.4.2, and I'm having a little issue with rules.
I created a rule to watch for any inserts to table XYZ, and registered
a listener. But as I simply do a select on the table, I receive several
notifications when nothing has been inserted into the table.
db=# create rule xyz_in
I've created a type that contains a few types and an array. But when
I try to create an array from that in a table, I get a '"type[]" does
not exist' error. The manual says that the array type is configured
automatically when a type is created, but this doesn't appear to be
the case. Am I missing s
I have a table that contains my unique identifiers and their
respective values. In another table, I have a field that is an
array of integers.
Is there a simple way for one to build a constraint that checks
each array value against the primary key table even though the
field types don't exactly ma
