[GENERAL] v9.3.0: bug with pgdump -s?

2013-09-15 Thread Eric B. Ridge
(Using the new PostgreSQL v9.3.0) I did a schema-only dump of the 'pg_catalog' schema in the hopes to study how the built-in OPERATOR CLASSes are defined. Doing so output a few warnings: $ [pg930] pg_dump -s -n pg_catalog template1 > /tmp/pg_catalog.sql pg_dump: WARNING: typtype of data type

Re: [GENERAL] v9.3.0: bug with pgdump -s?

2013-09-15 Thread Andres Freund
On 2013-09-15 12:01:29 -0400, Eric B. Ridge wrote: > Am I expecting too much against 'pg_catalog' or is something bugged? Yes, I think you do expect too much. It'd perhaps be nice to give a nicer error message, but some of the stuff (like the pseudotypes you see warnings about here) doesn't fully

[GENERAL] Unary Operators

2013-09-15 Thread Andreas Ulbrich
Salvete! I have the following problem. I'd like to define the operator symbol / as a left unary operator for reciprocal value of a number. I did this with a C-function and all the stuff around, but it does not work. Hiere is an extract and simplified example with the same error message as in m

Re: [GENERAL] v9.3.0: bug with pgdump -s?

2013-09-15 Thread Eric B. Ridge
On 09/15/2013 02:11 PM, Andres Freund wrote: What did you actually try to find out? Greetings, Andres Freund I was just trying to mentally sync up http://www.postgresql.org/docs/9.3/static/xindex.html with (more) concrete examples. Investigating pg_catalog seemed like the obvious choice. T

Re: [GENERAL] How to switch file systems with least downtime?

2013-09-15 Thread Arjen Nienhuis
On Sat, Sep 14, 2013 at 2:32 PM, Moshe Jacobson wrote: > How do I migrate my 9.1 directory to a new file system with the least > downtime possible? > Create a new tablespace on a the new filesystem and move everything over. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] PG9.1 Static build over Windows

2013-09-15 Thread Muhammad Bashir Al-Noimi
On 09/10/2013 05:55 PM, Muhammad Bashir Al-Noimi wrote: Howdy, I want to link Postgresql client to my Qt project but I noticed that C:/PostgreSQL/9.1/lib/libpq.lib points to dynamic libaray (libpq.dll) which is not suiatble for static linking. How can I link statically my application with Po

[GENERAL] Using PL/R with 9.3beta2

2013-09-15 Thread Sandeep Gupta
Hi, I compiled g postgres9.3beta2 with PL/R which works fine. However, when I execute the command create extension plr, I get following error: ERROR: could not load library "/apps/packages/postgresql/9.3beta2/lib/plr.so": /apps/packages/postgresql/9.3beta2/lib/plr.so: undefined symbol: HeapTupl

Re: [GENERAL] v9.3.0: bug with pgdump -s?

2013-09-15 Thread Andres Freund
On 2013-09-15 15:24:57 -0400, Eric B. Ridge wrote: > On 09/15/2013 02:11 PM, Andres Freund wrote: > >What did you actually try to find out? Greetings, Andres Freund > > I was just trying to mentally sync up > http://www.postgresql.org/docs/9.3/static/xindex.html with (more) concrete > examples. I

Re: [GENERAL] Using PL/R with 9.3beta2

2013-09-15 Thread Joe Conway
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/15/2013 05:59 PM, Sandeep Gupta wrote: > Hi, > > I compiled g postgres9.3beta2 with PL/R which works fine. However, > when I execute the command create extension plr, I get following > error: > > ERROR: could not load library > "/apps/package

Re: [GENERAL] Segmentation fault: pg_upgrade 9.1 to 9.3: pg_dump: row number 0 is out of range 0..-1

2013-09-15 Thread Jeff Janes
On Sat, Sep 14, 2013 at 6:40 PM, Robert Nix wrote: > Running a pg_upgrade task is causing Segmentation fault: > > command: "/usr/lib/postgresql/9.3/bin/pg_dump" --host > "/var/lib/postgresql" --port 50432 --username "postgres" --schema-only > --quote-all-identifiers --binary-upgrade --format=cust

Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?

2013-09-15 Thread Jeff Janes
On Tue, Sep 10, 2013 at 10:37 AM, Chris Curvey wrote: > > > > > Great thought. Looking through the logs, it appears that all my failures > are on a CREATE INDEX. Usually on my biggest table, but often on another > table. > > > > 2013-09-10 10:09:46 EDT ERROR: canceling autovacuum task > > 2013-

Re: [GENERAL] Segmentation fault: pg_upgrade 9.1 to 9.3: pg_dump: row number 0 is out of range 0..-1

2013-09-15 Thread Robert Nix
> What happens if you manually run the pg_dump command quoted above against > a running 9.1 server, outside of the context of pg_upgrade? (Your port > will be probably be different from 50432) > > If that still crashes, What if you drop the --binary-upgrade option? The > --format=custom option? >

Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?

2013-09-15 Thread Chris Curvey
On Sun, Sep 15, 2013 at 7:49 PM, Jeff Janes wrote: > On Tue, Sep 10, 2013 at 10:37 AM, Chris Curvey > wrote: > >> >> >> >> >> Great thought. Looking through the logs, it appears that all my failures >> are on a CREATE INDEX. Usually on my biggest table, but often on another >> table. >> >> >>

Re: [GENERAL] Segmentation fault: pg_upgrade 9.1 to 9.3: pg_dump: row number 0 is out of range 0..-1

2013-09-15 Thread Jeff Janes
On Sun, Sep 15, 2013 at 5:06 PM, Robert Nix wrote: > > What happens if you manually run the pg_dump command quoted above against >> a running 9.1 server, outside of the context of pg_upgrade? (Your port >> will be probably be different from 50432) >> >> If that still crashes, What if you drop th

Re: [GENERAL] Segmentation fault: pg_upgrade 9.1 to 9.3: pg_dump: row number 0 is out of range 0..-1

2013-09-15 Thread Robert Nix
> > If you do the dump using 9.1's pg_dump without --binary-upgrade, and then > load that dump file into a new empty 9.1 server, then does it crash if you > take a dump against *that* server? > I'll give it a try. If so, would you be allowed to post that dump file? > I will not be able to provid