Re: Inserting data of two other tables [Now deleting ...]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nabil Sayegh wrote:

| please send us the output of all involved tables with \d

Here they are:
|           Table "captrajectes"
|    Column   |     Type      | Modifiers
| ------------+---------------+-----------
|  traye      | numeric(5,0)  |
|  linea      | numeric(4,0)  |
|  filler     | character(4)  |
|  n-bill-in  | numeric(9,0)  |
|  n-bill-fi  | numeric(9,0)  |
|  n-bono-in  | numeric(9,0)  |
|  n-bono-fi  | numeric(9,0)  |
|  c-bono-in  | numeric(9,0)  |
|  c-bono-fi  | numeric(9,0)  |
|  turno      | numeric(4,0)  |
|  condu      | numeric(4,0)  |
|  horahora   | numeric(2,0)  |
|  horamin    | numeric(2,0)  |
|  horafihora | numeric(2,0)  |
|  horafimin  | numeric(2,0)  |
|  fecha      | numeric(8,0)  | not null
|  maquina    | numeric(6,0)  |
|  bus        | numeric(4,0)  |
|  billenet   | numeric(5,0)  |
|  euronet    | numeric(7,2)  |
|  eurovalor  | numeric(7,2)  |
|  pkey       | character(10) | not null
|  trec       | numeric(6,0)  |
| Primary key: pkey_fecha
|
|         Table "detalltrajectes"
|    Column   |     Type      | Modifiers
| ------------+---------------+-----------
|  nserie     | numeric(9,0)  |
|  nseriechip | numeric(10,0) |
|  tipotrbus  | numeric(2,0)  |
|  paraor     | numeric(4,0)  |
|  parade     | numeric(4,0)  |
|  hora1hora  | numeric(2,0)  |
|  hora1min   | numeric(2,0)  |
|  pasaindi   | numeric(2,0)  |
|  numvez     | character(2)  |
|  clase      | numeric(4,0)  |
|  tarifa     | numeric(4,0)  |
|  tarneto    | numeric(8,2)  |
|  tarbruto   | numeric(8,2)  |
|  formapago  | numeric(1,0)  |
|  texto      | character(1)  |
|  journey    | character(10) |
|  salreca    | numeric(9,2)  |

Josep Sànchez
~ [papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+1L7R2vx52x0kyz4RArzkAKCG5pYRrHRQ/MCTekngl5R97oWCpQCfblzv
L/yMj/OHn00+unppRMFAggk=
=Cqjl
-----END PGP SIGNATURE-----