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
Jeff Janes 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 various words in bi
On Tue, Jan 29, 2013 at 12: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');
I wa
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
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), ther
On Mon, Jan 28, 2013 at 2:37 PM, Alvaro Herrera
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 (pgsql-bugs@postgresql.org)
To
On Tue, Jan 29, 2013 at 12:20 PM, 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:
>
> Using the _ (u
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 -
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 the
