Re: [GENERAL] Restore

2010-12-25 Thread Alban Hertroys
On 25 Dec 2010, at 3:20, Bob Pawley wrote: > When I type psql \I - I get the same as above. Not \I, that option doesn't exist. It's \l (lower-case el). You can't use it like that on the prompt either, but you can use "psql -l" there. The backslash (\) commands are available once you are in psq

Re: [GENERAL] Restore

2010-12-25 Thread Raymond O'Donnell
On 25/12/2010 01:43, Adrian Klaver wrote: On Friday 24 December 2010 5:20:50 pm Bob Pawley wrote: I just stopped the server after changing config to trust and I got the message `System error 5 has occurred. Access is denied` Perhaps this is a clue. Bob Does not meaning anything to me. Pleas

Re: [GENERAL] Constraining overlapping date ranges

2010-12-25 Thread Filip Rembiałkowski
that's really interesting; looks like a bug if point constructor is really mutable? can you prepare a test case with non-overlapping ranges which does not satisfy exclusion constraint? regarding your last comment about unnecessary f_point function: I tried "id WITH =" but postgres complained about

Re: [GENERAL] Restore

2010-12-25 Thread Scott Marlowe
On Fri, Dec 24, 2010 at 9:38 PM, Bob Pawley wrote: > I attempted loading earlier version of my backup database, using PDW# \I > PDW_May_2010  and it worked. > > Looks as tho the June version may have been corrupt. If it's a plain sql text file you can read it with a simple app like the notepad or

Re: [GENERAL] Compress data sent to client

2010-12-25 Thread pasman pasmański
I read in doc that by default longer text fields are compressed. They may be sent to client without decompression - this reduce netword load. pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[GENERAL] #include

2010-12-25 Thread Elliot Chance
Hi everyone, >From what i've read in the documentation you need funcapi.h to return SETOF >from a C function, the problem is when I include the header file the compile >throws heaps of errors; offending code 1. extern "C" { 2. #include 3. #include 4. #include 5. 6. #ifdef

Re: [GENERAL] #include

2010-12-25 Thread Craig Ringer
On 12/26/2010 02:14 PM, Elliot Chance wrote: In file included from /usr/include/pgsql/server/access/heapam.h:21, from /usr/include/pgsql/server/nodes/execnodes.h:18, from /usr/include/pgsql/server/executor/execdesc.h:18, from /usr/include/pgs