[GENERAL] Postgres on BSDI-3.1

1999-01-31 Thread Sergei Chernev
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 work with it via ODBC on BSDI-3.1. Compiling and installing postgr

Re: [GENERAL] Question about Linux, threads, and Postgres

1999-01-31 Thread Felix Morley Finch
>>In article <[EMAIL PROTECTED]>, Adam Haberlach ><[EMAIL PROTECTED]> writes: > On Sat, Jan 30, 1999 at 09:08:14PM -0800, Felix Morley Finch wrote: >> Q 2: Is it necessary and/or sufficient to have only one thread talk to >> the Postgres library? > Well, it would be sufficient--I am not

Re: [GENERAL] A forward-compatible pg_dump?

1999-01-31 Thread Oliver Elphick
Herouth Maoz wrote: >After *months* of delays, we are *finally* going to port all our databases >(and that's hundreds of small ones) to 6.4.2 from 6.2.1. >... >So, I recalled that there was somebody who wrote a forward-compatible >pg_dump. Something that works on 6.2.1 (or was it 6.1?) b

[GENERAL] Importing to Postgres from Filemaker Pro

1999-01-31 Thread Adam Haberlach
Has anyone out there done any work getting data from a FileMaker database into postgres? I have about 16000 fairly large records that I need to move from a crufty MacOS machine to a Linux box. I also have Filemaker for NT handy, as well as Lasso. At least four of the fields in the datab

Re: [GENERAL] Question about Linux, threads, and Postgres

1999-01-31 Thread Adam Haberlach
On Sat, Jan 30, 1999 at 09:08:14PM -0800, Felix Morley Finch wrote: > Q 1: Does anyone have experience with Postgres in a threaded program? I have done a bit of this under BeOS (where each window gets its own event loop and thread). My first program turned out to have problems in my ini

[GENERAL] A forward-compatible pg_dump?

1999-01-31 Thread Herouth Maoz
After *months* of delays, we are *finally* going to port all our databases (and that's hundreds of small ones) to 6.4.2 from 6.2.1. So, I took a test-case database and tried to load it from our backup dumps. Ah... Close, but no cigar. Several syntax changes happened over the past two years, inclu

[GENERAL] Missing features ?

1999-01-31 Thread Joerg Huettmann
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 the manual. Can

Re: [GENERAL] viewing/editing function definitions

1999-01-31 Thread Herouth Maoz
At 12:38 +0200 on 28/01/1999, Danny Rice wrote: > With pgaccess I can "Open" a user defined function and see how it was > defined. Is there a way to do this with psql or some other interface > (preferably text based)? What is the best way to edit an existing > function? The only way I can thi

Re: [GENERAL] Re: Displaying Image BLOBs

1999-01-31 Thread Herouth Maoz
At 18:01 +0200 on 26/01/1999, Fabrice Scemama wrote: > Keeping information about sizes of images might be embarrassing, > though I think there's on CPAN Perl modules to learn from an image > it's size, jpeg or gif alike (not sure). > > But people might prefer using only the WIDTH *or* the HEIGHT

[GENERAL] type creates broken view, which can't be deleted

1999-01-31 Thread Charles Hornberger
It looks like there's a bug that allows you to create views with columns of type unknown, and then prevents you from dropping the view/table. alpha_2=> \i brokenview CREATE VIEW article_contrib_info AS SELECT ac.article_id, p,firstname,-- TYPO HERE, USED COMMA

[GENERAL] Postgres on Alpha?

1999-01-31 Thread Adriaan Joubert
Has anybody managed to get any of the postgres 6.4 versions to run correctly on Alpha? I have tried 6.4 through 6.4.2 and cannot get any of them to compile/run (I managed to get some versions to compile after some minor modifications, but then they did not run without crashing). I've tried both th

[GENERAL] Question about Linux, threads, and Postgres

1999-01-31 Thread Felix Morley Finch
I've been running various versions of Postgres for several years now, including one prototype web site for a customer. I currently run 6.3.2 at home, and will upgrade to 6.4.2, but I have some questions. I am programming on Linux 2.0, libc6, in C. I am writing a server application to sit betwee