[HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalidargument

2003-07-02 Thread Kenji Sugita
It seems that a value of addr-ai_socktype returned by getaddrinfo in pg_stat.c is not SOCK_DGRAM. Kenji Sugita ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] Index expressions: how to recreate

2003-07-02 Thread Dave Page
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 23:26 To: Andreas Pflug Cc: PostgreSQL Development Subject: Re: [HACKERS] Index expressions: how to recreate Does anyone else think it's reasonable to define a backend function along the lines of

Re: [HACKERS] PHP/PgSQL *and* libpq ...

2003-07-02 Thread Dave Page
-Original Message- From: Marc G. Fournier [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 00:56 To: Jan Wieck Cc: Robert Treat; Bruce Momjian; [EMAIL PROTECTED] Subject: Re: [HACKERS] PHP/PgSQL *and* libpq ... Well, actually, I believe Dave already does up the ODBC driver in

Re: [HACKERS] Dllist public/private part

2003-07-02 Thread Mendola Gaetano
Bruce Momjian [EMAIL PROTECTED] wrote: Mendola Gaetano wrote: I certainly would like to see Dllist removed too. This mean that is waste of time work on dllist. I seen that exist a TODO list about features, exist a list about: code to optimize ? What TODO item where you looking at? I

[HACKERS] 7.4dev initdb problem

2003-07-02 Thread Oleg Bartunov
Build from current CVS: [EMAIL PROTECTED]:~/add/7.4/pgsql-server$ initdb -E KOI8 The files belonging to this database system will be owned by user postgres. This user must also own the server process. The database cluster will be initialized with locales: COLLATE: ru_RU.KOI8-R CTYPE:

Re: [HACKERS] 7.4dev initdb problem

2003-07-02 Thread Oleg Bartunov
Replying to my message: 'make distclean' helps Sorry for bothering Oleg On Wed, 2 Jul 2003, Oleg Bartunov wrote: Build from current CVS: [EMAIL PROTECTED]:~/add/7.4/pgsql-server$ initdb -E KOI8 The files belonging to this database system will be owned by user postgres. This user

Re: [HACKERS] help needed with yacc/bison

2003-07-02 Thread Oleg Bartunov
On Wed, 1 Jul 2003, Hannu Krosing wrote: Oleg Bartunov kirjutas T, 01.07.2003 kell 15:49: Hi there, attached archive contains simple parser demonstrating our problem. untar it, make, make test Good test: echo -n 12 34.1234 ... | ./parser INTEGER:'12' CHAR: ' '

Re: [HACKERS] Index expressions: how to recreate

2003-07-02 Thread Andreas Pflug
Tom Lane wrote: Andreas Pflug [EMAIL PROTECTED] writes: pg_get_indexdef converts that string to a list of nodes (not surprising), while pg_get_expr whill join these list elements with an explicit and (according to a comment, needed for partial index). Do I need to retrieve indexprs and

Re: [HACKERS] Setting locale per connection

2003-07-02 Thread Behdad Esfahbod
On Wed, 2 Jul 2003, Tom Lane wrote: On Wed, 2 Jul 2003, Behdad Esfahbod wrote: so I have wrote my 10lines function as a wrapper around setlocale, that is attached. Indeed, this is exactly why Postgres goes out of its way to prevent you from changing the backend's collation setting

Re: [HACKERS] help needed with yacc/bison

2003-07-02 Thread Hannu Krosing
Oleg Bartunov kirjutas K, 02.07.2003 kell 11:39: The problem is recognizing VERSION (from gram.y) version: INTEGER DOT INTEGER{ $$ = strconcat($1, $3, $2); } | version DOT INTEGER { $$ = strconcat($1, $3, $2); } removing the line above seems to fix your

[HACKERS] help with rpm script

2003-07-02 Thread Craig Jensen
Hello, I am building an rpm for Mitle SME (a scaled down redhat 7.3) and have all functions working except: I need to have the rpm when installed create a database and a user with privilege to that database. These are the command functions I need to execute within the rpm... # service

[HACKERS] same new code

2003-07-02 Thread User For Mails
here is function to get client ip address (only ipv4), server address, and fe/be ports , details inside http://www.psycho.pl/public/src/pgsql/ivnet.tar.bz2 please test it in yours systems (i tested on Debian 2.4.21 with grsec.) 2. Whats up with PG_RETURN_UINT16 ?? and with type

Re: [HACKERS] help with rpm script

2003-07-02 Thread Lamar Owen
On Wednesday 02 July 2003 01:20, Craig Jensen wrote: I need to have the rpm when installed create a database and a user with privilege to that database. These are the command functions I need to execute within the rpm... # service postgresql start # su postgres # createdb account # psql

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Robert Treat
Once you folks are done going through the remaining list of patches, can we get someone to send a rough list of new features in 7.4 sent over to -advocacy? Please feel free to highlight any items that you think warrant special notice from a technical standpoint. Thanks in advance, Robert Treat

Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid

2003-07-02 Thread Bruce Momjian
I don't see any pg_stat.c in the source tree. Can you show us the exact line, and perhaps the failure. --- Kenji Sugita wrote: It seems that a value of addr-ai_socktype returned by getaddrinfo in pg_stat.c is not

Re: [HACKERS] Dllist public/private part

2003-07-02 Thread Bruce Momjian
Mendola Gaetano wrote: Bruce Momjian [EMAIL PROTECTED] wrote: Mendola Gaetano wrote: I certainly would like to see Dllist removed too. This mean that is waste of time work on dllist. I seen that exist a TODO list about features, exist a list about: code to optimize ? What

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Bruce Momjian
I usually do it, but it might take a week to put together. --- Robert Treat wrote: Once you folks are done going through the remaining list of patches, can we get someone to send a rough list of new features in 7.4 sent

Re: [HACKERS] Index expressions: how to recreate

2003-07-02 Thread Tom Lane
Andreas Pflug [EMAIL PROTECTED] writes: Tom Lane wrote: Does anyone else think it's reasonable to define a backend function along the lines of pg_get_indexdef(indexoid, columnnumber) that retrieves just the column-name-or-expression for the indicated column of the index? There's a

[HACKERS] compile failure

2003-07-02 Thread Greg Stark
Is recode a feature that's normally enabled? ./configure '--enable-recode' '--enable-integer-datetimes' '--enable-debug' '--with-perl' '--with-pam' '--with-openssl' '--with-gnu-ld' '--with-maxbackends=64' '--with-pgport=5432' 'CFLAGS=-O0 -g -pg -DLINUX_PROFILE' ... gcc -O0 -g -pg

Re: [HACKERS] Setting locale per connection

2003-07-02 Thread Tom Lane
Behdad Esfahbod [EMAIL PROTECTED] writes: So, assuming I want to go for the right way, I've just seen the column-based LC_COLLATE in the TODO list. Is there any more information about that? If you troll the pghackers archives you will find several past discussions about it. A reasonably

Re: [HACKERS] compile failure

2003-07-02 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: Is recode a feature that's normally enabled? Not by me --- wouldn't be the least bit surprised if it's broken. Can you send a patch? regards, tom lane ---(end of broadcast)--- TIP 8:

Re: [HACKERS] compile failure

2003-07-02 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Greg Stark [EMAIL PROTECTED] writes: Is recode a feature that's normally enabled? Not by me --- wouldn't be the least bit surprised if it's broken. Can you send a patch? Well my patch was to change --enable-recode to --disable-recode :) I'm not even

Re: [HACKERS] compile failure

2003-07-02 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: Now I'm getting timestamp.c: In function `tm2timestamp': timestamp.c:69: warning: implicit declaration of function `elog' timestamp.c:69: `ERROR' undeclared (first use in this function) I assume this is expected due to the error handling changes? No, not

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Andreas Pflug
Bruce Momjian wrote: I usually do it, but it might take a week to put together. --- Robert Treat wrote: Once you folks are done going through the remaining list of patches, can we get someone to send a rough list of new

Re: [HACKERS] compile failure

2003-07-02 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: Now I'm getting timestamp.c: In function `tm2timestamp': timestamp.c:69: warning: implicit declaration of function `elog' timestamp.c:69: `ERROR' undeclared (first use in this function) I assume this is expected due to the error handling changes? FWIW,

Re: [HACKERS] compile failure

2003-07-02 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Greg Stark [EMAIL PROTECTED] writes: Now I'm getting timestamp.c: In function `tm2timestamp': timestamp.c:69: warning: implicit declaration of function `elog' timestamp.c:69: `ERROR' undeclared (first use in this function) I assume this is expected

Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid

2003-07-02 Thread Kurt Roeckx
On Wed, Jul 02, 2003 at 10:06:54AM -0400, Bruce Momjian wrote: I don't see any pg_stat.c in the source tree. Can you show us the exact line, and perhaps the failure. He means pgstat.c of course. Kurt ---(end of broadcast)--- TIP 2: you can

Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid argument

2003-07-02 Thread Kurt Roeckx
On Wed, Jul 02, 2003 at 03:49:19PM +0900, Kenji Sugita wrote: It seems that a value of addr-ai_socktype returned by getaddrinfo in pg_stat.c is not SOCK_DGRAM. What system are you running on, and does it have a getaddrinfo() or not? If I tell getaddrinfo() it should return a SOCK_DGRAM, it can

Re: [HACKERS] compile failure

2003-07-02 Thread Kurt Roeckx
On Wed, Jul 02, 2003 at 10:39:11AM -0400, Greg Stark wrote: miscinit.c: In function `SetCharSet': miscinit.c:205: structure has no member named `in' This is obviously something I overlooked. I'll see if I can fix it. Kurt ---(end of

[HACKERS] compile failure in ecpg

2003-07-02 Thread Greg Stark
Ok, trying again with integer datetimes off and recode off it gets a bit further: /usr/bin//flex -o'pgc.c' pgc.l gcc -O0 -g -pg -DLINUX_PROFILE -g -Wall -Wmissing-prototypes -Wmissing-declarations -Wno-error -I./../include -I. -I../../../../src/include -DMAJOR_VERSION=3 -DMINOR_VERSION=0

Re: [HACKERS] compile failure in ecpg

2003-07-02 Thread Michael Meskes
On Wed, Jul 02, 2003 at 02:00:49PM -0400, Greg Stark wrote: Ok, trying again with integer datetimes off and recode off it gets a bit further: What exactly was special on your site? This surely works for me. pgc.c:3429: warning: no previous prototype for `yyget_lineno' ... These are

Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid argument

2003-07-02 Thread Kurt Roeckx
On Wed, Jul 02, 2003 at 03:49:19PM +0900, Kenji Sugita wrote: It seems that a value of addr-ai_socktype returned by getaddrinfo in pg_stat.c is not SOCK_DGRAM. What do you base this on? My guess is that it returns an ipv6 address while you do not have IPv6 support in the kernel. If that is

Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid argument

2003-07-02 Thread Kurt Roeckx
On Wed, Jul 02, 2003 at 08:35:00PM +0200, Kurt Roeckx wrote: On Wed, Jul 02, 2003 at 03:49:19PM +0900, Kenji Sugita wrote: It seems that a value of addr-ai_socktype returned by getaddrinfo in pg_stat.c is not SOCK_DGRAM. What do you base this on? My guess is that it returns an ipv6

Re: [HACKERS] compile failure in ecpg

2003-07-02 Thread Greg Stark
Michael Meskes [EMAIL PROTECTED] writes: On Wed, Jul 02, 2003 at 02:00:49PM -0400, Greg Stark wrote: Ok, trying again with integer datetimes off and recode off it gets a bit further: What exactly was special on your site? This surely works for me. pgc.c:3429: warning: no previous

[HACKERS] Compile failure in ecpg/pgtypeslib/numeric.c

2003-07-02 Thread Kurt Roeckx
It seems someone removed some include files in revision 1.11 from interfaces/ecpg/pgtypeslib/numeric.c. One of them was limits.h, which is needed for INT_MAX and LONG_MAX. Readding it fixes it. Kurt ---(end of broadcast)--- TIP 5: Have you

Re: [HACKERS] Compile failure in ecpg/pgtypeslib/numeric.c

2003-07-02 Thread Bruce Momjian
#include limits.h readded. Thanks. --- Kurt Roeckx wrote: It seems someone removed some include files in revision 1.11 from interfaces/ecpg/pgtypeslib/numeric.c. One of them was limits.h, which is needed for INT_MAX

Re: [HACKERS] compile failure in ecpg

2003-07-02 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: Perhaps it's a bug in flex? I have: bash-2.05b$ flex -V flex 2.5.31 There's your problem. See http://fts.postgresql.org/db/msg.html?mid=1366520 Personally I'm still running 2.5.4 ... regards, tom lane

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Philip Yarra
On Thu, 3 Jul 2003 12:14 am, you wrote: I usually do it, but it might take a week to put together. You might like to mention that (as far as I can tell) ECPG is now safe for pthreads on Linux and FreeBSD. The recursive mutex locks are removed, so even platforms that implement the earlier

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Dann Corbit
-Original Message- From: Philip Yarra [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 5:17 PM To: Bruce Momjian Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] 7.4 feature freeze is here On Thu, 3 Jul 2003 12:14 am, you wrote: I usually do it, but it might take a week

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Bruce Momjian
Yes, I grab this info from the CVS logs, and I certainly mentioned it in the commit. --- Philip Yarra wrote: On Thu, 3 Jul 2003 12:14 am, you wrote: I usually do it, but it might take a week to put together. You might

[HACKERS] contract opportunity for the willing.

2003-07-02 Thread Richard Schilling
Just wanted to announce that for those interested I'm looking at submitting an RFP to Washington State (in the US). Being PostgreSQL is my database of choice I would like to invite anyone who is interested and has PostgreSQL programming/administration experience to contact me. Backend

Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed:

2003-07-02 Thread Kenji Sugita
From: Kurt Roeckx [EMAIL PROTECTED] To: Kenji Sugita [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Date: Wed, 2 Jul 2003 19:20:11 +0200 ;;; What system are you running on, and does it have a getaddrinfo() ;;; or not? Red Hat Linux and Mac OS X 10.2.6. Both nm libc display getaddrinfo as follows: $ nm

Re: [HACKERS] Index expressions: how to recreate

2003-07-02 Thread Christopher Kings-Lynne
Clearly understood, while pgadmin3 will always behave quite backend specific. The code for index display broke just shortly ago, because the column pg_index.indproc went away. There's a growing number of version specific stuff in it, because we try to prevent the user from doing illegal

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Christopher Kings-Lynne
Read the HISTORY file - there's a few things. Chris - Original Message - From: Robert Treat [EMAIL PROTECTED] To: Tom Lane [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 9:27 PM Subject: Re: [HACKERS] 7.4 feature freeze is here Once you folks are done going

[HACKERS] 7.4 feature freeze

2003-07-02 Thread Christopher Kings-Lynne
No-one's fixed the %rowtype with dropped columns business yet either... Chris ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] 7.4 feature freeze is here

2003-07-02 Thread Christopher Kings-Lynne
You might like to mention that (as far as I can tell) ECPG is now safe for pthreads on Linux and FreeBSD. The recursive mutex locks are removed, so even platforms that implement the earlier version of pthreads ought to work as well, once configure supports them (anyone care to actually test

[HACKERS] Anyone still using --enable-recode? (was Re: compile failure)

2003-07-02 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: Is recode a feature that's normally enabled? ./configure '--enable-recode' '--enable-integer-datetimes' '--enable-debug' '--with-perl' '--with-pam' '--with-openssl' '--with-gnu-ld' '--with-maxbackends=64' '--with-pgport=5432' 'CFLAGS=-O0 -g -pg

Re: [HACKERS] Anyone still using --enable-recode? (was Re: compile failure)

2003-07-02 Thread Kurt Roeckx
On Wed, Jul 02, 2003 at 01:23:52PM -0400, Tom Lane wrote: Greg Stark [EMAIL PROTECTED] writes: Is recode a feature that's normally enabled? ./configure '--enable-recode' '--enable-integer-datetimes' '--enable-debug' '--with-perl' '--with-pam' '--with-openssl' '--with-gnu-ld'

Re: [HACKERS] Anyone still using --enable-recode? (was Re: compile failure)

2003-07-02 Thread Tom Lane
Kurt Roeckx [EMAIL PROTECTED] writes: I'll probably rewrite that code to use rangeSockAddr / SockAddr_cidr_mask instead of having it's own cidr code. Given that it's been under death sentence for awhile, I'm not sure it's worth putting that much work into ... the feature is superseded by

Re: [HACKERS] Anyone still using --enable-recode? (was Re: compile failure)

2003-07-02 Thread Kurt Roeckx
On Wed, Jul 02, 2003 at 01:52:46PM -0400, Tom Lane wrote: Kurt Roeckx [EMAIL PROTECTED] writes: I'll probably rewrite that code to use rangeSockAddr / SockAddr_cidr_mask instead of having it's own cidr code. Given that it's been under death sentence for awhile, I'm not sure it's worth

[HACKERS] compile failures on cvs tip

2003-07-02 Thread Joe Conway
I'm seeing ecpg related compile failures on cvs tip: make[3]: Entering directory `/opt/src/pgsql/src/interfaces/ecpg' make -C include all make[4]: Entering directory `/opt/src/pgsql/src/interfaces/ecpg/include' make[4]: Nothing to be done for `all'. make[4]: Leaving directory

[HACKERS] pgAdmin III - Call for Translators

2003-07-02 Thread Dave Page
As many of you already know, pgAdmin is a widely used Open Source GUI Management tool for PostgreSQL, similar to DB2's Control Center or SQL Server's Enterprise Manager. We are currently working on the next generation pgAdmin III, with the aim of releasing it at approximately the same time as