i'm having the same problem running pg8.0.1 on redhat enterprise linux
AS 3 (2.4.21-27.0.4.ELsmp).
shutting off my firewall via 'service iptables stop' solves the
problem... what needs to be modified in the iptables to allow remote pg
connections?
Richard Huxton wrote:
Michael Korotun wrote:
H
dear readers,
i've created a simple Fooey table that inherits from Foo:
!--!
CREATE TABLE Foo(
fooid serial UNIQUE,
footype text);
CREATE TABLE Fooey(
datatext);
INHERITS(Foo);
!---
hi,
i would like to use lo_import() on the client side to insert images
into postgresql version 8.0.1 on a remote server using psql as follows:
psql -h my.db.host.com -U user -c "insert into binblob (binary_blob)
values(lo_import('/path/on/client/machine/ks.jpg'))" -d mydb
i'm getting the
hi,
i'm setting up a forum that's connected to postgresql 7.4.2 (via
drupal.org framework) and i'm getting some errors. here's the link,
followed by the errors verbatim:
http://128.32.146.140/dmap/?q=forum
warning: pg_query(): Query failed: ERROR: invalid input syntax for type
boolean: "2"
CONT
hi bruno,
would it be useful to see the IF PLSQL function, or would you recommend
a modification to the database.pgsql.inc file?
On Jan 5, 2005, at 10:52 AM, Bruno Wolff III wrote:
On Wed, Jan 05, 2005 at 10:17:39 -0800,
Aaron Steele <[EMAIL PROTECTED]> wrote:
hi,
warning: pg_query():
hi steven,
here's another file where the actual SQL query (the one in the error
message) is defined. it's in the forum_get_forums() function. bruno
noticed that the IF (via pl/pgsql) might not like the boolean casting
to "2" since 7.4 is more strict about casting? does this help?
/**
* @file
hi bruno,
turns out that l.last_comment_uid and l.last_comment_name are integer
and char var respectively. since i'm using 7.4.1 with strict boolean
casting, is there a better alternative to instantiating a different
version of pgsql on my server?
In the php code you showed the following fragme
.uid AND
n.nid = l.nid AND " . node_access_where_sql() . ' ORDER BY
l.last_comment_timestamp DESC', $forum->tid, 0, 1));
thanks for all the support!
aaron
On Jan 6, 2005, at 10:25 PM, Bruno Wolff III wrote:
On Thu, Jan 06, 2005 at 17:32:30 -0800,
Aaron Steele <[EMAIL PROTECTED]> wrote:
