datactrl
Last Activity: Mar 28 '14, 12:18 PM
Joined: Jul 7 '08
Location:
-
I solved the problem. PHP does receive the exception message from psql and apache does report the error to client browser. on browser side, it's an ajax request. That exception message have to be handled on error event rather than success event. -
get raise notice/exception message on PHP
I use PHP to do database with Postresql. On PHP, I would like to get message from Raise notice/exception on Postgresql procedure. It's used to work fine. After some Postgresql, Aapache and PHP upgrade. Now it won't work. That means on PHP, I cannot get any of them and just a server timeout message. I can find all of then are in postgresql log file. Is there any configuration can change it back? Thank you very much! -
I've got the solution. On schedule task should be like:
then a.wsf will see all the argument a1 and a2.Code:wscript c:\script\a.wsf a1 a2
Leave a comment:
-
Questions about Windows 2003 schedule task
I have a wsh file in with some arguments. It runs fine with a shortcut passed required arguments. When I specified the same command line in schedule task. It seems the wsh cannot read arguments. So I have to use a bath file comes with argument run on the task. Then it works.
On schedule task:the a.wsh won't see all the argumentsCode:c:\script\a.wsh a1 a2
Bath file a.bat
...Code:c:\script\a.wsh a1 a2
-
Thanks a lot. I found the problem is I installed apache as services and login as system on my Windows 2003. Services won't allow to prompt for password. Now I save a pgpass.conf in system/application data, then it works.Leave a comment:
-
PHP exec has no responding
The following function is used to execute pg_dump but have no responding at all. And I found there is no output. While the exactly command string executing on server desktop does work. And I have another function to execute a program saved in somewhere rather than "program files" and it works. php safe_mode is off.
...Code:function create_new_csn_schema($xfrom_schema, $xtoschema){ $cmd ="\"c:\\program files\\PostgreSQL\\9.0\\bin\\pg_dump.exe\" -
I did "drop ... cascade" and re-build by information_sch ema.sql. Both done successfully. I don't know what catalog is. Anyway, originally under CATALOGS ANSI(informatio n_schema), there are lots of objects. After I did that, it becomes 0 objects. I restart posgresql. It works fine. Did I miss anything?Leave a comment:
-
Questions of information_schema
When I read 9.0.6 upgrade (from 9.0.x) notes, upgrade bin folder is not enough. Need to drop information_sch ema and recreate it by a sql file in share folder.
My questions are
1) Why I can't fine that schema on pgAdmin in each database.
2) I tried to query its tables and it works. That means it's there.
3) I try to drop it: drop schema information_sch ema. It causes a lot of errors about depending objects.
... -
How to upgrade postgresql database from 9.0.5 to 9.0.6
I would like to upgrade my postgresql 9.0.5 to 9.0.6 on Windows 2003 server. Is that possible I just download 9.0.6 zip file and replace all the files in bin folder? Thank you in advance! -
View & search_path
postgresql 8.3
Views do not follow search_path. It always uses the tables in the same schema of itself.
The adm_items in public is always used.Code:CREATE OR REPLACE VIEW public.admv_acct AS SELECT a.itemno, a.itemtype, a.category, a.itemdesc, a.negativeacct FROM adm_items a WHERE a.itemtype::text = 'A'::text ORDER BY a.itemno;
-
how to remove pgagent
how to remove pgagent from postgresql? Thank you in advance! -
Can we run dumpall at application working time
I'm used to do dumpall after work everyday. Is that possible to do it at business hours time, such as 10am, 12am, 3pm, which is within business hours and lots on line updates are still working? I just try to make a backup as uptodate as possible. If backup is made in this situation, will it has a integration problem in the backup? Thank you! -
Thank you, rski. I changed my scripts as followings which has some point to output log on a text file, t1.txt. I run it from command window with the same login user as pgAgent service. It works and t1.txt is output correctly. While on pgAgent, I click 'Run now'. there is just nothing happened. And no output log as well. I check the statistic, there is no any entry on it. It seems pgAgent didn't run it at all.
...Code:echo start here >t1.txt
Leave a comment:
-
I have a script to run pg_dumpall and pg_dump modified from pgAgent installation document. It won't work at all. That why I try a simple script just echo something to see if it works. The script is as the following. It works when I run it on command windows.
...Code:set BACKUPDIR=D:\cij\works\backup\ set PGHOST=localhost set PGUSER=quals set PGBIN=C:\Program Files (x86)\PostgreSQL\8.3\bin\ rem date format: dd/mm/yy
Leave a comment:
-
Thank you,rski. It works!Leave a comment:
-
How to remove a schema in catalogs from a database
When I install pgagent, I make a mistake to create a pgagent schema in catalogs in wrong database, by running an installation script, rather than in database of postgres. How can I remove it? On pgAdmin3, right click on pgagent schema in catalogs, there is no drop command. -
job won't work on pgagent schedule
I installed pgagent in a windows 7. On pgadmin3, I can see JOB. And I create a simple Job on it to run a simple batch file, just one line, echo ZZZ. I try to "run now". it won't work at all. I check pgAgent service, it's running. And run by a PC account who can access the batch file. Just don't what else I have missed out! -
it's "schemaname " rather than "tableschem a".Leave a comment:
-
Thanks a lot, rski!Leave a comment:
-
About how to query trigger enabled status
Is that possible to show all triggers enabled status(true/false) within a schema by an SQL query?
No activity results to display
Leave a comment: