[GENERAL] PGS 7.2 : Insert with wrong number of values did not fail

2005-02-21 Thread Geoffrey KRETZ
Hi, I've got a question about a difference beetween PGS 7.2 and PGS 7.4 behaviours. With PGS 7.2 : INSERT INTO table (col1, col2) VALUES (val1) doesn't fail With PGS 7.4 : INSERT INTO table (col1, col2) VALUES (val1) failed Is it a known bug ? Thx. Geoffrey KRETZ Four J's De

Re: [GENERAL] PGS 7.2 : Insert with wrong number of values did not

2005-02-21 Thread Geoffrey KRETZ
Scott Marlowe wrote: On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote: Hi, I've got a question about a difference beetween PGS 7.2 and PGS 7.4 behaviours. With PGS 7.2 : INSERT INTO table (col1, col2) VALUES (val1) doesn't fail With PGS 7.4 : INSERT INTO table (col1, col2) VA

Re: [GENERAL] PGS 7.2 : Insert with wrong number of values did not

2005-02-21 Thread Geoffrey KRETZ
Geoffrey KRETZ wrote: Scott Marlowe wrote: On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote: Hi, I've got a question about a difference beetween PGS 7.2 and PGS 7.4 behaviours. With PGS 7.2 : INSERT INTO table (col1, col2) VALUES (val1) doesn't fail With PGS 7.4 : INSERT INTO t

Re: [GENERAL] PGS 7.2 : Insert with wrong number of values did not

2005-02-21 Thread Geoffrey KRETZ
Scott Marlowe wrote: On Mon, 2005-02-21 at 09:49, Geoffrey KRETZ wrote: Scott Marlowe wrote: On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote: Hi, I've got a question about a difference beetween PGS 7.2 and PGS 7.4 behaviours. With PGS 7.2 : INSERT INTO table (col1, col2) V

[GENERAL] PGS 7.4.x PREPARE statement

2005-02-24 Thread Geoffrey KRETZ
Hi, I was wondering when a PREPARE statement is check. (ie : is it normal that the following statement doesn't return an error : PREPARE stmnt AS "") ? Geoffrey Kretz Four J's Development Tools ---(end of broadcast)--

Re: [GENERAL] PGS 7.4.x PREPARE statement

2005-02-24 Thread Geoffrey KRETZ
Tom Lane wrote: Geoffrey KRETZ <[EMAIL PROTECTED]> writes: I was wondering when a PREPARE statement is check. (ie : is it normal that the following statement doesn't return an error : PREPARE stmnt AS "") ? Hm? regression=# PREPARE stmnt AS &quo

[GENERAL] Question on INSERT statement

2004-07-19 Thread Geoffrey KRETZ
ow whereas with informix or db2 for exemple, it will return an error. So is that normal ? Geoffrey Kretz - Four J's Development Tools ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregi

[GENERAL] UPDATE statement

2004-07-19 Thread Geoffrey KRETZ
bit2_vc200 = 'xx' WHERE dbit2_key=1 Geoffrey KRETZ - Four J's Development Tools ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] UPDATE statement

2004-07-19 Thread Geoffrey KRETZ
Richard Huxton wrote: Geoffrey KRETZ wrote: Hello, Is it a way to make the following UPDATE statement work with PGS 7.4 (UNIX) : UPDATE dbit2 SET (dbit2_key,dbit2_c10,dbit2_vc200) = (ABS(-1),NULL,'xx') WHERE dbit2_key=1 Or am I force to use the following syntax : UPDATE dbit2 SET

Re: [GENERAL] Question on INSERT statement

2004-07-19 Thread Geoffrey KRETZ
Richard Huxton wrote: Geoffrey KRETZ wrote: I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching the following request : INSERT INTO temp_tab VALUES (1,2,3) It will insert the values in the three first row whereas with informix or db2 for exemple, it will return an

[GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Hello, For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. Is it still possible to find such an old version of pgs available for download ? Thx in advance Geoffrey Kretz - Four J's Develop

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Devrim GUNDUZ wrote: Hi, On Mon, 16 Aug 2004, Devrim GUNDUZ wrote: For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. ftp.postgresql.org/postgresql/source/ Sorry for the typo. It should be: ftp.postg

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
P.S. The original request was posted as a reply to another thread. This is not a nice thing to do. It messes up the archives and can hide the fact that your request is new, causing some people who could have helped you to ignore it. I'm sorry for that, I don't mind to bother anyone (I've just r

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Bruno Wolff III wrote: On Mon, Aug 16, 2004 at 18:08:44 +0200, Geoffrey KRETZ <[EMAIL PROTECTED]> wrote: Hello, For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. Is it still possible to find