[BUGS] Re: timestamps cannot be created without time zones

2001-08-27 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > I'm not sure how to test for "correctness" of time zone support in a way > that gives better results than this assumption. We do know that some > timezone databases are incorrect before 1970, for example (AIX), and > that there are variations in conten

[BUGS] Re: timestamps cannot be created without time zones

2001-08-27 Thread Thomas Lockhart
> Ok, I now understand more about how Postgres handles these older dates but... It isn't quite as nice and clean as we'd like. For example, the cutoff dates for assuming that time zone is correctly supported are arbitrarily chosen to be near the Unix system time range boundaries of 1901 and 2038,

Re: [BUGS] Bug #429: Concurrent JDBC connections to result in wrong data

2001-08-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > If two users (we have not tried more) use different clients and click on the >getInvoices button at the same time, the data becomes mixed. > I.e. > If i say pick client 'smith trucks' and my collegue picks a client 'post modern', i >get some of 'post modern' invoices

Re: [BUGS] Bug #431: pg_dump errors on renamed primary key column names

2001-08-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > pg_dump errors on renamed primary key column names This appears to be fixed already in PG 7.1. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PR

Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

2001-08-27 Thread David Daney
It is now unclear to me the the catch(PrivilegedActionException pae) part of the patch is correct.  If a SecurityException is thrown in Socket() (as might happen if the policy file did not give the proper permissions), then it might be converted into a ClassCastException, which is probably the w

[BUGS] Bad input decoding in another encoding environment

2001-08-27 Thread Ondrej Palkovsky
Hello, I'm reporting a problem with decoding the input line and converting arguments to appropriate encoding. I have a database in UNICODE encoding but I'm accessing it in LATIN2 form. Now this works (where 'xxx' are special characters in latin2): psql mail mail=> \encoding latin2 mail=> update f

[BUGS] Bug #431: pg_dump errors on renamed primary key column names

2001-08-27 Thread pgsql-bugs
Markus Bertheau ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_dump errors on renamed primary key column names Long Description Sample Code test=# select version(); version

[BUGS] PROBLEM IN STARTING POSTMASTER

2001-08-27 Thread suresh viswanath
Sir, I am able to run initdb as mentioned in your installation procedure. but i can't start postmaster. when i am using the command .. /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data/ -l logfile start in logfile it is givin error message like this.., (IpcMemoryCreate: shmget(key=5432

Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

2001-08-27 Thread David Daney
I am sorry to keep going back and forth on this, but: The original patch is correct and does the proper thing.  I should have tested this before sounding the alarm. AccessController.doPrivileged()Propagates SecurityExceptions without wrapping them in a PrivilegedActionException so it appears th

[BUGS] Re: low performance

2001-08-27 Thread Jonas Lindholm
Do you have any index on the tables ? Any triggers ? If you want to insert 1 million rows you should drop the index, insert the data and then recreate the index. You should also try the COPY command to insert the data. You should also avoid having anyone to connect to the database when you inse

[BUGS] memory leak while using vacuum

2001-08-27 Thread Achim Krümmel
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the prob

[BUGS] Bug #430: triggered data change violation on relation "tbl_b"

2001-08-27 Thread pgsql-bugs
Pawe³ Paw³owski ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description triggered data change violation on relation "tbl_b" Long Description When I insert to table new row and after this in the same transaction I delete this row I get