with Rails migrations) tool that generates slonik-friendly
scripts for changes to the database structure.
Thanks in advance,
Robby
--
Robby Russell
http://www.robbyonrails.com/
http://www.planetargon.com/
---(end of broadcast)---
TIP 6: explain analyze
On Sep 29, 2006, at 10:45 AM, Rick Schumeyer wrote:
I hope pg-general is the correct forum for this question…if not
please let me know the correct location.
I have a pg application that uses tsearch2. I would like to move
this application off my local machine and onto a web host
not going away. Any pointers?
Robby
--
Robby Russell
Founder Executive Director
PLANET ARGON, LLC
Ruby on Rails Development, Consulting Hosting
www.planetargon.com
www.robbyonrails.com
+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4068 [fax]
---(end
On Aug 5, 2006, at 4:29 PM, Robby Russell wrote:
I'm seeing this weird issue pop up on one a database.
This seems to work...
robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE title
~* 'postgresql' LIMIT 20;
count
---
19
(1 row)
...but these two seem to be causing
been with Rails.. and there is no need
to make javascript talk directly to PostgreSQL.
Robby
--
Robby Russell
Founder Executive Director
PLANET ARGON, LLC
Ruby on Rails Development, Consulting Hosting
www.planetargon.com
www.robbyonrails.com
+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815
right.
I don't see why PostgreSQL wouldn't work for what you're working on...
-Robby
Robby Russell
Founder Executive Director
PLANET ARGON, LLC
Ruby on Rails Development, Consulting Hosting
www.planetargon.com
www.robbyonrails.com
+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642
Robby Russell
Founder Executive Director
PLANET ARGON, LLC
Ruby on Rails Development, Consulting Hosting
www.planetargon.com
www.robbyonrails.com
+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4968 [fax]
---(end of broadcast)---
TIP 1
--
/**
* Robby Russell, Founder Executive Director *
* PLANET ARGON, LLC | www.planetargon.com *
* Ruby on Rails Development, Consulting, and Hosting *
* Portland, Oregon | p: 503.351.4730 | f: 815.642.4068 *
* blog: www.robbyonrails.com | book
VERSION=0'
def self.down
drop_table :products
end
end
# Run from main Rails directory
rake migrate
Using either plain SQL like above or AR::Migrate will generate the same table
structure.
Cheers,
-Robby
--
/**
* Robby Russell
On Thu, 2005-11-17 at 15:10 -0600, Bruno Wolff III wrote:
On Thu, Nov 17, 2005 at 09:23:51 -0800,
Robby Russell [EMAIL PROTECTED] wrote:
CREATE TABLE product (
id SERIAL PRIMARY KEY,
name VARCHAR(255) NOT NULL DEFAULT '',
);
And depending on why you chose VARCHAR(255), you
and is
organized fairly well. It's recently become the first book that I reach
over to the bookshelf for to look up something when I don't feel like
searching on google/ps.org search.
-Robby
--
/**
* Robby Russell, Owner.Developer.Geek
* PLANET ARGON, Open
Apparently, PL/Ruby has an undocumented flag that you can pass it. :-)
http://rubyurl.com/Dz2 (usage)
http://rubyurl.com/t3S (install)
-Robby
--
/**
* Robby Russell, Owner.Developer.Geek
* PLANET ARGON, Open Source Solutions Web Hosting
/docs/current/static/queries-table-expressions.html
example:
SELECT *
FROM dblink('dbname=mydb', 'select proname, prosrc from pg_proc')
AS t1(proname name, prosrc text)
WHERE proname LIKE 'bytea%';
Cheers,
Robby
--
/***
* Robby Russell
world.
It's not an evil conspiracy against windows..just like Linux users can
point out that there not enough games for windows yet. The demand isn't
high enough yet and as it increases..this will hopefully change a bit.
-Robby
--
/***
* Robby Russell
ON (weather.city = cities.name);
Cheers,
Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
* --- Now hosting Ruby
, login for DB
Thanks in advance.
HD
wxWidgets (formerly wxWindows)
http://www.wxwidgets.org/
there is wxPython, wxRuby, wxEtc..
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED
created. I can se them in DBVisualizer.
I'm using version 7.4.5 on Linux Mandrake 10.1.
Best Regards,
Tommy Svensson
What do your CREATE TABLE commands look like? Also, what does \d
tablename respond with?
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
* --- Now hosting Ruby on Rails Apps
you have any good pointers/how-to to direct me to?
Thanks for the help.
Best,
Try Slony:
http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland
data type)
SELECT created::date FROM orders.payment WHERE id = 100;
created
2004-11-28
or
SELECT id, email FROM orders.payment WHERE created::date = now()::date;
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON
is the dprocedure
for dropping a column? an anyone point me to a document that tells
EXACTLY how to do this? Also, how do you find out the dependencies it
says it has? I know of none.
Art
ALTER TABLE foo DROP COLUMN name CASCADE;
--
/***
* Robby Russell
been updated since May 2004 though. :-/
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
* --- Now hosting
of this is...when we really
haven't the foggiest idea. ;-)
Cheers,
Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
* --- Now hosting PostgreSQL 8.0
of PostgreSQL since 6.3, including:
Good work everyone!
:-)
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
* --- Now
this flexibility
a great reason why multiple instances are good for a hosting company.
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP
id = 1;
DELETE 1
test= SELECT * FROM foo;
id | foo_type_id | name
+-+--
3 | 2 | bar3
(1 row)
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED
is white, and the text is also a light
color.
agreed. Font sizes are a little 'too' small in some areas. The font size
for the body is set to font-size: 69%;
maybe 72% would be a little less of a strain. ;-)
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET
AND
pg_attribute.attrelid = src.oid AND
pg_namespace.nspname = $1 AND
src.relname = $2 AND
pg_attribute.attname = $3;
' language sql;
hth,
Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland
component.
ftp://ftp.tummy.com/pub/tummy/Mail2DB/
You will
hth,
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL
don't always have that
option with some clients existing systems.
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting
On Thu, 2004-10-28 at 16:51 -0600, Ed L. wrote:
On Thursday October 28 2004 11:42, Robby Russell wrote:
Thanks, this seems to work well. My goal is to actually create a php
function that takes a result and returns the insert_id like
mysql_insert_id() does, but without needing to know
n);
n = interval
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
* --- Now supporting PHP5 and PHP4
this value if I pass
it the schema and table (and fieldname is necessary)
Thanks,
Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP
On Wed, 2004-10-27 at 21:06 -0700, Robby Russell wrote:
I am trying to track down a method of determining what a sequence name
is for a SERIAL is in postgresql.
For example,
CREATE TABLE foo (id SERIAL PRIMARY KEY NOT NULL, bar TEXT);
\d foo
Table public.foo
On Wed, 2004-10-27 at 21:33 -0700, Robby Russell wrote:
I figured out how to get this:
foo= SELECT adsrc FROM pg_attrdef WHERE adrelid = (SELECT oid FROM
pg_class WHERE relname = 'foo');
adsrc
nextval('public.foo_id_seq'::text)
(1 row
On Tue, 2004-10-26 at 17:26 -0400, Mike Mascari wrote:
joking
Apparently gamma functions and string theory have little to do with
understanding the relational model of data.
/joking
m.. string theory. :-)
--
/***
* Robby Russell
On Tue, 2004-10-26 at 22:03 -0500, Kevin Barnard wrote:
On Tue, 26 Oct 2004 17:05:27 -0700, Robby Russell [EMAIL PROTECTED] wrote:
On Tue, 2004-10-26 at 17:26 -0400, Mike Mascari wrote:
joking
Apparently gamma functions and string theory have little to do with
understanding
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
/
signature.asc
Description: This is a digitally signed
://techdocs.postgresql.org/guides/GUITools
hth,
Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
specifically for what they do.
...actually, I heard they were running it off a flat file database on 7
386 machines in some guys garage off a dsl connection. I could be wrong
though. ;-)
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
/
signature.asc
Description
installer.
Alex
Try here:
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL
or
incomplete?
Slony-I is the most active *community* project currently.
Will any of these projects be merged with PgSQL soon?
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED
On Wed, 2004-10-13 at 10:59 -0700, Robby Russell wrote:
On Wed, 2004-10-13 at 20:02 +0200, [EMAIL PROTECTED] wrote:
Hello
I am going to do a comparison betweem PgSQL and MySQL replication system.
I hear there are some replication projects available for PgSQL. Which are
still active
the change to 8.0
voila:
http://archives.postgresql.org/pgsql-advocacy/2004-08/msg00022.php
hth,
Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
/
signature.asc
Description
was released, please
see:
ftp://ftp.postgresql.org/pub/source/v8.0.0beta/ChangeLog-Beta2-to-Beta3
FYI, this file doesn't seem to exist when I go here.
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland
. :)
-Doug
Heh, at least it makes the user learn how to configure their postgresql
configuration. ;-)
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting Development
/
signature.asc
Description
middink
How can I create View like above?
Have you created a SQL statement to get this recordset yet? When you
have your SQL query working the way you want, you just run
CREATE VIEW view_name AS your sql query;
then you can perform a SELECT * FROM view_name;
--
Robby Russell, | Sr
:
http://techdocs.postgresql.org/guides/GUITools
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
[EMAIL PROTECTED] | Telephone: (503) 222.2783
---(end of broadcast)---
TIP 8: explain
. :-/
-Robby
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
[EMAIL PROTECTED] | Telephone: (503) 222.2783
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
all wait in anticipation... ;-)
However, the 1st release is open source and you can read it online anytime.
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
[EMAIL PROTECTED] | Telephone: (503) 222.2783
suggestion
would write your log to the /tmo directory. (which most users should
have access to write to)
-Robby
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
[EMAIL PROTECTED] | Telephone: (503) 222.2783
Should be a simple question.
When selecting a field that is of type money, how can I remove the $
when selected?
example: $10.00 would return as 10.00
-Robby
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
56 matches
Mail list logo
