Re: [SQL] FastPath Protocol Error

2001-01-29 Thread Tom Lane
Som <[EMAIL PROTECTED]> writes: > I have problem while retrieving image from postgres 7.0.0 through some > front-end. > I am getting Exception saying: > FastPath protocol error : Z Hm. The 'Z' message was added to the FE/BE protocol in rev 6.4. It looks to me like you've got a client that only

Re: [SQL] SQL Help

2001-01-29 Thread Mark A. Summers
I am loser -- I didn't realize there was analyze option on vacuum -- I created another index on Publisher code -- Now it smokes thanks Mark Summers "Stephan Szabo" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > On Fri, 26 Jan 2001, Mark A. Summers wrote: >

[SQL] Upgrade to 7.0.3

2001-01-29 Thread Mark A. Summers
Currently I am running 6.5.3 should I upgrade to 7.0.3 -- Any advantages or should I wait Maybe I should post this somewhere else but I thought I would ask here first Thanks in advance Mark Summers

Re: [SQL] Upgrade to 7.0.3

2001-01-29 Thread Bruce Momjian
> Currently I am running 6.5.3 should I upgrade to 7.0.3 -- Any advantages or > should I wait > > Maybe I should post this somewhere else but I thought I would ask here first Good question. 7.1 is near final release. You could try that or 7.0.3. Both are more reliable/faster than 6.5.3. --

[SQL]

2001-01-29 Thread Olivier PRENANT
set nomail -- Olivier PRENANT Tel:+33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED]

Re: [SQL]

2001-01-29 Thread Jan Wieck
Olivier PRENANT wrote: > set nomail ERROR: permission denied Jan -- #==# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #=

[SQL] Archival of Live database to Historical database

2001-01-29 Thread Stef Telford
Hello everyone, I have hit on a limit in my knowledge and i am looking for some guidance. Currently I have two seperate databases, one for live data, the other for historical data. The only difference really being that the historical data has a Serial in it so that the tables can keep mo

Re: [SQL] PostgreSQL HOWTO

2001-01-29 Thread Joseph Shraibman
Alvar Freude wrote: > > Hi, > > Poet/Joshua Drake wrote: > > > > >it seems that the author never used any other think then PHP ... > > > > I am afraid I would disagree. I have used all of the languages he metions > > and for the Web, PHP is the best. > > hmm, i guess it's not a good place for a

[SQL] script for unidirectional database update

2001-01-29 Thread Markus Wagner
Hi, I need to periodically transfer the content of one db into another. The target db should be deleted before and there should be one ascii file containing the data, because there's a firewall between the two db's and file transfer ist the most simple thing to do. Does anyone have a script to au