Menu
▾
▴
postgres-xc-bugs — Bug report
You can subscribe to this list here.
| 2012 |
Jan
(2) |
Feb
|
Mar
|
Apr
(7) |
May
(27) |
Jun
(15) |
Jul
(11) |
Aug
(3) |
Sep
(1) |
Oct
|
Nov
(5) |
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2013 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
(10) |
Oct
(19) |
Nov
(34) |
Dec
(6) |
| 2014 |
Jan
(31) |
Feb
(2) |
Mar
(4) |
Apr
|
May
(3) |
Jun
(6) |
Jul
(10) |
Aug
(2) |
Sep
|
Oct
|
Nov
(9) |
Dec
|
| 2015 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Michael P. <mic...@gm...> - 2012-04-27 01:32:33
|
On Fri, Apr 27, 2012 at 10:23 AM, Hitoshi HEMMI <hem...@la... > wrote: > Hi there. > > This is a report of two possible pg-xc bugs. > > > ============================================================================ > POSTGRES-XC BUG REPORT TEMPLATE > > ============================================================================ > > Your name : Hitoshi Hemmi > Your email address : hem...@la... > > > System Configuration: > --------------------- > Architecture : x86_64 > > Operating System : RHEL 6.1 > > Postgres-XC version : Postgres-XC 1.0beta1 > > Compiler used : gcc 4.4.5 > > > Description of problems: > ============================================== > > #### Operations on Postgres-XC > > postgres=# SELECT version(); > version > > ------------------------------------------------------------------------------------------------------------------------------------------------ > Postgres-XC 1.0beta1 on x86_64-unknown-linux-gnu, based on PostgreSQL > 9.1beta2, compiled by gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit > (1 row) > > #### (Problem 1) > > postgres=# CREATE TABLE test(test int); > CREATE TABLE > postgres=# CREATE TABLE test_old(test int); > CREATE TABLE > postgres=# INSERT INTO test VALUES (1); > INSERT 0 1 > postgres=# WITH deleted as(delete from test where test=1 returning test) > insert INTO test_old SELECT * from deleted; > ERROR: could not read block 0 in file "base/12863/16521": read only 0 of > 8192 bytes > Bug 1 has already been fixed in master, RETURNING clause is not supported. postgres=# CREATE TABLE test(test int); CREATE TABLE postgres=# CREATE TABLE test_old(test int); CREATE TABLE postgres=# INSERT INTO test VALUES (1); INSERT 1 1 postgres=# WITH deleted as(delete from test where test=1 returning test) postgres-# insert INTO test_old SELECT * from deleted; ERROR: RETURNING clause not yet supported #### (Problem 2) > > postgres=# CREATE TABLE test(test int,test_date timestamp); > CREATE TABLE > postgres=# INSERT INTO test VALUES (1,now()); > INSERT 0 1 ^ > postgres=# DELETE FROM test where test_date < now(); > ERROR: attribute 2 has wrong type > DETAIL: Table has type tid, but query expects timestamp without time zone. > This is indeed a bug. I registed it here with id 3521810 assigned to me. https://sourceforge.net/tracker/?func=detail&aid=3521810&group_id=311227&atid=1310232 This will be fixed. -- Michael Paquier http://michael.otacoo.com |
|
From: Hitoshi H. <hem...@la...> - 2012-04-27 01:24:01
|
Hi there. This is a report of two possible pg-xc bugs. ============================================================================ POSTGRES-XC BUG REPORT TEMPLATE ============================================================================ Your name : Hitoshi Hemmi Your email address : hem...@la... System Configuration: --------------------- Architecture : x86_64 Operating System : RHEL 6.1 Postgres-XC version : Postgres-XC 1.0beta1 Compiler used : gcc 4.4.5 Description of problems: ============================================== #### Operations on Postgres-XC postgres=# SELECT version(); version ------------------------------------------------------------------------------------------------------------------------------------------------ Postgres-XC 1.0beta1 on x86_64-unknown-linux-gnu, based on PostgreSQL 9.1beta2, compiled by gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit (1 row) #### (Problem 1) postgres=# CREATE TABLE test(test int); CREATE TABLE postgres=# CREATE TABLE test_old(test int); CREATE TABLE postgres=# INSERT INTO test VALUES (1); INSERT 0 1 postgres=# WITH deleted as(delete from test where test=1 returning test) insert INTO test_old SELECT * from deleted; ERROR: could not read block 0 in file "base/12863/16521": read only 0 of 8192 bytes #### (Problem 2) postgres=# CREATE TABLE test(test int,test_date timestamp); CREATE TABLE postgres=# INSERT INTO test VALUES (1,now()); INSERT 0 1 ^ postgres=# DELETE FROM test where test_date < now(); ERROR: attribute 2 has wrong type DETAIL: Table has type tid, but query expects timestamp without time zone. ============================================== #### Same operations on PostgreSQL postgres=# SELECT version(); version -------------------------------------------------------------------------------------------------------------- PostgreSQL 9.1.0 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit (1 row) postgres=# CREATE TABLE test(test int); CREATE TABLE postgres=# CREATE TABLE test_old(test int); CREATE TABLE postgres=# INSERT INTO test VALUES (1); INSERT 0 1 postgres=# WITH deleted as(delete from test where test=1 returning test) insert INTO test_old SELECT * from deleted; INSERT 0 1 postgres=# CREATE TABLE test(test int,test_date timestamp); CREATE TABLE postgres=# INSERT INTO test VALUES (1,now()); INSERT 0 1 postgres=# DELETE FROM test where test_date < now(); DELETE 1 ============================================== Tnks. -- Hitoshi HEMMI NTT Open Source Software Center hem...@la... (Please note that my address has changed.) Tel:(03)5860-5115 Fax:(03)5463-5490 |
|
From: Koichi S. <koi...@gm...> - 2012-04-24 01:55:03
|
Thanks Michael for closing the bug. ---------- Koichi Suzuki 2012年4月24日9:59 SourceForge.net <no...@so...>: > Bugs item #3316512, was opened at 2011-06-14 17:56 > Message generated for change (Comment added) made by michaelpq > You can respond by visiting: > https://sourceforge.net/tracker/?func=detail&atid=1310232&aid=3316512&group_id=311227 > > Please note that this message will contain a full copy of the comment thread, > including the initial issue submission, for this request, > not just the latest update. > Category: Database Server > Group: 1.0 Dev Q >>Status: Closed > Priority: 3 > Private: No > Submitted By: Michael Paquier (michaelpq) > Assigned to: Koichi Suzuki (koichi-szk) > Summary: psql help > > Initial Comment: > Now psql help is built on the docs files located in doc/src/ref from a pearl script. > This has to be changed to refer to XC doc repository. > > ---------------------------------------------------------------------- > >>Comment By: Michael Paquier (michaelpq) > Date: 2012-04-23 17:59 > > Message: > TAB completion support is added by 739e32b > > ---------------------------------------------------------------------- > > Comment By: Michael Paquier (michaelpq) > Date: 2012-04-15 21:50 > > Message: > This is fixed by commit ceaf339. > > ---------------------------------------------------------------------- > > Comment By: Koichi Suzuki (koichi-szk) > Date: 2012-04-10 17:36 > > Message: > To fix this, we need three separate work. > i) Fix Makefile in src/bin/psql to include sgml in doc-xc, not in doc. > ii) Fix root Makefile and doc-xc/src/sgml/Makefile to generate sgml from > sgmlin before psql is compiled. > iii) Fix tab-complete.[ch]. They're hard-coded. > > ---------------------------------------------------------------------- > > Comment By: Koichi Suzuki (koichi-szk) > Date: 2012-03-12 02:17 > > Message: > Need Makefile change. > > ---------------------------------------------------------------------- > > You can respond by visiting: > https://sourceforge.net/tracker/?func=detail&atid=1310232&aid=3316512&group_id=311227 |
|
From: Koichi S. <koi...@gm...> - 2012-01-26 02:58:58
|
Now doc is used as a copy of original PostgreSQL documentation to make document update easier. I think the template should be in doc-xc instead. ---------- Koichi Suzuki 2012/1/26 Michael Paquier <mic...@gm...>: > ============================================================================ > POSTGRES-XC BUG REPORT TEMPLATE > ============================================================================ > > Your name : Postgres-XC > Your email address : pos...@li... > > > System Configuration: > --------------------- > Architecture : Intel Pentium > > Operating System : Ubuntu 10.04 > > Postgres-XC version : Postgres-XC 1.0devel > > Compiler used : gcc 4.4.3 > > > Please enter a FULL description of your problem: > ------------------------------------------------ > This is intended only to be a bug report example. > This bug template can be found in doc/bug.template. > > > > Please describe a way to repeat the problem. Please try to provide a > concise reproducible example, if at all possible: > ---------------------------------------------------------------------- > This is intended only to be a bug report example. > This bug template can be found in doc/bug.template. > > > > If you know how this problem might be fixed, list the solution below: > --------------------------------------------------------------------- > This is intended only to be a bug report example. > This bug template can be found in doc/bug.template. > > > ------------------------------------------------------------------------------ > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > Postgres-xc-bugs mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs > |
|
From: Michael P. <mic...@gm...> - 2012-01-26 01:31:40
|
*
============================================================================
POSTGRES-XC BUG REPORT TEMPLATE
============================================================================
Your name : Postgres-XC
Your email address : pos...@li...
System Configuration:
---------------------
Architecture : Intel Pentium
Operating System : Ubuntu 10.04
Postgres-XC version : Postgres-XC 1.0devel
Compiler used : gcc 4.4.3
Please enter a FULL description of your problem:
------------------------------------------------
This is intended only to be a bug report example.
This bug template can be found in doc/bug.template.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
**This is intended only to be a bug report example.*
*This bug template can be found in doc/bug.template.*
*
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------*
*This is intended only to be a bug report example.*
*This bug template can be found in doc/bug.template.*
|
10 messages has been excluded from this view by a project administrator.