[GENERAL] Client Installation

1999-02-01 Thread Jeff Gerhart
Is there a minimum set of components that you install for just the client portion of postgres? I want to install just the client portion on a machine (that accesses a server on another machine) without installing the entire postgres environment. I thought I'd seen a place where somebody had b

RE: [GENERAL] Importing to Postgres from Filemaker Pro

1999-02-01 Thread Greg Youngblood
ODBC may be a solution. I dont know if Filemaker supports ODBC, but if it does you can open the database in Filemaker and connect to postgres via ODBC and move the data to postgres that way. Gregory S. Youngblood ext 2164     -Original Message- From: Adam Haberlach [mailto:[EMAIL PROTE

[GENERAL] big bad join problems

1999-02-01 Thread Dustin Sallings
Two messages floated by here last week describing similar optimizer problems, and I didn't see any responses to them. One of them was mine and it's causing some bad delays in my first attempt at running Postgres in production at work. The following query sits in the optimizer (even just

[GENERAL] Variable as a variable name in PL/pgSQL

1999-02-01 Thread Daniele Orlandi
I'm trying to implement a sort of templates for a user database. I tought of two possibilities. In the first I have a table like this: CREATE TABLE templates ( tplname varchar(32), fieldname varchar(32), value varchar(32) ); Where I specify the value to be assigned to each

[GENERAL] web interface for v.6.4.2

1999-02-01 Thread N. Thomas
hello, Can anyone suggest a good web interface for Postgres? I am have currently installed v6.4.2 running under HP-UX 10.20. I want to be able to create, add, sort, and delete records from the web, and to a certain degree, I want to be able to administer it somewhat from the web. If anyone know

[GENERAL] Strange error

1999-02-01 Thread Mark Kettner
Hi all, I'm new to postgres. I started a project with msql, but the project got bigger and bigger and I've reached the limits of msql, so I thought, why not change to postgres. Installing postgres went without any trouble (6.4.2 on a Solaris 2.5 machine). I exported all my tables made with msql a

[GENERAL] Anyone to compile PostgreSQL on 6.4.2?

1999-02-01 Thread Sebestyen Zoltan
I always got the following result everytime I try to compile pg 6.4.2(pwd: /home/szoli/postgresql-6.4.2/src) bash-2.01$ gmake Making postgres.imp ./backend/port/aix/mkldexport.sh postgres /home/szoli/pgsql//bin > postgres.imp nm: postgres: 0654-200 Cannot open the specified file. nm: Nem létező f

Re: [GENERAL] Missing features ?

1999-02-01 Thread Remigiusz Sokolowski
> Hi! > > I'm looking for a kind of history or archive-feature in Postgresql like in the > older postgres versions. > There it was possible by using Tmin and Tmax to recover old states of a > database. > Unfortunatly I didn't find something about database backup and recovery with > postgresql in

Re: [GENERAL] How can I call a function to return a code fragementfrom within a pg_Exec

1999-02-01 Thread Remigiusz Sokolowski
> > Original.. This works, but needs calls to three tables. Where 'code' actually > holds all required info. > $result = pg_Exec($database,"select code,title,price from catalog where ( > title like '%$keyword%' and category like '$category' and language like > '$language') order by code");

Re: [GENERAL] Postgres on BSDI-3.1u

1999-02-01 Thread Bruce Momjian
[Charset koi8-r unsupported, filtering to ASCII...] > Hello, > > Does anybody know about supporting postgres on BSDI-3.1. > I know it works well on BSDI-4.0 platform, but i have no this version > yet. > Current version (v6.4) of postgres does not work with PL/pgSQL and > server crashing when i w