I have created a browser-based documentation tool for PostgreSQL. I
thought this might be interesting to some. More information can be had
at:
http://ccl.cens.nau.edu/MOLI/livepgdoc.html
--
Karim Nassar
Collaborative Computing Lab of NAU
Office: (928) 523 5868 -=- Mobile: (928) 699 9221
http
On Mon, 2004-11-08 at 05:54, Stephan Szabo wrote:
> > If I have a subselect with an ORDER BY, and I LEFT JOIN the result with the
> > other table, is the order maintained? Or is PostgreSQL free to return the
> > rows
> > in any order, after the join?
>
> AFAIK, you have no guarantees as to the ou
On Sun, 2004-11-07 at 20:36, Thomas F.O'Connell wrote:
> What version of postgres are you using? In postgresql-7.4.6, I get an
> empty query buffer when I try what you describe here.
7.4.5
I got it. Apparently the query buffer is the last run query (good or
bad). So, to get my function into the
On Sun, 2004-11-07 at 21:16, Christopher Browne wrote:
> None of these systems _directly_ address how apps would get pointed to
> the shifting servers.
> Something needs to be "smart enough" to point apps to the right place;
> that's something to think about...
Seems like it would be pretty easy
On Wed, 2004-11-03 at 18:10, Ed L. wrote:
> unfortunately, the requirement is 100% uptime all the time, and any
> downtime at all is a liability. Here are some of the issues:
Seems like 100% uptime is always an issue, but not even close to
reality. I think it's unreasonable to expect a single pi
Here is what I get:
orfs=# \df+ get_datasets
List of functions
Result data type |Schema| Name | Argument
data types | Owner | Language
|
)
Prediction:
* Tom Lane says "upgrade to 8.0" ;-)
Post-Mortem:
Am I missing something? Please bless me with some postgres mojo.
TIA,
\<.
> On Sat, 2004-10-23 at 23:02, Scott Marlowe wrote:
> > On Sat, 2004-10-23 at 22:22, Karim Nassar wrote:
> > > If you jus
~postgres/data
ssh [EMAIL PROTECTED] tar czf - -C /safe/dir data|tar xvzf - -C ~postgres
/etc/init.d/postgresql start
Or something similar with rsync instead of tar.
\<.
On Sat, 2004-10-23 at 18:04, Scott Marlowe wrote:
> On Thu, 2004-10-21 at 02:39, Karim Nassar wrote:
> > I ne
On Sat, 2004-10-23 at 16:57, Curtis Zinzilieta wrote:
> rsync, or .tar.gz, or scp or use pg_dump.
>
> any of the copies run assuming you've shut down the DB first, and that
> you're using the same binaries on both boxen.
Aha! Shutdown first.
I knew it was something dumb.
Thanks for the help.
\<
On Sat, 2004-10-23 at 07:35, Philip Hofstetter wrote:
> It would just have been easier to find if PostgreSQL actually had
> told me so (I'm not getting those NOTICEs from PHP...).
As far as I can tell, Apache or PHP snarfs up all the messages that
postgres generates before they can get to the po
I am writing functions and I find it curious that CREATE FUNCTION does
not do syntax checking.
Example:
test=# CREATE FUNCTION foo(INTEGER) RETURNS BOOLEAN
test-# AS 'this is total crap' LANGUAGE plpgsql;
CREATE FUNCTION
test=# select foo(1);
ERROR: syntax error at or near "this"
CONTEXT: com
I need to have an exact copy of a postgres install on a testing
computer. I don't want to do slony. Is it feasible/reasonable to think
that I could just rsync to the devel boxen from the pg server? Or is
slony "The Way to Do It"(tm)?
\<.
---(end of broadcast)-
12 matches
Mail list logo
