Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
On Fri, 2002-11-01 at 11:30, Larry Rosenman wrote: Is the following supposed to work? $ psql -U neteng -h tide netmaster ERROR: parser: parse error at or near . 7.3 psql is schema safe. So... it's trying to do silly things like: SELECT * FROM pg_catalog.pg_class; Of course, 7.2 and earlier did not support such syntax. -- Rod Taylor ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
On Fri, 2002-11-01 at 10:38, Rod Taylor wrote: On Fri, 2002-11-01 at 11:30, Larry Rosenman wrote: Is the following supposed to work? $ psql -U neteng -h tide netmaster ERROR: parser: parse error at or near . 7.3 psql is schema safe. So... it's trying to do silly things like: SELECT * FROM pg_catalog.pg_class; Of course, 7.2 and earlier did not support such syntax. I know this, the question is, Should this happen? If not, can we fix it somehow? Or do we need to put a note somewhere? LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
Larry Rosenman [EMAIL PROTECTED] writes: Is the following supposed to work? No. 7.3 psql uses schema syntax in its internal queries, so it will fail to detect superuser status on pre-7.3 backends. Most backslash commands won't work very well either :-(. However, manually issued SQL should work as expected. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
On Fri, 2002-11-01 at 10:43, Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: Is the following supposed to work? No. 7.3 psql uses schema syntax in its internal queries, so it will fail to detect superuser status on pre-7.3 backends. Most backslash commands won't work very well either :-(. However, manually issued SQL should work as expected. Should this be prominent in some doc somewhere? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
I know this, the question is, Should this happen? If not, can we fix it somehow? Or do we need to put a note somewhere? I think it's a little late to fix now. Making psql support multiple versions was a suggestion Tom made a while back, but nobody took up the challenge. -- Rod Taylor ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
On Fri, 2002-11-01 at 12:25, Rod Taylor wrote: I know this, the question is, Should this happen? If not, can we fix it somehow? Or do we need to put a note somewhere? I think it's a little late to fix now. Making psql support multiple versions was a suggestion Tom made a while back, but nobody took up the challenge. Hmm. Ok. How about a cross-version/upgrade note somewhere? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
On Fri, 2002-11-01 at 14:18, Larry Rosenman wrote: On Fri, 2002-11-01 at 12:25, Rod Taylor wrote: I know this, the question is, Should this happen? If not, can we fix it somehow? Or do we need to put a note somewhere? I think it's a little late to fix now. Making psql support multiple versions was a suggestion Tom made a while back, but nobody took up the challenge. Hmm. Ok. How about a cross-version/upgrade note somewhere? Probably worth while mentioning on the psql client page that clients are only expected to work with the version they're released with. Some functionality may be missing otherwise. -- Rod Taylor ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
Rod Taylor wrote: On Fri, 2002-11-01 at 14:18, Larry Rosenman wrote: On Fri, 2002-11-01 at 12:25, Rod Taylor wrote: I know this, the question is, Should this happen? If not, can we fix it somehow? Or do we need to put a note somewhere? I think it's a little late to fix now. Making psql support multiple versions was a suggestion Tom made a while back, but nobody took up the challenge. Hmm. Ok. How about a cross-version/upgrade note somewhere? Probably worth while mentioning on the psql client page that clients are only expected to work with the version they're released with. Some functionality may be missing otherwise. We have always allowed old clients to connect to new servers, but often break new servers connecting to old clients. I think this is documented somewhere, but it rarely comes up as an issue. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
On Fri, 2002-11-01 at 21:54, Bruce Momjian wrote: Rod Taylor wrote: On Fri, 2002-11-01 at 14:18, Larry Rosenman wrote: On Fri, 2002-11-01 at 12:25, Rod Taylor wrote: I know this, the question is, Should this happen? If not, can we fix it somehow? Or do we need to put a note somewhere? I think it's a little late to fix now. Making psql support multiple versions was a suggestion Tom made a while back, but nobody took up the challenge. Hmm. Ok. How about a cross-version/upgrade note somewhere? Probably worth while mentioning on the psql client page that clients are only expected to work with the version they're released with. Some functionality may be missing otherwise. We have always allowed old clients to connect to new servers, but often break new servers connecting to old clients. I think this is documented somewhere, but it rarely comes up as an issue. So, what do we do in this case, where an OLDER client (=7.2.3) connects to a new (=7.3) server, and BASIC stuff like backslash commands BREAK because of the schema stuff? IT NEEDS TO BE AT LEAST DOCUMENTED PROMINENTLY. (IMHO). LER -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
We have always allowed old clients to connect to new servers, but often break new servers connecting to old clients. I think this is documented somewhere, but it rarely comes up as an issue. So, what do we do in this case, where an OLDER client (=7.2.3) connects to a new (=7.3) server, and BASIC stuff like backslash commands BREAK because of the schema stuff? All version mismatches are expected to cause some psql features to fail. But the basics still work fine. 7.3 happens to be a little more severe than previous releases -- though 7.0 - 7.1 wasn't overly happy either. See the third point in the 'NOTES' section on: http://developer.postgresql.org/docs/postgres/app-psql.html psql only works smoothly with servers of the same version. That does not mean other combinations will fail outright, but subtle and not-so-subtle problems might come up. Backslash commands are particularly likely to fail if the server is of a different version. However, perhaps this version is worthy of a remark in the release notes with the schema description: Non-schema aware versions of the utilities distributed with PostgreSQL to be 100% functional with PostgreSQL = 7.3. -- Rod Taylor ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?
Larry Rosenman wrote: We have always allowed old clients to connect to new servers, but often break new servers connecting to old clients. I think this is documented somewhere, but it rarely comes up as an issue. So, what do we do in this case, where an OLDER client (=7.2.3) connects to a new (=7.3) server, and BASIC stuff like backslash commands BREAK because of the schema stuff? IT NEEDS TO BE AT LEAST DOCUMENTED PROMINENTLY. In the case you are describing, it is new clients connecting to old servers. We have had several releases where this caused problems but received few error reports. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])