Thread: Problems with pgAdmin V1.4.2

Problems with pgAdmin V1.4.2

From
"Simon Hart"
Date:
Hi,
 
First many thanks for pgAdminII.
 
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.
 
- 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.
 
- 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'?
 
- The pgAdminII help seems to be 'thin on the ground' - there's plenty of postgresql help though.
 
Many thanks,
Simon Hart

Re: Problems with pgAdmin V1.4.2

From
"Dave Page"
Date:
 
-----Original Message-----
From: Simon Hart [mailto:simon.hart@totalise.co.uk]
Sent: 05 December 2002 21:29
To: pgadmin-support@postgresql.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.

Re: Problems with pgAdmin V1.4.2

From
"Dave Page"
Date:
Hi Simon (again :-) )
-----Original Message-----
From: Simon Hart [mailto:simon.hart@totalise.co.uk]
Sent: 05 December 2002 21:29
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Problems with pgAdmin V1.4.2
 
- 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.
 
I've just committed changes to fix this to CVS. If you want to try a snapshot build, you can download a tarball from the binaries director on http://cvs.pgadmin.org/. Installation instructions are in the readme.
 
Regards, Dave.