Re: [HACKERS] Poster(s) needed

2002-05-17 Thread Marc G. Fournier
Not that I'm aware of anyone making ... On Fri, 17 May 2002, Michael Meskes wrote: > Hi, > > since we will show PostgreSQL related stuff on Linuxtag in Germany next > month, I'd like to get some PostgreSQL posters for the booth. But I have > no idea where to find some. > > Do we have that kind

[HACKERS] Redhat 7.3 time manipulation bug

2002-05-17 Thread Manuel Sugawara
Hi, Something is pretty broken in redhat 7.3 but I'm not sure what and I don't have time to dig further masm@test=# select cast('1967-04-18' as timestamptz); timestamptz 1967-04-17 18:00:00-06 (1 row) masm@test=# select cast(cast('1967-04-18' as date) as timesta

Re: [HACKERS] Error on PQputline()

2002-05-17 Thread Tom Lane
"Dann Corbit" <[EMAIL PROTECTED]> writes: >> I'm confused too. For starters, I cannot find that error message >> string about 'A non-blocking socket operation could not be completed >> immediately' anywhere. Got any idea what's producing that? Exactly >> which version of libpq are you using, an

Re: [HACKERS] Error on PQputline()

2002-05-17 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 17, 2002 4:38 PM > To: Dann Corbit > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] Error on PQputline() > > > "Dann Corbit" <[EMAIL PROTECTED]> writes: > >> You're running libpq with the nonblocking mo

Re: [HACKERS] Error on PQputline()

2002-05-17 Thread Tom Lane
"Dann Corbit" <[EMAIL PROTECTED]> writes: >> You're running libpq with the nonblocking mode selected? > Actually no. It should be the default mode for a connection made by > PQconnectdb(). That's what made the error so puzzling. I'm confused too. For starters, I cannot find that error message

Re: [HACKERS] Updated CREATE FUNCTION syntax

2002-05-17 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Joel Burton writes: >> Is there any standardized way of handling the single-quotes within function >> definition? Rather than doubling them up (which can make for very messy code >> when your scripting language uses single quotes!), allowing another s

Re: [HACKERS] Error on PQputline()

2002-05-17 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 17, 2002 4:10 PM > To: Dann Corbit > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] Error on PQputline() > > > "Dann Corbit" <[EMAIL PROTECTED]> writes: > > The contents of the error message are: > > co

Re: [HACKERS] Error on PQputline()

2002-05-17 Thread Tom Lane
"Dann Corbit" <[EMAIL PROTECTED]> writes: > The contents of the error message are: > conn->errorMessage.data 0x00312440 "pqFlush() -- couldn't send data: > errno=0 > No error A non-blocking socket operation could not be completed > immediately. You're running libpq with the nonblocking mod

Re: [HACKERS] More schema queries

2002-05-17 Thread Tom Lane
"Dave Page" <[EMAIL PROTECTED]> writes: > It doesn't work quite like that anyway. Oh, so essentially you want to simulate the namespace search on the application side. I see. > Anyway, current_schemas() seems ideal, thanks. It may not be exactly what you need, because it doesn't tell you about

[HACKERS] Error on PQputline()

2002-05-17 Thread Dann Corbit
The contents of the error message are: conn->errorMessage.data 0x00312440 "pqFlush() -- couldn't send data: errno=0 No error A non-blocking socket operation could not be completed immediately. for this: if (PQputline(conn, pszBCPdata[i++]) == EOF) printf("Er

Re: [HACKERS] More schema queries

2002-05-17 Thread Dave Page
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: 17 May 2002 23:24 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] More schema queries > > > "Dave Page" <[EMAIL PROTECTED]> writes: > > helpdesk=# select relnamespace, relname from pg_class wher

Re: [HACKERS] More schema queries

2002-05-17 Thread Tom Lane
"Dave Page" <[EMAIL PROTECTED]> writes: > helpdesk=# select relnamespace, relname from pg_class where relname like > 'pg_%'; > relnamespace | relname > --+- > ... > 2200 | pg_user > 2200 | pg_rules > 2200 | pg_vie

Re: [HACKERS] +AFs-HACKERS+AF0- More schema queries

2002-05-17 Thread Dave Page
+AD4- -Original Message- +AD4- From: Tom Lane +AFs-mailto:tgl+AEA-sss.pgh.pa.us+AF0- +AD4- Sent: 17 May 2002 21:26 +AD4- To: Dave Page +AD4- Cc: pgsql-hackers+AEA-postgresql.org +AD4- Subject: Re: +AFs-HACKERS+AF0- More schema queries +AD4- +AD4- +AD4- +ACI-Dave Page+ACI- +ADw-dpage+

Re: [HACKERS] More schema queries

2002-05-17 Thread Tom Lane
"Dave Page" <[EMAIL PROTECTED]> writes: > 1) All the system views are currently part of the public namespace. Not > a problem for me, but shouldn't they be in pg_catalog? Say what? They *are* in pg_catalog. initdb creates nothing in public. > 2) pgAdmin needs to be able to find out the namespa

Re: [HACKERS] WIN32 native ... lets start?!?

2002-05-17 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > Might be an idea to create a pgsql-hackers-win32 list also? Or just > pgsql-win32? Actually, I think that'd be a bad idea. The very last thing we need is for these discussions to get fragmented. The issues affect the whole backend AFAICS.

[HACKERS] SSL client cert patch submitted

2002-05-17 Thread Bear Giles
I just submitted a patch to support SSL client certificates. With this patch the Port structure is extended to include a new field, 'peer', that contains the client certificate if offered. This patch also cleans up the SSL code. Most of this should be invisible to users, with the exception of a

Re: [HACKERS] Updated CREATE FUNCTION syntax

2002-05-17 Thread Manfred Koizar
On Fri, 17 May 2002 09:57:39 -0400, "Joel Burton" <[EMAIL PROTECTED]> wrote: >> -Original Message- >> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]] >> Sent: Friday, May 17, 2002 9:37 AM >> To: Joel Burton >> Cc: PostgreSQL Development >> Subject: RE: [HACKERS] Updated CREATE FUNCTION s

Re: [HACKERS] www.pgaccess.org - the official story (the way I saw it)

2002-05-17 Thread Mike Embry
What about http://sourceforge.net/projects/pgaccess/? It looks inactive but somebody did set it up on 2002-04-25. I think I found it from Teo's website. MikE > > To sum it up - > > -> pgaccess has not been officially updated since January 2001 > >= there is no real interest in it or t

[HACKERS] Trouble with pg_encoding_to_char

2002-05-17 Thread youenn . ballouard2
Hi, I've been developing a program with the postgres jdbc 2 driver, jdk-1.3.0 and postgres 6.5. When I start my program up it bombs like so: Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: ERROR: No such function 'pg_en

Re: [HACKERS] [BUGS] Bug #659: lower()/upper() bug on

2002-05-17 Thread Enke, Michael
Tatsuo Ishii wrote: > > > > Are you sure that say, de_DE.utf8 locale produce meaningful results > > > for any other languages? > > > > there are often subtle differences, but upper() and lower() are much > > more likely to produce right results than collation order or date/money > > formats. > >

Re: [HACKERS] Queries using rules show no rows modified?

2002-05-17 Thread Manfred Koizar
On Fri, 10 May 2002 10:51:05 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: >Thoughts, different proposals, alternative ways of breaking down >the problem? Well, you asked for it, so here is my wishlist :-) From a user POV I expect a command to return the number of "rows" it has processed successfull

Re: [HACKERS] [INTERFACES] libpgtcl - backend version information patch

2002-05-17 Thread Peter Eisentraut
Nigel J. Andrews writes: > I've attached a patch for libpgtcl which adds access to backend version > numbers. > > This is via a new command: > > pg_version ?? ?? This doesn't truly reflect the way PostgreSQL version numbers are handled. Say for 7.2.1, the "major" is really "7.2" and the minor

Re: [HACKERS] Updated CREATE FUNCTION syntax

2002-05-17 Thread Peter Eisentraut
Joel Burton writes: > Is there any standardized way of handling the single-quotes within function > definition? Rather than doubling them up (which can make for very messy code > when your scripting language uses single quotes!), allowing another symbol > to be used, with that symbol be declared

Re: [HACKERS] Updated CREATE FUNCTION syntax

2002-05-17 Thread Joel Burton
> -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 17, 2002 9:37 AM > To: Joel Burton > Cc: PostgreSQL Development > Subject: RE: [HACKERS] Updated CREATE FUNCTION syntax > > > Joel Burton writes: > > > Is there any standardized way of handling the

[HACKERS] Poster(s) needed

2002-05-17 Thread Michael Meskes
Hi, since we will show PostgreSQL related stuff on Linuxtag in Germany next month, I'd like to get some PostgreSQL posters for the booth. But I have no idea where to find some. Do we have that kind of stuff? Or where could I get it? Preferable of course as file so I can print it myself. Thank

[HACKERS] Future plans

2002-05-17 Thread Michael Meskes
Hi, what do we have planned for the next release? In the TODO file there are quite a lot of points but I don't like to talk about things we will eventually do, but would like to present what we will implement for 7.3 resp. 8.0. IMO the most important stuff seems to be: - replication (which is

Re: [HACKERS] Queries using rules show no rows modified?

2002-05-17 Thread Tom Lane
"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> Michael seems to feel that the tuple count should be nonzero if any >> of the replacement operations did anything at all. > Here we usually add triggers, for replication, accounting, setting of > ca

Re: [HACKERS] WIN32 native ... lets start?!?

2002-05-17 Thread Marc G. Fournier
On Fri, 17 May 2002, Christopher Kings-Lynne wrote: > Maybe Vince could set up a Win32 porting project page, and since we now seem > to have a few interested parties willing to code on a native Win32 version, > they should have their own project page. This could make communication > easier for t

Re: [HACKERS] interfaces/ecpg/preproc reduce/reduce conflicts

2002-05-17 Thread Alvaro Herrera
On Thu, 16 May 2002, Tom Lane wrote: > Joe Conway <[EMAIL PROTECTED]> writes: > > Just noticed this a few minutes ago on build from cvs tip: > > make -C preproc all > > make[4]: Entering directory `/opt/src/pgsql/src/interfaces/ecpg/preproc' > > bison -y -d preproc.y > > conflicts: 2 reduce/red

[HACKERS] More schema queries

2002-05-17 Thread Dave Page
Hi, I have some schema queries/thoughts that I would appreciate some help/insights/fixes with/for please! (Apologies if these have been asked before or have been addressed in a recent snapshot - my ISP's been having routing problems recently & I can't reach postgresql.org via http right now). 1