Hi all -
I'm trying to add functional index support to Rails' Active Record and
am getting stuck when it comes to a method Rails has to print out the
indexes associated with a given table.
The SQL being run is below:
SELECT distinct i.relname, d.indisunique, a.attname
FROM pg_class t, pg_class
Bill Moran [EMAIL PROTECTED] writes:
First off, clustering is a word that is too vague to be useful, so
I'll stop using it.
Right. MySQL Cluster, on the other hand, is a very specific technology.
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html
It is, however, capable of being d*mn
Maybe this is a well duh kind of question, or maybe there's no
straightforward way to do it, but is there any way that I could have a
pg function initiate a process on the host system?
Specifically I'd like to script an email to send off on an insert
trigger, but the ability to initiate system
That's not on my mac. Must be some bolt-on you installed.
So how did you get it working?
(I have no idea how this file got there. Wouldn't know where to begin)
Coming in late so maybe someone already posted this, but I used this:
http://www.postgresqlformac.com/
I wanted the server too,
I've just stumbled across pgsnmpd. It works quite well,
though I haven't yet found a web-based monitoring
software that works well with pgsnmpd. The problem is
that pgsnmpd exportsa bunch of values _per_ database.
(The output of snmpwalk looks something like
PGSQL-MIB::pgsqlDbDatabase.1.1.3 =
Is there any inbuilt facility in postgres for connection pooling .. ??
Not built in, but...
http://pgpool.projects.postgresql.org/
Never used it myself...
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the more they think it is what
they need :-)
I think
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the more they think it is what
they need :-)
I think that description is false. At a certain point in the
management
On Sun, 2006-04-30 at 14:32, Tony Lausin wrote:
[ rotfl... ] MySQL will fall over under any heavy concurrent-write
scenario. It's conceivable that PG won't do what you need either,
but if not I'm afraid you're going to be forced into Oracle or one
of the other serious-money DBs.
That's a scary idea - being forced into Oracle or Sybase. Isn't
Slashdot.org still running strongly off of MySQL?
Depends on how you define strongly. Slashdot has a LOT of code in place
to cache the content so it never has to hit the database directly.
Basically, every X seconds, the data
There are other techniques to balance the load of the database calls so that
some go to one box and some to others, yet keep the data in synch...
Continuent makes a commercial p/cluster product as well as an open source
product called Sequoia that sit in the JDBC layer and direct traffic and
I have a table of vacations
create table vacation (
id integer primary key,
dstart date,
dend date );
I need to find first non-vacation day before given date.
This can be done using the following procedural vfp code
function nonvacation( dbefore )
for i=dbefore to date(1960,1,1) step -1
I have a table of vacations
create table vacation (
id integer primary key,
dstart date,
dend date );
I need to find first non-vacation day before given date.
This can be done using the following procedural vfp code
function nonvacation( dbefore )
for i=dbefore to date(1960,1,1) step -1
[ Comment asking what we can do to protect ourselves.]
We can't do much, actually. The trademark thing can be secured, but
other than that, I see no other defenses we could use. We can't prevent
people from being hired, and we can't guard against patent attacks.
Seems you could argue that if
But no, Mark, I'm not worried by the FUD. It just means there's nothing
real for them to throw at PostgreSQL.
This just appeared on slashdot...
MySQL To Be Ikea Of The Database Market
http://developers.slashdot.org/article.pl?sid=05/10/07/1224213from=rss
From the linked article...
On Thu, Oct 06, 2005 at 10:10:14AM -0500, Scott Marlowe wrote:
But what really bugs me is that some things that ARE bugs simply aren't
getting fixed and probably won't. Specifically, while mysql understands
fk references made at a table level, it simply ignores, without error,
warning, or
I need to extract a SETOF column names for a table in plpgsql. How is this
done?
Start up psql with the -E option. Then type \dt tablename. This will
print out the SQL that psql runs to give you the column names. Maybe that
will do what you want?
-philip
---(end
contrib/tsearch2 ( http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ )
might works for you. It might because performance depends on cardinality of
your keywords.
Seconded. We use tsearch2 to earch about 40,000 rows containing
manufacturer, brand, and product name and it returns a
I'm sharing with 5 other small businesses a dedicated server with 60GB
hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month.
Where is this available?
Not quite that package and I've never used them (thinking about it), but
layeredtech.com has this as their cheapest:
. Intel
Where can I find instructions to install these functions in my 7.4 version?
I am awaret hat they are in the contrib. folder but I have never installed
functions from the contrib folder. Thanks in advance.
From postgresql-7.4.2/contrib/README:
Each subdirectory contains a README file with
we are developing GNUmed, a medical practice management
application running on PostgreSQL (you want your medical
data to be hosted by something reliable, don't you ;-) We
are putting out our first release sometime in the next two
weeks.
The idea is to name the production database gnumed0.1 for
Is anybody else thinking about the limits of SQL? As often I am probably
not the first to ask these questions. Any pointers?
Joe Celko (sp?) has a couple of books on this subject, SQL for Smarties. I
don't recall if he talks about graphs, but does discuss queries on tree
relationships.
I've
...We are proposing that Postgres be used for the application database.
Not too surprisingly we are being asked for additional information because
Postgres is open source.
So is the implication that they think open source is a bad thing? I would
think they would question a recommendation for
Hi all -
We've got a product built on FreeBSD and PostgreSQL 7.4.2 that
I've had to fit onto an installable CDROM tradeshows and customer demos.
This is the only way I've found to ensure an easy to re-install option
for the non-technical folks at the tradeshows should they corrupt the box
It is. We have been fooling with the postmaster startup logic to try to
eliminate this gotcha, but it's only very recently (8.0.2) that I think
we got it right.
So, then it would be correct to change my init scripts to do the
following: (if so, this patch can be applied to the 7.4 branch)
I
http://www.google.com/search?q=tsearch2
The first link contains info and links to what I used... worked all right
for me.
good luck!
On Sun, 17 Apr 2005, Tobias Heise wrote:
HI Everybody!
Could everyone give me a short instruction how to use tsearch2,
please?
Tobias
2. Statistics monitor (this is built in to the product):
http://www.postgresql.org/docs/current/static/monitoring-stats.html
Does anyone think an SNMP interface to these would be useful?
I do. Would make it easy to hook it up to MRTG, Cacti, or some other
monitoring system. Would be nice for
Take a look at the LIMIT part of the SELECT statement. in your case you'd
do:
select * from tablename limit 21;
ALthough you'll want to use an ORDER BY otherwise you could get different
results each time..
-philip
On Thu, 13 Sep 2001, Mike S. Nowostawsky wrote:
How can one select only a
Hi all -
I have some questions about tuning the various kernel parameters
on FreeBSD. I've read Bruce's article a couple of times and the various
parts of the documentation, but I still have some questions and was hoping
people here could confirm/deny my assumptions.
The machine in
You could take the password hashing routine out of client/password.c (in
the mysql source) and write your own C function... I know just enough C
to think that it shouldn't be that hard, but not enough to do it :)
-philip
On Sun, 15 Jul 2001, Jason DiCioccio wrote:
I am looking for a
Look at the SERIAL type and the CREATE SEQUENCE documentation.
-philip
On Thu, 12 Jul 2001, Markus Jais wrote:
hi
I have the following problem:
I create the following table:
CREATE TABLE address (
address_id int PRIMARY KEY ,
street VARCHAR(40),
zipcode
I missed the first part, but if the numbers are rows in a table, why not
do something like:
numrows = select count(*) from table1 where some_condition
median_value = select some_col from table1 where some_condition order by
some_col limit numrows/2, 1
(or something very close to
Neil Conway [EMAIL PROTECTED] writes:
It's just
for i in t1 t2 t3; do pg_dump -t$i mydb $i.tbl; done
Although with a strategy like this, they're no guarantee that the
snapshot you get will be consistent. And if you're using refential
integrity it might not even restore properly.
As someone else pointed out you can upgrade to 7.1. Or you can add your
own operators/functions.
I've included the C source and SQL create script. You'll need to do this
as the postgres superuser. And you'll probably need to edit the SQL
script and adjust the path of the .so file. The .c
Hi all -
I'm not here to start a war, but it seems to me that there is a
fairly large amount of MySQL bashing in this group. Why? What's the
point? It seems to me that if PostgreSQL wants an enemy to fight it
should be Microsoft SQLServer and Oracle. It seems to me that it's
Hi all -
Are triggers part of the transaction block that triggered the
trigger? I mean if I have a trigger that updates (an insert) a table (say
for logging or whatever) and that insert fails will the original query the
fired the trigger also get rolled back?
I'm using 7.0.3.
Thanks!
http://www.heraut.demon.nl/
I've only played with it and stopped because the SQL it generated was a
little odd (but maybe I'm just not thinking straight). It's the only one
I've ever found that supports mysql/postgresql though.
-philip
On Wed, 13 Dec 2000, Phil Glatz wrote:
I putting
On Jue 16 Nov 2000 22:54, Marko Kreen wrote:
On Thu, Nov 16, 2000 at 01:33:08PM -0400, The Hermit Hacker wrote:
I run PHP4 and IMP (http://www.horde.org) and we've gotten then to remove
the useof pg_pconnect() since it is broken. Broken how, you might
ask? Well, I ran on a
Thanks Tom!
I also realized (after I sent this of course :) that I could check the md5
signatures of my tar.gz with the one on the ftp site...
-philip
On Tue, 14 Nov 2000, Tom Lane wrote:
Philip Hallstrom [EMAIL PROTECTED] writes:
I downloaded 7.0.3 from ftp.postgresql.org yesterday
I downloaded 7.0.3 from ftp.postgresql.org yesterday (monday 14th). It
didn't say anything about a pre-release... is there some way to tell if I
have the final version?
On Sun, 12 Nov 2000, The Hermit Hacker wrote:
After a couple of pre-release tarballs, the PostgreSQL Developers are
proud
wrote:
Philip Hallstrom [EMAIL PROTECTED] writes:
NOTICE: AbortTransaction and not in in-progress state
IIRC, 7.0.3 fixes some problems that could lead to that message.
If you can still reproduce this with 7.0.3, it'd be interesting
to turn on query logging (-d2 to postmaster) and see
Hi -
I recently tried to start postmaster (7.0.2) with -B 128 -N 64 and
got the "semget failed" error. Looking in the faq[1] it says I need to
increase the amount allowed in the kernel. It tells me what I need to do,
but my question is what values should I set them to? Is there any way
* Philip Hallstrom [EMAIL PROTECTED] [001109 19:12] wrote:
Hi -
I recently tried to start postmaster (7.0.2) with -B 128 -N 64 and
got the "semget failed" error. Looking in the faq[1] it says I need to
increase the amount allowed in the kernel. It tells me what I
I'm starting postmaster as follows:
postmaster -i -D /local/db/postgresql/data -d 2 ! /var/log/postgresql'
I'd like to use newsyslog (automatically rotates logs) to keep the log
file in check, but I don't know how to tell postmaster to close/re-open
the log file... I'd rather not restart it
Hi -
I'm thinking about using postgres for an app that will store
various email messages which might (although probably not likely) be
larger than the builtin limit for tuples. Is there anything I should be
aware of before changing the below value and recompiling?
Also, it looks like
That doesn't work for me...
I get a parser error...
devloki= create index foo on rolo_entry (UPPER(text(fname)));
ERROR: parser: parse error at or near "("
-philip
On Thu, 10 Aug 2000, Joshua Adam Ginsberg wrote:
What I do is just invoke upper(text(field))... that converts the varchar
to
Hi -
I have a table that has a varchar field (fname). I'd like to
create an index on UPPER(fname), but am running into problems...
What I don't understand is that I can do "SELECT UPPER(fname) FROM
mytable" and it works just fine. I also tried creating a SQL function
that did upper for
Hi -
The following statements lock up my machine completely (I can
ping, but can't telnet, nothing). This is FreeBSD 3.4-STABLE running
7.0.2.
rolo_entry.fname is of type VARCHAR(30).
devloki= CREATE FUNCTION upper(VARCHAR) RETURNS TEXT AS '
devloki' BEGIN
devloki' RETURN
ine.
I just realized this after someone mentioned there was probably a
recursive loop, but wouldn't that affect simple select statements as well?
Oh well... I've renamed my function with a prefix which I'll probably just
do all the time as it makes it easy to know what's mine and what's not.
-philip
Yes... it is odd... especially since the following works fine:
SELECT UPPER(field) FROM test;
-philip
On Wed, 9 Aug 2000, Lamar Owen wrote:
Philip Hallstrom wrote:
CREATE INDEX test_idx ON test (UPPER(field));
devloki= create index foo on rolo_entry (UPPER(fname));
ERROR
In article [EMAIL PROTECTED],
Prasanth A. Kumar [EMAIL PROTECTED] wrote:
Philip Hallstrom [EMAIL PROTECTED] writes:
Hi -
The following statements lock up my machine completely (I can
ping, but can't telnet, nothing). This is FreeBSD 3.4-STABLE running
7.0.2.
rolo_entry.fname
In article [EMAIL PROTECTED],
Chris Bitmead [EMAIL PROTECTED] wrote:
Graeme Merrall wrote:
Without wanting to starta thread war I think postgres is
great, but for many people the learning curve is too great and thus
MySQL is a good introduction.
In what way is mysql easier to learn?
I think
Hi -
I'm new to postgres and have some questions regarding the
authentication and access systems. I've got postgres installed and can
connect from remote machines, but have some questions:
- I cannot connect as the postgres user 'postgres' from remote machines?
Why?
- How is pg_shadow
53 matches
Mail list logo