Re: [GENERAL] \copy: unexpected response (4)

with a pipeline of data being shoveled through a shared library call under the foreign data wrapper, while postgres bravely and pointlessly carries on. Charlie ... -- View this message in context: http://postgresql.1045698.n5.nabble.com/copy-unexpected-response-4-tp1922077p5461710.html Sent from t

List Ettiquette (perhaps Off Topic by now) was: Re: [GENERAL] Database access over the Internet...

Steve Atkins wrote: On Nov 16, 2008, at 2:41 AM, Michelle Konzack wrote: Am 2008-11-15 09:53:15, schrieb Scott Marlowe: What's mess up is that the solution given the user DOES work. She just refuses to try it, because she assumes that the mailing list server doesn't see the exact same CC lis

[GENERAL] Backup & Restore

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] Linux distro

Raymond O'Donnell wrote: I'm about to install a new Linux server, and I've followed this thread with interest, being a tinkerer rather than any sort of expert. I'm going to try out Debian, which I haven't used before - the server it's replacing is running an old RedHat - and would be intereste

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

(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

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

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] ERROR: Gin doesn't support full scan due to it's awful

features.vector; I see why it would now. But it would be nice if the message mentioned the root cause of the problem - that the tsquery value does not contain any lexemes and thus is not valid for doing a search. Thanks, Charlie Teodor Sigaev wrote: explain analyze select * from test

Re: [GENERAL] ERROR: Gin doesn't support full scan due to it's awful

.006..0.010 rows=1 loops=1) Total runtime: 0.129 ms You see the same things if you put a NULL in the query column (unlike above). If instead, you do this in the script above: INSERT INTO test.maps (query) VALUES (to_tsquery('test')); Then it always works. Seems like the m

Re: [GENERAL] ERROR: Gin doesn't support full scan due to it's awful

Sorry, mistyped the query causing the problem. It is: select * from maps, features where maps.query @@ features.tags_vector; Thanks, Charlie Charlie Savage wrote: I've run across another GIN index issue - using postgresql 8.1.4 on Window/Linux with the GIN/tsearch2 patch. I hav

[GENERAL] ERROR: Gin doesn't support full scan due to it's awful inefficiency

ike an incorrect conclusion. So, two things: 1. How do I work around this issue? 2. Seems like postgresql should be smart enough to pick a query that will run. Thanks, Charlie ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

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

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

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

pg_backup -f charlie.dmp -F c charlie I've been able to restore on my development machine without any problems pg_restore -d test -c -O charlie.dmp (I have been given database and user names on the target machine than on the current one). but I get CONSTRAINT errors when I try this on the tar

RE: [GENERAL] Re: Windows install

It seems that the cygwin stuff comes with this install (I already had cygwin configured on my machine, but this install created another one, with all the details taken care of). The install went fine. Then i entered the cygwin shell (that had been installed with postgreSQL) and did "su postgres"

RE: [GENERAL] Describe structure.

Title: RE: [GENERAL] Describe structure. While we're on the topic, can someone tell me where '\d *' went, and what to use instead? That particular command seems to have disappeared in PG7. Thanks for any light-shedding... -cw- > -Original Message- > From: Poul L. Christiansen [ma

RE: [GENERAL]

First of all, thank you very much for this detailed answer. (and also thanx to Janet for asking :-] ) I am a postgresql newbie as well, and this is very very helpful. I had been trying to get things to work under NT, but decided to reboot to linux and try it there when I saw these detailed ins