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 might be similar omissions in the
PAM or Kerberos4
Tom Lane wrote:
ascii() is defined as ascii(text). As of 7.4, bpchar-text conversion
strips trailing blanks, so what ascii() sees is a zero-length string.
That makes sense -- I was wondering where the blanks got stripped.
Given that trailing blanks are insignificant in bpchar, I'm not sure I'd
On Sun, 17 Aug 2003, Tom Lane wrote:
Stephan Szabo [EMAIL PROTECTED] writes:
Basically, the first thing I noticed was that changing reltuples
on the pg_class row for a table affected the speed of
explain analyze select * from othertable where foo not in (select bar from
table);
even
Joe Conway [EMAIL PROTECTED] writes:
I stumbled across this behavior today and it seems strange if not a bug:
ascii() is defined as ascii(text). As of 7.4, bpchar-text conversion
strips trailing blanks, so what ascii() sees is a zero-length string.
Given that trailing blanks are insignificant
On Sat, 16 Aug 2003, Joe Conway wrote:
I stumbled across this behavior today and it seems strange if not a bug:
-- this seems wrong
vsconf=# create table foo (f1 char(1));
CREATE TABLE
vsconf=# insert into foo values(' ');
INSERT 9002011 1
vsconf=# select ascii(f1) from foo;
ascii
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
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 might be similar omissions in
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.
To do
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:
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 truncate all
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
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 generates
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 ?
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 see details?
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 create cast
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.
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 :
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 other
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 on ctid
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.asc
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
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 seems the
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 expose
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
24 matches
Mail list logo