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 int
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 wrote:
> On Friday, December 30, 2011 7:49:31 am Culley Harrelson wrote:
> > They are just your sta
rd for 653009.
On Fri, Dec 30, 2011 at 6:51 AM, Adrian Klaver wrote:
> 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 th
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 migrati
lto:pgsql-general-
> > 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
** **
>
> David J.
>
> ** **
>
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *Misa Simic
> *Sent:* Tuesday, December 20, 2011 7:13 PM
> *To:* Culley Harrelson; pgsql-general@postgresql.org
> *Subject:* Re: [G
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 of
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 . I don't know the inner workings of
database internals but I would guess that there would be some
optimized way of c
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
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 :=
setweight(to_tsvector(coalesce(NEW.d
he worms 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 should be the same:
select 'lydia eugenia treviño', convert('lydia eugenia treviño' using
ascii_to_utf_8);
but they seem to be different. What am I missing?
culley
---(end of broadcast)---
TIP 8: explain analyze i
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 version
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 7.3.3.
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 hav
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 al
k the mail archives.
>
>thanks,
>--Barry
>
>
>Culley Harrelson wrote:
>>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 Postgr
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)
>
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?
I'm in the process of implementing connection pooling
and the setup I'm using (http://www.javaexchange.com -
really slick!) has settings for min # connections and
max # connection. Any suggestions on where I should
set these values? min=2, max=6? My site will be
outside the firewall, open to the
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 email
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 PROTECTE
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/
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 ind
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 /usr/local/tomcat/
Best, depending on the scenario. In cases where you
are using a fixed number
of characters, there's no need for the overhead of a
varchar. For instance
if you are storing state abbreviations, they will
ALWAYS be 2 characters.
The database can look up those fixed fields
32 matches
Mail list logo
