Hi all!
Trying to restore one of my db on PG-7.4.3 (on Debian-Sarge):
$ psql finanza < finanza.out
I get:
-
[...]
ERROR: invalid input syntax for type double precision: "-"
CONTEXT: COPY dep_tit, line 1, column ultima_quot: "-"
ERROR: invalid input syntax for type double precision: "-"
* Tom Lane <[EMAIL PROTECTED]> [231104, 14:37]:
> Ennio-Sr <[EMAIL PROTECTED]> writes:
> > This is an extract of the dump file:
>
>
> > COPY dep_tit (cod_rif, titolo, quantity, costo_med_fisc, data_rif,
> > ultima_quot, data_ult_q) FROM stdin;
> > 1
* Tom Lane <[EMAIL PROTECTED]> [231104, 14:37]:
> Ennio-Sr <[EMAIL PROTECTED]> writes:
> > This is an extract of the dump file:
>
> [...]
>
> If that is the correct analysis then the easiest fix is probably to edit
> the COPY commands to add WITH NULL AS &#x
* Tom Lane <[EMAIL PROTECTED]> [231104, 18:31]:
> Ennio-Sr <[EMAIL PROTECTED]> writes:
> > May I ask how to 'edit the COPY commands'? Perhaps you mean to edit the
> > dump file and add "WITH NULL AS '-' " ?
>
> Yeah.
>
>
[Possible duplicate: original sent to novice never got through! -;(]
Hi all!
Testing a script where I need to make sure that postgresql is running
before passing a instruction I
faced this curious behaviour:
This is the relevant content of the script:
--
#!/bin/bash
/usr/lib/post
Hi!
I'm thinking about creating a table listing my shares (say 'Shares') and
then update its price column from a .txt file (say 'Prices') downloaded
from an internet site periodically.
Recalling past readings my first idea would be to use
something like:
=> update table Shares set price = (select p
* Richard Huxton <[EMAIL PROTECTED]> [020904, 16:54]:
> Ennio-Sr wrote:
>
> >My questions are then:
> [ ... ]
> >2. In case I put the memos in the main table, would it be possible to
> > control someway the display of memo-text fields? [Only some of the
Hi all!
I'm writing a script that presents the user with a numbered lines
menu, each line corresponding to a which executes a psql
command. As the psql-commands are very similar to each other (all of
them have the structure:
1.- psql mydb -x -c "SELECT * FROM tb_nm WHERE col_nm LIKE '%$k_r%'" )
* Jim Wilson <[EMAIL PROTECTED]> [030904, 14:39]:
> Ennio-Sr said:
>
> > (once for all):
> > cmnd=echo psql mydb -x -c "SELECT * FROM tb_nm WHERE $col_nm LIKE '%$k_r%'"
>
> That will be executed immediately, and give you an error.
In fact, ye
* Stephan Szabo <[EMAIL PROTECTED]> [100904, 07:10]:
> On Fri, 10 Sep 2004, Ennio-Sr wrote:
>
> > I slightly modified your queries and the result gets nearer my goals,
> > but ...
> > Here is what I tried:
> > [ ... ]
>
> As an explanation of the dup
* Stephan Szabo <[EMAIL PROTECTED]> [100904, 09:05]:
>
> On Fri, 10 Sep 2004, Ennio-Sr wrote:
>
> > * Stephan Szabo <[EMAIL PROTECTED]> [100904, 07:10]:
> > > On Fri, 10 Sep 2004, Ennio-Sr wrote:
> > > [ big cut ]
>
> Note however, that
* Stephan Szabo <[EMAIL PROTECTED]> [100904, 10:39]:
> On Fri, 10 Sep 2004, Ennio-Sr wrote:
> > > > * Stephan Szabo <[EMAIL PROTECTED]> [100904, 07:10]:
> > > > > On Fri, 10 Sep 2004, Ennio-Sr wrote:
> > > > > [ big cut ]
> > &g
12 matches
Mail list logo
