t will put them
in public/foo.sql with CREATE OR REPLACE FUNCTION formatting around it.
Hope this is useful to others.
Tony Wasson
dump-all-functions.pl
Description: Binary data
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
roduct')
LEFT OUTER JOIN orders ON (items.order_id = orders.id AND paid = 1)
LEFT OUTER JOIN users ON (orders.user_id = users.id AND name = 'thomas')
> Moreover, the "name" argument in the WHERE comes from the user logged
> in data. So if the user is not logg
On 5/23/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> Is this a good idea? Would this be too bad, performance-wise, if I had
> thousands of schemas to use like that? Any advice on better approaches? Any
> expected problems?
One issue is that you'll probably be breaking new ground here a bit;
On 5/16/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Tony Wasson" <[EMAIL PROTECTED]> writes:
> When I saw the same error as you, the stats collector process was
> missing.
The collector, or the buffer process? The reported message would be
emitted by the buffer p
On 5/16/06, Sean Davis <[EMAIL PROTECTED]> wrote:
I had cranked things up a bit from the standard install.
shared_buffers = 15000 # min 16 or max_connections*2, 8KB
each
#temp_buffers = 1000# min 100, 8KB each
#max_prepared_transactions = 50 # can be
On 5/16/06, Sean Davis <[EMAIL PROTECTED]> wrote:
I am using postgresql 8.1.0 on an Xserver running MacOS 10.3.9. I am
getting the following in the log every minute for the past couple of days.
The database is otherwise running normally, as far as I can tell:
2006-05-16 07:26:01 EDT FATAL: c
Currently the documentation says:
A database that is marked datallowconn = false in pg_database is
assumed to be properly frozen; the automatic warnings and wraparound
protection shutdown do not take such databases into account. Therefore
it's up to you to ensure you've correctly frozen a databas
On 5/5/06, Sean Hamilton <[EMAIL PROTECTED]> wrote:
I have to log each time a user selects data from a table by inserting
record in another table.
For example
I have table xzy
user test selects id, name from table xyz.
I want to insert into table xyz_log
user, action, fields, timestamp
test, sele
On 1 May 2006 13:16:15 -0700, EbGrooveCb <[EMAIL PROTECTED]> wrote:
Is there a way to make seperate replacements in 1 field in one command
in SQL?
I need to remove all vowels (a,e,i,o,u) in a field. How would I go
about that?
You can do all the replacements in a single SQL statement by nestin
On 3/23/06, Wes <[EMAIL PROTECTED]> wrote:
> This keeps the indexes a more or less reasonable size, and allows quick
> deleting of the old data. Is there any problem with 180 child tables? How
> many would be too many (e.g. if I did one table per 6 hours?)
I am not a guru. Many, many people on
On 2/9/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Fri, Feb 10, 2006 at 11:30:04AM +0700, Luki Rustianto wrote:
> > So how can we terminate such a long running query ?
> >
> > The idea is to make a crontab to periodicaly do a job to search a
> > typical "SELECT * FROM bigtable" query who has r
On 1/5/06, Steve Crawford <[EMAIL PROTECTED]> wrote:
> > Resting Connections - connections that have no query information. I
> > suspect these are connections starting up or shutting down, but feel
> > free to clue me in.
>
> OK, this appears to be version-dependent but it can mean that
> stats_que
On 1/2/06, Julian Scarfe <[EMAIL PROTECTED]> wrote:
> I'm keeping config information for an application in a series of related
> tables. I'd like a command that INSERTs data if it's new, or UPDATEs it if
> the key is duplicated.
A MERGE trigger will do exactly what you are asking for.
http://arc
On 1/1/06, Tony Caduto <[EMAIL PROTECTED]> wrote:
> Hi,
> Does anyone know of a good resource on how to use Postgresql as a
> destination for Syslogd messages?
>
> I am interested in putting all postfix logs to a table rather than a file.
I set this up by using syslog-ng, djb's supervise and psql.
On 10/3/05, Giovanni M. <[EMAIL PROTECTED]> wrote:
> Round and trunc dont provide the functionality I need.
>
> Say for example I have two values in a column of type numeric as follows:
> 23.455
> 12.300
>
> What I need to happen is stripping the "useless" zeros in the
> fractional part of numbers
On 23 Sep 2005 11:30:24 -0700, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> I don't think your algorithm for calculating the number of days in the
> overlap will work. Picture a scenario where we have one date range that
> covers 100 days, and another that covers 10 days, and they overlap by 2
>
LECT (DATE '2001-02-16', DATE '2001-12-21') OVERLAPS
(DATE '2001-10-30', DATE '2002-10-30');
Thanks in advance!
Tony Wasson
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 9/21/05, Michael L. Artz <[EMAIL PROTECTED]> wrote:
> Tony Wasson wrote:
>
> >You can use the merge trigger below to do this. You'll need to add
> >some code to update the count. You may also benefit from using the new
> >constraint exclusion (table partit
On 9/21/05, Steve Manes <[EMAIL PROTECTED]> wrote:
> I need to extract a SETOF column names for a table in plpgsql. How is
> this done?
I got the queries for this by running psql with -E and then using \d
on a table. Use this function like so: SELECT * FROM
column_names('your_table');
CREATE OR
On 9/20/05, Michael L. Artz <[EMAIL PROTECTED]> wrote:
> I'm fairly new at Postgres and had some basic design questions. My
> problem is basically that I want to do large bulk imports (millions of
> rows) into a large DB (billions of rows) where there might already be
> data that needs to be updat
On 9/20/05, Matthew Peter <[EMAIL PROTECTED]> wrote:
> Wondering if there's a way for postgres to return how
> many elements are in a array as a single integer? For
> instance, returning 10 (items in array) instead of
> [-5:4]
>
> Also, is there a way to return the position of an item
> in a array?
hose issues before blaming postgresql.
We have seen several boxes have kswapd go crazy (near 100% CPU) on
RHEL 3 boxes. Upgrading to kernel 2.4.21-4 fixed this.
Tony Wasson
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please s
22 matches
Mail list logo
