This is for PostgreSQL questions specific to version 8.4.
I am working on an open source application that has PostgreSQL as its default DBMS. Now when I install it …
postgresql postgresql-8.4This question may seem to be a possible duplicate of some other questions that are related to this topic. I've …
postgresql postgresql-8.4 audit-trailUnfortunately, I have removed super user privileges from postgres user in PostgreSQL. And currently I have not any super user …
postgresql-8.4I need to add minutes coming from an integer column with a timestamp to compare to another column. Here's an …
postgresql postgresql-8.4I have a view and want to make one attribute a primary key. CREATE VIEW filedata_view AS SELECT num …
postgresql postgresql-8.4I'm creating a select statement that combines two tables, zone and output, based on a referenced device table and on …
sql postgresql postgresql-8.4I'm trying to run a Drupal migration via SSH and drush (a command line shell), copying data from a postgres …
postgresql drupal postgresql-8.4I am working with a PostgreSQL 8.4.13 database. Recently I had around around 86.5 million records in a table. I deleted almost …
postgresql postgresql-8.4 vacuumThis question concerns Postgresql 8.3. I cannot yet create tags so Ichose version 8.4 as tag. It's a test server, but I …
postgresql postgresql-8.4I have have a column name MyRoles that contains a list of items (integers) stored in a field named UserRoles. …
sql postgresql-8.4 denormalized