[BUGS] BUG #7834: Overflow with limited information provided

2013-01-29 Thread jackie . qq . zhang
The following bug has been logged on the website: Bug reference: 7834 Logged by: Jackie Zhang Email address: jackie.qq.zh...@gmail.com PostgreSQL version: 9.2.1 Operating system: Linux Description: Hi, PostgreSQL, I bumped into the error situation which only has

[BUGS] BUG #7835: The _ acts like a wildcard when used as '%_%'

2013-01-29 Thread elliott . groszek
The following bug has been logged on the website: Bug reference: 7835 Logged by: Elliott Groszek Email address: elliott.gros...@navy.mil PostgreSQL version: 9.0.11 Operating system: Linux Description: Using the _ (underscore) in a wildcard query accesses values with

Re: [BUGS] BUG #7835: The _ acts like a wildcard when used as '%_%'

2013-01-29 Thread Jaime Casanova
On Tue, Jan 29, 2013 at 12:20 PM, elliott.gros...@navy.mil wrote: The following bug has been logged on the website: Bug reference: 7835 Logged by: Elliott Groszek Email address: elliott.gros...@navy.mil PostgreSQL version: 9.0.11 Operating system: Linux Description:

Re: [BUGS] Re: BUG #7748: drop owned by fails with error message: unrecognized object class: 1262

2013-01-29 Thread Jeff Janes
On Mon, Jan 28, 2013 at 2:37 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Pushed, thanks. Jeff, Thomas, Jaime: please have a look and let me know what you think. I've tested it in the 9_2_STABLE branch and found no problems. Thanks, Jeff -- Sent via pgsql-bugs mailing list

[BUGS] BUG #7836: COPY command does not honor 'FORMAT' option

2013-01-29 Thread kurt . lidl
The following bug has been logged on the website: Bug reference: 7836 Logged by: Kurt Lidl Email address: kurt.l...@cello.com PostgreSQL version: 9.2.2 Operating system: FreeBSD 9.1 (i386 - 32bit) Description: The COPY documentation says that with 9.1 (or newer),

Re: [BUGS] BUG #7836: COPY command does not honor 'FORMAT' option

2013-01-29 Thread hubert depesz lubaczewski
On Tue, Jan 29, 2013 at 06:20:05PM +, kurt.l...@cello.com wrote: template1=# copy pg_aggregate to '/tmp/agg.bin' with format binary; correct syntax: copy pg_aggregate to '/tmp/agg.bin' with (format 'binary'); Best regards, depesz -- The best thing about modern society is how easy it is

Re: [BUGS] BUG #7836: COPY command does not honor 'FORMAT' option

2013-01-29 Thread Jeff Janes
On Tue, Jan 29, 2013 at 12:19 PM, hubert depesz lubaczewski dep...@depesz.com wrote: On Tue, Jan 29, 2013 at 06:20:05PM +, kurt.l...@cello.com wrote: template1=# copy pg_aggregate to '/tmp/agg.bin' with format binary; correct syntax: copy pg_aggregate to '/tmp/agg.bin' with (format

Re: [BUGS] BUG #7836: COPY command does not honor 'FORMAT' option

2013-01-29 Thread Tom Lane
Jeff Janes jeff.ja...@gmail.com writes: I figured out the need for the parenthesis by reading the docs. The need to also quote 'binary' really took me by surprise, especially as the other two formats don't need to be quoted. I assume the reason for this is the level of reservedness of the

Re: [BUGS] BUG #7836: COPY command does not honor 'FORMAT' option

2013-01-29 Thread Kurt Lidl
On 1/29/2013 3:19 PM, hubert depesz lubaczewski wrote: On Tue, Jan 29, 2013 at 06:20:05PM +, kurt.l...@cello.com wrote: template1=# copy pg_aggregate to '/tmp/agg.bin' with format binary; correct syntax: copy pg_aggregate to '/tmp/agg.bin' with (format 'binary'); Best regards, depesz