Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Joachim Wieland
On Fri, Dec 15, 2006 at 11:37:56AM -0500, Tom Lane wrote: Joachim Wieland [EMAIL PROTECTED] writes: Appended is a patch that adds JST and JDT into Asia.txt and the Default set. Um ... is there a JDT? Last I heard, Japan does not observe daylight time. I don't see a JDT in the old PG set of

Re: [HACKERS] unixware and --with-ldap

2006-12-16 Thread ohp
On Fri, 15 Dec 2006, Tom Lane wrote: Date: Fri, 15 Dec 2006 10:20:44 -0500 From: Tom Lane [EMAIL PROTECTED] To: Albe Laurenz [EMAIL PROTECTED] Cc: ohp@pyrenet.fr, pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] unixware and --with-ldap Albe Laurenz [EMAIL PROTECTED]

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Tom Lane
Joachim Wieland [EMAIL PROTECTED] writes: True... Actually I wonder how I have to read the zic files in this case. It says: Rule Japan 1948only- May Sun=1 2:001:00D Rule Japan 19481951- Sep Sat=8 2:000 S Rule Japan 1949only

Re: [PATCHES] [HACKERS] psql commandline conninfo

2006-12-16 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: BTW, what is the approved way to handle warnings about const? Copy the object? Well, in the revised code there shouldn't be any warning at all, but I think the mistake in your original was to declare the local variable as char * instead of const char *.

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Tom Lane
[EMAIL PROTECTED] writes: Operator class group, unwieldy as it is, conveys the meaning that we are talking about _sets of operator classes_. The nicer terms I have seen all lose a bit of that ring to me. The thing is that in the proposal as it currently stands, we're *not* talking about sets

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Alvaro Herrera
Tom Lane wrote: Gregory Stark [EMAIL PROTECTED] writes: Perhaps something like Operator Class and Data Type Class Data type classes happens to involve operator classes but it sounds like you're looking for them to specify other behaviours of how data types inter-relate than just

[HACKERS] pg_am.amstrategies should be 0 when not meaningful?

2006-12-16 Thread Tom Lane
GIST and GIN currently set their amstrategies entries to 100, which is a completely arbitrary number, since these index AMs don't impose any particular interpretation on operator strategy numbers. Usually it's far too large and results in wasted space in relcache entries. But it's not impossible

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Joachim Wieland
On Sat, Dec 16, 2006 at 10:26:52AM -0500, Tom Lane wrote: Joachim Wieland [EMAIL PROTECTED] writes: True... Actually I wonder how I have to read the zic files in this case. It says: RuleJapan 1948only- May Sun=1 2:001:00 D RuleJapan 1948

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Andrew Dunstan
Alvaro Herrera wrote: The superclass term passes that test, but fails because it is somehow expected that you can't put a class inside a superclass. How about hyperclass then? :-) Maybe school :-D Maybe somebody should ask a philologist about a greek or latin prefix with that meaning.

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: How about hyperclass then? :-) Maybe school :-D So I finally went and looked at a thesaurus, and came up with some possibilities: category variety family crowd cluster flock pack troop gang clique circle cabal association society union ensemble

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Dec 16, 2006 at 11:14:02AM -0500, Tom Lane wrote: [EMAIL PROTECTED] writes: Operator class group, unwieldy as it is, conveys the meaning that we are talking about _sets of operator classes_. The nicer terms I have seen all lose a bit of

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Martijn van Oosterhout
On Sat, Dec 16, 2006 at 11:48:48AM -0500, Tom Lane wrote: So I finally went and looked at a thesaurus, and came up with some possibilities: category variety family crowd cluster flock pack troop gang clique circle cabal association society union ensemble Operator family seems like it

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Joshua D. Drake
On Sat, 2006-12-16 at 11:48 -0500, Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: How about hyperclass then? :-) Maybe school :-D So I finally went and looked at a thesaurus, and came up with some possibilities: category variety family crowd cluster flock pack troop gang

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Brian Hurt
Joachim Wieland wrote: Yes, I completely agree that JDT should not be included. I just wanted to understand how those lines show that JST is still in active use. As far as I understand it, it says that JST was observed from 1948 to 1951 (the second rule) and now there is a time zone J%sT

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Joachim Wieland
On Sat, Dec 16, 2006 at 12:52:12PM -0500, Brian Hurt wrote: Joachim Wieland wrote: Yes, I completely agree that JDT should not be included. I just wanted to understand how those lines show that JST is still in active use. As far as I understand it, it says that JST was observed from 1948 to

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Alvaro Herrera
Martijn van Oosterhout wrote: On Sat, Dec 16, 2006 at 11:48:48AM -0500, Tom Lane wrote: So I finally went and looked at a thesaurus, and came up with some possibilities: category variety family crowd cluster flock pack troop gang clique circle cabal association society union ensemble

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Martijn van Oosterhout wrote: On Sat, Dec 16, 2006 at 11:48:48AM -0500, Tom Lane wrote: Operator family seems like it might be a good choice. I like this one more than opcluster. opfamily has a good ring to it also. +1 on opfamily. Done, unless

Re: [HACKERS] Operator class group proposal

2006-12-16 Thread Tom Lane
Operator family seems like it might be a good choice. I like this one more than opcluster. opfamily has a good ring to it also. +1 on opfamily. Done, unless anyone really doesn't like it. So I started revising my notes on what to change the catalog structure to, and immediately came up with

[HACKERS] info from prepared plan?

2006-12-16 Thread Pavel Stehule
Hello, is possible take names and types of returned columns of prepared plan? I need it, for implementation ANSI SQL FOR statement. Descr: FOR SELECT a,b,c FROM Foo DO PRINT a,b,c; -- inside stmt body a,b,c are local variables END LOOP; I have to get this list in compile time. Any ideas?

[HACKERS] Question.

2006-12-16 Thread HarmeekSingh Bedi
Hi All. I just looked this email from postgress sql site and wanted to ask you a question. I would be obliged if you could help me understand the duplicate key insertion behaviour correctly in Post gress SQL. The question is related to Btree [Leman and Yao] implementation When

Re: [HACKERS] libpq.a in a universal binary

2006-12-16 Thread Ted Petrosky
take a look at this link http://www.entropy.ch/blog/Software/2006/02/04/PostgreSQL-Universal- Binary-Build-Tips.html does this help? Ted On Dec 14, 2006, at 2:37 PM, Shane Ambler wrote: Dave Page wrote: Shane Ambler wrote: # make distclean # CFLAGS=-isysroot

[HACKERS] gendict and tsearch2

2006-12-16 Thread Andrea C. Granata
Hi All, I'm trying to generate italian dictionary templates for tsearch2 without success. These are the steps I do: 1) cd PGSQL_SRC/contrib/tsearch2/gendict wget http://snowball.tartarus.org/algorithms/italian/stem.c wget http://snowball.tartarus.org/algorithms/italian/stem.h ./config.sh -n

[HACKERS] development environment of postgres

2006-12-16 Thread dakotali kasap
Hi, I want to ask, which development environment should I use to add new features to postgresql. Is Eclipse CDT (C/C++ Development Tool) suitable for this, or are you using another environment, or just using pico, vi, etc.? Regards, __ Do

Re: [HACKERS] development environment of postgres

2006-12-16 Thread Joshua D. Drake
On Sat, 2006-12-16 at 16:47 -0800, dakotali kasap wrote: Hi, I want to ask, which development environment should I use to add new features to postgresql. Is Eclipse CDT (C/C++ Development Tool) suitable for this, or are you using another environment, or just using pico, vi, etc.? Use the

Re: [PATCHES] [HACKERS] psql commandline conninfo

2006-12-16 Thread Bruce Momjian
I assume this patch will still allow a database name with an equals sign, right? psql dbname='a=b' The libpq documentation isn't clear that single-quotes also escape equals, but I assume that is true looking at the code:

Re: [HACKERS] gendict and tsearch2

2006-12-16 Thread Oleg Bartunov
You need patch from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ to get updated snowball API. Oleg On Fri, 15 Dec 2006, Andrea C. Granata wrote: Hi All, I'm trying to generate italian dictionary templates for tsearch2 without success. These are the steps I do: 1) cd

Re: [HACKERS] development environment of postgres

2006-12-16 Thread Jonah H. Harris
On 12/16/06, dakotali kasap [EMAIL PROTECTED] wrote: I want to ask, which development environment should I use to add new features to postgresql. Is Eclipse CDT (C/C++ Development Tool) suitable for this, or are you using another environment, or just using pico, vi, etc.? My development

Re: [PATCHES] [HACKERS] psql commandline conninfo

2006-12-16 Thread Andrew Dunstan
Bruce Momjian wrote: I assume this patch will still allow a database name with an equals sign, right? psql dbname='a=b' Yes. In fact, reading the code it looks like the quotes are not necessary in this case. cheers andrew ---(end of