Re: pg_dump warings

Hi,

On Sun, 2006-04-30 at 21:42 +0000, Rick Ellis wrote:
> I did something foolish and now I'm getting warnings every time
> pg_dump runs (hourly from cron). Anybody have a suggestion on how
> to fix this?

Create the user again with the same userid (I mean revert what you did).
You can get this info from pg_tables and pg_authid(or pg_shadow,
depending on your PostgreSQL version).

Regards,
--

-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: pg_dump warings

In article <1146438618.5923.10.camel <at> laptop.gunduz.org>,
Devrim GUNDUZ <devrim <at> commandprompt.com> wrote:

>Create the user again with the same userid (I mean revert what you did).
>You can get this info from pg_tables and pg_authid(or pg_shadow,
>depending on your PostgreSQL version).

It turned out to be some tables had been created that shouldn't
have been and the user that created them had been deleted. So
the cure was deleting the tables.

Thank you very much. You provided just the clues I needed.

--
http://yosemitenews.info/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

PG_RETURN_?

Hi,

I have a set of functions for a data type that return
small integers (i.e. [0..12]).  I can, of course, represent
it as a char, short or long (CHAR, INT16 or INT32).
re there any advantages/drawbacks to chosing one particular
PG_RETURN_ type over another (realizing that they are
effectively just casts)?

Thanks!
--don

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Is PostgreSQL an easy choice for a large CMS?

Ahh. I see the point more clearly now. Perhaps the best strategy for
me is to press on with Postgres until the project is at a profitable
enough stage to merit a migration to Oracle - should Postgres become
an issue. I feel more confident about being able to migrate from
Postgres than from MySQL. I am financing this myself. hence the
apprehension about the cost. Is there another contender I should think
about.

On 4/30/06, Matthew T. O'Connor <matthew <at> zeut.net> wrote:
> 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?
>
> Yes Slashdot runs MySQL, however what Tom said was that MySQL will fall
> over under any heavy *concurrent-write* scenario.  Concurrent-write is
> the operative word in that sentence.  Slashdot by it's very nature reads
> from the database far far more than it writes.  The only writes to the
> database are things like a new story and user submitted comments, both
> of with are small in comparison to the number of reads from the database.
>
> Matt
>

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to

Re: Is PostgreSQL an easy choice for a large CMS?

Oops! tonylausin <at> gmail.com ("Tony Lausin") was seen spray-painting on a wall:
> Ahh. I see the point more clearly now. Perhaps the best strategy for
> me is to press on with Postgres until the project is at a profitable
> enough stage to merit a migration to Oracle - should Postgres become
> an issue. I feel more confident about being able to migrate from
> Postgres than from MySQL. I am financing this myself. hence the
> apprehension about the cost. Is there another contender I should think
> about.

The other plausible option as a "possibly inexpensive" alternative to
PostgreSQL or MySQL(tm) is Firebird, which used to be Borland
Interbase...

They lost a couple of developers to MySQL AB, which may present some
problems, eventually...
--

-- 
output = reverse("ofni.secnanifxunil" " <at> " "enworbbc")
http://linuxfinances.info/info/wp.html
"Tooltips are the proof that icons don't work."
-- Stefaan A. Eeckels

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Is PostgreSQL an easy choice for a large CMS?

The open source offerings of ingres, ingres R3, runs the Wire section of our business

http://www.onesteel.com


Allan
> > Postgres than from MySQL. I am financing this myself. hence the
> > apprehension about the cost. Is there another contender I 
> > should think
> > about.


The material contained in this email may be confidential, privileged or copyrighted. If you are not the
intended recipient, use, disclosure or copying of this information is prohibited. If you have received
this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender
accept responsibility for any viruses contained in this email or any attachments.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

OT: job offer

Hope nobody minds a job offer.....

We have developed an application for the insurance market that is based on:

wxPython for the GUI
twisted pb as network layer
certainly python 
reportlab/OpenOffice/pyUno for printing
zope/plone as alternative web interface.
the database backend is postgresql.

We're currently in the process of setting up a company to market this 
software. The software targets a niche market in the insurance business and 
has been in production for over 3 years with a limited number of clients.
We're looking for developers, preferably in the greater San Francisco Bay Area 
but not a necessity, who have as much experience as possible in any/all of 
the above technologies. We have certain projects that only need partial 
knowledge (I'm not disclosing specifics here, I much rather list requirements 
for the different projects):

1) Solely Plone based development. This basically only requires Plone and 
postgresql experience.

2) The printing backend needs work. Anyone with good XSLT/RML experience is 
welcome to apply. Intention is to write a Open Document Format to RML 
exporter for OpenOffice. We will contribute the exporter back to the 
community which would benefit the OpenOffice and the reportlab projects.

3)  Someone with a solid knowledge of twisted pb (not yet new pb) and wxPython 
experience. There are technical obstacles to the "twisted/wxPython"-marriage 

Re: Nested Query OK in psql but not in PHP

On Sun, Apr 30, 2006 at 03:52:29PM -0700, rloef <at> interfold.com wrote:
> ... Is there something that changes in the PHP code that builds
> the tabular display if a query is a nested query as opposed to it not
> being a nested query? 

PHP has no idea what a nested query is, let alone understanding SQL.
You must be doing something else wrong (quoting?).

> I can include some actual cut-'n-paste, but I'd like to try and figure
> at least some of this out myself first.

We can't help you at all without a cut-n-paste.

Have a nice day,
--

-- 
Martijn van Oosterhout   <kleptog <at> svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Authentication & connection problems

Re: Is PostgreSQL an easy choice for a large CMS?

* Tony Lausin (tonylausin <at> gmail.com) wrote:
> Ahh. I see the point more clearly now. Perhaps the best strategy for
> me is to press on with Postgres until the project is at a profitable
> enough stage to merit a migration to Oracle - should Postgres become
> an issue. I feel more confident about being able to migrate from
> Postgres than from MySQL. I am financing this myself. hence the
> apprehension about the cost. Is there another contender I should think
> about.

You may want to read up on MySQL's licenseing system if you havn't
already as well.  It's not necessairly what you expect...  Basically, if
you don't want to open source (ie: GPL-compatible) the code which uses
MySQL you might need to buy a license from them.  Check their website
for a more detailed (though not necessairly any clearer) discussion of
the issues.

	Thanks,

		Stephen