Re: [GENERAL] like performance w/o wildcards.

2003-08-03 Thread Joseph Shraibman
Hmm. I didn't work for me. I'll try and figure this out. Tom Lane wrote: Joseph Shraibman <[EMAIL PROTECTED]> writes: I notice in 7.3.3 the planner can't tell when a LIKE has no wildcards and is in reality an '='. Is this an easy change to make? On what do you base that conclusion? regress

Re: [GENERAL] pg_dumpall doesn't support -s anymore?

2003-08-03 Thread Tom Lane
Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > In 7.3.3 this no longer works (the -a option is gone too). If you're feeling desperate you could probably backpatch this 7.4 fix: 2003-05-30 19:55 tgl * doc/src/sgml/ref/pg_dumpall.sgml, src/bin/pg_dump/pg_dumpall.c: Cause pg_

[GENERAL] pg_dumpall doesn't support -s anymore?

2003-08-03 Thread Martijn van Oosterhout
Hi, Our backup scheme involves dumping the schema with pg_dumpall (including users, groups, etc) using the -s option. Then the databases are dumped individually with pg_dump -a. This works in 7.0. In 7.3.3 this no longer works (the -a option is gone too). Is there any particular reason for this?

Re: [GENERAL] COPY and double-quote-separated fields

2003-08-03 Thread Ron Johnson
On Sun, 2003-08-03 at 06:08, Jason Godden wrote: > Hi Ron, > > I have the same issue - best thing is to run the data through sed but pipe it > straight to the psql import table - that way you never have to worry about > creating misc. files. I also always use an intermediate temporary import >