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 `/opt/src/pgsql/src/i
> 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
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
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 don
> 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 s
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:
$
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 databas
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 m
> -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 tak
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 versi
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
--
#include 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 and LON
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 chec
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 p
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
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 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 flex/
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
>
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 -DP
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
CLI
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'
>
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 broadcast)---
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 -DLI
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 c
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 ca
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
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
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 f
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
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
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:
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 reasonabl
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 Pos
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 -DLINUX_PROFIL
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
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
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 op
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 SOCK_
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
On
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
> # p
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 uin
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 postgres
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 abo
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 set
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 spl
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'
> > C
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
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:
"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 y
> -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
>
> -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 l
51 matches
Mail list logo
