[GENERAL] Catch individual exceptions

hi all, i want to capture individual sqlexceptions and for each different exception i want to display a different message to the user. the problem is how should i capture from the exception of its type-content and then display a customised message. all help appreciated. thanks. --

[GENERAL] temp tables problem

hi all, i am working on a java based web application. this application connects to a postgres DB. now within some pages i am using temp tables to perform some calculation. when i access these pages locally it works fine. however when i access the web app remotely (as in over the web or on the netw

Re: [GENERAL] temp tables problem

just to add on that, there is only one user for the db. so both application accesses use the same db username and password. the web app automatically logs into the db in with the one username and password for both remote and local access. ---(end of broadcast)-

[GENERAL] deleting table content through command prompt

hi all, i am trying to create a database backup and restore windows batch file, which when run will do a database table backup and a corresponding table restore. now for table_usernames backup i run something like from the command prompt, pg_dump.exe -i -h localhost -p 5432 -U postgres -F t -v -f

Re: [GENERAL] Cant find temp tables

could be. i will have a look at the pgadmin site and see if i can find anything. but the pgadmin guys couldnt have missed this problem, seems to be pretty important functionality. thanks. ---(end of broadcast)--- TIP 6: explain analyze is your frien

[GENERAL] Cant find temp tables

hi all, i am struggling with temp tables. i have a statement like CREATE TEMP TABLE test (a BIGINT); it executes successfully, hence i know that the table has been created. but i cant see the table within the DB using PGADMIN. if i do SELECT * FROM test; it returns 0 records, but it still tells me

[GENERAL] Create a new table

hi all, i am trying to create a postgres table from within my java code. now the scenario is that the user selects a date range and clicks submit from my HTML form. now i want to create a table, which contains records for each hour within that date range as a timestamp and another column for value

[GENERAL] URGENT!!! SELECT statement please help

hi all, i have a web based java application with a postgres db. now i am trying to generate a temp table which contains all hour records for a selected date range. eg. if the user selects 2006-03-14 as from and 2006-03-14 as to, the system should insert 24 hour records with their individual time

Re: [GENERAL] Create a new table

i just had this thought. i should take both dates, subtract them and multiply the figure by 24. then i should insert that many rows with their individual timestamps into the table in a sequential order. eg 2005-12-12 12:00:00 2005-12-13 01:00:00 and so on. can somebody please guide me in this

[GENERAL] Hour records within a date range

hi all, i am trying to take a datefrom and dateto from a user and insert all hour records within that date range within the db. eg, if the user selects 2006-03-14 as datefrom and 2006-03-14 as dateto, the system would insert 24 rows within the table with their corresponding timestamps (eg 2006-03-1

[GENERAL] catch SELECT statement return

hi all, i am working on this postgresql statement. it picks up all non-null values only. is there a way to pickup all hour values (if any hour value not existing, still find them and assign their value to be 0). coz my table does not contain all hour values, only ones which have a non-zero value.

[GENERAL] Java, postgres and jasper help

hi all, i am trying to fix this bug within my program. its a java, postgres and jasper based program which generates charts. now i am generating a chart which does not show any 0 data points if they exist, only non-zero ones. obviously i am trying to do everything in just one sql query, but i am n