Thanks for answer, I will use TIMESTAMP WITH TIMEZONE.
--
Best regards,
Julian Legeny
mailto:[EMAIL PROTECTED]
=
On Thu, Nov 10, 2005 at 04:37:36PM +0100, [EMAIL PROTECTED] wrote:
> Hello,
>
> I have question about func
Hello,
I have question about functionality for TIMESTAMP (with/without time zone).
The main question is, what is better for usage: timemestamp WITH or WITHOUT
time zone?
I have e.g. server in USA and there is 6:00 a.m. Then I have client somwhere in
Europe (+7 hour) and I read timestamp
Hello,
I have problem that I can't to call function because postgres can't to find
this function with specified parameters and I receive following error:
Caused by: java.sql.SQLException: ERROR: function update_bf_domain(integer,
character varying,
characte
Hello,
I have problem to configure postgers datasource for
WebSphere Application Server 6 (WAS6) from admin console.
1.) I have configured new JDBC Provider for PostgreSQL as
following:
Name: Postgres JDBC Provider
Class path: ${UNIVERSAL_JDBC_DRIVER_P
Thank you for your answer. I think it's very interesting behaviour. Is
it a feature or bug ?
I have try this my jUnit test for another DB systems (e.g. Oracle 9i,
MS SQL Server 2000, MySQL, DB2, Sybase, SAP DB) and it works for each of
these databases (it was possible tu run next command succes
Hello,
I have the question about VACUUM ANALYZE. I have try to do Postgres
performance tests for selecting large amount of records from DB.
First I have insert 30.000 records into the 1 table. After this
insert I executed VACUUM ANALYZE query.
I have a test that retrieves page by page (2
Hello,
I'm using postgreSQL 8.0 beta1 and JDK 1.4.
I have following problem:
I have create test table that contains only unique column :
CREATE TABLE UNIQUE_COLUMN_TEST (
TEST_ID INTEGER,
CONSTRAINT TEST_ID_UQ UNIQUE (TEST_ID)
)
Within one transaction I have insert a few records int
