Re: [HACKERS] Another nasty pg_dump bug in 7.3 (and 7.4?)
Christopher Kings-Lynne [EMAIL PROTECTED] writes: We need to dump constraint name always for CHECK, or suppress default names in ADD FOREIGN KEY. Didn't Rod Taylor fix that recently? You're quite correct - it has been fixed. Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Problem retrieve Chinese characters in browser
Hi everybody, I created a db with encoding 'SQL-ASCII'. And I wrote a JSP application to manipulate corporate information which including both Traditional/Simplified Chinese characters. However, I can read both Traditional/Simplified Chinese information from my MS Access (OS: TChinese Win2K+MS Office XPwith switch default language setting for workaround) but I can't read Simplified Chinese completely from the browser! (Some characters become '??' even I set the codepage for the JSP page). Can anybody help? Thanks a lot! Colin
Re: [HACKERS] dns problem?
looks like it's not in yesterday's zone: $ grep fr postgresql.org 10800 ; refresh (3 hours) news.us CNAME news.pyrenet.fr. $ more postgresql.org $ head -20 postgresql.org $ORIGIN . $TTL 300; 5 minutes postgresql.org IN SOA ns.hub.org. root.hub.org. ( 2003070705 ; serial 10800 ; refresh (3 hours) 3600 ; retry (1 hour) 604800 ; expire (1 week) 300; minimum (5 minutes) ) NS ns.hub.org. NS ns2.hub.org. NS ns3.hub.org. NS ns-a.lerctr.org. NS ns-b.lerctr.org. A 64.117.224.193 MX 0 svr1.postgresql.org. MX 10 svr2.postgresql.org. MX 20 svr3.postgresql.org. MX 30 svr4.postgresql.org. $ORIGIN postgresql.org. $ --On Tuesday, July 08, 2003 15:35:39 +0200 [EMAIL PROTECTED] wrote: Hi all, Is there a dns problem at hub.org? my mirror www.fr.postgresql.org (and I guess ftp.fr.postgresql.org) does not resolve any more... Regards -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] dns problem?
Then mirrors here don't work anymore, and I have to restart apache here, meanning that web mirror wont come back until I notice domain is here et restart again. Marc, can you dol something? On Tue, 8 Jul 2003, Larry Rosenman wrote: Date: Tue, 08 Jul 2003 08:57:27 -0500 From: Larry Rosenman [EMAIL PROTECTED] To: [EMAIL PROTECTED], pgsql-hackers list [EMAIL PROTECTED] Cc: The Hermit Hacker [EMAIL PROTECTED] Subject: Re: [HACKERS] dns problem? looks like it's not in yesterday's zone: $ grep fr postgresql.org 10800 ; refresh (3 hours) news.us CNAME news.pyrenet.fr. $ more postgresql.org $ head -20 postgresql.org $ORIGIN . $TTL 300; 5 minutes postgresql.org IN SOA ns.hub.org. root.hub.org. ( 2003070705 ; serial 10800 ; refresh (3 hours) 3600 ; retry (1 hour) 604800 ; expire (1 week) 300; minimum (5 minutes) ) NS ns.hub.org. NS ns2.hub.org. NS ns3.hub.org. NS ns-a.lerctr.org. NS ns-b.lerctr.org. A 64.117.224.193 MX 0 svr1.postgresql.org. MX 10 svr2.postgresql.org. MX 20 svr3.postgresql.org. MX 30 svr4.postgresql.org. $ORIGIN postgresql.org. $ --On Tuesday, July 08, 2003 15:35:39 +0200 [EMAIL PROTECTED] wrote: Hi all, Is there a dns problem at hub.org? my mirror www.fr.postgresql.org (and I guess ftp.fr.postgresql.org) does not resolve any more... Regards -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] -- Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] running transactions in postgresql
hi, Iam working on project that deals with analyzing the locking mechanism in postgresql. I started a transaction in postgresql with 'begin work;' and noticed that even though no locks have been taken yet, there still exists data in LockData datastructures that indicates that the transaction i just started running is waiting for a lock.Does anyone know why this happens? I f not , could someone guide me to the appropriate site or mailinglist where my question can be answered. thank you JennyProtect your PC - Click here for McAfee.com VirusScan Online
Re: [HACKERS] [GENERAL] PG crash on simple query, story continues
After upgrade on 7.3.3 we have following: signal 11 #0 0x254f38 in pfree () #1 0x1fde44 in convert_to_scalar () #2 0x1faafc in scalarineqsel () #3 0x1fd574 in mergejoinscansel () #4 0x14fec8 in cost_mergejoin () #5 0x16b820 in create_mergejoin_path () #6 0x155048 in sort_inner_and_outer () #7 0x154dd0 in add_paths_to_joinrel () #8 0x1567cc in make_join_rel () #9 0x15669c in make_jointree_rel () #10 0x14dd28 in make_fromexpr_rel () #11 0x14d6d0 in make_one_rel () #12 0x15d328 in subplanner () #13 0x15d218 in query_planner () #14 0x15f29c in grouping_planner () #15 0x15d93c in subquery_planner () #16 0x15d5e4 in planner () #17 0x1a6a94 in pg_plan_query () #18 0x1a712c in pg_exec_query_string () #19 0x1a8fd8 in PostgresMain () #20 0x172698 in DoBackend () #21 0x171ac4 in BackendStartup () #22 0x16ff14 in ServerLoop () #23 0x16f780 in PostmasterMain () #24 0x128e60 in main () -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:14 PM To: Maksim Likharev Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] PG crash on simple query, story continues Maksim Likharev [EMAIL PROTECTED] writes: SELECT p.docid FROM prod.t_documents AS p INNER JOIN t_tempdocs AS t ON p.docid = t.docid LEFT OUTER JOIN prod.t_refs AS ct ON ct.docid = p.docid; here is a stack trace: 00252174 AllocSetAlloc (3813b0, 15, 251fe0, 20, 0, ffbee2f8) + 194 002532e4 MemoryContextAlloc (3813b0, 15, 11, 7efefeff, 81010100, ff00) + 68 0020dc0c varcharin (ffbee378, ffbee378, 20dae4, 0, 0, ffbee3f0) + 128 00243570 FunctionCall3 (ffbee4a8, 3c1ce8, 0, 324, 0, ffbee5c4) + 11c 0023e6c4 get_attstatsslot (3d6410, 413, 324, 2, 0, ffbee5c4) + 2b0 001f8cb4 scalarineqsel (3bb978, 42a, 0, 3bffa8, 40f0e8, 413) + 288 001fb824 mergejoinscansel (3bb978, 3c0080, 3c0968, 3c0970, 0, 1) + 23c Hmm, it would seem there's something flaky about your pg_statistic entries. Could we see the pg_stats rows for the columns mentioned in this query? regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [GENERAL] PG crash on simple query, story continues
Hi, I have very interesting suspicion:
See my comments !
convert_string_datum
...
!this is my case
if (!lc_collate_is_c())
{
/* Guess that transformed string is not much bigger than
original */
xfrmsize = strlen(val) + 32;/* arbitrary pad value
here... */
! I would say very interesting aproach,
! why not just
xfrmsize = strxfrm(xfrmstr, NULL, 0);
! fine
xfrmstr = (char *) palloc(xfrmsize);
!fine
xfrmlen = strxfrm(xfrmstr, val, xfrmsize);
!if error happend, xfrmlen will be (size_t)-1
if (xfrmlen = xfrmsize) {
!yep did not make it
/* Oops, didn't make it */
pfree(xfrmstr);
!what do we allocating here? 0 byte
xfrmstr = (char *) palloc(xfrmlen + 1);
!BOOM
xfrmlen = strxfrm(xfrmstr, val, xfrmlen + 1);
}
pfree(val);
val = xfrmstr;
}
-Original Message-
From: Maksim Likharev
Sent: Tuesday, July 08, 2003 9:35 AM
To: 'Tom Lane'
Cc: [EMAIL PROTECTED]; '[EMAIL PROTECTED]'
Subject: RE: [GENERAL] PG crash on simple query, story continues
After upgrade on 7.3.3 we have following:
signal 11
#0 0x254f38 in pfree ()
#1 0x1fde44 in convert_to_scalar ()
#2 0x1faafc in scalarineqsel ()
#3 0x1fd574 in mergejoinscansel ()
#4 0x14fec8 in cost_mergejoin ()
#5 0x16b820 in create_mergejoin_path ()
#6 0x155048 in sort_inner_and_outer ()
#7 0x154dd0 in add_paths_to_joinrel ()
#8 0x1567cc in make_join_rel ()
#9 0x15669c in make_jointree_rel ()
#10 0x14dd28 in make_fromexpr_rel ()
#11 0x14d6d0 in make_one_rel ()
#12 0x15d328 in subplanner ()
#13 0x15d218 in query_planner ()
#14 0x15f29c in grouping_planner ()
#15 0x15d93c in subquery_planner ()
#16 0x15d5e4 in planner ()
#17 0x1a6a94 in pg_plan_query ()
#18 0x1a712c in pg_exec_query_string ()
#19 0x1a8fd8 in PostgresMain ()
#20 0x172698 in DoBackend ()
#21 0x171ac4 in BackendStartup ()
#22 0x16ff14 in ServerLoop ()
#23 0x16f780 in PostmasterMain ()
#24 0x128e60 in main ()
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 10:14 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query, story continues
Maksim Likharev [EMAIL PROTECTED] writes:
SELECT p.docid FROM prod.t_documents AS p
INNER JOIN t_tempdocs AS t
ON p.docid = t.docid
LEFT OUTER JOIN prod.t_refs AS ct
ON ct.docid = p.docid;
here is a stack trace:
00252174 AllocSetAlloc (3813b0, 15, 251fe0, 20, 0, ffbee2f8) + 194
002532e4 MemoryContextAlloc (3813b0, 15, 11, 7efefeff, 81010100,
ff00)
+ 68
0020dc0c varcharin (ffbee378, ffbee378, 20dae4, 0, 0, ffbee3f0) + 128
00243570 FunctionCall3 (ffbee4a8, 3c1ce8, 0, 324, 0, ffbee5c4) + 11c
0023e6c4 get_attstatsslot (3d6410, 413, 324, 2, 0, ffbee5c4) + 2b0
001f8cb4 scalarineqsel (3bb978, 42a, 0, 3bffa8, 40f0e8, 413) + 288
001fb824 mergejoinscansel (3bb978, 3c0080, 3c0968, 3c0970, 0, 1) +
23c
Hmm, it would seem there's something flaky about your pg_statistic
entries. Could we see the pg_stats rows for the columns mentioned
in this query?
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed:
On Tue, Jul 08, 2003 at 12:34:19PM +0900, Kenji Sugita wrote:
From: Kurt Roeckx [EMAIL PROTECTED]
Subject: Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid
argument
Date: Sun, 6 Jul 2003 18:44:35 +0200
;;; On Sun, Jul 06, 2003 at 06:30:04PM +0200, Kurt Roeckx wrote:
;;; Try the attached patch instead.
;;;
;;; Oops, that one was a little broken. I change it.
;;;
;;; Try the attached one instead.
I tried the newest one.
I did some investigation on a redhat 6.0. It seems getaddrinfo
is really broken.
It returns an AF_INET socket, but it doesn't say it should be of
socket type SOCK_DGRAM. It also returns an AF_UNIX socket and
for that it sets the socktype correct, but we don't want to use
the AF_UNIX one.
I'm going to assume that Mac Os X is broken in the same way.
Here is a new patch.
Kurt
Index: ./src/backend/postmaster/pgstat.c
===
RCS file: /projects/cvsroot/pgsql-server/src/backend/postmaster/pgstat.c,v
retrieving revision 1.37
diff -u -r1.37 pgstat.c
--- ./src/backend/postmaster/pgstat.c 12 Jun 2003 07:36:51 - 1.37
+++ ./src/backend/postmaster/pgstat.c 8 Jul 2003 20:24:20 -
@@ -145,7 +145,7 @@
pgstat_init(void)
{
ACCEPT_TYPE_ARG3alen;
- struct addrinfo*addr, hints;
+ struct addrinfo*addrs, *addr, hints;
int ret;
/*
@@ -187,16 +187,32 @@
hints.ai_addr = NULL;
hints.ai_canonname = NULL;
hints.ai_next = NULL;
- ret = getaddrinfo2(localhost, NULL, hints, addr);
- if (ret || !addr)
+ ret = getaddrinfo2(localhost, NULL, hints, addrs);
+
+ if (ret || !addrs)
{
elog(LOG, PGSTAT: getaddrinfo2() failed: %s,
gai_strerror(ret));
goto startup_failed;
}
- if ((pgStatSock = socket(addr-ai_family,
- addr-ai_socktype, addr-ai_protocol)) 0)
+ for (addr = addrs; addr; addr = addr-ai_next)
+ {
+#ifdef HAVE_UNIX_SOCKETS
+ /* Skip AF_UNIX sockets. */
+ if (addr-ai_family == AF_UNIX)
+ {
+ continue;
+ }
+#endif
+ if ((pgStatSock = socket(addr-ai_family,
+ SOCK_DGRAM, 0)) = 0)
+ {
+ break;
+ }
+ }
+
+ if (!addr || pgStatSock 0)
{
elog(LOG, PGSTAT: socket() failed: %m);
goto startup_failed;
@@ -211,8 +227,8 @@
elog(LOG, PGSTAT: bind() failed: %m);
goto startup_failed;
}
- freeaddrinfo2(hints.ai_family, addr);
- addr = NULL;
+ freeaddrinfo2(hints.ai_family, addrs);
+ addrs = NULL;
alen = sizeof(pgStatAddr);
if (getsockname(pgStatSock, (struct sockaddr *)pgStatAddr, alen) 0)
@@ -257,9 +273,9 @@
return;
startup_failed:
- if (addr)
+ if (addrs)
{
- freeaddrinfo2(hints.ai_family, addr);
+ freeaddrinfo2(hints.ai_family, addrs);
}
if (pgStatSock = 0)
Index: ./src/backend/libpq/pqcomm.c
===
RCS file: /projects/cvsroot/pgsql-server/src/backend/libpq/pqcomm.c,v
retrieving revision 1.157
diff -u -r1.157 pqcomm.c
--- ./src/backend/libpq/pqcomm.c12 Jun 2003 07:36:51 - 1.157
+++ ./src/backend/libpq/pqcomm.c8 Jul 2003 20:24:35 -
@@ -216,7 +216,7 @@
/* Initialize hint structure */
MemSet(hint, 0, sizeof(hint));
hint.ai_family = family;
- hint.ai_flags = AI_PASSIVE | AI_ADDRCONFIG;
+ hint.ai_flags = AI_PASSIVE;
hint.ai_socktype = SOCK_STREAM;
#ifdef HAVE_UNIX_SOCKETS
@@ -266,8 +266,7 @@
/* Nothing found. */
break;
}
- if ((fd = socket(addr-ai_family, addr-ai_socktype,
- addr-ai_protocol)) 0)
+ if ((fd = socket(addr-ai_family, SOCK_STREAM, 0)) 0)
{
elog(LOG, server socket failure: socket(): %s,
strerror(errno));
---(end of broadcast)---
TIP 8: explain analyze is your friend
[HACKERS] sugsestions
What do you think about : 1. OPTION RETURNS NULL ON NULL INPUT (when function is created) change to RETURNS val ON NULL INPUT ??? 2. CREATE TYPE .. with INHERITS (..) like in CREATE TABLE but type should be normaly with including base type create type A AS (A INT,B INT); and create type B AS (C INT, D INT) INHERITS( A ); == create type B AS (A INT, B INT, C INT, D INT ); can be ?? 3. For example : CREATE TABLE t1 (A INT, B INT ); CREATE TABLE t2 (C INT , D INT ) INHERITS(t1); SELECT a.* FRom t2 a ; give me 4 cols (A,B,C and D) SELECT a.C,((t1)a).* FROM t2 a; should give me 3 cols (C,A and B) its like in c++ , but in c++ you need to use ((t1)a) cast it. I cant find the words in english , but i hope you understand this. 4. This is q question . Is in SPI sth like try and catch () ? It would be very useful to error .. plpgsql should have this too. (itd also from c++) 5. What do you think about crontab in postgres database , like pg_crontab ? 6. the last. i need to create function with only one select with security definer . The best way is to create function with language SQL . Problem is becaulse table from which is this select dont exists , jet. It will be a temp table . When i create function [] language SQL there is a error about non-exists table. So i have proposition to include option to create function command : WITH / WITHOUT CHECK ... ? or PRECOMPILE ? What do you think ? thanks : ivan ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgsql-advocacy] [HACKERS] [GENERAL] Postgresql AMD x86-64
The s_lock.h change will be in 7.4. --- Tom Lane wrote: Martin D. Weinberg [EMAIL PROTECTED] writes: I didn't change the source tree at all. I used: env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./configure --with-CXX --without-zlib BTW, see Jeff Baker's nearby report in pgsql-general that s_lock.h needs to be tweaked to use spinlocks on this platform. If you're using semaphores instead then you're taking a big performance hit. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] [GENERAL] PG crash on simple query, story continues
Maksim Likharev [EMAIL PROTECTED] writes: On failure, strxfrm() returns (size_t)-1. Not according to the Single Unix Specification, Linux, or HP-UX; I don't have any others to check. But anyway, that is not causing your problem, since palloc(0) would complain not dump core. I am on SunOS 5.8, Solaris, eh? IIRC, it was Solaris that we last heard about broken strxfrm on. Better check to see if Sun has a fix for this. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] [GENERAL] PG crash on simple query, story continues
I would referrer dump that gar.xxg, and put PG on Linux, but this is not up to me. Thanks for the help. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 3:58 PM To: Maksim Likharev Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [GENERAL] PG crash on simple query, story continues Maksim Likharev [EMAIL PROTECTED] writes: On failure, strxfrm() returns (size_t)-1. Not according to the Single Unix Specification, Linux, or HP-UX; I don't have any others to check. But anyway, that is not causing your problem, since palloc(0) would complain not dump core. I am on SunOS 5.8, Solaris, eh? IIRC, it was Solaris that we last heard about broken strxfrm on. Better check to see if Sun has a fix for this. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Bad permissions bug in 7.3 dump (and 7.4)?
Has anyone looked at this problem? I have delved into the source code, but I can't for the life of me see where to make the change. I think there are actually a few possible solutions: * Dump all foreign key constraints as a superuser * Prevent changing ownership of tables that have foreign keys where the new owner does not have REFERENCE privs for all referenced tables. * Grant REFERENCE to new owner when changing ownership of table. Chris - Original Message - From: Christopher Kings-Lynne [EMAIL PROTECTED] To: Hackers [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 9:35 AM Subject: [HACKERS] Bad permissions bug in 7.3 dump (and 7.4)? This: create user bob; create user sue; \c - bob create table parent (a int4 primary key); create table child(b int4 references parent); \c - chriskl (I'm superuser) alter table child owner to sue; Now, do a dump: pg_dump test script.sql (attached) And try to restore it: bash-2.03$ psql test script.sql You are now connected as new user chriskl. REVOKE GRANT You are now connected as new user bob. SET CREATE TABLE You are now connected as new user sue. SET CREATE TABLE You are now connected as new user bob. SET You are now connected as new user sue. SET You are now connected as new user bob. SET NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index 'parent_pkey' for table 'parent' ALTER TABLE You are now connected as new user sue. SET NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ERROR: parent: permission denied The solution (it seems to me) is to add all the foreign keys under the superuser account, NOT the owner of either table account. Chris ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[HACKERS] Another nasty pg_dump problem
On my 7.3 server:
australia=# \dp exercise_activities
Access privileges for database australia
Schema |Table|Access privileges
+-+-
public | exercise_activities |
{=,chriskl=arwdRxt,auadmin=arwdRxt,au-diary=r,au-php=r}
(1 row)
is dumped as:
REVOKE ALL ON TABLE exercise_activities FROM PUBLIC;
GRANT ALL ON TABLE exercise_activities TO chriskl;
GRANT SELECT ON TABLE exercise_activities TO au-diary;
GRANT SELECT ON TABLE exercise_activities TO au-php;
Now if you load that into 7.4CVS, you get:
australia=# \dp exercise_activities
Access privileges for
database australia
Schema |Table|
Access privileges
+-+-
-
public | exercise_activities |
{auadmin=a*r*w*d*R*x*t*/auadmin,chriskl=arwdRxt/auadmin,\au-diary\=r/auad
min,\au-php\=r/auadmin}
(1 row)
Which is dumped as:
REVOKE ALL ON TABLE exercise_activities FROM PUBLIC;
GRANT ALL ON TABLE exercise_activities TO chriskl;
GRANT SELECT ON TABLE exercise_activities TO \au-diary\;
GRANT SELECT ON TABLE exercise_activities TO \au-php\;
ie. 7.4 considers the double quotes around a username to be part of the
username...
Chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed:
From: Kurt Roeckx [EMAIL PROTECTED] Subject: Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Date: Tue, 8 Jul 2003 22:25:44 +0200 ;;; ;;; On Sun, Jul 06, 2003 at 06:30:04PM +0200, Kurt Roeckx wrote: ;;; ;;; Try the attached patch instead. ;;; ;;; ;;; ;;; Oops, that one was a little broken. I change it. ;;; ;;; ;;; ;;; Try the attached one instead. ;;; ;;; I tried the newest one. ;;; ;;; I did some investigation on a redhat 6.0. It seems getaddrinfo ;;; is really broken. ;;; It returns an AF_INET socket, but it doesn't say it should be of ;;; socket type SOCK_DGRAM. I pointed it in the first post. Rturned type is not SOCK_DGRAM. ;;; It also returns an AF_UNIX socket and ;;; for that it sets the socktype correct, but we don't want to use ;;; the AF_UNIX one. ;;; ;;; I'm going to assume that Mac Os X is broken in the same way. ;;; ;;; Here is a new patch. It works on both platforms. Thanks. Kenji Sugita ---(end of broadcast)--- TIP 8: explain analyze is your friend
