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
-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
-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
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
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:
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
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: ' '
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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,
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
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
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
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
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
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
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
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
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
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
#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
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
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
-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
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
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
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
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
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
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
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
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
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'
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
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
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
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
52 matches
Mail list logo