Re: [BUGS] BUG #2157: Disabling trigger
On Mon, Jan 09, 2006 at 03:35:47PM +, Jiri Klepac wrote: > I was tryiing to disable trigger for specific table. ALTER TABLE tbl DISABLE > TRIGGER trg_name; > This is well documented in manual for ALTER TABLE command. Are you sure you're looking at the documentation for the version you're running? DISABLE TRIGGER is in the documentation for 8.1 but not for 8.0. http://www.postgresql.org/docs/8.0/interactive/sql-altertable.html http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html -- Michael Fuhr ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [BUGS] BUG #2139: Problem when calling functions without any
hello Jaime, Sorry. I forgot to provide you with the information. Please find the function and the trace of jdbc calls in the enclosed file. Thank you in advance for your help. Jacques Jaime Casanova a écrit : > On 1/3/06, Jacques Gollion <[EMAIL PROTECTED]> wrote: > > > > The following bug has been logged online: > > > > Bug reference: 2139 > > Logged by: Jacques Gollion > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 8.1.1 > > Operating system: Windows 2000 > > Description:Problem when calling functions without any argument > > Details: > > > > have have written some functions without any argument. When my powerbuilder > > V9 application calls these functions, the behaviour is different : > > > > *Using ODBC driver, it works well > > *Using JDBC driver (I tried several versions), I get the error message > > "ERROR : Syntax error at or near $1. If I add a unused argument to the > > function; it works. > > If I call in JDBC the same function for Oracle or Sybase, it works. > > If I call other PostGreSQL functions with arguments, it works. > > > > Where am I wrong ? > > > > Thanks in advance for your help. > > > > and... where is the function? how is defined? how do you use it? > > code, please wiyhout that you can't expect any help... > > -- > regards, > Jaime Casanova > (DBA: DataBase Aniquilator ;) -- Jacques GOLLIONmailto:[EMAIL PROTECTED] SAMBA Technologies http://www.sambatechnologies.com 53 chemin du Vieux ChenePhone : +33 (0) 4 76 04 00 59 38240 MEYLAN FRANCE Fax : +33 (0) 4 76 04 15 98 Information.log Description: application/unknown-content-type-txtfile ---(end of broadcast)--- TIP 6: explain analyze is your friend
[BUGS] BUG #2158: psql
The following bug has been logged online: Bug reference: 2158 Logged by: Umberto Leandro Kaizer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: windows 2000 server Description:psql Details: Welcome to psql 8.1.1, the PostgreSql interactive terminal. Type: \copyright for distribuitions terms \h for help with SQL commands \? for help with psql commands \g for terminate with semicolon to execute query \q quit warning: Console code page (437) differs from Windows code page (1252) 8-bit characters may not work correctly. See psql reference page "Notes for Windows users"for details. postgres=# \? 'more' is not recognized as an internal or external command, operable program or batch file. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[BUGS] BUG #2157: Disabling trigger
The following bug has been logged online: Bug reference: 2157 Logged by: Jiri Klepac Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: win2000 Description:Disabling trigger Details: I was tryiing to disable trigger for specific table. ALTER TABLE tbl DISABLE TRIGGER trg_name; This is well documented in manual for ALTER TABLE command. But database answered: ERROR: syntax error at or near "DISABLE" at character 32. It even don't know DISABLE as a key word. Kind regards, Jiri Klepac. ---(end of broadcast)--- TIP 1: 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: [BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules
On 1/7/06, John Supplee <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > > OK, got it. Patch for 8.1 is attached if you need it. > > Thanks for the test case. > > Wow, thanks for the quick work. But since I can solve the problem with NOT > NULL constraints directly on the column I will wait for the next release to > test it (I don't have the source on my machine). > > BTW, I also observed the same behavior in 8.0.5 as well. > > > John Supplee > of course. Tom backpatch all branches until 7.3... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 6: explain analyze is your friend
