[GENERAL] Sub Query

Hi, I am getting a PQExec error (backend closed channel) when I run this query. delete from session where age('now',lastused) > '30 minutes'::timespan and sessionid in (select session.sessionid from session,administration where session.sessionid=administration.sessi

No Subject

Hi, I am getting a PQExec error when I run this query. delete from a where age('now

[GENERAL] Upgrading 6.3.1->6.3.2

To upgrade from 6.3.1 to 6.3.2 can I simply do a dumpall and then reload the information back into psql to re-create? Or is it more complicated than that? I do not want any information to be lost. I am running the latest DBD/DBI libraries so I assume I wouldn't have to recompile that or PHP or

[GENERAL] status on IPv6 implementation...

Hi all, I was just wondering if the IPv6 datatype has allready been implemented on the current version of postgres. Thanks, Lorenzo Huerta _ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com

[GENERAL] make[2]: *** [psql] Error 1

when I compile postgres 6.3.2 under linux I have this error with "make all" and "make install": from make install: /usr/lib/libreadline.a(terminal.o): In function `_rl_enable_meta_key': terminal.o(.text+0x7ce): undefined reference to `tputs' /usr/lib/libreadline.a(terminal.o): In function `_rl

[GENERAL] dropping a column from a table

I have been following the discussion about dropping a column with interest, because I ran into this problem just last week. The table I wanted to alter is very central in my database, and therefore has a lot of foreign key triggers defined on it. Am I correct that the method suggested in the FAQ

[GENERAL] Default 'timestamp' value on HP-UX running Postgresql6.3.2

I am re-posting this query to the Interfaces and hackers mailing lists with a little more information... OS: HP_UX 10.2 Version of JDK : 1.1.5 Version of Postgres: 6.3.2 Date Style : ISO I have a default record with a 'timestamp' field. Postgres saves 'epoch' as the default value for this field

[GENERAL] Binary number data type?

Hello, I was wondering if there is any way to implement a binary number type and allow binary math functions (xor, and, or, etc.) on that data in queries etc. Specifically what I'm trying to do is store what departments an employee works in (can be in multiple departments) and store that in a

RE: [GENERAL] Please help with performance tuning on Postgres

Yes, you assume correctly. I have read the FAQ. The only problem is the FAQ's answer is nice, short, and sweet, but does not have any good real world examples or real details.. The only details it mentions is that setting shared memory buffers too high can cause it to crash, and so forth. What is

[GENERAL] [Question] Help me with programming in C/C++

Hi. I have a question regarding programming in C and postgreSQL. Is there any way that I can save couple of results to one PGresult * ?? I got reply from some guys.. but... Ok.. this is what I'm going to do.. I'm developing search engine. Let's assume. If user enter for keywords like "Search En