Hello I am trying to migrate a database from 8.4.0 to 9.1.2 on a test
server before updating the production server. When piping the dump file
created with pg_dump in psql I am getting duplicate key errors and the
primary keys on several large tables do not get created. I have read all
the
.
On Fri, Dec 30, 2011 at 6:51 AM, Adrian Klaver adrian.kla...@gmail.comwrote:
On Friday, December 30, 2011 6:32:56 am Culley Harrelson wrote:
Hello I am trying to migrate a database from 8.4.0 to 9.1.2 on a test
server before updating the production server. When piping the dump file
There is not any data in the new database. I have dropped the database,
created the database and then piped in the backup every time.
On Fri, Dec 30, 2011 at 8:06 AM, Adrian Klaver adrian.kla...@gmail.comwrote:
On Friday, December 30, 2011 7:49:31 am Culley Harrelson wrote:
They are just
This is just the first of many duplicate key errors that cause primary key
creation statements to fail on other tables. I grepped for the key but it
is hard to tell where the problem is with 888 matches.
I will try pg_dump --inserts. It is a 17G file with copy statements so...
this should be
-
ow...@postgresql.org] On Behalf Of Alban Hertroys
Sent: Mittwoch, 21. Dezember 2011 08:53
To: Culley Harrelson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] design help for performance
On 21 Dec 2011, at 24:56, Culley Harrelson wrote:
Several years ago I added
I am bumping into some performance issues and am seeking help.
I have two tables A and B in a one (A) to many (B) relationship. There are
1.4 million records in table A and 44 million records in table B. In my
web application any request for a record from table A is also going to need
a count
:13 PM
*To:* Culley Harrelson; pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] design help for performance
** **
Hi Culley,
Have you tried to create fk together with index on fk column on table B?
What are results? Would be good if you could send the query and explain
analyze
Hi,
I am using Postgresql 7.4. I have a table with 1.5 million rows. It
has a primary key. VACUUM FULL ANALYZE is run every night. There are
2000-5000 inserts on this table every day but very few updates and
deletes. When I select count(*) from this table it is using a
sequence scan. Is this
On Fri, 07 Jan 2005 16:17:16 +0100, Tino Wildenhain [EMAIL PROTECTED] wrote:
How do you think an index would help if you do an unconditional
count(*)?
I really don't know grin. I don't know the inner workings of
database internals but I would guess that there would be some
optimized way of
Hi,
We just experienced this bug:
http://tinyurl.com/28gkh
on 7.4.1 (freebsd and os x). Is there any chance this is on the list
for 7.5?
culley
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
I am getting this error:
fmgr_info: function 7390843: cache lookup failed
when trying to insert some data into a table using the tsearch2 contrib
module (this is postgresql 7.3). I have the following trigger defined:
BEGIN
NEW.search_vector :=
around a bit, wrinkle my nose then promptly close the can
again and stuff it away for another 6 months. :) Wish I could figure it
out.
On Sun, 19 Oct 2003 00:31:43 -0700 (PDT), Stephan Szabo
[EMAIL PROTECTED] said:
On Sun, 19 Oct 2003, culley harrelson wrote:
It seems to me that these values
It seems to me that these values should be the same:
select 'lydia eugenia trevio', convert('lydia eugenia trevio' using
ascii_to_utf_8);
but they seem to be different. What am I missing?
culley
---(end of broadcast)---
TIP 8: explain analyze is
DeJuan Jackson wrote:
I have a suspicion that the version might be different. I have the same
symptom here on two different RH 7.3 boxes one running 7.3.2 and the
other running 7.3.3
It would appear 7.3.2 is more strict about the naming of the GROUP BY
fields.
They really are the same
That's a guess that doesn't really explain why it'd work under one OS
and not under another. Are the two versions of Postgres configured
the same?
I suppose they could be configured differently. I don't know how to
investigate this.
It isn't really a problem for me-- just strange.
culley
I don't know if this is a postgresql bug or a problem with my
architecture but I thought I would post here about a strange bug I just
came across in my application.
I use OS X 10.2.6 as my development machine and FreeBSD 4.8 for my
production machines. All systems are running postgresql
Dennis Gearon wrote:
so,
if Postgres were to have a manual like PHP's OLD manual(more next),
that would be a worthwhile contribution?
the new manuals seems to be drifting to using only GOOGLE listings.
MUCH less information on one page, not nearly as good search results as
the old one. I
Did you actually read the cited links?
I read the 7.3 docs then fired off an email and forgot about 7.4 docs.
duh! sorry.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I have the exact opposite problem-- I keep turning off direct mailing for
pgsql-general (with successfull confirmation) and it keeps sending me mail
anyway! haha
culley
--- David Link [EMAIL PROTECTED] wrote:
Jim Caley wrote:
Has anyone heard any more about this problem? I also haven't
For anyone who was watching me flail with JDBC and UNICODE...
I finally gave up on unicode-- I switched the database encoding to
MULE_INTERNAL and JDBC is handling everything I can throw at it (we'll just
have to wait and see if my users manage to enter some unsupported
characters). Thanks
. But check out the info at:
http://lab.applinet.nl/postgresql-jdbc/#CharacterEncoding
for a brief discussion of what I believe is your problem. There has also
been a number of discussions on this on the pgsql-jdbc mail list. You
might also want to check the mail archives.
thanks,
--Barry
Culley
Hello,
my isp recently upgraded form postgreSQL 7.0 to 7.1. It went pretty well
but I just discovered that non-english characters are now in the database
as a question mark-- inserting non-english characters produces a ? as
well. Any idea what has gone wrong and what we need to do to fix this?
The was corrupted in the process of the upgrade.
Is there some way to tell what the configuration options were when it was
installed? I am assuming by API you mean how am I accessing Postgres? JDBC.
Culley
X-Apparently-To: [EMAIL PROTECTED] via web9605; 10 Sep 2001
18:19:26 -0700 (PDT)
Can you create a full text index on more than one
column in a table?
Culley
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
columns with default timestamp('now') see to be
defaulting to the time I started posgresql!
What am I doing wrong here? Is it an os problem?
Need these columns to capture the current date and
time.
Culley
__
Do You Yahoo!?
Get personalized
Any suggestions on how to select a random record from
any given table?
Culley
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
Can this be done in the framework of plpgsql? I know
I can do it in the front end (java) but it would be
nice to aviod having to grab the rowcount first. I
haven't seen a random function in the documentation.
I could install another language but boy am I lazy :)
--- Mark Lane [EMAIL
Hi,
OK full text searching. Will the full text index
catch changes in verb tense? i.e. will a search for
woman catch women?
I'm researching before I dive in to this later in the
week so please excuse this incompletely informed
question: Will I need to rebuild postgresql with the
full-text
is there a way to make a unique index case insesitive
for text data? I can change case in my front end code but I
thought I'd ask :)
Hi,
I'm pulling my hair out trying to establish a jdbc
connection to postgresql. The error I recieve is:
unable to load class postgresql.Driver
I can however import org.postgresql.util.* without
generating an error through tomcat when I put the
postgresql.jar directly in the
30 matches
Mail list logo
