[pgadmin-support] A question
My postgresql version is 7.2.1
I have create a function:
create function returnset(varchar) returns setofcomputers
as '
select * from computer where hostname like ''%''+$1+''%'' '
language 'plpgsql';
But when I select returnset('aaa') ,it returns:
An error has occured in pgAdmin
II:frmSQLInput.cmdExecute_Click:
Number:-2147467259
Description:ERROR:fmgr_info:function 0:cache lookup failed
Please tell me what means!
»¶ÓʹÓÃ963Ãâ·ÑÓʾÖ(http://www.szonline.net)
---(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
[pgadmin-support] Can't uninstall pgadmin2 Version 1.3.82
Hy, when i try to uninstall pgadmin 1.3.82 the windows installer says that he can't find the file pdadmin2.msi because it's on a network resource. Manually specifying the path to pgadmin2.msi doesn't solve the problem. What's wrong ? Oliver ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-support] unsubscribe
unsubscribe ---(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: [pgadmin-support] A question
That error comes from the server, and usually means that a function being called
doesn't exist any more. I didn't think PostgreSQL 7.2 could return sets from a
function though?
Regards, Dave.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 28 November 2002 05:27
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] A question
>
>
> My postgresql version is 7.2.1
> I have create a function:
> create function returnset(varchar) returns setofcomputers
> as '
> select * from computer where hostname like ''%''+$1+''%'' '
> language 'plpgsql';
>
> But when I select returnset('aaa') ,it returns:
>
> An error has occured in pgAdmin
> II:frmSQLInput.cmdExecute_Click:
> Number:-2147467259
> Description:ERROR:fmgr_info:function 0:cache lookup failed
>
> Please tell me what means!
>
>
>»¶ÓʹÓÃ963Ãâ·ÑÓʾÖ(http://www.szonline.net)
>
>
> ---(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
[pgadmin-support] An error (hhctrl.ocx) and a bug (DROP DB)
On the installation of pgAdmin (.. 1.4.0 - 1.4.1. - 1.4.2) I get en error about hhctrl.ocx. But after I click OK the installation goes without error. The error is "Error 1931: The windows intaller service cannot update the system file C:\WINNT\System32\hhctrl.ocx because the fle is protected by Windows. You may need to update your operating system for this program to work correctly." I don't think this is a bug anyway I wanted to state it. The real issue comes with the 1.4.2 (I don't remember getting this error apriori). I cannot drop the databases I've created. I get two different errors. I couldn't figure out on what conditions one or other appears. The errors are: "An error has occured in pgAdmin II:basActions.Drop: Number: -2147467259 Description: ERROR: DROP DATABASE: database "test" is being accessed by other users" "An error has occured in pgAdmin II:basActions.Drop: Number: 424 Description: Object required" I am sure that no one accesses the databases while I drop them. These errors don't affected by number of tables, or not having any at all. Is this a bug or am I doing something wrong? Cagil SEKER - "Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The Mentor'86 (Hacker's Manifesto) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [pgadmin-support] Can't uninstall pgadmin2 Version 1.3.82
Hi, That is the Microsoft Installer being a PITA. Make sure you have the original pgadmin2.msi file, and not a different version, and if that doesn't work, your best bet is to look on www.microsoft.com for the msizap.exe utility which will clear the MSI database entries for a given program. Regards, Dave. > -Original Message- > From: oliver archner [mailto:[EMAIL PROTECTED]] > Sent: 28 November 2002 09:08 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Can't uninstall pgadmin2 Version 1.3.82 > > > Hy, > > when i try to uninstall pgadmin 1.3.82 the windows > installer says that he can't find the file pdadmin2.msi > because it's on a network resource. > Manually specifying the path to pgadmin2.msi doesn't solve > the problem. > > What's wrong ? > > Oliver > > > ---(end of > broadcast)--- > TIP 5: Have you checked our extensive FAQ? > http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-support] pgAdmin bugs observed.
I apologise if these bugs have already been
reported but I find searching for a list of acknowledged bugs close to
impossible using the mailing support system.
Name: Donald Fraser
Os: Windows 2000 professional SP2.
pgAdmin: 1.4.0 build 0.
My skills: Embedded systems, C, C++, Java, 10+
years as programmer.
Bugs:
1) During the install process, under administrator,
Windows reports that several files cannot be installed as the are controlled by
the operating system. It appears that certain system files are trying to be
installed and do not succeed due to Windows attempting to protected its
operating system files.
This may lead to further problems down the road if
the underlying system relies on those versions of files to operate
correctly...?
2) I tried to create a view and I got an immediate
error. I have taken the snippet from the log.
2002-11-27 17:25:29 - SQL (CISX): CREATE VIEW
vu_current_user AS SELECT id_usertype, id_4eyestype, id_contact, id_contrib,
s_loginid, dt_passwdset, n_passexpire, b_hasvaluation FROM tbl_user WHERE id =
get_userid() 2002-11-27 17:25:29 - SQL (CISX): SELECT c.oid, c.relname,
pg_get_userbyid(c.relowner) AS viewowner, c.relacl, pg_get_viewdef(c.relname) AS
definition FROM pg_class c WHERE ((c.relhasrules AND (EXISTS (SELECT r.rulename
FROM pg_rewrite r WHERE ((r.ev_class = c.oid) AND (bpchar(r.ev_type) =
'1'::bpchar) OR (c.relkind = 'v'::"char")) AND relname =
'vu_current_user'
2002-11-27 17:25:29 -
***2002-11-27
17:25:29 - Error(s)2002-11-27 17:25:29 -
***2002-11-27
17:25:29 - Error in pgAdmin II:frmView.cmdOK_Click: 424 - Object
required
2002-11-27 17:25:29 - Windows Version: Windows 2000
v5.0 build 2195 Service Pack 22002-11-27 17:25:29 - pgSchema Version:
1.4.02002-11-27 17:25:29 - MDAC Version: 2.52002-11-27 17:25:29 - DBMS
Version: 07.02.0004 PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC
2.962002-11-27 17:25:29 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=192.168.100.23;PORT=5432;UID=postgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"
Unfortunately as a programmer I know if I can't
reproduce the error myself what chance have you got at ever fixing it!
I have tried to reproduce the error and I cannot,
so logic tells me that it was not a single action that caused the error but
rather a chain of events that lead to it. If you want the complete log I can
send it to you.
What I did observe was that the view was acutally
created but the security rights where not.
3) Having created a view, any view it seems, if I
try to edit the properties either by the menu or by double clicking on the view
I get an error - Element not found.
Here's the snippet from the log.
2002-11-28 11:05:18 -
***2002-11-28
11:05:18 - Error(s)2002-11-28 11:05:18 -
***2002-11-28
11:05:18 - Error in pgAdmin II:frmView.Initialise: 35601 - Element not
found
2002-11-28 11:05:18 - Windows Version: Windows 2000
v5.0 build 2195 Service Pack 22002-11-28 11:05:18 - pgSchema Version:
1.4.02002-11-28 11:05:18 - MDAC Version: 2.5
Regards
Donald Fraser
Re: [pgadmin-support] An error (hhctrl.ocx) and a bug (DROP DB)
> -Original Message- > From: Çagil Seker [mailto:[EMAIL PROTECTED]] > Sent: 28 November 2002 10:16 > To: PGAdmin-Support-List (E-mail) > Subject: [pgadmin-support] An error (hhctrl.ocx) and a bug (DROP DB) > > > > On the installation of pgAdmin (.. 1.4.0 - 1.4.1. - 1.4.2) I > get en error about hhctrl.ocx. But after I click OK the > installation goes without error. The error is "Error 1931: > The windows intaller service cannot update the system file > C:\WINNT\System32\hhctrl.ocx because the fle is protected by > Windows. You may need to update your operating system for > this program to work correctly." I don't think this is a bug > anyway I wanted to state it. No, it's not a bug. > The real issue comes with the 1.4.2 (I don't remember getting > this error apriori). I cannot drop the databases I've > created. I get two different errors. I couldn't figure out on > what conditions one or other appears. The errors are: > > "An error has occured in pgAdmin II:basActions.Drop: > Number: -2147467259 > Description: ERROR: DROP DATABASE: database "test" is being > accessed by other users" > > "An error has occured in pgAdmin II:basActions.Drop: > Number: 424 > Description: Object required" > > I am sure that no one accesses the databases while I drop > them. These errors don't affected by number of tables, or not > having any at all. > > Is this a bug or am I doing something wrong? It is a bug, but it is related to the way Microsoft ADO opens database connections (ie. It doesn't close them immediately) and has *always* existed. For more info, look at the bottom of http://www.pgadmin.org/pgadmin2.php?ContentID=5 Regards, Dave. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-support] Setting varchar[] lenght?
How can I set the length of a varchar[] columns? On psql I can use varchar[50] but on the "create column" form, pgAdmin won't let me to edit the length field. Thanks, Cagil. - "Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The Mentor'86 (Hacker's Manifesto) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-support] unsubscribe
[pgadmin-support] unsubscribe
unsubscribe
[pgadmin-support] unsubscribe
unsubscribe
[pgadmin-support] unsubscribe
unsubscribe This mail sent through Visitmail.com (c) Altranet ---(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
[pgadmin-support]
unsubscribe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] pgAdmin bugs observed.
Title: Message
Hi,
-Original Message-From: Donald Fraser
[mailto:[EMAIL PROTECTED]] Sent: 28 November 2002
11:20To: [EMAIL PROTECTED]Subject:
[pgadmin-support] pgAdmin bugs observed.
I apologise if these bugs have already been
reported but I find searching for a list of acknowledged bugs close to
impossible using the mailing support system.
Name: Donald Fraser
Os: Windows 2000 professional SP2.
pgAdmin: 1.4.0 build 0.
My skills: Embedded systems, C, C++, Java, 10+
years as programmer.
Bugs:
1) During the install process, under
administrator, Windows reports that several files cannot be installed as the
are controlled by the operating system. It appears that certain system files
are trying to be installed and do not succeed due to Windows attempting to
protected its operating system files.
This may lead to further problems down the road
if the underlying system relies on those versions of files to operate
correctly...?
This is not a problem, it just means you have a newer
version of the Microsoft HTML Help viewer installed (normal with SP2). The
Microsoft Installer is just being overly alarming in it's
messages!!
2) I tried to create a view and I got an
immediate error. I have taken the snippet from the log.
2002-11-27 17:25:29 - SQL (CISX): CREATE VIEW
vu_current_user AS SELECT id_usertype, id_4eyestype, id_contact, id_contrib,
s_loginid, dt_passwdset, n_passexpire, b_hasvaluation FROM tbl_user WHERE id =
get_userid() 2002-11-27 17:25:29 - SQL (CISX): SELECT c.oid, c.relname,
pg_get_userbyid(c.relowner) AS viewowner, c.relacl, pg_get_viewdef(c.relname)
AS definition FROM pg_class c WHERE ((c.relhasrules AND (EXISTS (SELECT
r.rulename FROM pg_rewrite r WHERE ((r.ev_class = c.oid) AND
(bpchar(r.ev_type) = '1'::bpchar) OR (c.relkind = 'v'::"char")) AND
relname = 'vu_current_user'
2002-11-27 17:25:29 -
***2002-11-27
17:25:29 - Error(s)2002-11-27 17:25:29 -
***2002-11-27
17:25:29 - Error in pgAdmin II:frmView.cmdOK_Click: 424 - Object
required
2002-11-27 17:25:29 - Windows Version: Windows
2000 v5.0 build 2195 Service Pack 22002-11-27 17:25:29 - pgSchema Version:
1.4.02002-11-27 17:25:29 - MDAC Version: 2.52002-11-27 17:25:29 - DBMS
Version: 07.02.0004 PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC
2.962002-11-27 17:25:29 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=192.168.100.23;PORT=5432;UID=postgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"
Unfortunately as a programmer I know if I can't
reproduce the error myself what chance have you got at ever fixing it!
I have tried to reproduce the error and I cannot,
so logic tells me that it was not a single action that caused the error but
rather a chain of events that lead to it. If you want the complete log I can
send it to you.
What I did observe was that the view was acutally
created but the security rights where not.
No, I can't reproduce it either, though it's possibly because of another
bug that has been fixed in the version I'm running (see below). I'll keep an eye
out for it though.
3) Having created a view, any view it seems, if I
try to edit the properties either by the menu or by double clicking on the
view I get an error - Element not found.
Here's the snippet from the log.
2002-11-28 11:05:18 -
***2002-11-28
11:05:18 - Error(s)2002-11-28 11:05:18 -
***2002-11-28
11:05:18 - Error in pgAdmin II:frmView.Initialise: 35601 - Element not
found
2002-11-28 11:05:18 - Windows Version:
Windows 2000 v5.0 build 2195 Service Pack 22002-11-28 11:05:18 - pgSchema
Version: 1.4.02002-11-28 11:05:18 - MDAC Version: 2.5
This problem has been fixed in version 1.4.2, available from www.pgadmin.org/downloads.
Thanks for the report anyway!
Regards,
Dave.
Re: [pgadmin-support] Setting varchar[] lenght?
> -Original Message- > From: Çagil Seker [mailto:[EMAIL PROTECTED]] > Sent: 28 November 2002 14:35 > To: PGAdmin-Support-List (E-mail) > Subject: [pgadmin-support] Setting varchar[] lenght? > > > How can I set the length of a varchar[] columns? On psql I > can use varchar[50] but on the "create column" form, pgAdmin > won't let me to edit the length field. 'varchar[]' is an array of varchars. You probably want to select 'varchar' from near the bottom of the list. Regards, Dave. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
