[BUGS] BUG #3120: relation "pg_catalog.pg_user"

[ravishankar]

The following bug has been logged online:

Bug reference:  3120
Logged by:  ravishankar
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system:   Redhat ES 4.0
Description:relation "pg_catalog.pg_user"
Details: 

If I attempt the commands "\d" in psql, I get this:

ERROR: relation "pg_catalog.pg_user" does not exist

Can anyone suggest or help how to comeout of this problem?

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [BUGS] Bug #651: Time difference of 30 in while reading in timestamp

[R Ravishankar]

Actually the Timestamp class does not use Timezone. Timezone in Java 1.3 can be set 
only on Calendar class objects. Timestamp inherits some methods from the Date class 
but none which concerned with setting timezones :-(

Ravi


 Tom Lane <[EMAIL PROTECTED]>:

> [EMAIL PROTECTED] writes:
> > I am using Java 1.3.1 and Postgres 7.1.2 and am writing timestamp
> without zone info to the database using JDBC (my zone is IST or
> +5:30GMT). I find that there is always a time difference of 30 minutes
> when i read from the database.
> 
> > When i query the postgres database from the SQL prompt, the time is as
> i had written it. But when i read it from the database into my java code
> it is more exactly by 30 mins.
> 
> I assume the datatype of the table column is "timestamp"?  The internal
> storage is in GMT, which is converted to the timezone specified by your
> current TimeZone setting whenever you SELECT the value.  If it works in
> psql then the database side of things seems to be okay.  I suspect that
> in the JDBC case, the backend's TimeZone variable is being set to
> something different than what you think it is (either +5 or +6, not
> 5:30).  Can you try a "SET TimeZone" to set the zone explicitly within
> your JDBC program, and see whether the results change?
> 
>   regards, tom lane
> 

-
Sify Mail - now with Anti-virus protection powered by Trend Micro, USA.
Know more at http://mail.sify.com

Take the shortest route to success! 
Click here to know how http://education.sify.com

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] Bug #651: Time difference of 30 in while reading in timestamp

[R Ravishankar]

Is it safe to assume that this difference of 30 mins would be consistent even if our 
implementation in used across different timezones ? 

Moreover it was found that if we retrieve the resultset as a getString instead of a 
getTimestamp, it returns correctly.

But the valueOf operator to convert this String into a Timestamp cannot be used as the 
String format returned required by valueOf and that got by resultSet.getString are not 
the same.

Is there any official fix for this ?

Thanks.
Ravi



 R Ravishankar <[EMAIL PROTECTED]>:

> Actually the Timestamp class does not use Timezone. Timezone in Java 1.3
> can be set only on Calendar class objects. Timestamp inherits some
> methods from the Date class but none which concerned with setting
> timezones :-(
> 
> Ravi
> 
> 
>  Tom Lane <[EMAIL PROTECTED]>:
> 
> > [EMAIL PROTECTED] writes:
> > > I am using Java 1.3.1 and Postgres 7.1.2 and am writing timestamp
> > without zone info to the database using JDBC (my zone is IST or
> > +5:30GMT). I find that there is always a time difference of 30
> minutes
> > when i read from the database.
> > 
> > > When i query the postgres database from the SQL prompt, the time is
> as
> > i had written it. But when i read it from the database into my java
> code
> > it is more exactly by 30 mins.
> > 
> > I assume the datatype of the table column is "timestamp"?  The
> internal
> > storage is in GMT, which is converted to the timezone specified by
> your
> > current TimeZone setting whenever you SELECT the value.  If it works
> in
> > psql then the database side of things seems to be okay.  I suspect
> that
> > in the JDBC case, the backend's TimeZone variable is being set to
> > something different than what you think it is (either +5 or +6, not
> > 5:30).  Can you try a "SET TimeZone" to set the zone explicitly
> within
> > your JDBC program, and see whether the results change?
> > 
> > regards, tom lane
> > 
> 
> -
> Sify Mail - now with Anti-virus protection powered by Trend Micro, USA.
> Know more at http://mail.sify.com
> 
> Take the shortest route to success! 
> Click here to know how http://education.sify.com
> 

-
Sify Mail - now with Anti-virus protection powered by Trend Micro, USA.
Know more at http://mail.sify.com

Take the shortest route to success! 
Click here to know how http://education.sify.com

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster