[BUGS] Bug #469: The 7.1.3 tar ball from main site produced an error while extracting
Ralph ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description The 7.1.3 tar ball from main site produced an error while extracting Long Description Hi I download the latest code release of PostGresql from http://www.postgresql.org/ftpsite/ and proceded to extract it using tar -zxvf postgresql-7.1.3.tar.gz. I received the error that you see in the "example code" window below. I then proceded to download the same tar ball from the Australian mirror and I extracted it without getting any errors. Both files were exactly the same size after download (8124455 bytes). I am using RedHat 7.1 and I just thought I'd let you know this and see whether it has happened to anyone else. regards Ralph Sample Code ...last few lines of output postgresql-7.1.3/src/test/regress/expected/numeric_big.out postgresql-7.1.3/src/test/regress/expected/numerology.out postgresql-7.1.3/src/test/regress/expected/oidjoins.out postgresql-7.1.3/src/test/regress/expected/opr_sanity.out gzip: stdin: unexpected end of file tar: 63 garbage bytes ignored at end of archive tar: Unexpected EOF in archive tar: Unexpected EOF in archive tar: Error is not recoverable: exiting now No file was uploaded with this report ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [BUGS] CVS rejected me
On Tue, 18 Sep 2001, Marc G. Fournier wrote: > > > go to anoncvs.postgresql.org, not postgresql.org .. See the instructions at http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html If your advice is correct (I've not tried it yet) then the rules are changed and the werbsite's out of date. As I noted, it was working. > > On Tue, 18 Sep 2001, John Summerfield wrote: > > > This worked 2-3 days ago: what's changed? > > > > vs -z9 -q update > > cvs update: authorization failed: server postgresql.org rejected access to >/home/projects/pgsql/cvsroot for user anoncvs > > summer@dugite pgsql$ > > > > The entry's still in ~/.cvspass > > > > > > > > ---(end of broadcast)--- > > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > > ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [BUGS] Bug #456: postgres dumps core in initlocalbuffer
Hi, thank you for your fast answer. I will try to upgrade, with over 20 production databases not a one-hour job :-) I will report results to you... Am I the only one, where this occured?? Greetings Florian Tom Lane wrote: > > [EMAIL PROTECTED] writes: > > Stacktrace is: > > > #0 0x812ac0c in chunk_free (ar_ptr=0x81cb860, p=0xd4ef05d3) at malloc.c:3125 > > #1 0x812a4d3 in chunk_alloc (ar_ptr=0x81cb860, nb=7176) at malloc.c:2612 > > #2 0x8129f8f in __libc_malloc (bytes=7168) at malloc.c:2714 > > This looks like malloc's bookkeeping data structures must have gotten > clobbered, perhaps by a wild store operation or freeing a chunk twice > or some such. The error is doubtless somewhere in the postmaster, > not in InitLocalBuffer. Before you expend effort trying to hunt it > down, I'd suggest updating to the latest stable release, 7.1.3 --- > the problem may be fixed already. If that doesn't help, consider > linking the postmaster with a debugging malloc package, such as Electric > Fence... > > regards, tom lane smime.p7s Description: S/MIME Cryptographic Signature
[BUGS] CVS still doesn't work as described:
The instructions at http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html#ANONCVS do not work. pgtest@dugite pgtest$ cvs -d :pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot login (Logging in to [EMAIL PROTECTED]) CVS password: cvs login: authorization failed: server postgresql.org rejected access to /home/projects/pgsql/cvsroot for user anoncvs pgtest@dugite pgtest$ I produced the above error by cutting and pasting. My cvs update (which was working) hasn't worked for some days. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[BUGS] bug! in 7.1.3 (for recursion function)
Hi, please run below recursion function in 7.1.3 --- drop function listTest(int4);create function listTest(int4)returns textas 'declare mtype alias for $1; begin if mtype=0 then return ''0''; else return mtype||listTest(mtype-1); end if; end;'language 'plpgsql'; select listTest(5); --response: 10 (in 7.1.3, incorrenct!) 543210 (in 7.0.3, correct!) Please tell me how to slove this problem if I don't want to go back to 7.0.3. Thanks Xiaoming ***Internet Email Confidentiality Footer***Privileged/Confidential Information may be contained in this message. If youare not the addressee indicated in this message (or responsible for delivery ofthe message to such person), you may not copy or deliver this message to anyone.In such case, you should destroy this message and kindly notify the sender byreply email. Please advise immediately if you or your employer does not consentto Internet email for messages of this kind. Opinions, conclusions and otherinformation in this message that do not relate to the official business of myfirm shall be understood as neither given nor endorsed by it.
Re: [BUGS] Website, mailing list
On Wed, 19 Sep 2001, Justin Clift wrote: > Tom Lane wrote: > > > > > > While trying to retrieve the URL: http://developer.postgresql.org/index.php > > > > Where did you get that URL from? AFAIK we have never had such a site > > name as "developer.postgresql.org". > > Hi Tom, > > This is the new "Developer's Corner site" which Vince created. Looks > pretty nice, new color scheme, better layout, etc. People get to it > when clicking on "Developer's Corner" from the main PostgreSQL site. And when I retried later it worked. That's where I'm reading the CVS instructions (that don't work) now. > > :) > > Regards and best wishes, > > Justin Clift > > > > > regards, tom lane > > > > ---(end of broadcast)--- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] time's running short for you to reserve 5432/tcp!!!!
It's LONG past time you asked IANA to officially register the default PGPORT you've been using unofficially for a very long time now! You are no longer in the middle of an officially unassigned block -- there's an assignment at 5431 now! Please visit this link and fill out the application A.S.A.P. http://www.iana.org/cgi-bin/usr-port-number.pl -- Greg A. Woods +1 416 218-0098 VE3TCP <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Planix, Inc. <[EMAIL PROTECTED]>; Secrets of the Weird <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] Website, mailing list
On Fri, 21 Sep 2001, Tom Lane wrote: > John Summerfield <[EMAIL PROTECTED]> writes: > > I get response like this > > subscribe > > Illegal command! > > No valid commands processed. > > > when I send commands according to the instructions at > > http://developer.postgresql.org/subunsub.php > > It would seem that that page is out of date. Vince, can you fix it? > I have no idea where the website source files live... Actually the instructions are correct. Something happened in the last couple of weeks that broke things. I'm guessing Marc's recent upgrade. Marc?? Care to look into this? Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [BUGS] Website, mailing list
John Summerfield <[EMAIL PROTECTED]> writes: > I get response like this > subscribe > Illegal command! > No valid commands processed. > when I send commands according to the instructions at > http://developer.postgresql.org/subunsub.php It would seem that that page is out of date. Vince, can you fix it? I have no idea where the website source files live... regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] Website, mailing list
On Fri, 21 Sep 2001, Vince Vielhaber wrote: > On Fri, 21 Sep 2001, Tom Lane wrote: > > > John Summerfield <[EMAIL PROTECTED]> writes: > > > I get response like this > > > subscribe > > > Illegal command! > > > No valid commands processed. > > > > > when I send commands according to the instructions at > > > http://developer.postgresql.org/subunsub.php > > > > It would seem that that page is out of date. Vince, can you fix it? > > I have no idea where the website source files live... > > Actually the instructions are correct. Something happened in the > last couple of weeks that broke things. I'm guessing Marc's recent > upgrade. Marc?? Care to look into this? > In the mean time, can someone tell me what works now, or alternatively enrol me in hackers and bugs and jdbc and announcements? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [BUGS] Website, mailing list
On Sat, 22 Sep 2001, Tom Lane wrote: > Vince Vielhaber <[EMAIL PROTECTED]> writes: > >> It would seem that that page is out of date. Vince, can you fix it? > > > Actually the instructions are correct. > > Are they? The last time I subscribed to a new list, the right > incantation was to mail > subscribe list-name my-address > to [EMAIL PROTECTED] This doesn't square with what the webpage > says to do ... Majordomo2 and a number of other maillist packages accept subscription requests to [EMAIL PROTECTED] I know the instructions worked when I subscribed to general, odbc and at least one other list. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] Website, mailing list
On Sat, 22 Sep 2001, Vince Vielhaber wrote: > On Sat, 22 Sep 2001, Tom Lane wrote: > > > Vince Vielhaber <[EMAIL PROTECTED]> writes: > > >> It would seem that that page is out of date. Vince, can you fix it? > > > > > Actually the instructions are correct. > > > > Are they? The last time I subscribed to a new list, the right > > incantation was to mail > > subscribe list-name my-address > > to [EMAIL PROTECTED] This doesn't square with what the webpage > > says to do ... > > Majordomo2 and a number of other maillist packages accept subscription > requests to [EMAIL PROTECTED] I know the instructions worked > when I subscribed to general, odbc and at least one other list. Please, someone who can fix it test it. I have requests like that that didn't work, ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] Website, mailing list
On Tue, 18 Sep 2001, Tom Lane wrote: > John Summerfield <[EMAIL PROTECTED]> writes: > > I asked for help. Majordomo doesn't understand that either. > > What did you do exactly? The following message brought back a help > response for me: I get response like this subscribe Illegal command! No valid commands processed. when I send commands according to the instructions at http://developer.postgresql.org/subunsub.php I.E. NOTE: We recently upgraded to Majordomo2. This is the new procedure for getting on and off the lists. To subscribe to or unsubscribe from any of the lists below, send a message to [EMAIL PROTECTED] (with XXX being the name of the list as shown below) and in the body of the message put: subscribe or unsubscribe If you hate getting many mail messages per day then when you subscribe as shown above, add the following on the next line: > > > To: [EMAIL PROTECTED] > Subject: test > Date: Tue, 18 Sep 2001 09:48:50 -0400 > From: Tom Lane <[EMAIL PROTECTED]> > > help > > > > While trying to retrieve the URL: http://developer.postgresql.org/index.php > > Where did you get that URL from? AFAIK we have never had such a site > name as "developer.postgresql.org". > > regards, tom lane > ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[BUGS] how to return multiple values from a function
i have tried using SETOF but icouldnt solve it ,icould get muliple values but those r not the exact which i expected ,iam getting some junk values. the result iam getting is ?column? > --- > 136361584 > 136361584 > 136361584 some what like this,please give me a example code so that i could run out of this problem. please make it soon. cheers chowdary. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] Website, mailing list
Vince Vielhaber <[EMAIL PROTECTED]> writes: >> It would seem that that page is out of date. Vince, can you fix it? > Actually the instructions are correct. Are they? The last time I subscribed to a new list, the right incantation was to mail subscribe list-name my-address to [EMAIL PROTECTED] This doesn't square with what the webpage says to do ... regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [BUGS] CVS rejected me
On Tue, 18 Sep 2001, Marc G. Fournier wrote: > > > go to anoncvs.postgresql.org, not postgresql.org .. Fails the same. I used the password postgresql (by cut&paste). > > On Tue, 18 Sep 2001, John Summerfield wrote: > > > This worked 2-3 days ago: what's changed? > > > > vs -z9 -q update > > cvs update: authorization failed: server postgresql.org rejected access to >/home/projects/pgsql/cvsroot for user anoncvs > > summer@dugite pgsql$ > > > > The entry's still in ~/.cvspass > > > > > > > > ---(end of broadcast)--- > > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS]
Hello, Usually, I use Oracle for develop database application. However, I change my computer to Linux system (Mandrake 8) and I decide change database to Postgresql. In Oracle when I create a table where a colum is a char(n) or varchar(n), if I try to insert in this table value bigger than n , I get an error. That doesn't happen in Postgresql, if I try to insert a value bigger than n, it's accept because trunk the value. I don't want that, if the value is bigger I want an error. I created a check constraint with the function [char_length (parameter) < (n+1)] but still not working. Can you help me to resolve this problem? The version of Postgresql that I have is 7.1.2. Best Regards, Cláudia Portugal ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] is there any substitution for cursors
can i get a substitution for cursors in postgresql if possible please mail me back soon. cheers chowdary. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] to pass an array and retrive an array from a function
i need a solution how to pass an array into a function and retrieve an array from a function,itried but encountered many problems itried using setof while returning but i couldnt solve it can any one help out with this problem. if possible send me the example code explaining the way we should follow. with cheers chowdary. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [BUGS] bug! in 7.1.3 (for recursion function)
"Zhang Xiaoming" <[EMAIL PROTECTED]> writes: > please run below recursion function in 7.1.3 This is fixed in current sources (7.2-to-be). regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] maybe a bug?
I have problem with new PGSQL 7.1.3 I've a table like that TT ( V VARCHAR(10), D DATE, I INTEGER); and query "SELECT V || '' || D || '' || I FROM TT;" In version 7.1.2 result is '$V$D$I' when $? means text representation of ?. It's always true even if any $? is NULL. In version 7.1.3 result is '$V$D$I' or NULL if any of $? is NULL. Is that change of result intended? (as going to SQL 92?) Disk ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [BUGS] Bug #470: INTERSECT fails
[EMAIL PROTECTED] writes: > INTERSECT fails I believe this is fixed in current sources (7.2-to-be). The problem is with INTERSECT (or EXCEPT) as the input to another INTERSECT/EXCEPT. You could work around it in 7.1 by doing one INTERSECT into a temp table and then intersecting with that. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [BUGS] maybe a bug?
=?iso-8859-2?Q?=A3ukasz_Odziewa?= <[EMAIL PROTECTED]> writes: > I have problem with new PGSQL 7.1.3 > I've a table like that TT ( V VARCHAR(10), D DATE, I INTEGER); > and query "SELECT V || '' || D || '' || I FROM TT;" > In version 7.1.2 result is '$V$D$I' when $? means text > representation of ?. It's always true even if any $? is NULL. > In version 7.1.3 result is '$V$D$I' or NULL if any of > $? is NULL. The behavior you attribute to 7.1.3 is correct, and would have been the same in any 7.1.* release. I do not believe that 7.1.2 would have been different. Try COALESCE(foo::text, '') if you want to substitute an empty string for NULL values. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[BUGS]
POSTGRESQL BUG REPORT TEMPLATE
Your name : Ricardo Caesar Lenzi
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.16 (Conectiva Linux)
PostgreSQL version (example: PostgreSQL-7.1.1): PostgreSQL-7.2devel
Compiler used (example: gcc 2.95.2) : 2.91.66
Please enter a FULL description of your problem:
All the postgres functions, when using python interface, returns values
in wrong data type, text instead integer or float.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
--
Table structure:
ricardo=# \d contato
Table "contato"
Column | Type | Modifiers
+-+-
id_contato | integer | default nextval('contato_id'::text)
nome | text|
fone1 | text|
fone2 | text|
email | text|
Indexes: contato_ix1,
contato_ix2
Python program, using postgresql-7.1.3 server:
[ricardo@ricardo ricardo]$ python
Python 1.5.2 (#1, Jun 18 2000, 03:54:39) [GCC egcs-2.91.66 19990314/Linux]
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import pg
>>> db=pg.connect("ricardo")
>>> c=db.query("select count(*) from contato").getresult()[0][0]
>>> print repr(c), type(c)
'27'
>>> c=db.query("select sum(id_contato) from contato").getresult()[0][0]
>>> print repr(c), type(c)
'475'
>>> c=db.query("select nextval('contato_id')").getresult()[0][0]
>>> print repr(c), type(c)
'1'
Python program, using postgresql-7.1.2 server:
[ricardo@ricardo ricardo]$ python
Python 1.5.2 (#1, Jun 18 2000, 03:54:39) [GCC egcs-2.91.66 19990314/Linux]
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import pg
>>> db=pg.connect("ricardo")
>>> c=db.query("select count(*) from contato").getresult()[0][0]
>>> print repr(c), type(c)
27
>>> c=db.query("select sum(id_contato) from contato").getresult()[0][0]
>>> print repr(c), type(c)
475
>>> c=db.query("select nextval('contato_id')").getresult()[0][0]
>>> print repr(c), type(c)
1
If you know how this problem might be fixed, list the solution below:
-
--
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Re: [BUGS] time's running short for you to reserve 5432/tcp!!!!
being worked on ... thanks for the reminder ... On Sat, 22 Sep 2001, Greg A. Woods wrote: > It's LONG past time you asked IANA to officially register the default > PGPORT you've been using unofficially for a very long time now! > > You are no longer in the middle of an officially unassigned block -- > there's an assignment at 5431 now! > > Please visit this link and fill out the application A.S.A.P. > > http://www.iana.org/cgi-bin/usr-port-number.pl > > -- > Greg A. Woods > > +1 416 218-0098 VE3TCP <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> > Planix, Inc. <[EMAIL PROTECTED]>; Secrets of the Weird <[EMAIL PROTECTED]> > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS]
This will be fixed in the 7.2 release. > Hello, > > Usually, I use Oracle for develop database application. However, I > change my computer to Linux system (Mandrake 8) and I decide change database > to Postgresql. > In Oracle when I create a table where a colum is a char(n) or varchar(n), if > I try to insert in this table value bigger than n , I get an error. That > doesn't happen in Postgresql, if I try to insert a value bigger than n, it's > accept because trunk the value. I don't want that, if the value is bigger I > want an error. I created a check constraint with the function [char_length > (parameter) < (n+1)] but still not working. Can you help me to resolve this > problem? The version of Postgresql that I have is 7.1.2. > > Best Regards, > Cl?udia > > Portugal > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > -- 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 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [BUGS]
On Mon, 24 Sep 2001, Ana Claudia wrote: > Hello, > > Usually, I use Oracle for develop database application. However, I > change my computer to Linux system (Mandrake 8) and I decide change database > to Postgresql. > In Oracle when I create a table where a colum is a char(n) or varchar(n), if > I try to insert in this table value bigger than n , I get an error. That > doesn't happen in Postgresql, if I try to insert a value bigger than n, it's > accept because trunk the value. I don't want that, if the value is bigger I > want an error. I created a check constraint with the function [char_length > (parameter) < (n+1)] but still not working. Can you help me to resolve this > problem? The version of Postgresql that I have is 7.1.2. I believe this will be fixed in the upcoming 7.2 release. The reason the constraint doesn't work is probably that the truncation happens before the check. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[BUGS] Problems
Hi all! I have problems wich I can't manage. psql: ERROR: Function OID 1039 does not exist - one database and psql: FATAL 1: Index 'pg_trigger_tgrelid_index' does not exist - second database What's going on? Of course I can't connect to these databases and do anaything like pg_dump. Miky [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] Performance and 72.devel
On Wed, 19 Sep 2001, Tom Lane wrote: > John Summerfield <[EMAIL PROTECTED]> writes: > > Or if it is reusing them, it's renaming them too. > > That is what the "recycling..." message is all about... > 1) Why rename them? 2) Does anyone have a better idea how it floods my cache? I'll try again when someone sorts out why CVS isn't working as described. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] Vacuums and bad process status
Strange ... The process continued after stopping for a while (and using no CPU time). Sorry, no bug :) Hans ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[BUGS] Bug #470: INTERSECT fails
Tamas Vincze ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description INTERSECT fails Long Description I've used INTERSECT to get the common rows in 3 simple SELECTs. If I write the query without grouping parentheses, PG reports 0 rows which is incorrect. If I use parentheses to group the last two SELECTs then it gives a better answer. If I reorder the SELECTs then it gives another different answer. (see examples) The result should be independent of the order and grouping of the SELECTs, so I think it's a serious bug. I use version 7.1.2 on solaris/sparc. Sample Code sites=# select recseq from frags where len> and len<2406 sites-# intersect select recseq from frags where len>1503 and len<1627 sites-# intersect select recseq from frags where len>752 and len<814; recseq (0 rows) sites=# select recseq from frags where len> and len<2406 sites-# intersect (select recseq from frags where len>1503 and len<1627 sites(# intersect select recseq from frags where len>752 and len<814); recseq CACTG CAGTG CASTG RGCGCY YAACCT (5 rows) sites=# select recseq from frags where len>1503 and len<1627 sites-# intersect select recseq from frags where len>752 and len<814 sites-# intersect select recseq from frags where len> and len<2406; recseq CACTG CAGTG RGCGCY YAACCT (4 rows) No file was uploaded with this report ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[BUGS] Bug #471: [make install] problem with jdbc driver in 7.1.3
Stingray ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
[make install] problem with jdbc driver in 7.1.3
Long Description
While I untared all the tarballs and configure it with [--with-java] option, [make],
and [make install], the console shows that @MAJORVERSION@, @MINORVERSION@ were not
properly set in org.postgresql.Driver.java (along with '${major}', '${minor}', the
@DEF_PGPORT@, @VERSION@ are also mis-set), resulting in compiling failure.
Therefore I check postgresql-7.1.3/src/interfaces/jdbc/build.xml, on line 78 it read
'filtering="yes"', that value is incorrect and should be set to 'on'. I'd replaced the
value and it succeeded..
Sample Code
replace with: 'filtering="on"' on line 78
in postgresql-7.1.3/src/interfaces/jdbc/build.xml
of tarball postgresql-opt-7.1.3.tar.gz
No file was uploaded with this report
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[BUGS] Vacuums and bad process status
I am using PostgreSQL 7.1.2 and I am running into trouble when Vacuuming a very big DB while others are working on the DB: 21640 pts/0SN 0:00 /usr/local/pgsql/bin/psql -c VACUUM VERBOSE ANALYZE -d intranet 21641 ?D 3:05 postgres: postgres intranet [local] VACUUM Status "D" is a real problem. Is this already a known bug? Hans ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[BUGS] Bug #472: Cant get source from website for 7.2
Britton Wesley ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Cant get source from website for 7.2 Long Description The link ftp://ftp.postgresql.org/pub/postgresql-7.2.tar.gz is broken Sample Code No file was uploaded with this report ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
