Re: [BUGS] tablefunc extension
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/19/2013 12:24 PM, Carl Clemens wrote: > The following query appears to be correct but fails to execute. Your example is incorrect, however it is not clear (to me at least) from your example what you are expecting as output -- please see the documentation: http://www.postgresql.org/docs/9.2/interactive/tablefunc.html If you still have a problem please provide SQL that can be cut and pasted which: 1) create your table 2) insert sample rows Then show us what out put you are trying to acheive as output from that data. Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBAgAGBQJSP3qGAAoJEDfy90M199hljPoP/R/LPHwlkQYtIE9YjNS1FRoJ viivrvUzAeP27zivgo8rIIrfXNyghUTfE8dyBRL1JB934PLcyu83+J9fcfW979xO ogt2J4JJ3pctfOOm0cMdlYDarZPeo4VGXFQMe1K/7qMSZJGLUWbGwlR8pF2o/AGa JdIMxwWuv6DwmU7yt8YnwWYRuyScUPyBFJCqntcrlfIDDlB313fdSUpu55c5/c89 Nq6+OGWScN9hA5AGm6AeucGEs8g3aNuevKN+AA6BN0D1wuo+pvkdK+iI9MlNyYlD cB+i7+oluSb+UkNNcvz+PW0/3D0CJ12/nZfhOFsJCoplYzbuPJbZfI9eA/d9r8E3 YdDbN1/ofVAHLKx8Wy9LKqsGDb0pLFCTxc+jZhRkR87qf9qJ1OAb/DJHj7b9A0EC /xy5LoxAFF61yGZjK9dPllF/asJcJkm3074G+hfCG5NdlJdOzshQ6eSNZqwOSTOM 6TPfQNTkpGmFfuuKRYTQjjAC+rUO6rfD+OIA+02rhYuRA1d7bxQw/tZvhOA9ZwvT GVfpKHNnbG72euY8q9NMuamoImy1ivVdXkt1kkKKQkXi4UGwyRhS08Rf+JVfP5Zz rNNtFp8lAo/eo5C3P5vFGUMr/4hcvjnPV71ZjgN4dG4Gp/HWdUsXn09TUrr1xV27 gcDhB2QFu+vbuP4yG/+N =8/9U -END PGP SIGNATURE- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] tablefunc extension
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/22/2013 04:17 PM, Joe Conway wrote: > If you still have a problem please provide SQL that can be cut and > pasted which: 1) create your table 2) insert sample rows Then show > us what out put you are trying to acheive as output from that > data. Oh, and switch to the pgsql-general list, as there is no evidence of any bug here. Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBAgAGBQJSP357AAoJEDfy90M199hlzyAP/1uVXwa9twDS6vB5EKiXbM6J FSrktrUzaQGA47onFZ6JKFjCSy4LIhaY7bev+VIW5m9hxVT5bNXe6uPqf6QT+pdK CevU7M29FUIB/ncF62aNYMIdjsM7yXqh+ppSQjqs2cs4jOWzn2BBxb1QCRezps2K sHwOi5VfqKGcl/7Za/aX6ojzNfssgi9YGWF20c7IHhhhNAlXOlw6ARmnv98lsaS/ tVIUuzibVjAD36f0v80lx3+oOVv9H4IMDKfcRQ/c+V5RlGvo6ZxUiJYxRre5GAcw 1SllJ46kyGXxdhIWkPKBxF8/4E+QMc1rOqlLrUgj3j/1Ymua0YNlIL70M9tBcPIJ idN/z+2jXYa8vHkLtpcjXTZGEhSEppCFOOw1sYEznqaSkVARabGptUsiKdGG8pll D0FvKVzJRQeKWxdP0q5LwTF5BSz9KILT9vKPHcMz0aN9ddf25oDv9B5gyQECRxEf BQYz0nULvz3YPAAaEIQRZehg6HBR7jM82dAu4Hnpm9la50rtmandefr9PliUMlXB N3kkpnFQGvFOJpbOAvpSYsaJ2PxjPErlxe/0R5aJVMnpq/4E+1WDNAzm907sIsyb raPFMY/0gEeqjVsZ2+o/fARj3FT1jlSkAKumo8Td0Q82bdisPgY7Bk6RqB3BDhEv ZERlQeMkTiWESjB46W+f =LUHW -END PGP SIGNATURE- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8466: pg_basebackup backup database is not ok
The following bug has been logged on the website: Bug reference: 8466 Logged by: liuguanhu Email address: liugua...@gmail.com PostgreSQL version: 9.1.6 Operating system: CentOS 5.9 Description: hi: I try use pg_basebackup backup my postgresql cluster database,when I use a shell script with cron.the postgresql log say 2013-09-22 04:30:01.780 CST,"gameop_bak","",28478,"127.0.0.1:40884",523e01c9.6f3e,1,"sending backup ""20130922""",2013-09-22 04:30:01 CST,49/0,0,LOG,08006,"could not send data to client: Connection reset by peer","pg_basebackup" 2013-09-22 04:30:01.780 CST,"gameop_bak","",28478,"127.0.0.1:40884",523e01c9.6f3e,2,"sending backup ""20130922""",2013-09-22 04:30:01 CST,49/0,0,FATAL,XX000,"base backup could not send data, aborting backup","pg_basebackup" 2013-09-22 04:30:01.781 CST,"gameop_bak","",28478,"127.0.0.1:40884",523e01c9.6f3e,3,"sending backup ""20130922""",2013-09-22 04:30:01 CST,49/0,0,LOG,08006,"could not send data to client: Broken pipe","pg_basebackup" 2013-09-22 17:25:01.386 CST,"gameop_bak","",23241,"127.0.0.1:34349",523eb76d.5ac9,1,"sending backup ""20130922""",2013-09-22 17:25:01 CST,49/0,0,LOG,08006,"could not send data to client: Connection reset by peer","pg_basebackup" 2013-09-22 17:25:01.386 CST,"gameop_bak","",23241,"127.0.0.1:34349",523eb76d.5ac9,2,"sending backup ""20130922""",2013-09-22 17:25:01 CST,49/0,0,FATAL,XX000,"base backup could not send data, aborting backup","pg_basebackup" 2013-09-22 17:25:01.387 CST,"gameop_bak","",23241,"127.0.0.1:34349",523eb76d.5ac9,3,"sending backup ""20130922""",2013-09-22 17:25:01 CST,49/0,0,LOG,08006,"could not send data to client: Broken pipe","pg_basebackup" that、 the pg_basebackup is not work ok -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] installation bug
Hello, I have tried to install postgresql many times, but every time i have in instalation error: Problem running post-install step. Installation may not completely correctly Error reading file C:/Program files(x86)/PostgreSQL/8.4/data/postgresql.conf I also tried different version of postgresql...also i tried to install in OpenGeo application pack.nothing works. Can you help me please? Thanks
[BUGS] BUG #8465: major dump/reload problem
The following bug has been logged on the website: Bug reference: 8465 Logged by: Jan Mate Email address: jan.m...@inf-it.com PostgreSQL version: 9.3.0 Operating system: all Description: Hi PostgreSQL team, today I tried to upgrade from 9.2 to 9.3 (pg_upgradecluster 9.2 main) and the upgrade of one of my databases failed with the following error: "ERROR: new row for relation ... violates check constraint ...". I created an example to reproduce this bug: http://www.inf-it.com/fixes/postgres-bugreport2/schema.sql steps to reproduce it (tested with version 9.3): createdb test && psql test < schema.sql pg_dump test > dump.sql dropdb test && createdb test && psql test < dump.sql -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] installation bug
Hi It seems the data directory was not created. Please send the installation logs from the %TEMP%. On Sat, Sep 21, 2013 at 3:39 PM, Ludvík Adamec wrote: > Hello, I have tried to install postgresql many times, but every time i > have in instalation error: Problem running post-install step. Installation > may not completely correctly Error reading file C:/Program > files(x86)/PostgreSQL/8.4/data/postgresql.conf > I also tried different version of postgresql...also i tried to install in > OpenGeo application pack.nothing works. > Can you help me please? > Thanks > > > -- Sandeep Thakkar
