Re: [GENERAL] Restore from dump file: parse error

At 10:37 +0300 on 10/05/1999, darold wrote: > Hi, > > Well to quote that single quote, you have to quote that single quote :-) > ex : s_field='suivre l'actualite' > => s_field='suivre l''actualite' > > pg_dump -D mydatabase > recover.sql or other options will never solve > this pg_dump feature

Re: [GENERAL] virtual fields ( proxy execution ?? )

Hi Err maybe that was a bad example. How about this ... I have ( not really ) a large number of programmable power supplies connected to my remote Linux box where the details about each supply are stored in a database.( eg 100 supplies = 100 records ). One of the fields in each record might be

Re: [GENERAL] virtual fields ( proxy execution ?? )

> Hi > Err maybe that was a bad example. How about this ... I have ( not really ) > a large number of programmable power supplies connected to my remote Linux box > where the details about each supply are stored in a database.( eg 100 supplies > = 100 records ). One of the fields in each recor

Re: [GENERAL] virtual fields ( proxy execution ?? )

You can set up a trigger to be activated on any event such as UPDATE. The trigger calls a function which may be a C function. The trigger can take arguments. So I would say if you wrote a C function which execve()'s its arguments that would be what you want. I agree that it sounds useful enough

[GENERAL] pg_database corrupted(?) If so, what do I do????

Solaris 7 : snapshot dated 0506 The system has been running fine for several months. Yesterday it crashed and I have not been able to get it back. This is the message I get when I try to access the db from psql : bash-2.02$ psql Connection to database 'cdmwhere' failed. FATAL 1: Database 'cdm

Re: [GENERAL] dbase converter

Is this address on our web site. It should be. > > > Is there a dbase3 <=> postgresql converter available at all? I found > > > dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as > > > > > > -p primary: > > > Select the primary key. You have to give the exact >

Currency field is too small (formerly: RE: [GENERAL] Empty Date Field)

Try the numeric data type. You may want to use version 6.5 because numeric data type support has been expanded in 6.5. > -Original Message- > From: fabian baena [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, May 09, 1999 11:50 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject:

Re: [GENERAL] Problem with an indexing on a large table. Suggestionsneeded.

Can you try 6.5 beta when you can and let us know. Thomas, is this going to work better in 6.5beta? > > Folks, > > I have a very large table (10Gb, 20 million records each with 54 fields) > with both float, integer and text values. If I submit a query such as: > > select * from myt

RE: [GENERAL] pg_database corrupted(?) If so, what do I do????

More info: bash-2.02$ psql -l datname |datdba|encoding|datpath -+--++- template1| 1002| 0|template1 jonny| 1001| 0|jonny hom | 1003| 0|H cdmwhere | 1005| 0|cdmw H (4

[GENERAL] IRC, webcam, IM

I have reconfigured my system so I automatically connect to IRC and AOL's Instant messenger when I start Netscape, so people will see me more active in these areas. In IRC, I am on channel #postgresql(see FAQ for info), and in AOL/IM, I am bmomjian. (All my neighbors are on AOL. What can I say?

[GENERAL] Re: IRC, webcam, IM

> I have reconfigured my system so I automatically connect to IRC and > AOL's Instant messenger when I start Netscape, so people will see me > more active in these areas. > > In IRC, I am on channel #postgresql(see FAQ for info), and in AOL/IM, I > am bmomjian. (All my neighbors are on AOL. Wha