Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 170978 - Old, bugged and *unusable* PostgreSQL in portage
Summary: Old, bugged and *unusable* PostgreSQL in portage
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: x86 Linux
: High major (vote)
Assignee: Gentoo Linux bug wranglers
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-03-15 02:13 UTC by Marek Cruz
Modified: 2007-09-23 00:19 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Marek Cruz 2007-03-15 02:13:15 UTC
Today i've emerged postgresql, the newest aviable version in gentoo portage is 8.0.12 (which is *terribly* bugged). I don't think this version is vannilla, do you? After the installation, when i was working with pgsql there were lot for nasty error messages like is for example: cannot work because X is not X, but it is X (say character varying bug) -> this is fixed in the newer versions or: INSERT INTO configuration (name, value) VALUES ('commentsAllowed', '1');
ERROR:  array value must start with "{" or dimension information

both of the the name and value are varchar(). Is here any special trick how to insert some text with type of the varchar? I don't think so, do you? I think the best what we can do here is to update pgsql in portage to the newest aviable version (say 8.2.3 *not* 8.0.13). Your regards fr33z

Reproducible: Sometimes

Steps to Reproduce:
1.emerge postgresql and try to work with it directly using the binary file "psql"

Actual Results:  
A lot of error messages which are really unbelievable

Expected Results:  
Usability and functionallity of the version which is in the official gentoo 2006.1 portage tree marked as *stable*

I had running apache2, php5.1.2, mysql5.x (the newest), postgresql 8.0.12, eclipse 3.2.0 stable (this one is not from the gentoo portage, it's downloaded directly from eclipse.org because there is not stable eclipse version in portage, and i wonder why). That's all, no more rellevant program was running all the time.
Comment 1 Seemant Kulleen (RETIRED) gentoo-dev 2007-03-15 02:20:06 UTC
please don't file bugs like this to Developer Relations.  it belongs in the Gentoo Linux component.
Comment 2 Marek Cruz 2007-03-15 02:23:54 UTC
Excuse me, but i don't know better place to report this issue. Is here a chance to replace it somewhere else?
Comment 3 Mike Doty (RETIRED) gentoo-dev 2007-03-15 05:13:40 UTC
not devrel related
Comment 4 Jakub Moc (RETIRED) gentoo-dev 2007-03-15 07:32:49 UTC
What on earth are you talking about?

Keywords for dev-db/postgresql:

          | a a a h i m m p p p s s s s x x 
          | l m r p a 6 i p p p 3 h p p 8 8 
          | p d m p 6 8 p c c c 9   a a 6 6 
          | h 6   a 4 k s   6 - 0   r r   - 
          | a 4             4 m     c c   f 
          |                   a       -   b 
          |                   c       f   s 
          |                   o       b   d 
          |                   s       s     
          |                           d     
----------+--------------------------------
7.3.15-r1 | + + + + +   + + ~   + + +   +   
7.3.16    | + + + + +   ~ + ~   + + +   +   
7.3.18    | + + ~ + +   ~ + ~   ~ ~ +   +   
7.4.13    | + + + + +   + + +   + + +   +   
7.4.14    | + + + + +   ~ + +   + + +   +   
7.4.16    | + + ~ + +   ~ + +   ~ ~ +   +   
8.0.8     | + + + + +   + + +   + + +   +   
8.0.9-r1  | + + + + +   ~ + +   + + +   +   
8.0.12    | + + + + +   ~ + +   + + +   +   
8.1.5-r1  | ~ ~ ~ ~ ~   ~ ~ ~   ~ ~ ~ ~ ~ ~ 
8.1.8     | ~ ~ ~ ~ ~   ~ ~ ~   ~ ~ ~ ~ ~ ~ 

Bug 157337 is for postgresql-8.2, if you have something actually useful to say, beyond ranting about old and unusable.