[GENERAL] Backup & Restore

2007-08-06 Thread Charlie Clark
ewer errors as pg_restore exits on the first error Is the only way to drop the target database and recreate an empty one? Or am I simply misreading the docs? Thanks very much for any help. Charlie -- Charlie Clark Helmholtzstr. 20 Düsseldorf D- 40215 Tel: +49-211-938-5360 GSM: +4

Re: [GENERAL] Weird behaviour on a join with multiple keys

2007-03-09 Thread Charlie Clark
(and lc_ctype) in sync with server_encoding. That does indeed seem to have been the problem even though the examples I was looking at were all using plain ASCII characters. Glad to know it wasn't a bug and to have learned something new. Charlie -- Charlie Clark Helmholtzstr. 20 Düsseldorf D-

Re: [GENERAL] Weird behaviour on a join with multiple keys

2007-03-09 Thread Charlie Clark
Am 09.03.2007 um 05:30 schrieb Tom Lane: Charlie Clark <[EMAIL PROTECTED]> writes: I'm getting unexpected results on a query which involves joining two tables on two common variables (firstname and lastname). That looks like it should work. Given that you describe the columns

[GENERAL] Weird behaviour on a join with multiple keys

2007-03-08 Thread Charlie Clark
me)::text" "-> Seq Scan on table1 (cost=0.00..98.09 rows=4409 width=22)" " -> Sort (cost=1623.00..1667.00 rows=17599 width=21)" "Sort Key: (table2.lastname)::text, (table2.firstname)::text" "-> Seq Scan on table2 (cost=

Re: [GENERAL] How do I change sort order behavious with nulls

2005-02-20 Thread charlie clark
On Sat, 19 Feb 2005 12:01:07 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: On Sat, Feb 19, 2005 at 18:04:32 +0100, charlie clark <[EMAIL PROTECTED]> wrote: Dear list, is there a simple way to change the way ORDER BY works on columns with NULLs? I can understand the need for defau

[GENERAL] How do I change sort order behavious with nulls

2005-02-19 Thread charlie clark
with NULLs treated as <= 0. I've already tried a few things but nothing's working so far. Thanx for any pointers. Charlie -- Charlie Clark ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[GENERAL] Backuping and restoring databases on different systems

2004-06-26 Thread Charlie Clark
7;m over looking a simple command switch or are there other ways of doing what I want: drop the existing schema, import the backup, or do I need exta permissions for my user? Thank you very much. Charlie Clark ---(end of broadcast)--- TIP 1: subscri