Re: [BUGS] Insert statement changes timestamp value from MS Access

2005-07-27 Thread Tom Lane
"David Dabney" <[EMAIL PROTECTED]> writes: > I'm assuming this is a bug. Perhaps, but there is absolutely no chance of anyone reproducing the problem from the information you've offered. You say "it fails when I try to insert data from table DD5", but you give us no clue about what data is in DD5

Re: [BUGS] Insert statement changes timestamp value from MS Access

2005-07-27 Thread David Dabney
I'm sorry, but I attached the incorrect file the first time! We are using MS Access as a frontend to import many water quality records into postgresql v. 8.0.2 on Red Hat 3 Enterprise. When importing a table of 40,000+ records something is going wrong with the timestamp field only for certain re

[BUGS] Insert statement changes timestamp value from MS Access ODBC

2005-07-27 Thread David Dabney
Please see attached text document. Thanks, Dave David Dabney OHH Database Specialist/Programmer Hollings Marine Lab 131 Fort Johnson Road Charleston, SC 29464 843.762.8984 insert into public_collection (original_collection_code, method, station_id, date_time, sampling_project_id, contributo

Re: [BUGS] BUG #1790: coredump in postgres

2005-07-27 Thread Tom Lane
"Dmitry Karasik" <[EMAIL PROTECTED]> writes: > Description:coredump in postgres A SQL script to reproduce the problem would be much more useful than some incomplete gdb results. You showed the query, but how about table definitions and sample data to go with it? r

Re: [BUGS] BUG #1789: Error starting up server

2005-07-27 Thread Michael Fuhr
On Wed, Jul 27, 2005 at 07:36:05AM +0100, Chris Saringolis wrote: > > I have downloaded Postgresql 8.0.3 from the Australian mirror site, and am > following the online documentation for installation. > > I get to the pointof initialising the database via initdb -D > /usr/local/pgsql/data > > I t

[BUGS] BUG #1790: coredump in postgres

2005-07-27 Thread Dmitry Karasik
The following bug has been logged online: Bug reference: 1790 Logged by: Dmitry Karasik Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1-devel Operating system: freebsd 5.4 Description:coredump in postgres Details: pgsql is 8.1-devel, cvsup-latest configure

[BUGS] BUG #1789: Error starting up server

2005-07-27 Thread Chris Saringolis
The following bug has been logged online: Bug reference: 1789 Logged by: Chris Saringolis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Red Hat Linux 9.0 Description:Error starting up server Details: I have downloaded Postgresql 8.0.3

[BUGS] BUG #1791: Typo

2005-07-27 Thread uniware
The following bug has been logged online: Bug reference: 1791 Logged by: uniware Email address: [EMAIL PROTECTED] PostgreSQL version: CVS current Operating system: All Description:Typo Details: src\backend\utils\adt\varchar.c:line 229: number of charcters in the inp

[BUGS] Problem with the compilation and running of postgresql

2005-07-27 Thread Martin Nikolov
Hello, I have the folowing problem. The hard discks on the hosting machine, where was our web site, crashed 3 days ago. They have managed to recover all the files from data directory and they have sended them to me. I have installed on my test machine (Slackware 10, Kernel: 2.4.26) PostgreSQL 7.3

Re: [BUGS] BUG #1788: charset of sorting bug

2005-07-27 Thread Richard Huxton
lunter wrote: Bug reference: 1788 Operating system: WinXP SP2 PL My system is WinXP SP2 PL (charset WIN-1250) PG 8.0.3 sort records only with use of charset WIN-1250. But base encoding is ISO-8859-2 or UTF-8. How to coerce sorting charset same encoding of database ?? Locale controls

Re: [BUGS] BUG #1786: error in establishing connection

2005-07-27 Thread Richard Huxton
mohammed talat el shambakey wrote: Bug reference: 1786 Operating system: fedora project [EMAIL PROTECTED] shambakey1]$ postmaster -D /usr/local/pgsql/data OG: could not translate host name "localhost", service "5432" to address: Temporary failure in name resolution Name-lookup isn