Re: Problems with pgAdmin V1.4.2

-----Original Message-----
From: Simon Hart [mailto:simon(dot)hart(at)totalise(dot)co(dot)uk]
Sent: 05 December 2002 21:29
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Problems with pgAdmin V1.4.2


Hi,

First many thanks for pgAdminII.

You're welcome.

I've only just started using postgresql with pgAdminII so bear
with me if I'm being stupid but:

- If I edit table data in the SQL output data viewer, I cannot
delete any fields of type 'date'. I get the error 'bad date external
representation' when I try and save the record. I have tried but can
find no way round this.

There isn't. pgAdmin assumes you want to enter an empty string as it
doesn't handle most data types in any special way. I'll have to look at
how an empty date can be set to null.

- Also in the same viewer, the bubble help for the 'refresh'
button is incorrect, it reads 'Delete the selected record'. This is
obviously where the delete button parameters were copies over and not
completely updated.

Thanks, fixed.

- I would dearly love to be able to edit and resave data from
within the data viewer when using it with a view. Attempting to do this
seems to generate the error 'unterminated qouted identifier'?

You shouldn't be able to edit view data at all - can you send me a full
debug logfile from the time you press the 'View Data' or 'Execute'
button until the error occurs please?

- The pgAdminII help seems to be 'thin on the ground' - there's
plenty of postgresql help though.

Unfortunately there are only so many hours in the day and I much prefer
coding to writing docs. If there are any volunteers though....

Regards, Dave.