https://forum.postgresql.org.pl/viewtopic.php?id=190 Mon, 27 Apr 2009 05:04:47 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=762#p762 , jcl.jclid, 'zadanie', '', true, '' FROM pgagent.pga_jobclass jcl WHERE jclname='Routine Maintenance'; INSERT INTO pgagent.pga_jobstep (jstid, jstjobid, jstname, jstdesc, jstenabled, jstkind, jstonerror, jstcode, jstdbname) SELECT , , 'k1', '', true, 's', 'f', 'DROP TABLE "0001"; DROP TABLE "0001_actual"; DROP TABLE "0001_history"; DROP TABLE "0001_on_off_info"; DROP TABLE "0001_set_value_info"; DROP TABLE "0001_w"; ', 'baza2'; INSERT INTO pgagent.pga_schedule (jscid, jscjobid, jscname, jscdesc, jscminutes, jschours, jscweekdays, jscmonthdays, jscmonths, jscenabled, jscstart, jscend) VALUES(, , 'p1', '', '{t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f,t,f,f,f,f}', '{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}', '{f,f,f,f,f,f,f}', '{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}', '{f,f,f,f,f,f,f,f,f,f,f,f}', true, '2009-04-01 00:00:00', NULL);[/code] ale przy zatwierdzeniu na OK nie wpisują się te dane do tabel próbowałem wpisać ręcznie ale wyskakuje błąd dotyczący ostrych nawiasów [code] ERROR: syntax error at or near "<" LINE 2: SELECT , jcl.jclid, 'zadanie', '', true, '' ^ ********** Błąd ********** ERROR: syntax error at or near "<" Stan SQL:42601 Znak:98 [/code] może ktoś wie o co w tym chodzi z tymi nawiasami? :(]]> Mon, 27 Apr 2009 05:04:47 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=762#p762 https://forum.postgresql.org.pl/viewtopic.php?pid=760#p760 Fri, 24 Apr 2009 17:02:12 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=760#p760 https://forum.postgresql.org.pl/viewtopic.php?pid=758#p758 Fri, 24 Apr 2009 11:34:47 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=758#p758 https://forum.postgresql.org.pl/viewtopic.php?pid=757#p757 Fri, 24 Apr 2009 11:04:38 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=757#p757 https://forum.postgresql.org.pl/viewtopic.php?pid=755#p755 Fri, 24 Apr 2009 05:01:38 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=755#p755 https://forum.postgresql.org.pl/viewtopic.php?pid=753#p753 Thu, 23 Apr 2009 20:14:40 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=753#p753 https://forum.postgresql.org.pl/viewtopic.php?pid=751#p751 Thu, 23 Apr 2009 12:43:58 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=751#p751