OT : timestamps and jbuilder (help, please)
hi everybody, hope any one can give me some insigth about this one, we
are in great despair :(
we are developing an application using jbuilder 5 and postgresql
7.2.2-1PGDG, and found some strange beheavior with the timestamps, say
for example, in our database we have a record like this one:
id_emp | name | date
--------+--------+------------------------
1004 | laura | 2002-09-19 00:00:00-05
but when displaying this same date in a textfield in our application, it
says the date is 2002-09-18 23:00:00!!!!
the date field is a timestamp with time zone, we tried using a timestamp
without time zone, but our app starts complaining when trying to save
changes to the database about not finding the original row
it gets worst as we need the right date to make some calculations about
the number of days between dates.
when querying this same database using SquirrelSQL (a java database
client), the date apperas correctly as is in the database, so i think
the problem is with the borland dataexpress components, but i'm not
sure, so if somebody got the same problems, it would be greatly
appreciated if can share the solution
many thanks in advance, and best regards
Hullo all.
Developing with PostgreSQL for the first time, and just had a few quick
questions:
1) How are indexes recorded? Is there a system table that stores
sequences/indexes, or are they stored internally? I would like to be
able to access ALL sequences/indexes in a database just by name, so i
can have a program do maintenance ( i.e. delete them when needed ).
2) I need functionality akin to a "DESC table" where i can get a query
result ( from an API, not the command line program ) that describes
type, name, etc. about the fields in a table. I know this one has been
answered here, but i seem to have lost the message i saved about it.
Thanks very much,
dan
On Sunday 03 November 2002 18:47, Dan Ostrowski wrote:
Hullo all.
Developing with PostgreSQL for the first time, and just had a few quick
questions:1) How are indexes recorded? Is there a system table that stores
sequences/indexes, or are they stored internally? I would like to be
able to access ALL sequences/indexes in a database just by name, so i
can have a program do maintenance ( i.e. delete them when needed ).2) I need functionality akin to a "DESC table" where i can get a query
result ( from an API, not the command line program ) that describes
type, name, etc. about the fields in a table. I know this one has been
answered here, but i seem to have lost the message i saved about it.
The short answer:
have a look at the pg_* tables (in psql type \dS )
The "RTFM" answer:
http://www.postgresql.org/idocs/index.php?extend.html
The practical answer:
Start psql with the -E option; this will show you the SQL statements
used when executing various slash commands.
HTH
Ian Barwick
barwick@gmx.net
Ian Barwick <barwick@gmx.net> writes:
The "RTFM" answer:
http://www.postgresql.org/idocs/index.php?extend.html
Also see
http://developer.postgresql.org/docs/postgres/catalogs.html
for the lowdown on all the system catalogs. (As of 7.3, this
is actually pretty complete...)
regards, tom lane
On Saturday 02 Nov 2002 10:25 pm, miguel angel rojas aquino wrote:
hi everybody, hope any one can give me some insigth about this one, we
are in great despair :(we are developing an application using jbuilder 5 and postgresql
7.2.2-1PGDG, and found some strange beheavior with the timestamps, say
for example, in our database we have a record like this one:id_emp | name | date
--------+--------+------------------------
1004 | laura | 2002-09-19 00:00:00-05but when displaying this same date in a textfield in our application, it
says the date is 2002-09-18 23:00:00!!!!
Are you absolutely certain that psql and your java application have the same
timezone in their environment? What happens with a select now()?
--
Richard Huxton