[HACKERS] failure in latest cvs

2003-08-17 Thread Christopher Kings-Lynne
FreeBSD/Alpha, latest CVS: cd . && ./config.status --recheck running /usr/local/bin/bash ./configure --prefix=/home/chriskl/local --enable-integer-datetimes --enabl e-thread-safety --with-perl --with-pam --with-openssl --no-create --no-recu rsion ... gmake[3]: Leaving directory `/home/chriskl/

Re: [HACKERS] bidirectional cursors on views

2003-08-17 Thread Tom Lane
Shachar Shemesh <[EMAIL PROTECTED]> writes: > Am I to understand that psql's nativ cursors support bidirectional > movements on views? That is good news, actually. They do. (Complex views, like joins, may not work real well before 7.4.) I suspect your real difficulty is that a view will not exp

Re: [HACKERS] 7.4 beta 1 getting out of swap

2003-08-17 Thread Tom Lane
> Joe Conway <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: > 3. Set up a long-lived cache internal to the array functions that can > translate element type OID to the needed lookup data, and won't leak > memory across repeated calls. This is not the fastest or most general > solution, but it seem

Re: [HACKERS] bidirectional cursors on views

2003-08-17 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh <[EMAIL PROTECTED]> writes: When I try to open (using MFC) a non-forward only cursor on a view (i.e. - select * from viewname), I get an error of "attribute ctid not found". There are some chances that this is an ODBC problem, but my research suggests that the

Re: [HACKERS] DOMAIN NEED CAST ?

2003-08-17 Thread Rod Taylor
On Sun, 2003-08-17 at 14:30, ivan wrote: > but in real alias_to_int is equal to int, only with other name; > its should be like typedef from c/c++ ? Not necessarily. CREATE DOMAIN alias_to_int AS INT CHECK(VALUE BETWEEN 1 AND 4); The above is very different than plain old integer. signature.as

Re: [HACKERS] bidirectional cursors on views

2003-08-17 Thread Tom Lane
Shachar Shemesh <[EMAIL PROTECTED]> writes: > When I try to open (using MFC) a non-forward only cursor on a view (i.e. > - select * from viewname), I get an error of "attribute ctid not found". > There are some chances that this is an ODBC problem, but my research > suggests that the dependancy

Re: [HACKERS] compile error on cvs tip

2003-08-17 Thread Sean Chittenden
> > I don't remember any agreement to remove krb4 in 7.5. Am I wrong? > > My recollection is we had at least one person still using it, who > was apparently unworried by the security issues. Peter Eisentraut <[EMAIL PROTECTED]>: As long as people are still using it, I see no reason. Just the ot

Re: [HACKERS] DOMAIN NEED CAST ?

2003-08-17 Thread ivan
but in real alias_to_int is equal to int, only with other name; its should be like typedef from c/c++ ? On Sun, 17 Aug 2003, Rod Taylor wrote: > On Sun, 2003-08-17 at 12:34, ivan wrote: > > Why when i create domain like : > > > > CREATE DOMAIN alias_to_int AS INT; > > > > and then function like

[HACKERS] bidirectional cursors on views

2003-08-17 Thread Shachar Shemesh
Hi all, When I try to open (using MFC) a non-forward only cursor on a view (i.e. - select * from viewname), I get an error of "attribute ctid not found". There are some chances that this is an ODBC problem, but my research suggests that the dependancy on ctid is created by the database itself.

Re: [HACKERS] DOMAIN NEED CAST ?

2003-08-17 Thread Rod Taylor
On Sun, 2003-08-17 at 12:34, ivan wrote: > Why when i create domain like : > > CREATE DOMAIN alias_to_int AS INT; > > and then function like : > > CREATE FUNCTION func() RETURNS alist_to_int AS ' select 2::int; ' LANGUAGE > SQL; > > and pg can not convert int to aliast_to_int, so i need to crea

Re: [HACKERS] Question with hashed IN

2003-08-17 Thread Stephan Szabo
On Sun, 17 Aug 2003, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > On Sun, 17 Aug 2003, Tom Lane wrote: > >> That doesn't make any sense to me --- AFAICS, only the planner pays any > >> attention to reltuples, so it could only affect things via changing the > >> plan. Could we s

[HACKERS] DOMAIN NEED CAST ?

2003-08-17 Thread ivan
Why when i create domain like : CREATE DOMAIN alias_to_int AS INT; and then function like : CREATE FUNCTION func() RETURNS alist_to_int AS ' select 2::int; ' LANGUAGE SQL; and pg can not convert int to aliast_to_int, so i need to create cast for all this same types ?

Re: [HACKERS] Question with hashed IN

2003-08-17 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Sun, 17 Aug 2003, Tom Lane wrote: >> That doesn't make any sense to me --- AFAICS, only the planner pays any >> attention to reltuples, so it could only affect things via changing the >> plan. Could we see details? > I've included a perl file that ge

Re: [HACKERS] compile error on cvs tip

2003-08-17 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I don't remember any agreement to remove krb4 in 7.5. Am I wrong? My recollection is we had at least one person still using it, who was apparently unworried by the security issues. While I think deprecating krb4 is a good idea, I don't see any need to

Re: [HACKERS] compile error on cvs tip

2003-08-17 Thread Andrew Dunstan
Bruce Momjian wrote: I don't remember any agreement to remove krb4 in 7.5. Am I wrong? It needs to go. I thought the question was when, not if. In that case there seem to be 2 choices - deprecate in 7.4 and remove in 7.5, or deprecate in 7.5 and remove in following release. I favor the fo

Re: [HACKERS] "truncate all"?

2003-08-17 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > On Sun, 2003-08-17 at 00:42, Tom Lane wrote: >> To do anything else, you'd have to solve some locking and/or >> race-condition problems: rows could be inserted in the other table >> while the TRUNCATE runs. > Seems like you'll have that issue with truncat

Re: [HACKERS] UnixWare on Current CVS: Success!

2003-08-17 Thread ohp
Did something changed on today's cvs. src/template/unixware is wrong on last line: THREAD_CFLAGS += -D_REENTRANT should be THREAD_CFLAGS="$THREAD_CFLAGS -D_REENTRANT" Then, configure can't find strerror_r ... That worked like a charm 2 days ago... On Fri, 15 Aug 2003 [EMAIL PROTECTED] wrote: >

Re: [HACKERS] "truncate all"?

2003-08-17 Thread Robert Treat
On Sun, 2003-08-17 at 00:42, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > On Sun, 17 Aug 2003, Bruce Momjian wrote: > >> Is this a bug? > > > I don't think so. I'd say this is the expected behavior. Part of the > > point is that it fails without checking for matching rows. > >

Re: [HACKERS] compile error on cvs tip

2003-08-17 Thread Bruce Momjian
Sean Chittenden wrote: > > > > > auth.c: In function `pg_krb5_recvauth': > > > > > auth.c:294: structure has no member named `user' > > > > > > > > Ooops, my fault --- I didn't build with Kerberos support after > > > > changing those field names. > > > > > > > > Now that I think about it, there m

Re: [HACKERS] Stuff that doesn't work yet in IPv6 patch

2003-08-17 Thread Andreas Pflug
Bruce Momjian wrote: 2. SSL. Postmaster allows SSL for AF_INET but not AF_INET6. This is fixed and works now. Regards, Andreas ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail co