Great news. Thanks.
Thanks Tom, Sorry if that last post went over multiple times. I was getting
a mailing failure (or so I thought)
here is EXPLAIN ANALYZE . I really need to work on my skills at analyzing
these:
Limit (cost=105505.78..105505.83 rows=20 width=655) (actual
time=74806.973..74807.037 rows=20 loops=1)
There are less than 20,000 records being searched here, but the query takes
several minutes.
I know this may not be enough info, but would one suggest I optimize the
query or put my attention towards other areas.
SELECT id,date,headline as head,headline(body,q),rank(vectors,q),timestamp
FROM sto
There are less than 20,000 records being searched here, but the query takes
several minutes.
I know this may not be enough info, but would one suggest I optimize the
query or put my attention towards other areas.
SELECT id,date,headline as head,headline(body,q),rank(vectors,q),timestamp
FROM sto
On Jul 17, 2007, at 3:13 AM, Vince wrote:
When this fails, I get a useful error print:
$dbconn = pg_connect($connection_str);
Ouput:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: password authentication failed for user
"postgres1" in ...
How do
On May 14, 2007, at 6:21 PM, George Heller wrote:
psql mydatabase postgres
it gives me the error,
psql: could not connect to server: No such file or
directory
Depending on your setup, postgres might not be starting automatically
on reboot.
Try:
pg_ctl start -D [datadir]
replacing [datadi
On Jan 8, 2007, at 9:20 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a
SERIAL
On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a
SERIAL type column?
Or rather, how does one approach
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a SERIAL
type column?
Or rather, how does one approach that situation most effectively?
Could you give an example of
Is it true that you can't use COPY FROM to fill a table with a SERIAL
type column?
Or rather, how does one approach that situation most effectively?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
I suppose I should have named things differently but is there a way to
join two tables with a bunch of identical column names and rather than
explicitly alias each column just use some sort of wildcard like:
SELECT tablename.* AS alias.*
OR do I have to name each column like:
columnname as
here is an interesting question (to me)
suppose you wanted to be certain that either one of two or more columns
were present
Like in a user table, either a username or an email need to be present
to create a row.
You can't use not null because it's an either or situation.
what's the best
I'm looking into methods to store XML docs for query and retrieval
across all the docs or subsets.
I've looked over a couple of options and may end up creating relations
with the data.
Are there any "Super" solutions that I might be overlooking.
Also, this article claims that these functions a
reading the docs . . . let's see if I've got it.
1. Timestamp with timezone accepts a timestamp with the additional
timezone, converts it and stores it as GMT
2. It returns the value as the timestamp converted to the timezone of
the local machine?
---(end of broadcas
I want a query to return all the rows from one table along with a count
of rows in another table that reference each returned row from the
first table.
For instance, if you had a table of children and another table of
grandchildren that had a foreign key on the children table, I'd want to
r
On Nov 2, 2005, at 6:08 PM, Michael Glaesemann wrote:
As an aside, it's interesting to see that the PHP documentation states:
---
Magic Quotes is a process that automagically escapes incoming data to
the PHP script. It's preferred to code with magic quotes off and to
instead escape the data a
As much as I respect Marc and Postgresql.org, I can't see Oracle hiring
him away as a "killer" threat to the community. People would set up
camp somewhere else, like Command Prompt. It would hurt things for a
while but the software is too important to too many to be killed by a
domain name or p
On Oct 8, 2005, at 11:25 PM, Uwe C. Schroeder wrote:
Didn't MySQL AB acquire SAPdb (which was Adabas D before)? AFAIK (and
you're
welcome to correct me since I might very well be wrong) SAPdb supports
transactions and foreign keys. If that's the case MySQL AB might be
in a
position to offer
On Oct 8, 2005, at 10:34 PM, Marc G. Fournier wrote:
Are there any lessons to be learned from this with regards to
PostgreSQL?
Like Marc said, doesn't seem to be a worry to the Postgres community .
. .
Unless this is all really an Oracle ploy to grab the competition to the
their real fut
On Oct 8, 2005, at 5:11 PM, [EMAIL PROTECTED] wrote:
I don't understand. If both MySQL and Innodb are GPL licensed,
commercial or not should make no difference, and they can add all the
GPL changes they want o the last Innodb GPL release.
MySQL owns their code so they can release it with wha
On Oct 8, 2005, at 2:04 PM, CSN wrote:
AFAIK MySQL's fulltext indexing is only supported on
MyIsam tables, so if you want to use it, you lose
ACID,
For me, the fact that to use a feature means one needs to give up
ACIDity ends any debate on which DB to choose, and I'm not even a power
user
I had thought we were completely sunk until we moved everything over
to .Net.
Insert microsoft wisecrack of your choice here : )
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Sep 16, 2005, at 4:30 PM, Russ Brown wrote:
just because replication is included and
part of the core of a database, it doesn't mean that it's reliable or
well tested.
I just jumped into this thread, and this statement just triggers one
thought.
Many Postgres end users rely on experts
On Sep 13, 2005, at 5:05 PM, Federico Kereki wrote:
I'm having problems trying to install the PHP module for Apache2.
It seems it requires libpq.so.4 but the latest 8.0.3 PostgreSQL
version doesn't include it -- though it does include a libpq.so.3.
I hope you are getting help from Scott
On Sep 9, 2005, at 8:02 PM, Matthew Terenzio wrote:
On Sep 9, 2005, at 7:54 PM, Scott Marlowe wrote:
On Fri, 2005-09-09 at 18:35, Matthew Terenzio wrote:
On Sep 9, 2005, at 7:21 PM, Ron Mayer wrote:
I've found that with if you can get 5 companies/users to share a
dedicated server yo
On Sep 9, 2005, at 7:21 PM, Ron Mayer wrote:
I've found that with if you can get 5 companies/users to share a
dedicated server you can be much better off than a hosting plan,
and have full control over the services you run.
I'm sure the numbers work out, but it sounds like being in a Band.
On Aug 16, 2005, at 9:37 PM, Matthew Terenzio wrote:
db=# ALTER TABLE ONLY table ADD CONSTRAINT "$1" FOREIGN KEY (user)
REFERENCES users(user_id);
ERROR: syntax error at or near "user" at character 56
I'm either blind or something besides syntax can cause this e
db=# ALTER TABLE ONLY table ADD CONSTRAINT "$1" FOREIGN KEY (user)
REFERENCES users(user_id);
ERROR: syntax error at or near "user" at character 56
I'm either blind or something besides syntax can cause this error. no?
---(end of broadcast)---
T
I'm trying to do a full text search for URL's stored in a table.
SELECT *,headline(description,q), rank(vectors,q) FROM bb_item,
to_tsquery('http://www.yahoo.com') AS q WHERE vectors @@ q ORDER BY
rank(vectors,q) DESC LIMIT 10 OFFSET 0
I get a general syntax error. I know it;s the colon in th
If I'm using Tsearch2 to search a public online forum, do you think
it's okay to update on every forum entry?
Put another way: is to_tsvector() resource intensive when used in this
way?
---(end of broadcast)---
TIP 6: explain analyze is your
On Jul 12, 2005, at 11:43 PM, Joshua D. Drake wrote:
Matthew Terenzio wrote:
I 'm storing things in a table with now() and I want to select * from
theTable WHERE the Timestamp is > the current time - 20 minutes
Anyone know the correct syntax. I was trying something lik
I 'm storing things in a table with now() and I want to select * from
theTable WHERE the Timestamp is > the current time - 20 minutes
Anyone know the correct syntax. I was trying something like:
WHERE timestamp_field > (timestamp now() - interval '20 minutes')
and will continue reading the
On Jul 10, 2005, at 9:44 AM, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- From a wikipedia list I'm on:
At the moment there's not even anyone maintaining our PostgreSQL
support, which as free software is more accessible to users and
developers. Oracle isn't ev
I recently moved a database to a new machine:
PostgreSQL 7.4.7 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC)
3.4.2 [FreeBSD] 20040728
any queries related to tsearch2 give me this error:
ERROR: cache lookup failed for function 17188
I am running the same versions of Postgres, Freebsd
Any FreeBSD experts know what conditions might have the port
(postgresql-server-8.0.1_3) look like like it installs successfully but
/usr/local/pgsql/data is not created and so there is no postgresql.conf
to find.
also running /usr/local/etc/rc.d/010.pgsql.sh initdb looks like it
just shoo
I f you are using Apache, also check the max connections in the
httpd.conf. You really can't allow more Apache children than your max
number of Postgres connections. At least it solved the problem in my
case.
On May 23, 2005, at 9:47 AM, Richard Huxton wrote:
Shaun Clements wrote:
Thanks. G
On May 3, 2005, at 8:30 PM, Randal L. Schwartz wrote:
Is there a simple way with PostgreSQL to assign relative ranks to the
result of a query ORDER BY?
What do you mean by ranks?
---(end of broadcast)---
TIP 9: the planner will ignore your desire to
On Apr 7, 2005, at 11:33 PM, David Fetter wrote:
Relational purists sometimes insist that artificial keys cause more
problems than they solve
That's interesting.
It seems to come in handy for me. It is interesting though.
---(end of broadcast)---
TIP
I'm noticing that a sequence is advancing even if the insertion fails.
Is this weird or expected?
Matt Terenzio
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Mar 25, 2005, at 9:28 PM, Tom Lane wrote:
Matthew Terenzio <[EMAIL PROTECTED]> writes:
Anyone with any TSearch2 experience on FreeBSD? Any known Gotchas?
Postgres 7.3
ERROR: Load of file /usr/local/lib/postgresql/tsearch2.so failed:
dlopen '/usr/local/lib/postgresql/tsearch2.so
Anyone with any TSearch2 experience on FreeBSD? Any known Gotchas?
Postgres 7.3
Postgres is working fine and the Port for contrib seemed to install
okay. tsearch2.so is indeed in the below directory and permissions look
right.
$ psql database < tsearch2.sql
SET
BEGIN
NOTICE: CREATE TABLE / PRIM
Trying vacuumdb eventuallydisplays this:
ERROR: catalog is missing 3 attribute(s) for relid 31457
vacuumdb: vacuum databasename failed
There is another thread which states this is a corrupted systems
catalog. Is this definitely the case? Does it mean I need to re-build
the database? Re-install?
Meant this to go to whole list , sorry for duplicate
Begin forwarded message:
On Dec 29, 2004, at 4:58 PM, Dave Smith wrote:
I am trying to figure out the fastest way to move rows from a current
table to a history table. There are currently 150,000 rows of which
about 60,000 get moved (monthly). Th
43 matches
Mail list logo
