[BUGS] JDBC & XML-DBMS
1. JDBC Driver returns empty separator in the database catalog. 2. Why JDBC Driver returns column (procedures etc.) name pattern in lower case? Al
[BUGS] Ответ: [BUGS] reproducable command sequence to get "mdopen: Couldn't open..."
>>Making ALTER TABLE RENAME abort-safe requires changing the conventions >>for naming physical table files, and the details have been sufficiently >>controversial that it's not been done yet. In the meantime our only >>choices are to forbid ALTER TABLE RENAME within transaction blocks, or >>allow it with the knowledge that people can shoot themselves in the foot >>with it. The above warning notice is the current compromise. > > Is it going to be in 7.1? If not, it might be worth disabling in TX blocks > since a mistyped SQL query can cause an aborted transaction, something that > is somewhat counter-intuitive. Maybe the message should be expanded to say: Just couple days ago I've said that right now I implement new file naming because of this is required by WAL. As additional result ALTER TABLE RENAME will not rename files any more and so will be rollback-able. Please wait ~ 1 day -:) Vadim
Re: [BUGS] psql: ERROR: MultiByte strings (MB) must be enabled to use this function
> When I am trying to connect to my remote database kenyellow pages i.e. > psql -h colo.kenyaweb.com -p 5432 kenyellowpages, am getting this error > psql: ERROR: MultiByte strings (MB) must be enabled to use this function I get this symptom when mixing a 7.0.x client with a 6.5.x server. - Thomas
Re: [BUGS] Page 13 of tutorial has a typo I believe
Thanks. This has been fixed. > Chris Green ([EMAIL PROTECTED]) reports a bug with a severity of 4 > The lower the number the more severe it is. > > Short Description > Page 13 of tutorial has a typo I believe > > Long Description > the Cartesian product of domains. > > such that V1 (is a member of) D1, V1 (is a member of) D1, ... Vk (is a member of) Dk > > the second V1 should be V2 and D2 I believe > > Sample Code > > > No file was uploaded with this report > > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
[BUGS] constraints evaluate 'now' immediately
Roger Wernersson ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
constraints evaluate 'now' immediately
Long Description
I run Postgres 6.5.3 on Alpha/Linux.
I would like a constraint stating that a column may not have a date in the future:
CHECK(my_date <= 'now')
but I think it stores the time of constraint creation.
Sample Code
CREATE TABLE test (
my_date timestamp NOT NULL,
CONSTRAINT test_c_my_date CHECK (my_date <= 'now'));
--wait a second then
INSERT INTO test VALUES ('now');
-- fails
No file was uploaded with this report
Re: [BUGS] constraints evaluate 'now' immediately
[EMAIL PROTECTED] writes: > I would like a constraint stating that a column may not have a date in the future: > CHECK(my_date <= 'now') > but I think it stores the time of constraint creation. Yes, because 'now' is evaluated when the constant is parsed. Try CHECK(my_date <= now()) instead. regards, tom lane
[BUGS] bug-report
POSTGRESQL BUG REPORT
Your name : Eivind Kvedalen
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Intel Pentium III
Operating System (example: Linux 2.0.26 ELF) :
Linux support 2.2.14 #9 SMP Thu Oct 12 12:10:07 CEST 2000 i686 unknown
PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.2
Compiler used (example: gcc 2.8.0) : egcs-2.91.66
Please enter a FULL description of your problem:
to_char gives incorrect day conversion of the date 2000/03/26.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
--
The SQL-code
create table test_table (
date_col date
);
insert into test_table values ('2000/03/25');
insert into test_table values ('2000/03/26');
select date_col from test_table;
select to_char(date_col, '/MM/DD - WW') from test_table;
drop table test_tab
results in
CREATE
INSERT 2370569 1
INSERT 2370570 1
date_col
2000-03-25
2000-03-26
(2 rows)
to_char
-
2000/03/25 - 12
2000/03/25 - 12
(2 rows)
which is incorrect. I have not detected any other dates which gives
the same result.
If you know how this problem might be fixed, list the solution below:
-
Re: [BUGS] eeeh... buffer leak?
On Sun, 15 Oct 2000, Tom Lane wrote: > > ulsec=# truncate job; > > NOTICE: Buffer Leak: [002] (freeNext=-3, freePrev=-3, relname=job, blockNum=0, > > flags=0xc, refcount=1 -1) > > TRUNCATE > > Hmm, that's interesting. It shouldn't be possible for PrivateRefCount > (the last value printed) to become negative. Can you give a sequence > for reproducing this notice from a standing start? Unfortunately not. I was very very surprised when I saw this (as I never got any errors like this), and I tried to reproduce what I did, but I didn't get this message again. (This is a pretty heavily-used database (lots of clients via the network), so the odds of reproducing the exact sequence of events is pretty small anyway). By the way, this is PostgreSQL 7.0.2 on a Red Hat 6.2 box with a custom kernel. So.. what am I to do if I ever get this message again? greetings, Lennert
[BUGS] Bug!!
Applet: Something unusual has occured to cause the driver to fail. Please report this exception: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:5432 connect,resolve) java.lang.Throwable() java.lang.Exception() java.sql.SQLException() org.postgresql.util.PSQLException(java.lang.String, java.lang.Object) java.sql.Connection org.postgresql.Driver.connect(java.lang.String, java.util.Properties) java.sql.Connection java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties, java.lang.ClassLoader) java.sql.Connection java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String)
Re: [BUGS] eeeh... buffer leak?
Lennert Buytenhek <[EMAIL PROTECTED]> writes: >> Hmm, that's interesting. It shouldn't be possible for PrivateRefCount >> (the last value printed) to become negative. Can you give a sequence >> for reproducing this notice from a standing start? > Unfortunately not. I was very very surprised when I saw this (as I never > got any errors like this), and I tried to reproduce what I did, but I > didn't get this message again. (This is a pretty heavily-used database > (lots of clients via the network), so the odds of reproducing the exact > sequence of events is pretty small anyway). PrivateRefCount is local to a particular backend, so the behavior of other clients shouldn't matter (in theory anyway ;-)). It should be sufficient to reproduce the sequence executed by your specific session. Not that that helps much if you don't remember, but please try. > So.. what am I to do if I ever get this message again? Don't panic ... but see if you can reproduce it. regards, tom lane
Re: [BUGS] bug-report
> to_char gives incorrect day conversion of the date 2000/03/26. This is fixed in the current (development) sources. - Thomas
