eration
(compatible 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)-
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
somew
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
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 t
ried reindexing the table but it''s 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
ngs not
displaying 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
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)-
eful outside of allowing some
older PHP applications to use some rubygems in the database.
Robby
--
/**
* Robby Russell, Founder & Executive Director *
* PLANET ARGON, LLC | www.planetargon.com *
* Ruby on Rails Development, Cons
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 '
tory
rake migrate
Using either plain SQL like above or AR::Migrate will generate the same table
structure.
Cheers,
-Robby
--
/**
* Robby Russell, Founder.Developer.Geek
* PLANET ARGON, Rails Development, Consulting & Hosting
* Portland, Oregon
and while it doesn't get too
deep into the realm of working with PostgreSQL (complex queries, custom
types, etc) it does provide a good overview of PostgreSQL and is
organized fairly well. It's recently become the first book that I reach
over to the bookshelf for to look up someth
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 Hos
name name, prosrc text)
> WHERE proname LIKE 'bytea%';
>
Cheers,
Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog
for windows yet. The demand isn't
high enough yet and as it increases..this will hopefully change a bit.
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED
OUTER JOIN cities 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 & Deve
e select a file to upload, 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.planetargo
ables you have
>created so that postgres will find them ?
>The tables do actually get 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?
o recompile PHP to use 8.0 client,
> or is it compatible ?
You shouldn't notice any issues with this. In our hosting environment,
we're using older pgsql client libs with postgresql 8 with no issues.
-Robby
--
/*******
* Robby Russell | Owner.D
the documentation site.
-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
e package since 7.3.x.
>
> Do 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 Rus
: (created is a timestamp 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
t
ALTER TABLE foo DROP COLUMN name CASCADE;
--
/*******
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED]
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & D
.
>
> Sincerely,
>
> Joshua D. Drake
> Command Prompt, Inc.
> 503-667-4564
>
It hasn't been updated since May 2004 though. :-/
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, O
ation of metaphors
which we overuse to try to explain what all 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 PROTECTE
http://www.johnbenzart.com
demo of admin:
http://www.pgcart.com/pgcart_demo/pgcart_demo_1.htm
Cheers,
-Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | [EMAIL PROTECTED
; version 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 &
C2..and will want 8.0 the day it's ready). I find 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 PROT
ay, say from 500k to 50M) as large
> objects, will I still be able to restore the _whole_ database from a
> single pg_dump tar file?
Yes, you will be able to do this. Your pg_dump
http://www.postgresql.org/docs/current/static/app-pgdump.html
> -b
> --blobs
>
text as the background 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. ;-)
--
/******
bar3
> (3 rows)
>
> test=> SELECT * FROM foo_type;
> id | name
> +
> 1 | type 1
> 2 | type 2
> (2 rows)
Now, I will test it:
test=> DELETE FROM foo_type WHERE id = 1;
DELETE 1
test=> SELECT * FROM foo;
id | foo_type_id | name
+-
g_depend
> WHERE
> pg_depend.refobjsubid = pg_attribute.attnum AND
> pg_depend.refobjid = src.oid AND
> seq.oid = pg_depend.objid AND
> src.relnamespace = pg_namespace.oid AND
> pg_attribute.attrelid = src.oid AND
> pg_namespace.nspname = $1 AND
>
se. Currently, there is only the storage 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
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() d
hat takes a result and returns the insert_id like
mysql_insert_id() does, but without needing to know the sequence names
and such. I would make a psql function, but I don't always have that
option with some clients existing systems.
-Robby
--
/**
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
>
&g
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
>
iven
schema.table? I would like to build a function that would return 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 |
.
>
SELECT extract(epoch FROM 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
*
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:
> > >
> > >
> > > Apparently gamma function
On Tue, 2004-10-26 at 17:26 -0400, Mike Mascari wrote:
>
>
> Apparently gamma functions and string theory have little to do with
> understanding the relational model of data.
>
>
m.. string theory. :-)
--
/*******
* Robby Russell | Ow
Thanks,
>
\h COPY
The COPY command will help you with this.
-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
**
gt; they use. I bet they built their own 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 |
ts and crayons?
http://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
cents,
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
/
signatu
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 project
are not active 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
* Po
the
> windows 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 | bl
ives, it
was first mentioned by Josh Berkus as to why 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
tgresql.org/docs/current/static/functions-
formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABLE
Good luck,
Robby
--
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland,
t of changes/improvement since Beta 1 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.Develope
abled by default, leaving just Unix sockets
> for connections. This is probably not a very useful default
> configuration on Windows. :)
>
> -Doug
Heh, at least it makes the user learn how to configure their postgresql
configuration. ;-)
-Robby
--
/*
phpwiki can utilize a PostgreSQL backend.
-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
**
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
might help you:
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)---
MySQL had a booth this year, and PostgreSQL didn't. :-/
-Robby
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
[EMAIL PROTECTED] | Telephone: (503) 222.2783
---(end of broadcast)---
7.3 or 7.4.
We 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:
, doesn't have permission to
create/write to the 'logfile' in the current directory. My 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 Pro
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
58 matches
Mail list logo
