Re: [HACKERS] plpq

[Darko Prenosil]

It is wrapper about libpq client library functions for use in PL/PSQL.
I agreed with Joe Conway that it may fit within dblink, because dblink is much
more easy to work with than the libpq, but sometimes it is Just not enough.
So, the idea is to re-implement all important libpq functions like 
PQConnectdb,
PQExec ... and make one postgres server become just a client for another (or 
another's) postgres server. As You know, dblink still does not support 
simultaneous connections to two different databases, but with this it can !
I agreed with Joe that when he is back from holiday he will take a look.

Regards !

On Monday 28 October 2002 20:35, Bruce Momjian wrote:
> Would you tell us exactly what this is.
>
> ---
>
> Darko Prenosil wrote:
> > Tree weeks later than I promised, but it is finished (I hope).
> >
> > In attachment are files:
> > dblink.c
> > dblink.h
> > dblink.sql.in
> > pqtest.sql
> >
> > In file pqtest.sql is sample queries and results. It seem OK to me.
> >
> > There are two reasons why I did not make a diff.
> >
> > 1. The source I started from is 7.3b1, not the latest.
> > 2. I would like You to check the code, especially the part that touches
> > memory management.
> > I can say that it works, but I do not know exactly why, and this can be
> > dangerous. With my knowledge of postgres internals this is
> > as far I can go at the moment. And once more sorry for bad English !
> >
> > Regards !
>
> [ Attachment, skipping... ]
>
> [ Attachment, skipping... ]
>
> [ Attachment, skipping... ]
>
> [ Attachment, skipping... ]
>
> > ---(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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] idle connection timeout ...

[Karel Zak]

On Fri, Oct 25, 2002 at 03:31:22PM -0400, Mike Mascari wrote:
> Bruce Momjian wrote:
> > Andrew Sullivan wrote:
> > 
> >>On Fri, Oct 25, 2002 at 11:02:48AM -0400, Tom Lane wrote:
> >>
> >>>So?  If it hits the installation-wide limit, you'll have the same
> >>>problem; and at that point the (presumably runaway) app would have
> >>>sucked up all the connections, denying service to other apps using other
> >>>databases.  I think Marc's point here is to limit his exposure to
> >>>misbehavior of any one client app, in a database server that is serving
> >>>multiple clients using multiple databases.
> >>
> >>That would indeed be a useful item.  The only way to avoid such
> >>exposure right now is to run another back end.
> > 
> > 
> > Added to TODO:
> > 
> > * Allow limits on per-db/user connections
> > 
> 
> Could I suggest that such a feature falls under the category of 
> resource limits, and that the TODO should read something like:
> 
> Implement the equivalent of Oracle PROFILEs.

 Yes! Please it's better than all discussions about some ugly
 variables. The PROFILE is better extendable and it's user 
 specific and in the system with ROLEs it really cool and simple
 set user's system options.
 
 I talked about it more times, but is still ignore :-) I don't want 
 to maintain my databases by SET command.

> profname
> session_per_user
> cpu_per_session
> cpu_per_call
> connect_time
> idle_time
> logical_reads_per_session
> logical_reads_per_call

 ... and a lot of others things in future.

Karel

-- 
 Karel Zak  <[EMAIL PROTECTED]>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Request for supported platforms

[Bruce Momjian]

I have updated CVS and re-added getopt.c, now in /port, and updated
win32.mak.  That should help.

---

Dave Page wrote:
> 
> 
> > -Original Message-
> > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] 
> > Sent: 26 October 2002 03:17
> > To: PostgreSQL-development
> > Cc: Thomas Lockhart; Tom Lane
> > Subject: [HACKERS] Request for supported platforms
> > 
> > 
> > Folks. start sending in those plaform reports, OS name and 
> > version number please.
> > 
> 
> Windows XP Professional SP1
> 
> Client build fails :-(
> 
> Regards, Dave.
> 
> C:\cygwin\usr\local\src\postgresql-7.3b3\src>nmake /f win32.mak
> 
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
> 
> cd include
> if not exist pg_config.h copy pg_config.h.win32 pg_config.h
> 1 file(s) copied.
> cd ..
> cd interfaces\libpq
> nmake /f win32.mak
> 
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
> 
> Building the Win32 static library...
> 
> if not exist ".\Release/" mkdir ".\Release"
> cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma04188.
> dllist.c
> cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmb04188.
> md5.c
> cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmc04188.
> wchar.c
> cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmd04188.
> encnames.c
> cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nme04188.
> win32.c
> fe-auth.c
> fe-connect.c
> fe-exec.c
> fe-lobj.c
> fe-misc.c
> fe-print.c
> fe-secure.c
> pqexpbuffer.c
> link.exe -lib @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmf04188.
> cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmg04188.
> libpqdll.c
> rc.exe /l 0x409 /fo".\Release\libpq.res" libpq.rc
> link.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmh04188.
>Creating library .\Release\libpqdll.lib and object
> .\Release\libpqdll.exp
> cd ..\..\bin\psql
> nmake /f win32.mak
> 
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
> 
> if not exist ".\Release/" mkdir ".\Release"
> NMAKE : fatal error U1073: don't know how to make '..\..\utils\getopt.c'
> Stop.
> NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual
> Studio\VC98\bin\N
> MAKE.EXE"' : return code '0x2'
> Stop.
> 
> C:\cygwin\usr\local\src\postgresql-7.3b3\src>
> 

-- 
  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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] FreeBSD 4.7: BETA3 (from port): regression failures...

[Larry Rosenman]

On Mon, 2002-10-28 at 21:45, Bruce Momjian wrote:
> Larry Rosenman wrote:
> > On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> > > 
> > > See the resultmap file in the regression directory.  I see:
> > > 
> > >   geometry/.*-bsdi=geometry-bsdi-precision
> > >   geometry/.*-darwin=geometry-powerpc-darwin
> > >   geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
> > >   geometry/alpha.*-freebsd=geometry-positive-zeros
> > >   geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
> > >   geometry/sparc-.*-openbsd=geometry-positive-zeros
> > >   geometry/.*-irix6=geometry-irix
> > >   geometry/.*-netbsd=geometry-positive-zeros
> > >   geometry/.*-sysv5.*:cc=geometry-uw7-cc
> > >   geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 
> > > 
> > > I assume we need to modify the FreeBSD entries.  Once you give me a
> > > string to match your OS, I will rename geometry-bsdi-precision to
> > > something non-OS specific.  I assume we need a string that is 4.7-only.
> > geometry/i.86-.*-freebsd4.7= 
> > 
> > I think...
> > 
> > I don't see where it picks out the release? 
> 
> resultmap is read by pg_regress.sh.
I made the following addition:
geometry/i.86-.*-freebsd4.7=geometry-bsdi-precision

(The anon cvs server hasn't updated yet), and we pass geometry.

Still fail horology, but I suspect that's DST change day fubar. 


> 
> -- 
>   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
-- 
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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Request for supported platforms

[Matthew T. O'Connor]

Are you compiling from CVS or from a released tarball?  The bison
requirement was recently raised to bison 1.5 or above (1.75 was recently
released also.)  This is an issue only when compiling from CVS, since
the bison stuff is preprocessed for released tarballs.  So you might
want to try the just release beta3.

On Mon, 2002-10-28 at 08:32, Jason Tishler wrote:
> Dave,
> 
> Thanks for the heads up...
> 
> On Mon, Oct 28, 2002 at 10:31:00AM -, Dave Page wrote:
> > > -Original Message-
> > > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] 
> > > Sent: 26 October 2002 03:17
> > > Subject: [HACKERS] Request for supported platforms
> > >
> > > Folks. start sending in those plaform reports, OS name and 
> > > version number please.
> > 
> > CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown
> ^^
> 
> Please try with Cygwin 1.3.14-1 while I attempt to deal with at least
> the following Cygwin build issues with PostgreSQL CVS as of today at
> about 7:00 AM EST:
> 
> 1. pg_config.h.in HAVE_FSEEKO ifdef:
> 
> make[4]: Entering directory `/home/jt/src/pgsql/src/backend/access/common'
> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include  
>-DBUILDING_DLL  -c -o heaptuple.o heaptuple.c
> In file included from ../../../../src/include/c.h:56,
>  from ../../../../src/include/postgres.h:48,
>  from heaptuple.c:21:
> /usr/include/stdio.h:207: parse error before `('
> 
> 2. Cygwin bison limit exceeded:
> 
> make[4]: Entering directory `/home/jt/src/pgsql/src/interfaces/ecpg/preproc'
> [snip]
> bison -y -d  preproc.y
> preproc.y:5560: fatal error: maximum table size (32767) exceeded
> 
> > Make check failed with the normal spurious errors.
> 
> I would stick with make installcheck due to the Cygwin (i.e., Windows)
> backlog issue.
> 
> > Make installcheck also failed on horology, copy2 and domain - see
> > attached output. 
> > 
> > The clocks changed here on Saturday night, so I guess that shouldn't
> > have caused the first error (or should the docs be updated?).
> > 
> > The second 2 errors are both with copys - related to the problem with
> > the listen() backlog queue in the parallel test perhaps?
> 
> I haven't looked into the above yet due to the build problems.  Any help
> regarding these issues is gratefully appreciated.
> 
> Thanks,
> Jason
> 
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html



---(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] Request for supported platforms

[Bruce Momjian]

Ports list updated:

  http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html

---
Magnus Naeslund(f) wrote:
> Linux alpha.
> 
> An Redhat 6.2, "Linux gsX 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002
> alpha unknown" (ev56 ruffian).
> 
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> 
> ./configure \
>   --prefix=/usr/local/pgsql-7.3b3 \
>   --with-maxbackends=512 \
>   --with-tcl \
>   --without-tk   \
>   --with-perl\
>   --with-openssl \
>   --enable-odbc  \
>   --with-CXX
> 
> The box passes every tests except Horology.
> It's wintertime here aswell, as i read in some other report.
> 
> It installs and runs nicely.
> 
> Magnus
> 
> 
> 
> 
> 
> 
> 

-- 
  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 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] FreeBSD 4.7: BETA3 (from port): regression failures...

[Bruce Momjian]

Larry Rosenman wrote:
> On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> > 
> > See the resultmap file in the regression directory.  I see:
> > 
> > geometry/.*-bsdi=geometry-bsdi-precision
> > geometry/.*-darwin=geometry-powerpc-darwin
> > geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
> > geometry/alpha.*-freebsd=geometry-positive-zeros
> > geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
> > geometry/sparc-.*-openbsd=geometry-positive-zeros
> > geometry/.*-irix6=geometry-irix
> > geometry/.*-netbsd=geometry-positive-zeros
> > geometry/.*-sysv5.*:cc=geometry-uw7-cc
> > geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 
> > 
> > I assume we need to modify the FreeBSD entries.  Once you give me a
> > string to match your OS, I will rename geometry-bsdi-precision to
> > something non-OS specific.  I assume we need a string that is 4.7-only.
> geometry/i.86-.*-freebsd4.7= 
> 
> I think...
> 
> I don't see where it picks out the release? 

resultmap is read by pg_regress.sh.

-- 
  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] FreeBSD 4.7: BETA3 (from port): regression failures...

[Bruce Momjian]

OK, I just updated CVS to add a freebsd 4.7 entry to use the bsdi
output.  Please update cvs and let me know if it passes now.  Thanks.

---

Larry Rosenman wrote:
> On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> > 
> > See the resultmap file in the regression directory.  I see:
> > 
> > geometry/.*-bsdi=geometry-bsdi-precision
> > geometry/.*-darwin=geometry-powerpc-darwin
> > geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
> > geometry/alpha.*-freebsd=geometry-positive-zeros
> > geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
> > geometry/sparc-.*-openbsd=geometry-positive-zeros
> > geometry/.*-irix6=geometry-irix
> > geometry/.*-netbsd=geometry-positive-zeros
> > geometry/.*-sysv5.*:cc=geometry-uw7-cc
> > geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 
> > 
> > I assume we need to modify the FreeBSD entries.  Once you give me a
> > string to match your OS, I will rename geometry-bsdi-precision to
> > something non-OS specific.  I assume we need a string that is 4.7-only.
> geometry/i.86-.*-freebsd4.7= 
> 
> I think...
> 
> I don't see where it picks out the release? 
> 
> LER
> 
> > 
> > 
> > ---
> > 
> > Larry Rosenman wrote:
> > > On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> > > > On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> > > > Ignore the first one, stupid me forgot about permissions.  
> > > > 
> > > > Here is the real one (horology and geometry):
> > > > (and I expect horology is due to DST change day). 
> > > The geometry on FreeBSD4.7 MATCHES EXACTLY geometry-bsdi-precision.out. 
> > > $ diff -c ../expected/geometry-bsdi-precision.out geometry.out 
> > > $ 
> > > 
> > > So, how can we change the resultmap to take the 4.7 stuff into account?
> > > 
> > > 
> > > 
> > > > 
> > > > LER
> > > > 
> > > > 
> > > > 
> > > > *** ./expected/geometry-positive-zeros-bsd.out  Tue Sep 12 16:07:16 2000
> > > > --- ./results/geometry.out  Mon Oct 28 00:15:32 2002
> > > > ***
> > > > *** 114,120 
> > > >   | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
> > > >   | (-5,-12)   | [(1,2),(3,4)] | (1,2)
> > > >   | (10,10)| [(1,2),(3,4)] | (3,4)
> > > > ! | (0,0)  | [(0,0),(6,6)] | (0,0)
> > > >   | (-10,0)| [(0,0),(6,6)] | (0,0)
> > > >   | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
> > > >   | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
> > > > --- 114,120 
> > > >   | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
> > > >   | (-5,-12)   | [(1,2),(3,4)] | (1,2)
> > > >   | (10,10)| [(1,2),(3,4)] | (3,4)
> > > > ! | (0,0)  | [(0,0),(6,6)] | (-0,0)
> > > >   | (-10,0)| [(0,0),(6,6)] | (0,0)
> > > >   | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
> > > >   | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
> > > > ***
> > > > *** 224,233 
> > > >twentyfour |  rotation   
> > > >   +-
> > > >   | (0,0),(0,0)
> > > > ! | (0,0),(-20,-20)
> > > > ! | (0,2),(-14,0)
> > > >   | (0,79.2),(-58.8,0)
> > > > ! | (14,0),(0,-34)
> > > >   | (0,40),(0,0)
> > > >   | (0,0),(0,0)
> > > >   | (-10,-10),(-30,-30)
> > > > --- 224,233 
> > > >twentyfour |  rotation   
> > > >   +-
> > > >   | (0,0),(0,0)
> > > > ! | (-0,0),(-20,-20)
> > > > ! | (-0,2),(-14,0)
> > > >   | (0,79.2),(-58.8,0)
> > > > ! | (14,-0),(0,-34)
> > > >   | (0,40),(0,0)
> > > >   | (0,0),(0,0)
> > > >   | (-10,-10),(-30,-30)
> > > > ***
> > > > *** 254,264 
> > > >  WHERE (p.f1 <-> point '(0,0)') >= 1;
> > > >twenty | rotation   
>   
> > > >   
>+---
> > > > ! | (0,0),(-0.2,-0.2)
> > > >   | (-0.1,-0.1),(-0.3,-0.3)
> > > >   | (-0.25,-0.25),(-0.25,-0.35)
> > > >   | (-0.3,-0.3),(-0.3,-0.3)
> > > > ! | (0.08,0),(0,-0.56)
> > > >   | (0.12,-0.28),(0.04,-0.84)
> > > >   | (0.26,-0.7),(0.1,-0.82)
> > > >   | (0.12,-0.84),(0.12,-0.84)
> > > > --- 254,264 
> > > >  WHERE (p.f1 <-> point '(0,0)') >= 1;
> > > >twenty | rotation   
>   
> > > >   
>+-

Re: [HACKERS] Request for supported platforms

[Magnus Naeslund(f)]

Linux alpha.

An Redhat 6.2, "Linux gsX 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002
alpha unknown" (ev56 ruffian).

gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)

./configure \
  --prefix=/usr/local/pgsql-7.3b3 \
  --with-maxbackends=512 \
  --with-tcl \
  --without-tk   \
  --with-perl\
  --with-openssl \
  --enable-odbc  \
  --with-CXX

The box passes every tests except Horology.
It's wintertime here aswell, as i read in some other report.

It installs and runs nicely.

Magnus







---(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] Request for supported platforms

[Bruce Momjian]

Strange.  I just got report from another OSX 10.2.1 user saying
regression tests passed:

 10.2.1, Adam Witney  ([EMAIL PROTECTED]>

The proper value seems to be:

15.3864610140472

or

15.3864610140473

in ./expected/geometry-powerpc-darwin.out.  Which is it, folks?

---

Tara Piorkowski wrote:
> Tom Lane wrote:
> 
> > Bruce Momjian  writes:
> >
> > >Folks. start sending in those plaform reports, OS name and version
> > >number please.
> >
> >
> > I've checked CVS tip on:
> > HPUX 10.20, using both gcc and vendor's cc
> > PPC Linux
> > Mac OS X 10.1
> 
> 
> Here's the regression.diffs file from Mac OS X 10.2.1 (Jaguar). It 
> failed geometry (rounding) and horology (not sure). gcc -v returns 
> "Apple Computer, Inc. GCC version 1161, based on gcc version 3.1 
> 20020420 (prerelease)".
> 
> 
> *** ./expected/geometry-powerpc-darwin.out  Mon Dec 11 11:45:16 2000
> --- ./results/geometry.out  Sun Oct 27 21:27:11 2002
> ***
> *** 127,133 
>| (-5,-12)   | [(10,-10),(-3,-4)]| 
> (-1.60487804878049,-4.64390243902439)
>| (10,10)| [(10,-10),(-3,-4)]| 
> (2.39024390243902,-6.48780487804878)
>| (0,0)  | [(-100,200),(30,-40)] | 
> (0.0028402365895872,15.384614860264)
> ! | (-10,0)| [(-100,200),(30,-40)] | 
> (-9.99715942258202,15.3864610140472)
>| (-3,4) | [(-100,200),(30,-40)] | 
> (-2.99789812267519,15.3851688427303)
>| (5.1,34.5) | [(-100,200),(30,-40)] | 
> (5.09647083221496,15.3836744976925)
>| (-5,-12)   | [(-100,200),(30,-40)] | 
> (-4.99494420845634,15.3855375281616)
> --- 127,133 
>| (-5,-12)   | [(10,-10),(-3,-4)]| 
> (-1.60487804878049,-4.64390243902439)
>| (10,10)| [(10,-10),(-3,-4)]| 
> (2.39024390243902,-6.48780487804878)
>| (0,0)  | [(-100,200),(30,-40)] | 
> (0.0028402365895872,15.384614860264)
> ! | (-10,0)| [(-100,200),(30,-40)] | 
> (-9.99715942258202,15.3864610140473)
>| (-3,4) | [(-100,200),(30,-40)] | 
> (-2.99789812267519,15.3851688427303)
>| (5.1,34.5) | [(-100,200),(30,-40)] | 
> (5.09647083221496,15.3836744976925)
>| (-5,-12)   | [(-100,200),(30,-40)] | 
> (-4.99494420845634,15.3855375281616)
> 
> ==
> 
> *** ./expected/horology.out Wed Sep 18 17:35:25 2002
> --- ./results/horology.out  Sun Oct 27 21:27:12 2002
> ***
> *** 537,549 
>SELECT (timestamp with time zone 'today' = (timestamp with time zone 
> 'tomorrow' - interval '1 day')) as "True";
> True
>--
> !  t
>(1 row)
> 
>SELECT (timestamp with time zone 'tomorrow' = (timestamp with time 
> zone 'yesterday' + interval '2 days')) as "True";
> True
>--
> !  t
>(1 row)
> 
>SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
> --- 537,549 
>SELECT (timestamp with time zone 'today' = (timestamp with time zone 
> 'tomorrow' - interval '1 day')) as "True";
> True
>--
> !  f
>(1 row)
> 
>SELECT (timestamp with time zone 'tomorrow' = (timestamp with time 
> zone 'yesterday' + interval '2 days')) as "True";
> True
>--
> !  f
>(1 row)
> 
>SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
> 
> ==
> 
> 
> -- 
> Tara Piorkowski
> System Administrator, vilaj.com, LLC
> 
> 
> 
> ---(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
> 

-- 
  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 4: Don't 'kill -9' the postmaster

Re: [HACKERS] FreeBSD 4.7: BETA3 (from port): regression failures...

[Larry Rosenman]

On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> 
> See the resultmap file in the regression directory.  I see:
> 
>   geometry/.*-bsdi=geometry-bsdi-precision
>   geometry/.*-darwin=geometry-powerpc-darwin
>   geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
>   geometry/alpha.*-freebsd=geometry-positive-zeros
>   geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
>   geometry/sparc-.*-openbsd=geometry-positive-zeros
>   geometry/.*-irix6=geometry-irix
>   geometry/.*-netbsd=geometry-positive-zeros
>   geometry/.*-sysv5.*:cc=geometry-uw7-cc
>   geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 
> 
> I assume we need to modify the FreeBSD entries.  Once you give me a
> string to match your OS, I will rename geometry-bsdi-precision to
> something non-OS specific.  I assume we need a string that is 4.7-only.
geometry/i.86-.*-freebsd4.7= 

I think...

I don't see where it picks out the release? 

LER

> 
> 
> ---
> 
> Larry Rosenman wrote:
> > On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> > > On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> > > Ignore the first one, stupid me forgot about permissions.  
> > > 
> > > Here is the real one (horology and geometry):
> > > (and I expect horology is due to DST change day). 
> > The geometry on FreeBSD4.7 MATCHES EXACTLY geometry-bsdi-precision.out. 
> > $ diff -c ../expected/geometry-bsdi-precision.out geometry.out 
> > $ 
> > 
> > So, how can we change the resultmap to take the 4.7 stuff into account?
> > 
> > 
> > 
> > > 
> > > LER
> > > 
> > > 
> > > 
> > > *** ./expected/geometry-positive-zeros-bsd.outTue Sep 12 16:07:16 2000
> > > --- ./results/geometry.outMon Oct 28 00:15:32 2002
> > > ***
> > > *** 114,120 
> > >   | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
> > >   | (-5,-12)   | [(1,2),(3,4)] | (1,2)
> > >   | (10,10)| [(1,2),(3,4)] | (3,4)
> > > ! | (0,0)  | [(0,0),(6,6)] | (0,0)
> > >   | (-10,0)| [(0,0),(6,6)] | (0,0)
> > >   | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
> > >   | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
> > > --- 114,120 
> > >   | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
> > >   | (-5,-12)   | [(1,2),(3,4)] | (1,2)
> > >   | (10,10)| [(1,2),(3,4)] | (3,4)
> > > ! | (0,0)  | [(0,0),(6,6)] | (-0,0)
> > >   | (-10,0)| [(0,0),(6,6)] | (0,0)
> > >   | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
> > >   | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
> > > ***
> > > *** 224,233 
> > >twentyfour |  rotation   
> > >   +-
> > >   | (0,0),(0,0)
> > > ! | (0,0),(-20,-20)
> > > ! | (0,2),(-14,0)
> > >   | (0,79.2),(-58.8,0)
> > > ! | (14,0),(0,-34)
> > >   | (0,40),(0,0)
> > >   | (0,0),(0,0)
> > >   | (-10,-10),(-30,-30)
> > > --- 224,233 
> > >twentyfour |  rotation   
> > >   +-
> > >   | (0,0),(0,0)
> > > ! | (-0,0),(-20,-20)
> > > ! | (-0,2),(-14,0)
> > >   | (0,79.2),(-58.8,0)
> > > ! | (14,-0),(0,-34)
> > >   | (0,40),(0,0)
> > >   | (0,0),(0,0)
> > >   | (-10,-10),(-30,-30)
> > > ***
> > > *** 254,264 
> > >  WHERE (p.f1 <-> point '(0,0)') >= 1;
> > >twenty | rotation 
> 
> > >   
>+---
> > > ! | (0,0),(-0.2,-0.2)
> > >   | (-0.1,-0.1),(-0.3,-0.3)
> > >   | (-0.25,-0.25),(-0.25,-0.35)
> > >   | (-0.3,-0.3),(-0.3,-0.3)
> > > ! | (0.08,0),(0,-0.56)
> > >   | (0.12,-0.28),(0.04,-0.84)
> > >   | (0.26,-0.7),(0.1,-0.82)
> > >   | (0.12,-0.84),(0.12,-0.84)
> > > --- 254,264 
> > >  WHERE (p.f1 <-> point '(0,0)') >= 1;
> > >twenty | rotation 
> 
> > >   
>+---
> > > ! | (0,-0),(-0.2,-0.2)
> > >   | (-0.1,-0.1),(-0.3,-0.3)
> > >   | (-0.25,-0.25),(-0.25,-0.35)
> > >   | (-0.3,-0.3),(-0.3,-0.3)
> > > ! | (0.08,-0),(0,-0.56)
> > >   | (0.12,-0.28),(0.04,-0.84)
> > >   | (0.26,-0.7),(0.1,-0.82)
> > >   | (0.12,-0.84),(0.12,-0.84)
> > > ***
> > > *** 266,272 
> > >   

Re: [HACKERS] FreeBSD 4.7: BETA3 (from port): regression failures...

[Bruce Momjian]

See the resultmap file in the regression directory.  I see:

geometry/.*-bsdi=geometry-bsdi-precision
geometry/.*-darwin=geometry-powerpc-darwin
geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
geometry/alpha.*-freebsd=geometry-positive-zeros
geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
geometry/sparc-.*-openbsd=geometry-positive-zeros
geometry/.*-irix6=geometry-irix
geometry/.*-netbsd=geometry-positive-zeros
geometry/.*-sysv5.*:cc=geometry-uw7-cc
geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 

I assume we need to modify the FreeBSD entries.  Once you give me a
string to match your OS, I will rename geometry-bsdi-precision to
something non-OS specific.  I assume we need a string that is 4.7-only.


---

Larry Rosenman wrote:
> On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> > On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> > Ignore the first one, stupid me forgot about permissions.  
> > 
> > Here is the real one (horology and geometry):
> > (and I expect horology is due to DST change day). 
> The geometry on FreeBSD4.7 MATCHES EXACTLY geometry-bsdi-precision.out. 
> $ diff -c ../expected/geometry-bsdi-precision.out geometry.out 
> $ 
> 
> So, how can we change the resultmap to take the 4.7 stuff into account?
> 
> 
> 
> > 
> > LER
> > 
> > 
> > 
> > *** ./expected/geometry-positive-zeros-bsd.out  Tue Sep 12 16:07:16 2000
> > --- ./results/geometry.out  Mon Oct 28 00:15:32 2002
> > ***
> > *** 114,120 
> >   | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
> >   | (-5,-12)   | [(1,2),(3,4)] | (1,2)
> >   | (10,10)| [(1,2),(3,4)] | (3,4)
> > ! | (0,0)  | [(0,0),(6,6)] | (0,0)
> >   | (-10,0)| [(0,0),(6,6)] | (0,0)
> >   | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
> >   | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
> > --- 114,120 
> >   | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
> >   | (-5,-12)   | [(1,2),(3,4)] | (1,2)
> >   | (10,10)| [(1,2),(3,4)] | (3,4)
> > ! | (0,0)  | [(0,0),(6,6)] | (-0,0)
> >   | (-10,0)| [(0,0),(6,6)] | (0,0)
> >   | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
> >   | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
> > ***
> > *** 224,233 
> >twentyfour |  rotation   
> >   +-
> >   | (0,0),(0,0)
> > ! | (0,0),(-20,-20)
> > ! | (0,2),(-14,0)
> >   | (0,79.2),(-58.8,0)
> > ! | (14,0),(0,-34)
> >   | (0,40),(0,0)
> >   | (0,0),(0,0)
> >   | (-10,-10),(-30,-30)
> > --- 224,233 
> >twentyfour |  rotation   
> >   +-
> >   | (0,0),(0,0)
> > ! | (-0,0),(-20,-20)
> > ! | (-0,2),(-14,0)
> >   | (0,79.2),(-58.8,0)
> > ! | (14,-0),(0,-34)
> >   | (0,40),(0,0)
> >   | (0,0),(0,0)
> >   | (-10,-10),(-30,-30)
> > ***
> > *** 254,264 
> >  WHERE (p.f1 <-> point '(0,0)') >= 1;
> >twenty | rotation   
>   
> >   
>+---
> > ! | (0,0),(-0.2,-0.2)
> >   | (-0.1,-0.1),(-0.3,-0.3)
> >   | (-0.25,-0.25),(-0.25,-0.35)
> >   | (-0.3,-0.3),(-0.3,-0.3)
> > ! | (0.08,0),(0,-0.56)
> >   | (0.12,-0.28),(0.04,-0.84)
> >   | (0.26,-0.7),(0.1,-0.82)
> >   | (0.12,-0.84),(0.12,-0.84)
> > --- 254,264 
> >  WHERE (p.f1 <-> point '(0,0)') >= 1;
> >twenty | rotation   
>   
> >   
>+---
> > ! | (0,-0),(-0.2,-0.2)
> >   | (-0.1,-0.1),(-0.3,-0.3)
> >   | (-0.25,-0.25),(-0.25,-0.35)
> >   | (-0.3,-0.3),(-0.3,-0.3)
> > ! | (0.08,-0),(0,-0.56)
> >   | (0.12,-0.28),(0.04,-0.84)
> >   | (0.26,-0.7),(0.1,-0.82)
> >   | (0.12,-0.84),(0.12,-0.84)
> > ***
> > *** 266,272 
> >   | 
>(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
> >   | 
>(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
> >   | 
>(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
> > ! | (0,0.0828402366863905),(-0.20118343195266

Re: [HACKERS] FreeBSD 4.7: BETA3 (from port): regression failures...

[Larry Rosenman]

On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> Ignore the first one, stupid me forgot about permissions.  
> 
> Here is the real one (horology and geometry):
> (and I expect horology is due to DST change day). 
The geometry on FreeBSD4.7 MATCHES EXACTLY geometry-bsdi-precision.out. 
$ diff -c ../expected/geometry-bsdi-precision.out geometry.out 
$ 

So, how can we change the resultmap to take the 4.7 stuff into account?



> 
> LER
> 
> 
> 
> *** ./expected/geometry-positive-zeros-bsd.outTue Sep 12 16:07:16 2000
> --- ./results/geometry.outMon Oct 28 00:15:32 2002
> ***
> *** 114,120 
>   | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
>   | (-5,-12)   | [(1,2),(3,4)] | (1,2)
>   | (10,10)| [(1,2),(3,4)] | (3,4)
> ! | (0,0)  | [(0,0),(6,6)] | (0,0)
>   | (-10,0)| [(0,0),(6,6)] | (0,0)
>   | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
>   | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
> --- 114,120 
>   | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
>   | (-5,-12)   | [(1,2),(3,4)] | (1,2)
>   | (10,10)| [(1,2),(3,4)] | (3,4)
> ! | (0,0)  | [(0,0),(6,6)] | (-0,0)
>   | (-10,0)| [(0,0),(6,6)] | (0,0)
>   | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
>   | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
> ***
> *** 224,233 
>twentyfour |  rotation   
>   +-
>   | (0,0),(0,0)
> ! | (0,0),(-20,-20)
> ! | (0,2),(-14,0)
>   | (0,79.2),(-58.8,0)
> ! | (14,0),(0,-34)
>   | (0,40),(0,0)
>   | (0,0),(0,0)
>   | (-10,-10),(-30,-30)
> --- 224,233 
>twentyfour |  rotation   
>   +-
>   | (0,0),(0,0)
> ! | (-0,0),(-20,-20)
> ! | (-0,2),(-14,0)
>   | (0,79.2),(-58.8,0)
> ! | (14,-0),(0,-34)
>   | (0,40),(0,0)
>   | (0,0),(0,0)
>   | (-10,-10),(-30,-30)
> ***
> *** 254,264 
>  WHERE (p.f1 <-> point '(0,0)') >= 1;
>twenty | rotation 
> 
>   
>+---
> ! | (0,0),(-0.2,-0.2)
>   | (-0.1,-0.1),(-0.3,-0.3)
>   | (-0.25,-0.25),(-0.25,-0.35)
>   | (-0.3,-0.3),(-0.3,-0.3)
> ! | (0.08,0),(0,-0.56)
>   | (0.12,-0.28),(0.04,-0.84)
>   | (0.26,-0.7),(0.1,-0.82)
>   | (0.12,-0.84),(0.12,-0.84)
> --- 254,264 
>  WHERE (p.f1 <-> point '(0,0)') >= 1;
>twenty | rotation 
> 
>   
>+---
> ! | (0,-0),(-0.2,-0.2)
>   | (-0.1,-0.1),(-0.3,-0.3)
>   | (-0.25,-0.25),(-0.25,-0.35)
>   | (-0.3,-0.3),(-0.3,-0.3)
> ! | (0.08,-0),(0,-0.56)
>   | (0.12,-0.28),(0.04,-0.84)
>   | (0.26,-0.7),(0.1,-0.82)
>   | (0.12,-0.84),(0.12,-0.84)
> ***
> *** 266,272 
>   | 
>(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
>   | 
>(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
>   | 
>(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
> ! | (0,0.0828402366863905),(-0.201183431952663,0)
>   | 
>(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
>   | 
>(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
>   | 
>(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
> --- 266,272 
>   | 
>(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
>   | 
>(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
>   | 
>(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
> ! | (-0,0.0828402366863905),(-0.201183431952663,0)
>   | 
>(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
>   | 
>(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
>   | 
>(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
> 
> ==
> 
> *** ./expected/horology.out   Wed Sep 18 16:35:25

Re: [HACKERS] 7.3b3 on MacOSX 10.2.1

[Bruce Momjian]

Ports list updated:

  http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html

---
Adam Witney wrote:
> 
> Just to update the list of supported platforms, 7.3b3 compiles and passes
> all the regression tests on MacOSX 10.2.1
> 
> Although don't know if this is relevant but this appears when running the
> tests:
> 
> parallel group (20 tests): ./pg_regress: fork: Resource temporarily
> unavailable
> ./pg_regress: fork: Resource temporarily unavailable
>  comments lseg box path timetz point circle reltime tinterval date inet
> interval timestamp time abstime polygon timestamptz oidjoins
> 
> Cheers
> 
> Adam
> 
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
> 
> 
> ---(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
> 

-- 
  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] string freeze

[Bruce Momjian]

Dennis Björklund wrote:
> Is there a planned string freeze for postgresql?
> 
> There was a (good) change some weeks ago that altered lots of witespace.
> Remember that it's enough to change a single space to make that
> translation of that string not work. To do "psql --help" and get half the
> entries in swedish and half in english would be ugly. I sent an update a
> couple of days ago that fixes the swedish translation. I'm not sure about
> the status of the other languages. Now I'm just planning for the release
> and to prevent us from getting into a situation where strings are altered
> the day before the release or something.
> 
> There have been a lot work with the translations and would be nice if it
> works in the release.

This is a good question.  We only added translations in 7.2 so we are
still learning how to get those languages updated.  There should be
_very_ few changes from now until 7.3 final.  We need to keep in mind
that changes affect the translators.

-- 
  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 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Request for supported platforms

[Bruce Momjian]

Ports list updated:

  http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html

---
Andrew Sullivan wrote:
> On Mon, Oct 28, 2002 at 05:32:04PM -0500, Andrew Sullivan wrote:
> > Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests
> > pass.  Solaris 8 forthcoming.
> 
> I should have mentioned that this is for beta 3; I don't have the
> necessary bison installed to compile from CVS.
> 
> Solaris 8, 2xUltraSPARC-II 400 MHz, 3G RAM, gcc 3.2 also passes.
> 
> The details I'll put in the regression database.
> 
> A
> 
> -- 
> 
> Andrew Sullivan 204-4141 Yonge Street
> Liberty RMS   Toronto, Ontario Canada
> <[EMAIL PROTECTED]>  M2P 2A8
>  +1 416 646 3304 x110
> 
> 
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] About the Request for supported platforms

[Magnus Naeslund(f)]

Is there i faq item or maybe some other way that we can tell users
that --disable-rpath should be used when checking regressiontests if you
have an install already on the box?
The rpath defaults to the installdir even in the temporary install that
is made when doing "gmake check", and that confuses some programs (like
pg_encoding) because it loads the installed libpq. In my case that's an
old install running in production state.

There are tools that set the rpath on an already linked executable, but
i dunno if that feels appropriate. But maybe an warning in "gmake check"
would be nice.

Magnus

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 Programmer/Networker [|] Magnus Naeslund
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


---(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] Request for supported platforms

[Bruce Momjian]

Ports list updated:

  http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html

---
Andrew Sullivan wrote:
> On Fri, Oct 25, 2002 at 10:17:22PM -0400, Bruce Momjian wrote:
> > OK, Tom will be away next week, and Thomas will too. I can do it. 
> > Folks. start sending in those plaform reports, OS name and version
> > number please.
> 
> Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests
> pass.  Solaris 8 forthcoming.
> 
> A 
> 
> -- 
> 
> Andrew Sullivan 204-4141 Yonge Street
> Liberty RMS   Toronto, Ontario Canada
> <[EMAIL PROTECTED]>  M2P 2A8
>  +1 416 646 3304 x110
> 
> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

-- 
  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 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Trigger on 'create table' ?

[Paul Ramsey]

We have a similar requirement for PostGIS.
In order to meet the OpenGIS specification, we have to maintain a 
GEOMETRY_COLUMNS table which includes an entry for every column in the 
db which holds a spatial column. It would be ideal if we could have 
triggers run on CREATE TABLE, DROP TABLE, and ALTER TABLE to watch for 
the comings and goings of spatial columns and update GEOMETRY_COLUMNS 
appropriately.
Unfortunately, triggers seem to not be allowed on system tables, or we 
would just watch pg_class for new geometry columns and update the 
OpenGIS table as necessary. :/


Bruce Momjian wrote:
Sorry, I can't think of any to have a view created automatically for
every table creation.  Interesting idea, though.  I wonder if you could
pass the CREATE string into a function that does the proper creation.

---

Bruce David wrote:


All,

I'm trying to implement row level security using PostgreSQL.  I envision
having column on each and every table in the database that will contain a
discriminating value that determines if a given user is able to see that row
or not.  Users do not directly access the database; they get at it only
through client applications.

Is there a way to initially configure PostgreSQL such that each and every
time a 'create table foo' command is executed that, something else would
happen instead?

For example,

CREATE TABLE weather (
   cityvarchar(80),
   loint,
   hiint,
   prcpreal,
   datedate
);

would result in the following being executed automatically:

CREATE TABLE t_weather (
   cityvarchar(80),
   loint,
   hiint,
   prcpreal,
   datedate,
   hidden_columnint
);

CREATE VIEW weather AS
   SELECT city, lo, hi, prcp, date
   FROM t_weather;


How the view gets populated is another discussion entirely.

But is there a way to set things up initially such that each 'create table'
command will exhibit the behavior described above?

Thanks.

--

Bruce





---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html








---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Trigger on 'create table' ?

[Bruce Momjian]

Sorry, I can't think of any to have a view created automatically for
every table creation.  Interesting idea, though.  I wonder if you could
pass the CREATE string into a function that does the proper creation.

---

Bruce David wrote:
> All,
> 
> I'm trying to implement row level security using PostgreSQL.  I envision
> having column on each and every table in the database that will contain a
> discriminating value that determines if a given user is able to see that row
> or not.  Users do not directly access the database; they get at it only
> through client applications.
> 
> Is there a way to initially configure PostgreSQL such that each and every
> time a 'create table foo' command is executed that, something else would
> happen instead?
> 
> For example,
> 
> CREATE TABLE weather (
> cityvarchar(80),
> loint,
> hiint,
> prcpreal,
> datedate
> );
> 
> would result in the following being executed automatically:
> 
> CREATE TABLE t_weather (
> cityvarchar(80),
> loint,
> hiint,
> prcpreal,
> datedate,
> hidden_columnint
> );
> 
> CREATE VIEW weather AS
> SELECT city, lo, hi, prcp, date
> FROM t_weather;
> 
> 
> How the view gets populated is another discussion entirely.
> 
> But is there a way to set things up initially such that each 'create table'
> command will exhibit the behavior described above?
> 
> Thanks.
> 
> --
> 
> Bruce
> 
> 
> 
> 
> 
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/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 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] Request for supported platforms

[Bruce Momjian]

Sorry, Ian, here is the patch I applied.  You can apply this to whatever
version you are using and test Irix with that, rather than having to
grab CVS.

---

Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Ports list updated:
> 
> Shouldn't the "join" regression test failure be fixed?
> 
> Cheers,
> 
> Neil
> 
> -- 
> Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC
> 
> 
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/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

? config.log
? GNUmakefile
? config.status
? autom4te.cache
? configure.lineno
? contrib/retep/build
? contrib/retep/jars
? src/log
? src/Makefile.custom
? src/Makefile.global
? src/backend/postgres
? src/backend/catalog/postgres.bki
? src/backend/catalog/postgres.description
? src/backend/utils/mb/conversion_procs/conversion_create.sql
? src/backend/utils/mb/conversion_procs/ascii_and_mic/libascii_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/cyrillic_and_mic/libcyrillic_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/euc_cn_and_mic/libeuc_cn_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/euc_jp_and_sjis/libeuc_jp_and_sjis.so.0.0
? src/backend/utils/mb/conversion_procs/euc_kr_and_mic/libeuc_kr_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/euc_tw_and_big5/libeuc_tw_and_big5.so.0.0
? src/backend/utils/mb/conversion_procs/latin2_and_win1250/liblatin2_and_win1250.so.0.0
? src/backend/utils/mb/conversion_procs/latin_and_mic/liblatin_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_ascii/libutf8_and_ascii.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_big5/libutf8_and_big5.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_cyrillic/libutf8_and_cyrillic.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_euc_cn/libutf8_and_euc_cn.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_euc_jp/libutf8_and_euc_jp.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_euc_kr/libutf8_and_euc_kr.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_euc_tw/libutf8_and_euc_tw.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_gb18030/libutf8_and_gb18030.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_gbk/libutf8_and_gbk.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_iso8859/libutf8_and_iso8859.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_iso8859_1/libutf8_and_iso8859_1.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_johab/libutf8_and_johab.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_sjis/libutf8_and_sjis.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_tcvn/libutf8_and_tcvn.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_uhc/libutf8_and_uhc.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_win1250/libutf8_and_win1250.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_win1256/libutf8_and_win1256.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_win874/libutf8_and_win874.so.0.0
? src/bin/initdb/initdb
? src/bin/initlocation/initlocation
? src/bin/ipcclean/ipcclean
? src/bin/pg_config/pg_config
? src/bin/pg_controldata/pg_controldata
? src/bin/pg_ctl/pg_ctl
? src/bin/pg_dump/pg_dump
? src/bin/pg_dump/pg_restore
? src/bin/pg_dump/pg_dumpall
? src/bin/pg_encoding/pg_encoding
? src/bin/pg_id/pg_id
? src/bin/pg_resetxlog/pg_resetxlog
? src/bin/psql/psql
? src/bin/psql/i
? src/bin/scripts/createlang
? src/include/pg_config.h
? src/include/stamp-h
? src/interfaces/ecpg/lib/libecpg.so.3.4.0
? src/interfaces/ecpg/preproc/ecpg
? src/interfaces/jdbc/build
? src/interfaces/jdbc/jars
? src/interfaces/libpq/libpq.so.2.2
? src/pl/plpgsql/src/libplpgsql.so.1.0
? src/test/regress/pg_regress
? src/test/regress/results
? src/test/regress/regression.out
? src/test/regress/regression.diffs
? src/test/regress/expected/copy.out
? src/test/regress/expected/create_function_1.out
? src/test/regress/expected/create_function_2.out
? src/test/regress/expected/misc.out
? src/test/regress/expected/constraints.out
? src/test/regress/sql/copy.sql
? src/test/regress/sql/create_function_1.sql
? src/test/regress/sql/create_function_2.sql
? src/test/regress/sql/misc.sql
? src/test/regress/sql/constraints.sql
Index: src/test/regress/expected/join.out
===
RCS file: /cvsroot/pgsql-server/src/test/regress/expected/join.out,v
retrieving revision 1.11
retrieving revision 1.12
diff -c -c -r1.11 -r1.12
*** src/test/regress/expected/join.out  28 Apr 2002 19:54:29 -  1.11
--- src/test/regress/expected/join.out  28 Oct 2002 22:54:45 -  1.12
**

Re: [HACKERS] Turning the PLANNER off

[Bruce Momjian]

 
That is a good question.  The planner does more than just analyse the
query.  It generates the Plan used by the executor, so that can't be
removed.

It is always a pain when the optimizer/planner takes longer than the
executor. We do have PREPARE/EXECUTE in 7.3beta for you to use.


---

Ben McMahan wrote:
> I'm looking at different ways of optimizing queries with a large number of
> joins.  I write the same query in a number of different ways and compare
> the running times.  Now the problem is I do not want the optimizer
> changing the queries.  So I explicit state the order of the joins in the
> FROM clause.  I also turn off everything I can except for one type of join
> (say hash join), and I've turned off geqo.  But I find that the PLANNER
> still takes an enormous amount of time for some queries.  It doesn't look
> like the Planner is actually optimizing (changing) anything, but just in
> case, I was wondering if there was a way to turn off the PLANNER.
> 
> Note, when I say an enormous amount of time, I mean at least double the
> time the EXECUTOR takes to actually answer the query.
> 
> Thanks for your help,
> 
> Ben McMahan
> 
> ps. here is a small example of what my queries look like (so you can see
> if there is something else it might be deciding on):
> 
> SELECT DISTINCT c0.x1 , c1.x2 , c0.x3 , c0.x4 , c2.x5
> FROM r1 c4 (x4,x2,x5) JOIN (r0 c3 (x2,x3,x5) JOIN (r2 c2 (x3,x1,x5) JOIN (r1 c1
> (x4,x1,x2) JOIN r1 c0 (x1,x3,x4)
> ON ( c0.x4 = c1.x4  AND  c0.x1 = c1.x1 ))
> ON ( c0.x3 = c2.x3  AND  c0.x1 = c2.x1 ))
> ON ( c1.x2 = c3.x2  AND  c0.x3 = c3.x3  AND  c2.x5 = c3.x5 ))
> ON ( c0.x4 = c4.x4  AND  c1.x2 = c4.x2  AND  c2.x5 = c4.x5 );
> 
> A quick reminder, FROM r1 c4 (x4,x2,x5) just renames a table r1 into c4
> where it also renames the columns to x4, x2, and x5 respectively.
> 
> 
> ---(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
> 

-- 
  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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Request for supported platforms

[Andrew Sullivan]

On Mon, Oct 28, 2002 at 05:32:04PM -0500, Andrew Sullivan wrote:
> Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests
> pass.  Solaris 8 forthcoming.

I should have mentioned that this is for beta 3; I don't have the
necessary bison installed to compile from CVS.

Solaris 8, 2xUltraSPARC-II 400 MHz, 3G RAM, gcc 3.2 also passes.

The details I'll put in the regression database.

A

-- 

Andrew Sullivan 204-4141 Yonge Street
Liberty RMS   Toronto, Ontario Canada
<[EMAIL PROTECTED]>  M2P 2A8
 +1 416 646 3304 x110


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Request for supported platforms

[Ian Barwick]

On Tuesday 29 October 2002 00:08, Bruce Momjian wrote:
> Neil Conway wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > Ports list updated:
> >
> > Shouldn't the "join" regression test failure be fixed?
>
> OK, I have updated the join regression test to add ORDER BY in the
> queries Irix differed.  Ian, would you retest the CVS version of
> PostgreSQL to see if all the regression tests pass now?

For confirmation: IIRC CVS now requires the latest Bison (1.75)?
(The Irix machine has 1.35).

Ian Barwick
[EMAIL PROTECTED]

 

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Request for supported platforms

[Bruce Momjian]

Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Ports list updated:
> 
> Shouldn't the "join" regression test failure be fixed?

OK, I have updated the join regression test to add ORDER BY in the
queries Irix differed.  Ian, would you retest the CVS version of
PostgreSQL to see if all the regression tests pass now?

-- 
  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 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Request for supported platforms

[Andrew Sullivan]

On Fri, Oct 25, 2002 at 10:17:22PM -0400, Bruce Momjian wrote:
> OK, Tom will be away next week, and Thomas will too. I can do it. 
> Folks. start sending in those plaform reports, OS name and version
> number please.

Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests
pass.  Solaris 8 forthcoming.

A 

-- 

Andrew Sullivan 204-4141 Yonge Street
Liberty RMS   Toronto, Ontario Canada
<[EMAIL PROTECTED]>  M2P 2A8
 +1 416 646 3304 x110


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] Request for supported platforms

[Larry Rosenman]

On Mon, 2002-10-28 at 14:58, Dave Page wrote:
> 
> > >
> > > My WAG is that you will be able to upgrade your Cygwin installation 
> > > before I fix the Cygwin build issues. :,)
> > 
> > I guess my WAG was wrong... :,)
> 
> I've been meaning to ask this for a while - what exactly is a WAG? :-)
Wild-A**ed-Guess, I would presume. 


-- 
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] Request for supported platforms

[Dave Page]

> -Original Message-
> From: Jason Tishler [mailto:jason@;tishler.net] 
> Sent: 28 October 2002 20:42
> To: Dave Page
> Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; 
> Tom Lane; Pgsql-Cygwin
> Subject: Re: [HACKERS] Request for supported platforms
> 
> 
> Dave,
> 
> On Mon, Oct 28, 2002 at 11:20:16AM -0500, Jason Tishler wrote:
> >
> > My WAG is that you will be able to upgrade your Cygwin installation 
> > before I fix the Cygwin build issues. :,)
> 
> I guess my WAG was wrong... :,)

I've been meaning to ask this for a while - what exactly is a WAG? :-)

> 1. Cygwin bison needs to be upgraded from 1.35 to 1.75 (i.e., 
> 1.50+) to process src/interfaces/ecpg/preproc/preproc.y 
> successfully.  I will post to the Cygwin mailing list asking 
> the maintainer for this upgrade.

OK. This shouldn't stop a release though I assume, only a build from
CVS.

> 2. The following fseeko/ftello ifdef in src/include/pg_config.h.in:
> 
> #ifndef HAVE_FSEEKO
> #define fseeko(a, b, c) fseek((a), (b), (c))
> #define ftello(a) ftell((a))
> #endif
> 
> conflicts with the following Cygwin /usr/include/stdio.h entries:
> 
> int _EXFUN(fseeko, (FILE *, off_t, int));
> off_t   _EXFUN(ftello, ( FILE *));
> 
> Unfortunately, I'm not sure what is the best way to solve 
> this one yet. Any suggestions would be appreciated.

Yes, I'm seeing errors with this on my updated Cygwin very early in the
build. I did think it was my hacked about installation, but I guess not!

Unfortunately though, I don't know the answer either, but I guess the
change was in Cygwin as I didn't see it before you asked me to upgrade.

Regards, Dave.

---(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] Request for supported platforms

[Jason Tishler]

Dave,

On Mon, Oct 28, 2002 at 11:20:16AM -0500, Jason Tishler wrote:
> On Mon, Oct 28, 2002 at 02:56:01PM -, Dave Page wrote:
> > Ok, but this is going to take a while as few of the mirrors seem to
> > have this release yet. I also need to download a new set of everything
> > for reasons I won't go into.
> 
> My WAG is that you will be able to upgrade your Cygwin installation
> before I fix the Cygwin build issues. :,)

I guess my WAG was wrong... :,)

Under the following platform:

$ uname -a
CYGWIN_NT-5.0 TISHLERJASON 1.3.14(0.62/3/2) 2002-10-23 14:47 i686 unknown

all make installcheck tests pass except for horology.  However, the
horology failure is to be expected due to the recent time change.

Unfortunately, there are some Cygwin build issues that I need to
address:

1. Cygwin bison needs to be upgraded from 1.35 to 1.75 (i.e., 1.50+) to
process src/interfaces/ecpg/preproc/preproc.y successfully.  I will post
to the Cygwin mailing list asking the maintainer for this upgrade.

2. The following fseeko/ftello ifdef in src/include/pg_config.h.in:

#ifndef HAVE_FSEEKO
#define fseeko(a, b, c) fseek((a), (b), (c))
#define ftello(a) ftell((a))
#endif

conflicts with the following Cygwin /usr/include/stdio.h entries:

int _EXFUN(fseeko, (FILE *, off_t, int));
off_t   _EXFUN(ftello, ( FILE *));

Unfortunately, I'm not sure what is the best way to solve this one yet.
Any suggestions would be appreciated.

Thanks,
Jason

---(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] plpq

[Bruce Momjian]

Would you tell us exactly what this is.

---

Darko Prenosil wrote:
>   Tree weeks later than I promised, but it is finished (I hope).
> 
> In attachment are files:
>   dblink.c
>   dblink.h
>   dblink.sql.in
>   pqtest.sql
> 
> In file pqtest.sql is sample queries and results. It seem OK to me.
> 
> There are two reasons why I did not make a diff.
> 
> 1. The source I started from is 7.3b1, not the latest.
> 2. I would like You to check the code, especially the part that touches memory 
> management. 
> I can say that it works, but I do not know exactly why, and this can be 
> dangerous. With my knowledge of postgres internals this is
> as far I can go at the moment. And once more sorry for bad English !
> 
> Regards !

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

> 
> ---(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

-- 
  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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] [ANNOUNCE] Server downtime ...

[Marc G. Fournier]

On 28 Oct 2002, Larry Rosenman wrote:

> On Mon, 2002-10-28 at 11:33, Marc G. Fournier wrote:
> >
> > Ummm .. by the fact that you see [ANNOUNCE] in the above subject, I did
> > send it to -announce :)
> I think he was saying that this was **NOT** stuff he wants to see on
> -ANNOUNCE.

Oops, just re-read, and you are right, that is what he said ...

i


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] Request for supported platforms

[Tom Lane]

"Dave Page" <[EMAIL PROTECTED]> writes:
>> Horology failures are normal for a day or so on either side 
>> of a DST change --- see the "regression tests interpretation" 
>> docs.  I have no time right now to examine the other diffs.

> The docs say:

> Some of the queries in the timestamp test will fail if you run the test
> on
> the day of a daylight-savings time changeover, or the day before or
> after
> one.

> Clocks changed at midnight Saturday so I figured a Monday morning run
> should be OK. Do they actually change on Sunday at 00:00:00 I wonder?
> I'll try again tomorrow.

In the US, DST changes occur at 02:00 Sunday, so the affected queries
actually fail starting at 00:00 Sunday and ending 00:00 Tuesday ---
but that's local time in PST8PDT.  The docs are vague because your local
time might vary considerably from that ...

regards, tom lane

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] pg_dump and large files - is this a problem?

[Tom Lane]

"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
> The problem with flex is, that the generated c file does #include 
> before we #include "postgres.h".
> In this situation _LARGE_FILES is not defined for unistd.h and unistd.h
> chooses to define _LARGE_FILE_API, those two are not compatible.

Yeah.  AFAICS the only way around this is to avoid doing any I/O
operations in the flex-generated files.  Fortunately, that's not much
of a restriction.

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] [ANNOUNCE] Server downtime ...

[Larry Rosenman]

On Mon, 2002-10-28 at 11:33, Marc G. Fournier wrote:
> 
> Ummm .. by the fact that you see [ANNOUNCE] in the above subject, I did
> send it to -announce :)
I think he was saying that this was **NOT** stuff he wants to see on
-ANNOUNCE. 

LER

-- 
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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] [ANNOUNCE] Server downtime ...

[Marc G. Fournier]

Ummm .. by the fact that you see [ANNOUNCE] in the above subject, I did
send it to -announce :)




On 28 Oct 2002, Adrian 'Dagurashibanipal' von Bidder wrote:

> Yo!
>
> Would it be sensible not to use -announce for such things? These bits
> are not really interesting if I'm subscribed to -announce to keep on top
> of what's happening wrt to new releases and such things.
>
> (Yes, I'm also subscribed to a few postgres lists, but I only read them
> when I have spare time. I don't filter announce, however, so the
> important things won't go unnoticed in case I don't look at list mail
> for a few weeks).
>
> cheers
> -- vbi
>
>
> On Sun, 2002-10-27 at 18:25, Marc G. Fournier wrote:
> >
> > Just a quick note that I'm going to be rebooting mars (the PostgreSQL.Org)
> > server later on this evening to upgrade the OS ... downtime should be no
> > more then 1 hour, unless something unforeseen happens ...
> >
> >
> >
> >
> > ---(end of broadcast)---
> > TIP 4: Don't 'kill -9' the postmaster
> --
> this email is protected by a digital signature:  http://fortytwo.ch/gpg
>
> NOTE: keyserver bugs! get my key here: https://fortytwo.ch/gpg/92082481
>


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] [ANNOUNCE] Server downtime ...

[Adrian 'Dagurashibanipal' von Bidder]

Yo!

Would it be sensible not to use -announce for such things? These bits
are not really interesting if I'm subscribed to -announce to keep on top
of what's happening wrt to new releases and such things.

(Yes, I'm also subscribed to a few postgres lists, but I only read them
when I have spare time. I don't filter announce, however, so the
important things won't go unnoticed in case I don't look at list mail
for a few weeks).

cheers
-- vbi


On Sun, 2002-10-27 at 18:25, Marc G. Fournier wrote:
> 
> Just a quick note that I'm going to be rebooting mars (the PostgreSQL.Org)
> server later on this evening to upgrade the OS ... downtime should be no
> more then 1 hour, unless something unforeseen happens ...
> 
> 
> 
> 
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster
-- 
this email is protected by a digital signature:  http://fortytwo.ch/gpg

NOTE: keyserver bugs! get my key here: https://fortytwo.ch/gpg/92082481



signature.asc
Description: This is a digitally signed message part

Re: [HACKERS] pg_dump and large files - is this a problem?

[Zeugswetter Andreas SB SD]

> > > The question is *which* seek APIs we need to support.  Are there any
> > > besides fseeko() and fgetpos()?
> > 
> > On AIX we have 
> > int fseeko64 (FILE* Stream, off64_t Offset, int Whence);
> > which is intended for large file access for programs that do NOT
> > #define _LARGE_FILES
> > 
> > It is functionality that is available if _LARGE_FILE_API is defined,
> > which is the default if _LARGE_FILES is not defined.
> > 
> > That would have been my preferred way of handling large files on AIX
> > in the two/three? places that need it (pg_dump/restore, psql and backend COPY).
> > This would have had the advantage that off_t is not 64 bit in all other places
> > where it is actually not needed, no ?
> 
> OK, I am focusing on AIX now.  I don't think we can go down the road of
> saying where large file support is needed or not needed.  I think for
> each platform either we support large files or we don't.  Is there a way
> to have off_t be 64 bits everywhere, and if it is, why wouldn't we just
> enable that rather than poke around figuring out where it is needed?

if _LARGE_FILES is defined, off_t is 64 bits on AIX (and fseeko works). 
The problem with flex is, that the generated c file does #include 
before we #include "postgres.h".
In this situation _LARGE_FILES is not defined for unistd.h and unistd.h
chooses to define _LARGE_FILE_API, those two are not compatible.

If a general off_t of 64 bits is no performance problem, we should focus
on fixing the #include  issue, and forget what I wanted/hinted.
Peter E. has a patch for this in his pipeline. I can give it a second try 
tomorrow.

Sorry for the late answer, I am very pressed currently :-(
Andreas

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] Request for supported platforms

[Larry Rosenman]

On Mon, 2002-10-28 at 10:20, Jason Tishler wrote:

> > > 2. Cygwin bison limit exceeded:
> > > 
> > > make[4]: Entering directory 
> > > `/home/jt/src/pgsql/src/interfaces/ecpg/preproc'
> > > [snip]
> > > bison -y -d  preproc.y
> > > preproc.y:5560: fatal error: maximum table size (32767) exceeded
> > 
> > I believe a new bison is required now. Don't know much about it other
> > than ecpg hit some limit or other and much discussion followed. Iirc,
> > it's only an issue when compiling from CVS, not a tarball.
> 
> The above should help save me some time.
1.50 of Bison fixed the issue, 1.75 works as well (current public
release). 

Just my $.02. 


> 
> Thanks,
> Jason
> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
-- 
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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] 7.3b3 build --with-perl fails on RH 8.0

[snpe]

Change directory in src/pl/plperl
and execute gcc command with option -D_GNU_SOURCE 
(2 files)
and then continue make form base directory
You must add /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/libperl.so in 
/etc/ld/so/conf or in LD_LIBRARY_PATH

regards
Haris Peco

On Monday 28 October 2002 12:41 pm, P.J. \"Josh\" Rovero wrote:
> RH 8.0 has perl 5.8, here are the details:
>
>  From config.log:
>
> configure:4159: checking for perl
> configure:4177: found /usr/bin/perl
> configure:4189: result: /usr/bin/perl
> configure:4198: checking for Perl archlibexp
> configure:4201: result: /usr/lib/perl5/5.8.0/i386-linux-thread-multi
> configure:4203: checking for Perl privlibexp
> configure:4206: result: /usr/lib/perl5/5.8.0
> configure:4208: checking for Perl useshrplib
> configure:4211: result: true
> configure:4214: checking for flags to link embedded Perl
> configure:4219: result:   -L/usr/local/lib
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/auto/DynaLoader/DynaLoader.a
> -L/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE -lperl -lnsl -ldl
> -lm -lpthread -lc -lcrypt -lutil
>
> from gmake:
> gmake[3]: Entering directory
> `/localhome/rovero/postgresql-7.3b3/src/pl/plperl'
> gcc -O2 -fpic -I. -I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE
> -I../../..
> /src/include   -c -o plperl.o plperl.c
> In file included from
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/op.h:480
> ,
>   from
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/perl.h:2
> 209,
>   from plperl.c:61:
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/reentr.h:602: field
> `_crypt_st
> ruct' has incomplete type
> In file included from
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/perl.h:3
> 368,
>   from plperl.c:61:
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:246: parse
> error befor
> e "off64_t"
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:248: parse
> error befor
> e "Perl_do_sysseek"
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:248: parse
> error befor
> e "off64_t"
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:248: warning:
> data def
> inition has no type or storage class
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:249: parse
> error befor
> e "Perl_do_tell"
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:249: warning:
> data def
> inition has no type or storage class
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:1378: parse
> error befo
> re "Perl_PerlIO_tell"
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:1378: warning:
> data de
> finition has no type or storage class
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:1379: parse
> error befo
> re "off64_t"
> gmake[3]: *** [plperl.o] Error 1
> gmake[3]: Leaving directory
> `/localhome/rovero/postgresql-7.3b3/src/pl/plperl'
> gmake[2]: *** [all] Error 2
> gmake[2]: Leaving directory `/localhome/rovero/postgresql-7.3b3/src/pl'
> gmake[1]: *** [all] Error 2
> gmake[1]: Leaving directory `/localhome/rovero/postgresql-7.3b3/src'
> gmake: *** [all] Error 2


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] Request for supported platforms

[Jason Tishler]

Dave,

On Mon, Oct 28, 2002 at 02:56:01PM -, Dave Page wrote:
> > -Original Message-
> > From: Jason Tishler [mailto:jason@;tishler.net] 
> > Sent: 28 October 2002 13:33
> > Subject: Re: [HACKERS] Request for supported platforms
> > 
> > Please try with Cygwin 1.3.14-1 while I attempt to deal with at
> > least the following Cygwin build issues with PostgreSQL CVS as of
> > today at about 7:00 AM EST:
> 
> Ok, but this is going to take a while as few of the mirrors seem to
> have this release yet. I also need to download a new set of everything
> for reasons I won't go into.

My WAG is that you will be able to upgrade your Cygwin installation
before I fix the Cygwin build issues. :,)

> Is there actually a reason for this though or are you just trying to
> keep me busy? :-) It can't be a good thing for us to require that
> people upgrade to the latest release of their OS.

Agreed, but sometimes a new Cygwin release fixes some problems and
breaks others...

> > 2. Cygwin bison limit exceeded:
> > 
> > make[4]: Entering directory 
> > `/home/jt/src/pgsql/src/interfaces/ecpg/preproc'
> > [snip]
> > bison -y -d  preproc.y
> > preproc.y:5560: fatal error: maximum table size (32767) exceeded
> 
> I believe a new bison is required now. Don't know much about it other
> than ecpg hit some limit or other and much discussion followed. Iirc,
> it's only an issue when compiling from CVS, not a tarball.

The above should help save me some time.

Thanks,
Jason

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [Fwd: Re: [HACKERS] UnixWare 7.1.3 (BETA), C99 compiler,

[Tom Lane]

Larry Rosenman <[EMAIL PROTECTED]> forwards:
>>> My inclination is to change the code for ApplySortFunction to look like
>>> 
>>> #if defined(__GNUC__)
>>> __inline__
>>> #endif
>>> int32
>>> ApplySortFunction
>>> 
>>> so that the inline optimization only gets done for gcc, which we know
>>> interprets inline sanely.  Anyone see a better answer?
>> 
>> You've given us one source file.  Is ApplySortFunction() really called
>> from other files?  Another approach, assuming both this and that the
>> inlining is viewed as important for its three calls within this file,

Yup, both of those are correct: the performance-critical calls are in
the same file, but there are others.

>> to have a front end version of an internal function.  To wit:
>> 
>> static inline int32
>> StaticApplySortFunction(FmgrInfo *sortFunction, SortFunctionKind kind,
>> Datum datum1, bool isNull1,
>> Datum datum2, bool isNull2)
>> {
>> //etc.
>> }
>> 
>> int32
>> ApplySortFunction(FmgrInfo *sortFunction, SortFunctionKind kind,
>> Datum datum1, bool isNull1,
>> Datum datum2, bool isNull2)

Grumble.  I suppose we have to do it that way, but it's really pretty
stupid.  Also, won't this fall foul of the original restriction
(ApplySortFunction referencing the static function myFunctionCall2)?
If not, why not?

> Until the open source base (and GCC) get around to matching the C99
> inline model,

Don't hold your breath... it looks like a net loss in functionality
for no gain, from where I sit.

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Request for supported platforms

[Dave Page]

> -Original Message-
> From: Tom Lane [mailto:tgl@;sss.pgh.pa.us] 
> Sent: 28 October 2002 15:53
> To: Jason Tishler
> Cc: Dave Page; Bruce Momjian; PostgreSQL-development; Thomas 
> Lockhart; Pgsql-Cygwin
> Subject: Re: [HACKERS] Request for supported platforms 
> 
> 
> >> Make installcheck also failed on horology, copy2 and domain - see 
> >> attached output.
> >> 
> >> The clocks changed here on Saturday night, so I guess that 
> shouldn't 
> >> have caused the first error (or should the docs be updated?).
> 
> Horology failures are normal for a day or so on either side 
> of a DST change --- see the "regression tests interpretation" 
> docs.  I have no time right now to examine the other diffs.

The docs say:


Some of the queries in the timestamp test will fail if you run the test
on
the day of a daylight-savings time changeover, or the day before or
after
one.


Clocks changed at midnight Saturday so I figured a Monday morning run
should be OK. Do they actually change on Sunday at 00:00:00 I wonder?
I'll try again tomorrow.

Regards, Dave.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Request for supported platforms

[Tom Lane]

>> Make installcheck also failed on horology, copy2 and domain - see
>> attached output. 
>> 
>> The clocks changed here on Saturday night, so I guess that shouldn't
>> have caused the first error (or should the docs be updated?).

Horology failures are normal for a day or so on either side of a DST
change --- see the "regression tests interpretation" docs.  I have
no time right now to examine the other diffs.

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Request for supported platforms

[Dave Page]

> -Original Message-
> From: Jason Tishler [mailto:jason@;tishler.net] 
> Sent: 28 October 2002 13:33
> To: Dave Page
> Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; 
> Tom Lane; Pgsql-Cygwin
> Subject: Re: [HACKERS] Request for supported platforms
> 
> 
> Dave,
> 
> Thanks for the heads up...
> 
> On Mon, Oct 28, 2002 at 10:31:00AM -, Dave Page wrote:
> > > -Original Message-
> > > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us]
> > > Sent: 26 October 2002 03:17
> > > Subject: [HACKERS] Request for supported platforms
> > >
> > > Folks. start sending in those plaform reports, OS name and
> > > version number please.
> > 
> > CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown
> ^^
> 
> Please try with Cygwin 1.3.14-1 while I attempt to deal with 
> at least the following Cygwin build issues with PostgreSQL 
> CVS as of today at about 7:00 AM EST:

Ok, but this is going to take a while as few of the mirrors seem to have
this release yet. I also need to download a new set of everything for
reasons I won't go into.

Is there actually a reason for this though or are you just trying to
keep me busy? :-) It can't be a good thing for us to require that people
upgrade to the latest release of their OS.

> 2. Cygwin bison limit exceeded:
> 
> make[4]: Entering directory 
> `/home/jt/src/pgsql/src/interfaces/ecpg/preproc'
> [snip]
> bison -y -d  preproc.y
> preproc.y:5560: fatal error: maximum table size (32767) exceeded

I believe a new bison is required now. Don't know much about it other
than ecpg hit some limit or other and much discussion followed. Iirc,
it's only an issue when compiling from CVS, not a tarball.

Regards, Dave.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [Fwd: Re: [HACKERS] UnixWare 7.1.3 (BETA), C99 compiler,

[Larry Rosenman]

Dave,
   Thanks for the details, I've copied this reply back to the PostgreSQL
guys as well. 

LER

On Mon, 2002-10-28 at 09:00, Dave Prosser wrote:
> Larry Rosenman wrote:
> > From: Tom Lane <[EMAIL PROTECTED]>
> > To: Larry Rosenman <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [HACKERS] UnixWare 7.1.3 (BETA), C99 compiler, current CVS, error...
> > Date: 26 Oct 2002 11:07:13 -0400
> > 
> > Larry Rosenman <[EMAIL PROTECTED]> writes:
> > > Without specifying the -Xb switch to kill the C99 interpretation of
> > > inline, I get the following from current CVS:
> > 
> > > UX:acomp: ERROR: "tuplesort.c", line 1854: "inline" functions cannot use
> > > "static" identifier: myFunctionCall2
> > 
> > I don't understand what it's unhappy about.  My C99 draft sez
> > 
> >[#6] Any function with internal linkage  can  be  an  inline
> >function.
> > 
> > so the text of the message is surely not what they are really
> > complaining about?  Or is the compiler broken?
> 
> There is a contraint (i.e., a diagnostic is required) in 6.7.4 Function Specifiers
> that says:
> 
>  An inline definition of a function with external linkage shall not contain a
>  definition of a modifiable object with static storage duration, and shall not
>  contain a reference to an identifier with internal linkage.
> 
> Line 1854 is
>   if (DatumGetBool(myFunctionCall2(sortFunction, datum1, datum2)))
> where myFunctionCall2() is a static function defined above ApplySortFunction().
> It's not the inlinedness--a word?--of myFunctionCall2() that's the problem,
> it's that myFunctionCall2() is static and that ApplySortFunction() is inline'd.
> 
> You wrote in your follow up:
> >After reading a little further, it seems that the brain damage is in the
> >standard, not the compiler :-(.  It looks like C99's notion of a
> >function that is both global and inline is that you must provide *two*
> >definitions of the function, one marked inline and one not; moreover,
> >these must appear in separate translation units.  What in the world were
> >those people smoking?  That's a recipe for maintenance problems (edit
> >one definition, forget to edit the other), not to mention completely at
> >variance with the de facto standard behavior of inline that's been
> >around for a long time.
> 
> The C committee's view of inline does not match the historic GCC one.
> They were trying to find a middle ground that was fully compatible with
> the C++ inline, while not requiring any fancy code generation tricks.
> In other words, that C could still be compiled with a one-pass compiler.
> 
> The motivation for this restriction is to make sure that all instances
> of an inline function that's visible outside of the compilation unit
> are identical.  Having the same sequence of tokens isn't good enough
> if there are references to identifiers that could well be different in
> differing compilation units.
> 
> Until the open source base (and GCC) get around to matching the C99
> inline model, I generally attempt to compile open source with "cc -Xb"
> as that eliminates recognition of inline as a keyword, and thus doesn't
> get into the issues with the clashes between the two models.
> 
> >My inclination is to change the code for ApplySortFunction to look like
> >
> >#if defined(__GNUC__)
> >__inline__
> >#endif
> >int32
> >ApplySortFunction
> >
> >so that the inline optimization only gets done for gcc, which we know
> >interprets inline sanely.  Anyone see a better answer?
> 
> You've given us one source file.  Is ApplySortFunction() really called
> from other files?  Another approach, assuming both this and that the
> inlining is viewed as important for its three calls within this file,
> to have a front end version of an internal function.  To wit:
> 
> static inline int32
> StaticApplySortFunction(FmgrInfo *sortFunction, SortFunctionKind kind,
>   Datum datum1, bool isNull1,
>   Datum datum2, bool isNull2)
> {
> //etc.
> }
> 
> int32
> ApplySortFunction(FmgrInfo *sortFunction, SortFunctionKind kind,
>   Datum datum1, bool isNull1,
>   Datum datum2, bool isNull2)
> {
>   return StaticApplySortFunction(sortFunction, kind, datum1, isNull1, datum2, 
>isNull2);
> }
> 
> and change all the existing calls within tuplesort.c to use
> StaticApplySortFunction().  This approach requires no #ifdef's and
> should have the same effect as the existing source with GCC's view
> of inline.
> 
> -- 
> Dave Prosser   [EMAIL PROTECTED]   (908)790-2358   The SCO Group, Murray Hill, NJ
-- 
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 2: you can get off all lists at once w

Re: [HACKERS] How to store chinese using the Postgresql?

[Tatsuo Ishii]

> i would like to use postgresql to store any data (some include chinese), but 
>when i access the chinese data in postgresql, i can't get back correct data, it 
>return any unknow word/data to me.
> How can i solve it? i am using the RedHat Linux 7.2 and Postgresql 7.1, and i 
>haven't install CLE on Linux.

Define "chinese." What character set for Chinese are you using?
--
Tatsuo Ishii

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Request for supported platforms

[Bruce Momjian]

I thought the join was part of the timezone change, but I see now that
it is separate.  I will fix it by adding ORDER BY.

---

Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Ports list updated:
> 
> Shouldn't the "join" regression test failure be fixed?
> 
> Cheers,
> 
> Neil
> 
> -- 
> Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC
> 
> 
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] How to store chinese using the Postgresql?

[Shridhar Daithankar]

On 27 Oct 2032 at 0:24, Timothy Chan wrote:

> 
> Hi
>  i would like to use postgresql to store any data (some include chinese), 
> but when i access the chinese data inpostgresql, i can't get back correct 
> data, it return any unknow word/data to me.
> How can i solve it? i am using the RedHat Linux 7.2 and Postgresql 7.1, and i 
> haven't install CLE on Linux.

You might have done this but just confirrming, did you use initdb -E to enable 
proper locale?

Bye
 Shridhar

--
"I would rather spend 10 hours reading someone else's source code than10 
minutes listening to Musak waiting for technical support which isn't."(By Dr. 
Greg Wettstein, Roger Maris Cancer Center)


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Request for supported platforms

[Jason Tishler]

Dave,

Thanks for the heads up...

On Mon, Oct 28, 2002 at 10:31:00AM -, Dave Page wrote:
> > -Original Message-
> > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] 
> > Sent: 26 October 2002 03:17
> > Subject: [HACKERS] Request for supported platforms
> >
> > Folks. start sending in those plaform reports, OS name and 
> > version number please.
> 
> CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown
^^

Please try with Cygwin 1.3.14-1 while I attempt to deal with at least
the following Cygwin build issues with PostgreSQL CVS as of today at
about 7:00 AM EST:

1. pg_config.h.in HAVE_FSEEKO ifdef:

make[4]: Entering directory `/home/jt/src/pgsql/src/backend/access/common'
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include  
-DBUILDING_DLL  -c -o heaptuple.o heaptuple.c
In file included from ../../../../src/include/c.h:56,
 from ../../../../src/include/postgres.h:48,
 from heaptuple.c:21:
/usr/include/stdio.h:207: parse error before `('

2. Cygwin bison limit exceeded:

make[4]: Entering directory `/home/jt/src/pgsql/src/interfaces/ecpg/preproc'
[snip]
bison -y -d  preproc.y
preproc.y:5560: fatal error: maximum table size (32767) exceeded

> Make check failed with the normal spurious errors.

I would stick with make installcheck due to the Cygwin (i.e., Windows)
backlog issue.

> Make installcheck also failed on horology, copy2 and domain - see
> attached output. 
> 
> The clocks changed here on Saturday night, so I guess that shouldn't
> have caused the first error (or should the docs be updated?).
> 
> The second 2 errors are both with copys - related to the problem with
> the listen() backlog queue in the parallel test perhaps?

I haven't looked into the above yet due to the build problems.  Any help
regarding these issues is gratefully appreciated.

Thanks,
Jason

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Pgsql and .NET (Help!)

[Dave Page]

> -Original Message-
> From: Tommy [mailto:tmartin1@;telocity.com] 
> Sent: 28 October 2002 03:56
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] Pgsql and .NET (Help!)
> 
> 
> I have been trying for 3 days to connect to my postgres linux 
> box via vb .net on a windows box. I have to make this work somehow.
> 
> I found npgsql provider and tried it but could not make it 
> connect either. I would prefer to use the OleDbConnection if possible.
> 
> Has anyone been able to connect via the odbc driver and .NET?

Yes, instructions are on http://odbc.postgresql.org, though they are for
C#, but they are using .Net. Npgsql does work quite well as well
though...

Regards, Dave

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] PREPARE / EXECUTE

[Hans-Jürgen Schönig]

The standard approach to such a scenario would imho be to write stored procedures
for the complex queries (e.g. plpgsql) and use that from the client.
Maybe even eliminate a few ping pongs between client and server.

Andreas
 


Does it reduce the time taken by the planner?
Are server side SQL functions optimized at runtime or at "create 
function" time?

If the function is optimized at runtime it is not a gain.

   Hans


--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at , cluster.postgresql.at 
, www.cybertec.at 
, kernel.cybertec.at 



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] Turning the PLANNER off

[Ben McMahan]

I'm looking at different ways of optimizing queries with a large number of
joins.  I write the same query in a number of different ways and compare
the running times.  Now the problem is I do not want the optimizer
changing the queries.  So I explicit state the order of the joins in the
FROM clause.  I also turn off everything I can except for one type of join
(say hash join), and I've turned off geqo.  But I find that the PLANNER
still takes an enormous amount of time for some queries.  It doesn't look
like the Planner is actually optimizing (changing) anything, but just in
case, I was wondering if there was a way to turn off the PLANNER.

Note, when I say an enormous amount of time, I mean at least double the
time the EXECUTOR takes to actually answer the query.

Thanks for your help,

Ben McMahan

ps. here is a small example of what my queries look like (so you can see
if there is something else it might be deciding on):

SELECT DISTINCT c0.x1 , c1.x2 , c0.x3 , c0.x4 , c2.x5
FROM r1 c4 (x4,x2,x5) JOIN (r0 c3 (x2,x3,x5) JOIN (r2 c2 (x3,x1,x5) JOIN (r1 c1
(x4,x1,x2) JOIN r1 c0 (x1,x3,x4)
ON ( c0.x4 = c1.x4  AND  c0.x1 = c1.x1 ))
ON ( c0.x3 = c2.x3  AND  c0.x1 = c2.x1 ))
ON ( c1.x2 = c3.x2  AND  c0.x3 = c3.x3  AND  c2.x5 = c3.x5 ))
ON ( c0.x4 = c4.x4  AND  c1.x2 = c4.x2  AND  c2.x5 = c4.x5 );

A quick reminder, FROM r1 c4 (x4,x2,x5) just renames a table r1 into c4
where it also renames the columns to x4, x2, and x5 respectively.


---(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] plpq

[Darko Prenosil]

Tree weeks later than I promised, but it is finished (I hope).

In attachment are files:
dblink.c
dblink.h
dblink.sql.in
pqtest.sql

In file pqtest.sql is sample queries and results. It seem OK to me.

There are two reasons why I did not make a diff.

1. The source I started from is 7.3b1, not the latest.
2. I would like You to check the code, especially the part that touches memory 
management. 
I can say that it works, but I do not know exactly why, and this can be 
dangerous. With my knowledge of postgres internals this is
as far I can go at the moment. And once more sorry for bad English !

Regards !
/*
 * dblink.c
 *
 * Functions returning results from a remote database
 *
 * Joe Conway <[EMAIL PROTECTED]>
 *
 * Copyright (c) 2001, 2002 by PostgreSQL Global Development Group
 * ALL RIGHTS RESERVED;
 *
 * Permission to use, copy, modify, and distribute this software and its
 * documentation for any purpose, without fee, and without a written agreement
 * is hereby granted, provided that the above copyright notice and this
 * paragraph and the following two paragraphs appear in all copies.
 *
 * IN NO EVENT SHALL THE AUTHOR OR DISTRIBUTORS BE LIABLE TO ANY PARTY FOR
 * DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
 * LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
 * DOCUMENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 *
 * THE AUTHOR AND DISTRIBUTORS SPECIFICALLY DISCLAIMS ANY WARRANTIES,
 * INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
 * AND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED HEREUNDER IS
 * ON AN "AS IS" BASIS, AND THE AUTHOR AND DISTRIBUTORS HAS NO OBLIGATIONS TO
 * PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
 *
 */
#include "postgres.h"

#include "libpq-fe.h"

#include "fmgr.h"
#include "funcapi.h"
#include "access/tupdesc.h"
#include "access/heapam.h"
#include "catalog/catname.h"
#include "catalog/namespace.h"
#include "catalog/pg_index.h"
#include "catalog/pg_type.h"
#include "executor/executor.h"
#include "executor/spi.h"
#include "lib/stringinfo.h"
#include "nodes/nodes.h"
#include "nodes/execnodes.h"
#include "nodes/pg_list.h"
#include "parser/parse_type.h"
#include "tcop/tcopprot.h"
#include "utils/builtins.h"
#include "utils/fmgroids.h"
#include "utils/array.h"
#include "utils/lsyscache.h"
#include "utils/syscache.h"

#include "dblink.h"

/*
 * Internal declarations
 */
static dblink_results *init_dblink_results(MemoryContext fn_mcxt);
static public_pq_connections *init_public_connections();
static public_pq_results *init_public_results();
static char **get_pkey_attnames(Oid relid, int16 *numatts);
static char *get_sql_insert(Oid relid, int16 *pkattnums, int16 pknumatts, char **src_pkattvals, char **tgt_pkattvals);
static char *get_sql_delete(Oid relid, int16 *pkattnums, int16 pknumatts, char **tgt_pkattvals);
static char *get_sql_update(Oid relid, int16 *pkattnums, int16 pknumatts, char **src_pkattvals, char **tgt_pkattvals);
static char *quote_literal_cstr(char *rawstr);
static char *quote_ident_cstr(char *rawstr);
static int16 get_attnum_pk_pos(int16 *pkattnums, int16 pknumatts, int16 key);
static HeapTuple get_tuple_of_interest(Oid relid, int16 *pkattnums, int16 pknumatts, char **src_pkattvals);
static Oid	get_relid_from_relname(text *relname_text);
static dblink_results *get_res_ptr(int32 res_id_index);
static void append_res_ptr(dblink_results * results);
static void remove_res_ptr(dblink_results * results);
static TupleDesc pgresultGetTupleDesc(PGresult *res);

static public_pq_connections *get_public_conn(int32 public_conn_id_index);
static void append_public_conn(public_pq_connections * connections);
static void remove_public_conn(public_pq_connections * connections);

static public_pq_results *get_public_res(int32 public_res_id_index);
static void append_public_res(public_pq_results * results);
static void remove_public_res(public_pq_results * results);

static PGresult* getResultPointer(int32 nResId, bool removePointer);
static PGconn* getConnPointer(int32 nConnId,bool removePointer);


/* Global */
List	   *res_id = NIL;
int			res_id_index = 0;

List	   *public_conn_id = NIL;
int			public_conn_id_index = 0;
List	   *public_res_id = NIL;
int			public_res_id_index = 0;

PGconn	   *persistent_conn = NULL;

#define GET_TEXT(cstrp) DatumGetTextP(DirectFunctionCall1(textin, CStringGetDatum(cstrp)))
#define GET_STR(textp) DatumGetCString(DirectFunctionCall1(textout, PointerGetDatum(textp)))
#define xpfree(var_) \
	do { \
		if (var_ != NULL) \
		{ \
			pfree(var_); \
			var_ = NULL; \
		} \
	} while (0)


/*
 * Create a persistent connection to another database
 */
PG_FUNCTION_INFO_V1(dblink_connect);
Datum
dblink_connect(PG_FUNCTION_ARGS)
{
	char	   *connstr = GET_STR(PG_GETARG_TEXT_P(0));
	char	   *msg;
	text	   *result_text;
	MemoryContext oldcontext;

	if (persistent_conn !

Re: [HACKERS] [ADMIN] Security question : Database access control

[Chad R. Larson]

On Tue, Oct 22, 2002 at 05:05:38PM +0200, Igor Georgiev wrote:
> or my nightmare a cygwin on Win 98 everybody can can access everything

Or =my= nightmare:  Anything important on any Windows platform.

 -crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
  Eldorado Computing, Inc.   602-604-3100
 5353 North 16th Street, Suite 400
   Phoenix, Arizona   85016-3228

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] 'epoch'::timestamp and Daylight Savings

[Hosen, John]

Thomas & Tom,

Thanks for all your help, I have updated all the defaults to use timestamptz
and everything is working fine again.

We can't wait for 7.3, keep up the good work.


John


-Original Message-
From: Tom Lane [mailto:tgl@;sss.pgh.pa.us] 
Sent: 23 October 2002 19:47
To: Hosen, John
Cc: 'Thomas Lockhart'; '[EMAIL PROTECTED]'
Subject: Re: [HACKERS] 'epoch'::timestamp and Daylight Savings 


"Hosen, John" <[EMAIL PROTECTED]> writes:

>  e_app_print_date  | timestamp with time zone | default
> "timestamp"('epoch'::text)

Yeah, there's your problem.  You are casting 'epoch' to type timestamp
without time zone, and thence to timestamp with time zone.  The first step
gives "midnight" and the second assumes that that means "midnight local
time".

For example, in US EST zone I get:

regression=# select "timestamp"('epoch'::text);
  timestamp
-
 1970-01-01 00:00:00
(1 row)

regression=# select ("timestamp"('epoch'::text))::timestamptz;
   timestamp

 1970-01-01 00:00:00-05
(1 row)

whereas what is wanted is

regression=# select "timestamptz"('epoch'::text);
  timestamptz

 1969-12-31 19:00:00-05
(1 row)

So you can fix the problem just by setting the default to be
'epoch'::timestamptz.

The problem is probably related to the renaming we've been carrying out to
get closer to the SQL spec: "timestamp" now means timestamp without time
zone, which is not what it meant in older Postgres releases.

regards, tom lane

This email has been scanned for all viruses by the MessageLabs SkyScan
service.


***

This email and any files attached to it are confidential and intended 
solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify 
the system manager.

The message and any files attached to it have been scanned by 
MIMEsweeper with Sophos Sweep and found to be free from all known
viruses.

Information on MIMEsweeper can be found at http://www.mimesweeper.com/

***


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[HACKERS] FreeBSD 4.7: BETA3 (from port): regression failures...

[Larry Rosenman]

Regression Diffs:

*** ./expected/geometry-positive-zeros-bsd.out  Tue Sep 12 16:07:16 2000
--- ./results/geometry.out  Mon Oct 28 00:06:41 2002
***
*** 114,120 
  | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
  | (-5,-12)   | [(1,2),(3,4)] | (1,2)
  | (10,10)| [(1,2),(3,4)] | (3,4)
! | (0,0)  | [(0,0),(6,6)] | (0,0)
  | (-10,0)| [(0,0),(6,6)] | (0,0)
  | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
  | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
--- 114,120 
  | (5.1,34.5) | [(1,2),(3,4)] | (3,4)
  | (-5,-12)   | [(1,2),(3,4)] | (1,2)
  | (10,10)| [(1,2),(3,4)] | (3,4)
! | (0,0)  | [(0,0),(6,6)] | (-0,0)
  | (-10,0)| [(0,0),(6,6)] | (0,0)
  | (-3,4) | [(0,0),(6,6)] | (0.5,0.5)
  | (5.1,34.5) | [(0,0),(6,6)] | (6,6)
***
*** 224,233 
   twentyfour |  rotation   
  +-
  | (0,0),(0,0)
! | (0,0),(-20,-20)
! | (0,2),(-14,0)
  | (0,79.2),(-58.8,0)
! | (14,0),(0,-34)
  | (0,40),(0,0)
  | (0,0),(0,0)
  | (-10,-10),(-30,-30)
--- 224,233 
   twentyfour |  rotation   
  +-
  | (0,0),(0,0)
! | (-0,0),(-20,-20)
! | (-0,2),(-14,0)
  | (0,79.2),(-58.8,0)
! | (14,-0),(0,-34)
  | (0,40),(0,0)
  | (0,0),(0,0)
  | (-10,-10),(-30,-30)
***
*** 254,264 
 WHERE (p.f1 <-> point '(0,0)') >= 1;
   twenty | rotation   
   
  
+---
! | (0,0),(-0.2,-0.2)
  | (-0.1,-0.1),(-0.3,-0.3)
  | (-0.25,-0.25),(-0.25,-0.35)
  | (-0.3,-0.3),(-0.3,-0.3)
! | (0.08,0),(0,-0.56)
  | (0.12,-0.28),(0.04,-0.84)
  | (0.26,-0.7),(0.1,-0.82)
  | (0.12,-0.84),(0.12,-0.84)
--- 254,264 
 WHERE (p.f1 <-> point '(0,0)') >= 1;
   twenty | rotation   
   
  
+---
! | (0,-0),(-0.2,-0.2)
  | (-0.1,-0.1),(-0.3,-0.3)
  | (-0.25,-0.25),(-0.25,-0.35)
  | (-0.3,-0.3),(-0.3,-0.3)
! | (0.08,-0),(0,-0.56)
  | (0.12,-0.28),(0.04,-0.84)
  | (0.26,-0.7),(0.1,-0.82)
  | (0.12,-0.84),(0.12,-0.84)
***
*** 266,272 
  | 
(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
  | 
(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
  | 
(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
! | (0,0.0828402366863905),(-0.201183431952663,0)
  | 
(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
  | 
(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
  | 
(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
--- 266,272 
  | 
(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
  | 
(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
  | 
(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
! | (-0,0.0828402366863905),(-0.201183431952663,0)
  | 
(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
  | 
(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
  | 
(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)

==

*** ./expected/horology.out Wed Sep 18 16:35:25 2002
--- ./results/horology.out  Mon Oct 28 00:06:41 2002
***
*** 537,549 
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - 
interval '1 day')) as "True";
   True 
  --
!  t
  (1 row)
  
  SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' 
+ interval '2 days')) as "True";
   True 
  --
!  t
  (1 row)
  
  SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 537,549 
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - 
interval '1 day')) as "True";
   True 
  --
!  f
  (1 row)
  
  SELECT (timestamp with time zone 'tomorr

[HACKERS] 7.3b3 on MacOSX 10.2.1

[Adam Witney]

Just to update the list of supported platforms, 7.3b3 compiles and passes
all the regression tests on MacOSX 10.2.1

Although don't know if this is relevant but this appears when running the
tests:

parallel group (20 tests): ./pg_regress: fork: Resource temporarily
unavailable
./pg_regress: fork: Resource temporarily unavailable
 comments lseg box path timetz point circle reltime tinterval date inet
interval timestamp time abstime polygon timestamptz oidjoins

Cheers

Adam


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


---(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] Request for supported platforms

[Tara Piorkowski]

Tom Lane wrote:


Bruce Momjian  writes:

>Folks. start sending in those plaform reports, OS name and version
>number please.


I've checked CVS tip on:
	HPUX 10.20, using both gcc and vendor's cc
	PPC Linux
	Mac OS X 10.1



Here's the regression.diffs file from Mac OS X 10.2.1 (Jaguar). It 
failed geometry (rounding) and horology (not sure). gcc -v returns 
"Apple Computer, Inc. GCC version 1161, based on gcc version 3.1 
20020420 (prerelease)".


*** ./expected/geometry-powerpc-darwin.out  Mon Dec 11 11:45:16 2000
--- ./results/geometry.out  Sun Oct 27 21:27:11 2002
***
*** 127,133 
  | (-5,-12)   | [(10,-10),(-3,-4)]| 
(-1.60487804878049,-4.64390243902439)
  | (10,10)| [(10,-10),(-3,-4)]| 
(2.39024390243902,-6.48780487804878)
  | (0,0)  | [(-100,200),(30,-40)] | 
(0.0028402365895872,15.384614860264)
! | (-10,0)| [(-100,200),(30,-40)] | 
(-9.99715942258202,15.3864610140472)
  | (-3,4) | [(-100,200),(30,-40)] | 
(-2.99789812267519,15.3851688427303)
  | (5.1,34.5) | [(-100,200),(30,-40)] | 
(5.09647083221496,15.3836744976925)
  | (-5,-12)   | [(-100,200),(30,-40)] | 
(-4.99494420845634,15.3855375281616)
--- 127,133 
  | (-5,-12)   | [(10,-10),(-3,-4)]| 
(-1.60487804878049,-4.64390243902439)
  | (10,10)| [(10,-10),(-3,-4)]| 
(2.39024390243902,-6.48780487804878)
  | (0,0)  | [(-100,200),(30,-40)] | 
(0.0028402365895872,15.384614860264)
! | (-10,0)| [(-100,200),(30,-40)] | 
(-9.99715942258202,15.3864610140473)
  | (-3,4) | [(-100,200),(30,-40)] | 
(-2.99789812267519,15.3851688427303)
  | (5.1,34.5) | [(-100,200),(30,-40)] | 
(5.09647083221496,15.3836744976925)
  | (-5,-12)   | [(-100,200),(30,-40)] | 
(-4.99494420845634,15.3855375281616)

==

*** ./expected/horology.out Wed Sep 18 17:35:25 2002
--- ./results/horology.out  Sun Oct 27 21:27:12 2002
***
*** 537,549 
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 
'tomorrow' - interval '1 day')) as "True";
   True
  --
!  t
  (1 row)

  SELECT (timestamp with time zone 'tomorrow' = (timestamp with time 
zone 'yesterday' + interval '2 days')) as "True";
   True
  --
!  t
  (1 row)

  SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 537,549 
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 
'tomorrow' - interval '1 day')) as "True";
   True
  --
!  f
  (1 row)

  SELECT (timestamp with time zone 'tomorrow' = (timestamp with time 
zone 'yesterday' + interval '2 days')) as "True";
   True
  --
!  f
  (1 row)

  SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";

==


--
Tara Piorkowski
System Administrator, vilaj.com, LLC



---(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] How to store chinese using the Postgresql?

[Timothy Chan]

Hi
    i would like to use postgresql to store any 
data (some include chinese), but when i access the chinese data 
in postgresql, i can't get back correct data, it return any unknow 
word/data to me.
How can i solve it? i am using the RedHat Linux 7.2 and 
Postgresql 7.1, and i haven't install CLE on Linux.
 
Thanks
Tim

[HACKERS] Pgsql and .NET (Help!)

[Tommy]

I have been trying for 3 days to connect to my postgres linux box via vb
.net on a windows box. I have to make this work somehow.

I found npgsql provider and tried it but could not make it connect either. I
would prefer to use the OleDbConnection if possible.

Has anyone been able to connect via the odbc driver and .NET?

I am getting despirate and not sure which way to turn now.

A snip of the code I have been using to try to connect is below.

Thanks in advance.

Tommy


Dim connstring As String = "Server=192.168.5.5;User
Id=myname;Password=mypassword;Database=mydbname"

Dim conn As New NpgsqlConnection(connstring)

conn.Open()

conn.Close()




---(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] Trigger on 'create table' ?

[Bruce David]

All,

I'm trying to implement row level security using PostgreSQL.  I envision
having column on each and every table in the database that will contain a
discriminating value that determines if a given user is able to see that row
or not.  Users do not directly access the database; they get at it only
through client applications.

Is there a way to initially configure PostgreSQL such that each and every
time a 'create table foo' command is executed that, something else would
happen instead?

For example,

CREATE TABLE weather (
cityvarchar(80),
loint,
hiint,
prcpreal,
datedate
);

would result in the following being executed automatically:

CREATE TABLE t_weather (
cityvarchar(80),
loint,
hiint,
prcpreal,
datedate,
hidden_columnint
);

CREATE VIEW weather AS
SELECT city, lo, hi, prcp, date
FROM t_weather;


How the view gets populated is another discussion entirely.

But is there a way to set things up initially such that each 'create table'
command will exhibit the behavior described above?

Thanks.

--

Bruce





---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] 7.3b3 build --with-perl fails on RH 8.0

[P.J. \"Josh\" Rovero]

RH 8.0 has perl 5.8, here are the details:

From config.log:

configure:4159: checking for perl
configure:4177: found /usr/bin/perl
configure:4189: result: /usr/bin/perl
configure:4198: checking for Perl archlibexp
configure:4201: result: /usr/lib/perl5/5.8.0/i386-linux-thread-multi
configure:4203: checking for Perl privlibexp
configure:4206: result: /usr/lib/perl5/5.8.0
configure:4208: checking for Perl useshrplib
configure:4211: result: true
configure:4214: checking for flags to link embedded Perl
configure:4219: result:   -L/usr/local/lib 
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/auto/DynaLoader/DynaLoader.a 
-L/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE -lperl -lnsl -ldl 
-lm -lpthread -lc -lcrypt -lutil

from gmake:
gmake[3]: Entering directory 
`/localhome/rovero/postgresql-7.3b3/src/pl/plperl'
gcc -O2 -fpic -I. -I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE 
-I../../..
/src/include   -c -o plperl.o plperl.c
In file included from 
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/op.h:480
,
 from 
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/perl.h:2
209,
 from plperl.c:61:
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/reentr.h:602: field 
`_crypt_st
ruct' has incomplete type
In file included from 
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/perl.h:3
368,
 from plperl.c:61:
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:246: parse 
error befor
e "off64_t"
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:248: parse 
error befor
e "Perl_do_sysseek"
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:248: parse 
error befor
e "off64_t"
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:248: warning: 
data def
inition has no type or storage class
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:249: parse 
error befor
e "Perl_do_tell"
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:249: warning: 
data def
inition has no type or storage class
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:1378: parse 
error befo
re "Perl_PerlIO_tell"
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:1378: warning: 
data de
finition has no type or storage class
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/proto.h:1379: parse 
error befo
re "off64_t"
gmake[3]: *** [plperl.o] Error 1
gmake[3]: Leaving directory 
`/localhome/rovero/postgresql-7.3b3/src/pl/plperl'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/localhome/rovero/postgresql-7.3b3/src/pl'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/localhome/rovero/postgresql-7.3b3/src'
gmake: *** [all] Error 2


--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: [EMAIL PROTECTED]www.sonalysts.com215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[HACKERS] string freeze

[Dennis Björklund]

Is there a planned string freeze for postgresql?

There was a (good) change some weeks ago that altered lots of witespace.
Remember that it's enough to change a single space to make that
translation of that string not work. To do "psql --help" and get half the
entries in swedish and half in english would be ugly. I sent an update a
couple of days ago that fixes the swedish translation. I'm not sure about
the status of the other languages. Now I'm just planning for the release
and to prevent us from getting into a situation where strings are altered
the day before the release or something.

There have been a lot work with the translations and would be nice if it
works in the release.

-- 
/Dennis


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] Request for supported platforms

[Dave Page]

> -Original Message-
> From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] 
> Sent: 26 October 2002 03:17
> To: PostgreSQL-development
> Cc: Thomas Lockhart; Tom Lane
> Subject: [HACKERS] Request for supported platforms
> 
> 
> Folks. start sending in those plaform reports, OS name and 
> version number please.
> 

Windows XP Professional SP1

Client build fails :-(

Regards, Dave.

C:\cygwin\usr\local\src\postgresql-7.3b3\src>nmake /f win32.mak

Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.

cd include
if not exist pg_config.h copy pg_config.h.win32 pg_config.h
1 file(s) copied.
cd ..
cd interfaces\libpq
nmake /f win32.mak

Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.

Building the Win32 static library...

if not exist ".\Release/" mkdir ".\Release"
cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma04188.
dllist.c
cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmb04188.
md5.c
cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmc04188.
wchar.c
cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmd04188.
encnames.c
cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nme04188.
win32.c
fe-auth.c
fe-connect.c
fe-exec.c
fe-lobj.c
fe-misc.c
fe-print.c
fe-secure.c
pqexpbuffer.c
link.exe -lib @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmf04188.
cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmg04188.
libpqdll.c
rc.exe /l 0x409 /fo".\Release\libpq.res" libpq.rc
link.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmh04188.
   Creating library .\Release\libpqdll.lib and object
.\Release\libpqdll.exp
cd ..\..\bin\psql
nmake /f win32.mak

Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.

if not exist ".\Release/" mkdir ".\Release"
NMAKE : fatal error U1073: don't know how to make '..\..\utils\getopt.c'
Stop.
NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual
Studio\VC98\bin\N
MAKE.EXE"' : return code '0x2'
Stop.

C:\cygwin\usr\local\src\postgresql-7.3b3\src>

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] Request for supported platforms

[Dave Page]

> -Original Message-
> From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] 
> Sent: 26 October 2002 03:17
> To: PostgreSQL-development
> Cc: Thomas Lockhart; Tom Lane
> Subject: [HACKERS] Request for supported platforms
> 
>
> Folks. start sending in those plaform reports, OS name and 
> version number please.

CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown

Make check failed with the normal spurious errors.
Make installcheck also failed on horology, copy2 and domain - see
attached output. 

The clocks changed here on Saturday night, so I guess that shouldn't
have caused the first error (or should the docs be updated?).

The second 2 errors are both with copys - related to the problem with
the listen() backlog queue in the parallel test perhaps?

Regards, Dave.



regression.out
Description: regression.out


regression.diffs
Description: regression.diffs

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster