Re: [HACKERS] PL/pgSQL doc sample bug? (in 7.1.3)

2001-10-08 Thread Tom Lane
KobayashiJunichi <[EMAIL PROTECTED]> writes: > I could not execute sample code of plsql.sgml. PostgreSQL version is 7.1.3. > Then I made patches for reference. Thanks for the corrections! regards, tom lane ---(end of broadcast)---

Re: [HACKERS] [patch] ALTER RENAME and indexes

2001-10-08 Thread Tom Lane
Brent Verner <[EMAIL PROTECTED]> writes: > Thanks for fixing that problem. Out of curiousity, did you put that > code in the renameatt() function for any reason, or is it just a > style thing? Just to avoid closing and reopening the target relation and pg_attribute relation. Releasing and then

[HACKERS] PL/pgSQL doc sample bug? (in 7.1.3)

2001-10-08 Thread KobayashiJunichi
Hello, I could not execute sample code of plsql.sgml. PostgreSQL version is 7.1.3. Then I made patches for reference. 1) cs_refresh_one_mv function sample code bug. *** 512,526 2) Singule quotation missing. *** 1152,1158 3) cs_refresh_mviews function sample code bug. *** 1305,1313

Re: [HACKERS] [patch] ALTER RENAME and indexes

2001-10-08 Thread Brent Verner
On 08 Oct 2001 at 14:43 (-0400), Tom Lane wrote: | Brent Verner <[EMAIL PROTECTED]> writes: | > wooohoo!!! Of course, it would be best if someone else looked this | > code over, because I get the feeling there is an easier way to get | > this done. | | No, that's about right, except that you for

Re: [HACKERS] Place of PO files for NLS (was Re: [PATCHES] PG_DUMP NLS (Russian))

2001-10-08 Thread Serguei Mokhov
- Original Message - From: Peter Eisentraut <[EMAIL PROTECTED]> Sent: Monday, October 08, 2001 7:25 PM > > > I just thought I would point out that could get > > > messy and many projects realizing this have created a po directory off the > > > source tree to store the translations in. I

Re: [HACKERS] Place of PO files for NLS (was Re: [PATCHES] PG_DUMP NLS (Russian))

2001-10-08 Thread Peter Eisentraut
Serguei Mokhov writes: > > I just thought I would point out that could get > > messy and many projects realizing this have created a po directory off the > > source tree to store the translations in. It might be worthwhile to > > create such a directory and implement this now then when more and

[HACKERS] Mule internal code ?

2001-10-08 Thread Patrice Hédé
Hi, As said in another mail, I have tried to add iso-8859-15 (Latin 9) & iso-8859-16 (Latin 10) to PostgreSQL, I think I have done mostly all that's necessary. But I miss two things : - latin92mic/mic2latin9/latin102mic/mic2latin10 in conv.c - the leading character value in pg_wchar.h I don't k

[HACKERS] Beta Wednesday

2001-10-08 Thread Bruce Momjian
Are we ready for beta on Wednesday? I don't know anything holding us up at this point. Seems like major work has stopped and everyone is ready to start testing. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your

Re: [HACKERS] [patch] ALTER RENAME and indexes

2001-10-08 Thread Tom Lane
Brent Verner <[EMAIL PROTECTED]> writes: > wooohoo!!! Of course, it would be best if someone else looked this > code over, because I get the feeling there is an easier way to get > this done. No, that's about right, except that you forgot one step: you shouldn't try to update column names of fun

Re: Daily snapshots hosed (was Re: [pgadmin-hackers] [HACKERS] Wh

2001-10-08 Thread Dave Page
> -Original Message- > From: Dave Page > Sent: 08 October 2001 16:52 > To: 'Tom Lane'; Dave Page > Cc: [EMAIL PROTECTED]; The Hermit Hacker > Subject: RE: Daily snapshots hosed (was Re: [pgadmin-hackers] > [HACKERS] What about CREATE OR REPLACE FUNCTION?) > > > -Original Message---

Re: [HACKERS] Accessing Database files on a "read-only" medium...like a CD.

2001-10-08 Thread Tom Lane
"Serguei Mokhov" <[EMAIL PROTECTED]> writes: > Kelly Harmon <[EMAIL PROTECTED]> wrote in message >9pr7f7$k0j$[EMAIL PROTECTED]">news:9pr7f7$k0j$[EMAIL PROTECTED]... >> At that point, it seems that your screwed...in that even if you shut down >> postgres and restart it, somewhere it knows that tha

Re: Daily snapshots hosed (was Re: [pgadmin-hackers] [HACKERS] Wh

2001-10-08 Thread Dave Page
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: 08 October 2001 16:43 > To: Dave Page > Cc: [EMAIL PROTECTED]; The Hermit Hacker > Subject: Daily snapshots hosed (was Re: [pgadmin-hackers] > [HACKERS] What about CREATE OR REPLACE FUNCTION?) > > > Dave Page <[

Daily snapshots hosed (was Re: [pgadmin-hackers] [HACKERS] What about CREATE OR REPLACE FUNCTION?)

2001-10-08 Thread Tom Lane
Dave Page <[EMAIL PROTECTED]> writes: > ... I can't find an up-to-date snapshot > I tried postgresql.rmplc.co.uk and got one (apparently) dated 7 Oct, however > CREATE OR REPLACE FUNCTION didn't seem to be there (it certainly doesn't > work anyway - syntax error at OR). I then looked in the prima

Re: [pgadmin-hackers] [HACKERS] What about CREATE OR REPLACE FUNC TION?

2001-10-08 Thread Tom Lane
Dave Page <[EMAIL PROTECTED]> writes: > ... I can't find an up-to-date snapshot Where have you looked? I checked a couple of FTP mirrors at random and see up-to-date snapshots, eg at ftp://ftp.us.postgresql.org/dev/ ftp://postgresql.wavefire.com/pub/dev/ ftp://postgresql.rmplc.co.uk/pub/postgres

Temprary issue gripes(was:Re: [HACKERS] cvs problem)

2001-10-08 Thread Lamar Owen
On Friday 05 October 2001 07:48 pm, John Summerfield wrote: > On Fri, 5 Oct 2001, Lamar Owen wrote: > I made it clear I was getting frustrated. Read in that context, I think it > was pretty mild;-) But it was done in an uninformed way. Had you read the previous two-three weeks of the archives,

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

2001-10-08 Thread Jean-Michel POURE
Dear all, 1) CREATE OR REPLACE FUNCTION In pgAdmin II, we plan to use the CREATE OR REPLACE FUNCTION if the patch is applied. Do you know if there is any chance it be applied for beta time? We would very much appreciate this feature... 2) PL/pgSQL default support It is sometimes tricky for Win

Re: [HACKERS] Bulkloading using COPY - ignore duplicates?

2001-10-08 Thread Horak Daniel
> I've made some inroads towards adding 'ignore duplicates' > functionality to PostgreSQL's COPY command. I've updated the parser > grammar for COPY FROM to now accept: > > COPY [ BINARY ] table [ WITH OIDS ] > FROM { 'filename' | stdin } > [ [USING] DELIMITERS 'delimiter' ] > [ WITH

[HACKERS] Bulkloading using COPY - ignore duplicates?

2001-10-08 Thread Lee Kindness
Guys, I've made some inroads towards adding 'ignore duplicates' functionality to PostgreSQL's COPY command. I've updated the parser grammar for COPY FROM to now accept: COPY [ BINARY ] table [ WITH OIDS ] FROM { 'filename' | stdin } [ [USING] DELIMITERS 'delimiter' ] [ WITH [NULL AS