[pgadmin-support] Error Message: ERROR: cache lookup of type 44822021 failed
This e-mail was scanned by RAV Antivirus. (www.ravantivirus.com)
Re: [pgadmin-support] Error Message: ERROR: cache lookup of type 44822021 failed
From: Attila Toth [mailto:[EMAIL PROTECTED] Sent: 05 December 2003 07:49To: [EMAIL PROTECTED]Subject: [pgadmin-support] Error Message: ERROR: cache lookup of type 44822021 failed Description: ERROR: cache lookup of type 44822021 failedNumber: -2147467259Routine: pgAdmin II:frmMain.tvNamespace Hi, That is an error from PostgreSQL - it generally means that you have a data type missing that is needed by a function or table or some other object. Upgrading to 7.3.5 or 7.4 would help prevent this problem occuring in the future as there is now a dependency tracking mechanism in place - the 7.1.3 version that you are currently using is positively ancient now :-) Regards, Dave.
[pgadmin-support] Creating functions with pgAdmin III
Hi I don't know if anyone has encountered this problem before. I couldn't find any reference to this on the list archives or FAQ. I can't find the pseudo-type RECORD in the drop-down list of return types so it is impossible to create functions like "CREATE OR REPLACE FUNCTION foo (TEXT) RETURNS SET OF RECORD AS..." using the gui. Currently I have to work around this by manually creating the function shell from psql or using the query editor and then editing the function body using pgAdmin. I've tried pgAdmin 1.0.1 and 1.0.2 against postgreSQL-7.2.3, 7.3.3, 7.3.4 and 7.4 but none of the combinations work. BTW, this is a _great_ tool which has helped our sysadmins and junior developers quickly and easily administer, grasp the structure of our databases and develop their own schemas. Any ideas? Ian ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-support] SQL window hangs/errors upon close of approx. 3,000 recs
Platform : Windows 9x Language : us-en Distribution : Binary Hi, I think I have found a problem on the SQL/Query window. I'd this simple SELECT statement that would retrieve around 3,000 records from the table, the records was displayed in a zap, oh cool!:D. But then when I have to close the window, the view was cleared but the window is stucked and then the Illegal Operation window of the OS appears and it completely closes the App!.. Is it the SysListView32 class? Thanks. Regards, Chay Luna __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] SQL window hangs/errors upon close of approx.
Chay Luna wrote: Platform : Windows 9x Language : us-en Distribution : Binary Hi, I think I have found a problem on the SQL/Query window. I'd this simple SELECT statement that would retrieve around 3,000 records from the table, the records was displayed in a zap, oh cool!:D. But then when I have to close the window, the view was cleared but the window is stucked and then the Illegal Operation window of the OS appears and it completely closes the App!.. Is it the SysListView32 class? Yes, I believe this class is used. This problem hasn't been reported so far, so I'm suspecting Win9x to be the reason. Can you try the same on W2000 or XP? Regards, Andreas ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-support] Creating functions with pgAdmin III
Ian Freislich wrote: I can't find the pseudo-type RECORD in the drop-down list of return types so it is impossible to create functions like "CREATE OR REPLACE FUNCTION foo (TEXT) RETURNS SET OF RECORD AS..." using the gui. Not all 'p' types are allowed as return types for functions, but apparently the list was too restricted. I expanded the list (to be precise: allow all for certain exceptions), committed to cvs. Currently I have to work around this by manually creating the function shell from psql or using the query editor and then editing the function body using pgAdmin. Yeah, this is what pgAdmin3's sql preview is meant for. Not necessary for this special case any more. BTW, this is a _great_ tool which has helped our sysadmins and junior developers quickly and easily administer, grasp the structure of our databases and develop their own schemas. Thanks! Regards, Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] New FC1 RPMS uploaded to snake
Hi, I've rebuilt today's snapshots using the latest wxWindows packages. They are now on snake. Yes, it solved the Help menu crash problem. Thanks all. But the crash which happens while trying to add a new user continues. I'm not sending a bug report again since I've posted one yesterday. Regards, -- Devrim GUNDUZ <[EMAIL PROTECTED]> TDMSoft ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
