I've seen this error on systems that don't realize they have Apple
Remote Desktop installed which has its own copy of Postgres - you may
be running a copy and not know it.
On Dec 28, 2006, at 11:04 AM, Tom Lane wrote:
Scott Ribe <[EMAIL PROTECTED]> writes:
Finally, the error message you're
I got this going with a dump/reload.
Beware however, 8.0b5 and the JDBC driver don't seem to work with UNICODE
encoding for the database. You have to use b4 or HEAD.
Hunter
> From: Kris Jurka <[EMAIL PROTECTED]>
> Date: Tue, 30 Nov 2004 01:34:46 -0500 (EST)
> To: Hun
I am having some trouble pulling some data out from the database. I have
tried against both 7.4.5, 8.0b4 and 8.0b5 and get the same result.
I have used both the v308 and CVS HEAD of the JDBC driver.
When I SELECT from a certain table, I see this JDBC exception:
"Invalid character data was found.
possible that this is an issue with beta5 in conjunction with the JDBC
driver and encoding? I didn't see a CHANGELOG note that would make me
suspicious but I'm not sure I would know if it I saw it.
Hunter
> From: Peter Eisentraut <[EMAIL PROTECTED]>
> Date: Wed, 24 Nov 20
I need to import a file into a Unicode database.
I am getting an error:
ERROR: Unicode characters greater than or equal to 0x1 are not
supported
CONTEXT: COPY mailing_list_entry, line 30928, column first_last_name:
"Ver?nica"
The source file came from pg_dump... Is there a way I can easily
ov 2004 21:21:25 +0100
> To: Hunter Hillegas <[EMAIL PROTECTED]>, PostgreSQL
> <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Mass Import/Generate PKs
>
> Hunter Hillegas wrote:
>> I have a CSV file with 400,000 lines of email mailing list
>> information that I n
I have a CSV file with 400,000 lines of email mailing list information that
I need to migrate to a new PostgreSQL database.
Each line has all the info I need except a PK (I usually use an int4 column
for a PK).
If the file were smaller I would probably just use Excel to pop in a PK and
then just
We use PostgresSQL 7.4 with JBoss without any trouble at all.
I believe the datasource samples that come with JBoss include a PG example.
We've found PostgreSQL to be an EXCELLENT companion to our Java server apps
(JBoss based J2EE, straight servlet, and Apple's WebObjects).
Hunter
> From: Razv
I have recently seen my 'postmaster' processes sucking up a lot of CPU.
What can I do to determine why they have started eating the processors?
I am running 7.4.2 on Red Hat Enterprise 2.1.
Thanks,
Hunter
---(end of broadcast)---
TIP 8: explain
Is there any reasonable PGSQL query that could do something like this:
Find all the releases from the releases table. For each release, do what is
basically a find and replace on a column? Each column contains slightly
different data and so the find and replace is not a constant. There needs to
be
I am trying to restore a file that I created using pg_dumpall.
I have searched the archives and the documentation. I know I am supposed to
use pg_restore but there is no example for restoring from a pg_dumpall file
(where the databases don't already exist).
How is it done? I think I have to speci
I see that this is in fact documenated in the man page for pg_dumpall, when
I was looking at psql and pg_restore.
Thanks,
Hunter
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I cannot determine what character is stored in a varchar...
For instance:
thedonnaholics=# select state from mailing_list where rec_num = 7;
state
---
(1 row)
If I then execute:
thedonnaholics=# select count(*) from mailing_list where state = '';
count
---
0
(1 row)
So, what i
ing_list where rec_num
= 7;
?column?
--
(1 row)
Any insight appreciated.
Thanks,
Hunter
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Fri, 08 Aug 2003 19:03:24 -0400
> To: Hunter Hillegas <[EMAIL PROTECTED]>
> Cc: PostgreSQL <[EMAIL PROTECTED]>
> Subject: Re:
hole build?
Thanks,
Hunter
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Mon, 28 Jul 2003 01:40:50 -0400
> To: Hunter Hillegas <[EMAIL PROTECTED]>
> Cc: PostgreSQL <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Can't Build 7.3.4 on OS X
>
> Hmph. It builds
The short answer is that most of your questions are still unknowns.
Both of the World Trade Center towers have collapsed after being hit by
hijacked passenger aircraft. 50,000 people work in the towers but there is
no estimated casualty figures.
Another hijacked passenger plane crashed into the
My postgres build on MacOS X is failing:
cc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-bundle -undefined suppress -bundle -undefined suppress fe-auth.o
fe-connect.o fe-exec.o fe-misc.o fe-print.o fe-lobj.o pqexpbuffer.o dllist.o
pqsignal.o -o libpq.so.2.1
/us
That fixed it! Thanks!
Hunter
> From: Stephan Szabo <[EMAIL PROTECTED]>
> Date: Mon, 23 Apr 2001 14:54:50 -0700 (PDT)
> To: Hunter Hillegas <[EMAIL PROTECTED]>
> Cc: PostgreSQL <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Query Question
>
> On Mon, 23 A
I have 4 tables: releases, artist_info, categories, and formats.
I am using this query:
SELECT DISTINCT *, categories.category_name as category_name,
categories.rec_num as category, formats.format_name as format_text,
releases.rec_num as release_rec_num, artist_info.name as artist_name FROM
rele
cally fuse them together...
Also, is there a good reference to the PostgreSQL function library? I've
looked around and can't seem to find one.
Thanks,
Hunter
--
Hunter Hillegas
[EMAIL PROTECTED]
I am considering migrating to PostgreSQL 7.1 from mySQL for some of my Web
applications.
I have a couple of questions:
1. The JDBC driver for mySQL will automatically escape special characters
(like single quotes) if you use the PreparedStatement class. Does the
Postgre JDBC driver do the same t
21 matches
Mail list logo
