Top "Postgresql-8.4" questions

RETURN cannot have a parameter in function returning set; use RETURN NEXT at or near "QUERY" Postgres

When I try to compile this function: CREATE OR REPLACE FUNCTION test_proc4(sr_num bigint) RETURNS TABLE(sr_number …

postgresql postgresql-8.4

Importing CSV with commas in string values

I am trying to import a trivial CSV to Postgres 8.4 database: Here is a table: CREATE TABLE public.sample ( a …

postgresql csv postgresql-8.4 postgresql-copy

COPY (import) data into PostgreSQL array column

How should a (CSV?) text file be formatted so that it can be imported (with COPY?) into an array column …

arrays postgresql postgresql-8.4

Restore Postgres Database from pg_data directory

I have a broken VM that won't boot with an old postgresql database on it (used to run PostgreSQL 8.4). I …

directory restore postgresql-8.4

PostgreSQL drop table command is not reducing DB size

I dropped a couple of tables from my Postgres database. However, before dropping tables the size of the database was 6586…

sql postgresql postgresql-9.1 postgresql-9.2 postgresql-8.4

Fetch records that are non zero after the decimal point in PostgreSQL

I have a table with an amount field of type Numeric. It contains different amount values. For example 5.00 7.13 8.86 6.00 1.00 ... etc. I've …

sql postgresql types postgresql-8.4

Find duplicate records in large table on multiple columns the right way

I have read many threads on this subject now and tried a few things but it has not worked as …

sql postgresql postgresql-8.4

PostgreSQL - inconsistent COPY permissions errors

I am using the EnterpriseDB pgAdmin III (v. 1.12.1) on a Windows 7, 32-bit machine to work with PostgreSQL databases on a …

permissions pgadmin postgresql-8.4

Error "cannot insert multiple commands into a prepared statement"

Using PHP 5.3.3, PostgreSQL 8.4.11, pgbouncer 1.3.4 (in session mode) on CentOS 6.2 I'm trying to execute several SQL commands and fetch the results …

php postgresql pdo postgresql-8.4

Cannot get log_min_duration_statement to work

I have been googling for more than 2 hours, but I am really stuck with this one. I want PostgreSQL (I …

postgresql logging configuration postgresql-8.4