[GENERAL] cannot create table using pl/perl

Installed latest postgresql 8 on windows xp, everything works fine with pl/pgsql; problems creating a table with perl however: CREATE OR REPLACE FUNCTION datetable() RETURNS integer AS $$ CREATE TABLE tabletest ( dayofmonth int4, monthofyear int4, theyear int4 ) $$ LANGUAG

[GENERAL] prepared statement already exists

Hi! In a function to insert rows into a table, I keep getting ERROR: prepared statement "updateplan" already exists. If any ideas; thanks. CREATE OR REPLACE FUNCTION testPreparedStatement() RETURNS SETOF FLOAT AS $$ DECLARE tryint1 int4:=1 ; tryint2 int4:=2 ; BEGIN PREPARE updatePlan

[GENERAL] cannot open pg_database

Installing with yum, Fedora core 5. Get error: "could not open file "global/pg_database": No such file or directory." The file exists however, in /var/lib/pgsql/data/global and contains 3 lines: “postgres” 10793 1663 499 499 “template” 1 1663 499 499 “template0” 10792 1663 499 499 >From the use

[GENERAL] copy command

Hi! - Fedora Core 5, cannot copy text file into a table called datetime, yet the permissions seem OK: copy datetime from '/home/jb/Desktop/DateTimeData.txt' with csv; ERROR: could not open file "/home/jb/Desktop/DateTimeData.txt" for reading: Permission denied -rw-rw-r-- 1 jb jb 83 Au