Re: [HACKERS] [ODBC] UTF-8 support

2001-09-23 Thread Hiroshi Inoue
Jean-Michel POURE wrote: > > 3) Is there a way to query available encodings in PostgreSQL for display in > pgAdmin. Could pgAdmin display multibyte chars in the first place ? regards, Hiroshi Inoue ---(end of broadcast)--- TIP 2: you can get off a

Re: [HACKERS] CLUSTER TODO item

2001-09-23 Thread Gavin Sherry
On Sun, 23 Sep 2001, Tom Lane wrote: > > Note: I'm not convinced that relfilenode and pg_class.oid are each > used in exactly the right spots. Once we have cases where they can > differ, we may well find some bugs to flush out. But that needs to > happen anyway, so don't let it dissuade you fro

Re: [HACKERS] [SQL] outer joins strangeness

2001-09-23 Thread Alex Pilosov
On Sun, 23 Sep 2001, Stephan Szabo wrote: > On Sun, 23 Sep 2001, Alex Pilosov wrote: > > > It may be just me, or I am grossly misunderstanding syntax of outer joins, > > but I see that plans for my queries are different depending on how I place > > join conditions and sometimes even on order of

[HACKERS] LOCAL_CREDS -> SCM_CREDS in src/backend/libpq/auth.c:535

2001-09-23 Thread bpalmer
For OpenBSD to work, we need a change from LOCAL_CREDS to SCM_CREDS. Bruce, I think you are familure with this one. Care to make the change? (I have no idea where to make it!). Thanks all, - Brandon c: 646-456-5455

Re: [HACKERS] an already existing alter table drop column ?!?!?!

2001-09-23 Thread Hiroshi Inoue
Stephan Szabo wrote: > > On Fri, 21 Sep 2001, Gowey, Geoffrey wrote: > > > While looking through the code I found an already existing alter table drop > > column in src/backend/parser/gram.y. However, when I try to run it in psql > > it comes back with a not implemented. Was the left hand not t

Re: [HACKERS] UTF-8 support

2001-09-23 Thread Serguei Mokhov
- Original Message - From: Tatsuo Ishii <[EMAIL PROTECTED]> Sent: Sunday, September 23, 2001 10:47 PM > > My question is now how many BE's/FE's would you return encodings for? > > I don't quite understand your question. What I thought were something > like this: > > SELECT pg_available

Re: [HACKERS] UTF-8 support

2001-09-23 Thread Tatsuo Ishii
> > pg_available_encodings([INTEGER how]) RETURNS setof TEXT > > > > where how is > > > > 0(or omitted): returns all available encodings > > 1: returns encodings in backend > > 2: returns encodings in frontend > > > > Comments? > > 3: returns encodings of both backend

Re: [HACKERS] Beta time

2001-09-23 Thread Marc G. Fournier
with all the changes going on, we're most likely looking at Oct 1st, earliest ... things are startin to stabilize, but until that 18gig is installed next week, we still have th eproblems with updating ftp, unless Peter can clear out th e400+Meg in his acount? :) On Sun, 23 Sep 2001, Bruce Momjia

Re: [HACKERS] CVS changes

2001-09-23 Thread Marc G. Fournier
try that ... all three are now installed ... On Mon, 24 Sep 2001, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > Someone want to refresh for me which software is required, as I'll get it > > installed ASAP ... > > These would get us started: > > devel/bison > textproc/docproj > text

Re: [HACKERS] UTF-8 support

2001-09-23 Thread Serguei Mokhov
- Original Message - From: Tatsuo Ishii <[EMAIL PROTECTED]> Sent: Sunday, September 23, 2001 7:58 PM > > 3) Is there a way to query available encodings in PostgreSQL for display in > > pgAdmin. > > Is it a planned feature in PostgreSQL 7.2? This would be nice if it existed. > > Example:

Re: [HACKERS] UTF-8 support

2001-09-23 Thread Tatsuo Ishii
> 1) UTF-8 > http://www.postgresql.org/idocs/index.php?app-psql.html explains > "Anything contained in single quotes is furthermore subject to C-like > substitutions for \n (new line), \t (tab), \digits, \0digits, and \0xdigits > (the character with the given decimal, octal, or hexadecimal code)

[HACKERS] Bug?: Update on ancestor for a row of a child

2001-09-23 Thread Kovacs Baldvin
Hello (mainly developer) folks! Probably Kevin really found a bug. When I saw his words in $50, I immediately started to look around his problem... You probably don't think that as a student here, in Hungary I live half a month for $50 :- So I simplified his given schema as much as I needed

Re: [HACKERS] CVS changes

2001-09-23 Thread Peter Eisentraut
Marc G. Fournier writes: > Someone want to refresh for me which software is required, as I'll get it > installed ASAP ... These would get us started: devel/bison textproc/docproj textproc/openjade I tried building OpenJade on that server the other day by hand and got Bus errors when I ran it.

Re: [HACKERS] CVS changes

2001-09-23 Thread Marc G. Fournier
Someone want to refresh for me which software is required, as I'll get it installed ASAP ... On Sun, 23 Sep 2001, Peter Eisentraut wrote: > Bruce Momjian writes: > > > I take that back. I just updated this last night with the proper path. > > Should be OK tomorrow. > > The docs currently aren'

Re: [HACKERS] CLUSTER TODO item

2001-09-23 Thread Tom Lane
>> I've been looking at CLUSTER today. I've put together a patch which >> recreates all the indices which current CLUSTER drops and copies relacl >> from the old pg_class tuple and puts it in the new one. This is entirely the wrong way to go at it. > We did strange things with this in the past

Re: [HACKERS] CVS changes

2001-09-23 Thread Peter Eisentraut
Bruce Momjian writes: > I take that back. I just updated this last night with the proper path. > Should be OK tomorrow. The docs currently aren't building on *.postgresql.org because the software is not installed. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter -

Re: [HACKERS] CVS changes

2001-09-23 Thread Serguei Mokhov
- Original Message - From: bpalmer <[EMAIL PROTECTED]> Sent: Sunday, September 23, 2001 1:36 PM > Since there have been drastic CVS changes, the web page doc should REALLY > be updated... > > http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html ... and CVSweb put back on-l

Re: [HACKERS] CVS changes

2001-09-23 Thread Bruce Momjian
I take that back. I just updated this last night with the proper path. Should be OK tomorrow. > > Since there have been drastic CVS changes, the web page doc should REALLY > > be updated... > > I updated the SGML but they are not building nightly, I think. > > -- > Bruce Momjian

Re: [HACKERS] CVS changes

2001-09-23 Thread Bruce Momjian
> Since there have been drastic CVS changes, the web page doc should REALLY > be updated... I updated the SGML but they are not building nightly, I think. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life

Re: [HACKERS] CVS changes

2001-09-23 Thread bpalmer
> Since there have been drastic CVS changes, the web page doc should REALLY > be updated... Withdrawn, I notive Bruce made the changes, but I guess they havn't hit yet. My bad. - Brandon c: 646-456-5455

[HACKERS] Beta time

2001-09-23 Thread Bruce Momjian
I know we had expected beta last Friday, but I think the needed CVS changes have delayed that. I know a few people are working on final additions. Perhaps this Friday would be a good beta target. Tom and I will be at the OSDN conference until Wednesday. -- Bruce Momjian

[HACKERS] CVS changes

2001-09-23 Thread bpalmer
Since there have been drastic CVS changes, the web page doc should REALLY be updated... http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html - Brandon c: 646-456-5455

[HACKERS] UTF-8 support

2001-09-23 Thread Jean-Michel POURE
Hello, I have set up a UNICODE database in PostgreSQL 7.1.2 and use psql for querying (\ENCODING > UNICODE). To perform tests, I downloaded code charts from http://www.unicode.org/charts/ 1) UTF-8 http://www.postgresql.org/idocs/index.php?app-psql.html explains "Anything contained in single quo

Re: [HACKERS] CLUSTER TODO item

2001-09-23 Thread Bruce Momjian
> Hi guys, > > I've been looking at CLUSTER today. I've put together a patch which > recreates all the indices which current CLUSTER drops and copies relacl > from the old pg_class tuple and puts it in the new one. > > I was working on updating pg_inherits to handle the new OID when it > occure

Re: [HACKERS] mutibyte aware functions

2001-09-23 Thread Bruce Momjian
> I have made lpad/rpad/btrim/ltrim/rtirm/translate functions multibyte > aware. I think we could mark following item as "done". > > * Make functions more multi-byte aware, e.g. trim() Done. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED]

[HACKERS] CLUSTER TODO item

2001-09-23 Thread Gavin Sherry
Hi guys, I've been looking at CLUSTER today. I've put together a patch which recreates all the indices which current CLUSTER drops and copies relacl from the old pg_class tuple and puts it in the new one. I was working on updating pg_inherits to handle the new OID when it occured to me that pg_

[HACKERS] mutibyte aware functions

2001-09-23 Thread Tatsuo Ishii
I have made lpad/rpad/btrim/ltrim/rtirm/translate functions multibyte aware. I think we could mark following item as "done". * Make functions more multi-byte aware, e.g. trim() Anything I forgot to make multibyte aware? -- Tatsuo Ishii ---(end of broadcast)--