Re: [HACKERS] Little mess in RPM RH ?

2003-12-28 Thread Sander Steffann
Hi, Inside the RH9.0 coesist the 7.4.0-0.3 and 7.4.0-0.5 versions looking on other RH directory version I found that actually 7.4.0-0.2 7.4.0-0.3 7.4.0-0.4 7.4.0-0.5 are existing. Inside the SRPMS directory is present only the 7.4.0-0.2 version! This is because when I built the RPMs

Re: [HACKERS] new-line

2003-12-28 Thread Andrew Dunstan
AFAICS the server doesn't know (and in my opinion shouldn't care) what platform a non-local client is running on. This appears to be purely a client-side issue. Furthermore, on Windows, if you are writing the data you get from Postgres to a file which you opened in non-binary mode, Windows will

Re: [HACKERS] Connecting to Postgres

2003-12-28 Thread Tony Reina
In postgresql.conf the first entry should be something like 'tcpip'. Set it to 'true'. That's the equivalent of the postmaster -D. HTH, -Tony [EMAIL PROTECTED] (Nailah Ogeer) wrote in message news:[EMAIL PROTECTED]... How do you connect to postgres if it is running on a different machine. I

Re: [HACKERS] Little mess in RPM RH ?

2003-12-28 Thread Gaetano Mendola
Sander Steffann wrote: Hi, Inside the RH9.0 coesist the 7.4.0-0.3 and 7.4.0-0.5 versions looking on other RH directory version I found that actually 7.4.0-0.2 7.4.0-0.3 7.4.0-0.4 7.4.0-0.5 are existing. Inside the SRPMS directory is present only the 7.4.0-0.2 version! This is because when I

Re: [HACKERS] [GENERAL] Strange permission problem regarding pg_settings

2003-12-28 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Why wouldn't we force checkAsUser to the rule owner in the copied RTEs, similar to the rest of the rule query? Because it would be the wrong check. We need to check that the rule caller has permissions on the view for whatever he originally tried to do

[HACKERS] How to get oprname ??

2003-12-28 Thread Ramanujam H S Iyengar
Hello , I was trying to write a patch code in converting the querytree being generated after the pg_analyze_and_rewrite(). For that I want to know the operator name ( like =, , etc ) .. but the Oper node stores the opno How to get the operator from the opno ??? Thanks for the Help in

Re: [HACKERS] [GENERAL] Strange permission problem regarding pg_settings

2003-12-28 Thread Joe Conway
Tom Lane wrote: No; it's possible for the amalgamated query to include references to tables that are referenced only in the original query and nowhere in the text of the rule. (This is obviously possible right now, since we just take the union of the two rtables and don't make any effort to

[HACKERS] select from table with unique values

2003-12-28 Thread ivan
hi how to do select from same table to get only unique values from same column(s) ? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [HACKERS] select from table with unique values

2003-12-28 Thread Christopher Kings-Lynne
how to do select from same table to get only unique values from same column(s) ? SELECT DISTINCT a, b FROM tab; or even: SELECT DISTINCT ON (a) a, b FROM tab; Chris ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Use of 'cp -r' in CREATE DATABASE

2003-12-28 Thread Andrew Dunstan
Tom Lane wrote: A final point is that implementing CREATE DATABASE via cp -r is and always has been fundamentally broken anyway, because of the lack of interlocking against other backends changing the source database. We have a very half-baked defense against that (erroring out if anyone else

Re: [HACKERS] Use of 'cp -r' in CREATE DATABASE

2003-12-28 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: Longer term, a robust mechanism for DB level locks would probably be preferable, I guess, so I'm not sure if my idea is worth doing in the mean time. Presumably it hasn't caused much of a problem up to now, since most people are not likely to monkey