Re: [GENERAL] Problem with copy

2006-04-26 Thread Eduardo Muñoz
Nevermind. It was a problem with the encoding type of the file. --- Eduardo Muñoz <[EMAIL PROTECTED]> escribió: > Hi, I'm trying to copy information from a csv file > using pgadminIII. I run the following command: > > copy cliente from '/path/file.csv' wi

[GENERAL] Problem with copy

2006-04-26 Thread Eduardo Muñoz
Hi, I'm trying to copy information from a csv file using pgadminIII. I run the following command: copy cliente from '/path/file.csv' with csv; The command runs and i get no output. I thought the process could be taking a lot to complete, but i don't think so. I'm trying with just a few records an

[GENERAL] Problem with Transaction

2006-03-08 Thread Eduardo Muñoz
Hi, I'm trying to make a PL/pgSQL function to update or insert if the row is not present. I tested the function and it works fine, but when I call it through JDBC, it executes, but the row is not inserted or updated. This is my JDBC code. try{ connection.setTransactionIsolation

[GENERAL] Problem with function that returns a cursor

2006-03-03 Thread Eduardo Muñoz
I'm new to pgSQL and I'm having some trouble with a function. I keep getting the following error: org.postgresql.util.PSQLException: ERROR: cursor "" does not exist This is the function: CREATE OR REPLACE FUNCTION ret_user(pusername "varchar") RETURNS refcursor AS $BODY$ DECLARE ccursor re

[GENERAL] Problem with Function

2006-03-02 Thread Eduardo Muñoz
Hi, I'm new with pgSQL and I'm not sure why, but I keep getting the same error. I want to call a function that returns a cursor and I keep getting the following exception: org.postgresql.util.PSQLException: ERROR: cursor "" does not exist I would appreciate any help with this problem. This is my