Re: [BUGS] Core Dump on SunOS + 7.3.3
Tom, > * src/backend/utils/adt/selfuncs.c (REL7_3_STABLE): Work around > buggy strxfrm() present in some Solaris releases. > > Don't recall now which are "some" Solaris releases. Turns out it is the "user with no password" bug, which was throught to affect only Solaris 7 or 8. However, it turns out that they are using a pre-release of Solaris 9, so they have the same issue. They've been told to upgrage to 7.3.6. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[BUGS] [7.4.2] Still "variable not found in subplan target lists"
Hello all.. I have a 7.4.2 pg server and the situation is the following: Table detorders with 69 columns, one of which is called docomment. There is a view based on this table called qrydorders and there are other 5 views which include qrydorders in there definitions. Today after changing (with pgadmin III) the datatype of qrydorders.docomment from varchar(255) to varchar(2500) i got the error "variable not found in subplan target lists" when a SELECT * from qrydorders WHERE did=101015 . Everything got back working after i dropped qrydorders and all of the views in cascade and then recreated them. I saw this was a problem in the 7.4.1. Before installing 7.4.2 and recreating the database i dropped the old DB, removed the directory which contained the PG files, created a new one and recreated everything with initdb so i do not think its a mistake that i made when i installed the new PG. Regards, Fabrizio Mazzoni ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [BUGS] [7.4.2] Still "variable not found in subplan target lists"
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > Today after changing (with pgadmin III) the datatype of > qrydorders.docomment from varchar(255) to varchar(2500) i got the > error "variable not found in subplan target lists" [ from a view > dependent on the table ] This is an unsupported operation. You should perhaps complain to the pgadmin guys that they are not correctly updating the system catalogs. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
