Re: [GENERAL] Connection question

- Original Message - From: Craig Ringer cr...@postnewspapers.com.au To: Bayless Kirtley bk...@cox.net Cc: List, Postgres pgsql-general@postgresql.org Sent: Thursday, September 02, 2010 10:15 PM Subject: Re: [GENERAL] Connection question On 2/09/2010 11:59 PM, Bayless Kirtley wrote

Re: [GENERAL] Connection question

are standing in line trying to pay. I tried initially to get the customer to go Linux instead of Windows but without much luck. Thanks again for the thorough explanation. Bayless - Original Message - From: Craig Ringer cr...@postnewspapers.com.au To: Bayless Kirtley bk...@cox.net Cc: List

[GENERAL] Connection question

I have a two-user point-of-sale application on Windows XP PRO. The DB runs on the cash register. The second user is a manager's computer. They are connected through a wired router which is also connected to an internet cable modem. The manager's computer just checks statistics on the DB and

Re: [GENERAL] PostgreSQL Performance issue

Thanks a lot for your help. However I am new to Postgres database therefore it would be nice if you can let me know how to set autocommit off. I know from psql client issuing “\set Autocommit Off” would set it off but unfortunately it doesn’t set it off. It's a client-side setting, not a

Re: R: [GENERAL] Field's position in Table

- Original Message - From: Adam Rich To: Sam Mason ; vinny Cc: pgsql-general@postgresql.org Sent: Monday, August 24, 2009 2:58 PM Subject: Re: R: [GENERAL] Field's position in Table From: vinny vi...@xs4all.nl Subject: Re: R: [GENERAL] Field's

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Paul Taylor, 04.08.2009 15:48: Thats a shame, I wanted to write junit test for a java program that queried a database, requiring a full database to be available for unit tests is not really an environment I want to have. Well if you want to test the database, you will need a full

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

- Original Message - From: Paul Taylor ij...@fastmail.fm To: pgsql-general@postgresql.org Sent: Tuesday, August 04, 2009 9:56 AM Subject: Re: [GENERAL] Does derby have an embedded Mode like Derby ? Of course you can always use Derby for testing the Postgres later. I have found HSQLDB

[GENERAL] Serious JDBC problem

For some reason, the PostgreSQL JDBC driver fails to properly recognize daylight saving time. When retrieving the current time as a java.sql.Time, if returns an hour behind when DST is in effect. Here is a tested sample Java code that demonstrates the error.. private void

Re: [GENERAL] Daylight saving time question

Apparently this did not go through the first time. I'll try again. Bayless Kirtley wrote: Thanks Tom and Scott. You got me looking in the right direction. In this case the client and server are on the same machine (testing/development) and psql does return the right result. I tried all

Re: [GENERAL] Switching databases over JDBC/ODBC

You can establish a new connection without dropping the old one. Thus you can be connected to 2 databases at the same time. Just use the appropriate connection for the database you want. Bayless - Original Message - From: Scott Bailey arta...@comcast.net To: pgsql-general

Re: [GENERAL] Daylight saving time question

- Original Message - From: Lew no...@lwsc.ehost-services.com To: pgsql-general@postgresql.org Sent: Saturday, May 23, 2009 2:18 PM Subject: Re: [GENERAL] Daylight saving time question Bayless Kirtley wrote: Thanks Tom and Scott. You got me looking in the right direction

Re: [GENERAL] Daylight saving time question

- Original Message - From: Tom Lane t...@sss.pgh.pa.us To: Bayless Kirtley bk...@cox.net Cc: John R Pierce pie...@hogranch.com; PostgreSQL pgsql-general@postgresql.org; scottmarl...@gmail.com Sent: Monday, May 18, 2009 3:22 PM Subject: Re: [GENERAL] Daylight saving time question

[GENERAL] Daylight saving time question

How can I tell PostgreSQL to use daylight saving time when applicable? Times returned by the database are one hour behind. TIA Bayless

Re: [GENERAL] Daylight saving time question

- Original Message - From: John R Pierce pie...@hogranch.com To: Bayless Kirtley bk...@cox.net; PostgreSQL pgsql-general@postgresql.org Sent: Sunday, May 17, 2009 10:19 PM Subject: Re: [GENERAL] Daylight saving time question Bayless Kirtley wrote: How can I tell PostgreSQL to use

Re: [GENERAL] Daylight saving time question

a workaround but would like to know. Thanks again. - Original Message - From: Tom Lane t...@sss.pgh.pa.us To: Bayless Kirtley bk...@cox.net Cc: John R Pierce pie...@hogranch.com; PostgreSQL pgsql-general@postgresql.org Sent: Monday, May 18, 2009 12:26 PM Subject: Re: [GENERAL] Daylight

Re: [GENERAL] open transaction?

- Original Message - From: Terry Lee Tucker te...@chosen-ones.org To: pgsql-general@postgresql.org Sent: Monday, December 29, 2008 5:57 AM Subject: Re: [GENERAL] open transaction? On Monday 29 December 2008 06:48, blackwater dev wrote: I just logged into postgres from the command

Re: [GENERAL] Database access over the Internet...

Michelle, I don't think the list is going to change its operations for one disgruntled user. Since you seem unwilling or unable to employ the advice already given, maybe your only acceptable option is to unsubscribe from the list. At least that would eliminate much of the noise that currently

Re: [GENERAL] MS Access and PostgreSQL - a warning to people thinking about it

Right, passthrough queries is the answer. I once had to build an Access front end to a very large Oracle database for a client. As you discovered, directAccess queries can be extermely slow and large. With a passthrough, all the real work is done on the host database and just the result you want

[GENERAL] pgdump problem or question?

Early Friday morning a bad record caused me to reload the Thursday night pgdump backup. I performed a pgdump first to study later. In the backup I found several incomplete transactions all done at the end of the day. Investigating later I found the original bad record from the Friday dump and

[GENERAL] Moved database question

I had to move my database to a new disk. I dropped the original after a pg_dump and then removed the old directory. I then ran initdb on the new location, created the database and restored from the pg_dump. My problem now is that I have to supply the full pathnames to start or stop the

[GENERAL] Cause of error message?

An old app is giving a new error message. I query a table and make one update. Later I come back to query the table again and get this error: ERROR: current transaction is aborted, commands ignored until end of transaction block The error only occurs after I have made an update. As long as no

[GENERAL] Closed ResultSet error

I am migrating from another database to PostgreSQL and have run into a serious problem. The Java program runs fine on the other DB but under PostgreSQL it gives the error, ResultSet is closed. This result set is created in a method that processes each row sequentially. Within the processing,

[GENERAL] No server after starting

First, I am new to Postgres. I am hoping to migrate an existing Java application from a couple of tried but unreliable open source Java databases. I have a fair amount of experience with Oracle, Informix and DB2 but it has been a few years. No on to my problem. I finally got PostgreSQL