Re: [SQL] Split a string to rows?

2013-01-08 Thread Dave Page
Yes" for 8.3. > > I believe that "Supported" would be fine, wouldn't it? It is supported until February (or more precisely, until the next point release after then, which will be the final wrapup release). At that point, there will be no more releases or bug fixes.

Re: [SQL] PostgreSQL ontop of FreeBSD jails, maybe there is still hope!

2010-07-21 Thread Dave Page
frastructure for 10 years or more. The only issue we run into is that we need to use a unique port in each jail as shared memory isn't entirely isolated between jails. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-sql

Re: [SQL]

2010-07-08 Thread Dave Page
>> WHAT??? >> >> You do understand that if you don't like it you can spend time fixing it. > > fix what? human minds of so-called programmers? That is not appropriate behaviour for the PostgreSQL mailing lists. Please treat others with respect, even if you di

Re: [SQL] pgAgent stats

2010-03-17 Thread Dave Page
:-) On Wed, Mar 17, 2010 at 12:40 PM, Marcin Krawczyk wrote: > Yeah... my bad. Sorry for being a pain in the a... ;) > > pozdrowienia > mk > > > 2010/3/17 Dave Page >> >> On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk >> wrote: >> > Ha, it

Re: [SQL] pgAgent stats

2010-03-17 Thread Dave Page
nd job step statistics rows to retrieve when viewing the statistics in the main browser. Unlike the statistics for other objects which normally consist of a fixed number of rows, a row is created every time a job or job step is executed. The most recent statistics will be shown. -- Dave Page Ente

Re: [SQL] pgAgent stats

2010-03-17 Thread Dave Page
f rows to retrieve' option on the Query tab of the Options dialog. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to

Re: [SQL] proposal for a CookBook in postgresql.org

2009-05-18 Thread Dave Page
On Mon, May 18, 2009 at 1:29 PM, Gerardo Herzig wrote: > I think this is a good time to propose some kind of CookBook, to > preserve this kind of answers. What, like this one? http://wiki.postgresql.org/wiki/Snippets :-) -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com --

Re: [SQL] Rollback in Postgres

2008-07-12 Thread Dave Page
On Sat, Jul 12, 2008 at 8:56 AM, Simon Riggs <[EMAIL PROTECTED]> wrote: > > Please don't put links to copyrighted material on our lists. That's an odd thing to say, given that virtually every link on our lists probably points to material copyrighted in some way. -- Dav

Re: [SQL] dblinks

2008-05-19 Thread Dave Page
; > select * from dblink('YOUR_DB_LINK_NAME','select * from mytable')as > tmp(column1 datatype,column2 datatype.) The OP was using EnterpriseDB's Postgres Plus Advanced Server, which has Oracle-style dblinks built in. They are not used in the same way as the Postgre

Re: [SQL] Bouncing replies [was: SQL standards in Mysql]

2008-02-25 Thread Dave Page
On Mon, Feb 25, 2008 at 9:08 PM, Dean Gibson (DB Administrator) <[EMAIL PROTECTED]> wrote: > > On 2008-02-22 21:34, Scott Marlowe wrote: > > > Bouncing messages from a public list is kinda rude. > > No more so, than sending two copies of your reply to me, because you don't > go up to your mailer

Re: [SQL] Bouncing replies

2008-02-11 Thread Dave Page
be coming only from hub.org/postgresql.org machines. I'd be interested to see where else you've seen it come from, and when. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Oracle-compatible database company ---(end of broadcast)---

Re: [SQL] Bouncing replies

2008-02-11 Thread Dave Page
> address as the "Reply-to" address, rather than using the list address. > That means that, unless the user is careful to "reply all" (or even > better, just reply to the list address), any discussion immediately goes > private. Because thats the convention o

Re: [SQL] Does postgresql8.2 supports multithreading?

2007-09-11 Thread Dave Page
A. Kretschmer wrote: > am Tue, dem 11.09.2007, um 12:38:38 +0530 mailte Jyoti Seth folgendes: >> Hi , >> >> >> >> Does postgresql8.2 supports multithreading? > > No. In the bits that (should) matter to end users (ie. libpq), yes, it does. Regards, Dave ---(end of broa

Re: [SQL] workday function

2007-05-15 Thread Dave Page
Kenneth Gonsalves wrote: > > On 15-May-07, at 2:39 PM, Richard Huxton wrote: > >> Don't know of one - not sure what "workday" would mean in a global >> sense. I mean, Mon-Fri in most European office settings, but you'd >> include Sat in retail settings and in Islamic countries presumably >> exclu

Re: [SQL] [ADMIN] [GENERAL] PgAgent logging verbosity

2007-03-13 Thread Dave Page
Ezequias R. da Rocha wrote: Ok I will use only on error ok ? -l 0 :) In the normal case, yes, that is what I'd use (0 is the default in fact, so you can omit the option altogether). Regard,s Dave ---(end of broadcast)--- TIP 2: Don't 'kill

Re: [SQL] [GENERAL] PgAgent logging verbosity

2007-03-13 Thread Dave Page
Ezequias Rodrigues da Rocha wrote: Hi list, I would like to know if I set the debug mode to 2 (-l 2) in the pgAgent connection string it could spend much cpu processing. I have other things running in the server and I don't like to create problem to others. Please stop cross posting to lot

Re: [SQL] [GENERAL] Is there anyway to...

2006-11-02 Thread Dave Page
imad wrote: Or you can probably use a PostgreSQL administration tool for scheduled jobs. I know a number of such tools which provide this feature and EnterpriseDB Management Server is one of them. As is pgAdmin's pgAgent. Regards, Dave ---(end of broadcast)

Re: [SQL] MS-SQL<->Postgres sync

2006-07-10 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe > Sent: 10 July 2006 20:03 > To: Kevin Bednar > Cc: Forums @ Existanze; pgsql-sql@postgresql.org > Subject: Re: [SQL] MS-SQL<->Postgres sync > > I think there's a version with windows

Re: [SQL] hi can u give solution to this query

2006-05-23 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P.Sent: 23 May 2006 13:41To: pgsql-sql@postgresql.orgSubject: [SQL] hi can u give solution to this query Hi sir…    If u don’t mind can u reply for this  question   This is on

Re: [SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Dave Page
  From: Penchalaiah P. [mailto:[EMAIL PROTECTED] Sent: 23 May 2006 13:18To: Dave PageSubject: RE: [SQL] some error when executing query in pgAdmin tool Hi sir…   I tried like that also … but I am getting same error……I tried like these……   1).Select * fr

Re: [SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P.Sent: 23 May 2006 13:11To: pgsql-sql@postgresql.orgSubject: [SQL] some error when executing query in pgAdmin tool   I created one table in pgAdmin tool but when I am executing query i

Re: [SQL] Recursive SELECT problem

2006-05-17 Thread Dave Page
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 17 May 2006 15:07 > To: Dave Page > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] Recursive SELECT problem > > "Dave Page" writes: > > I'm trying to write a

[SQL] Recursive SELECT problem

2006-05-17 Thread Dave Page
Hi, I'm trying to write a query to determine whether or not the current login role has CREATEDB (or CREATEROLE) privileges, either directly or inherited from a parent role. The query: SELECT EXISTS (SELECT 1 FROM pg_authid WHERE rolcreatedb = TRUE AND pg_has_role(rolname, 'MEMBER')) AS has_creat