Re: [GENERAL] How to view user defined TYPE

Hi, Any help on the question below? Thanks. On Oct 15, 6:00 pm, Goboxe <[EMAIL PROTECTED]> wrote: > Hi, > > Let say I created a new type: > > CREATE TYPE compfoo AS (f1 int, f2 text); > > How can I view its definition? > > I tried to view it in pgAdmin bu

[GENERAL] Trigger does not behave as expected

Hi, I have a trigger as below. I am wondering why when I tried to insert to master table with date= 20080908, the trigger does not insert to z_agg_tmcarr_pfx_gtwy_cc_w_20080908. Is that something wrong with the statement "ELSEIF NEW.CallDate >= 20080908 AND NEW.CallDate <= 20080914 THEN"? ---

Re: [GENERAL] PostgreSQL on Windows x64

] ("Dave Page") wrote: > On Mon, Aug 18, 2008 at 7:48 AM, Goboxe <[EMAIL PROTECTED]> wrote: > > Hi, > > > Does PostgreSQL can run on Windows x64? > > If yes, which version? > > All versions (though you should start with > 8.3.3):http://wiki.postgres

[GENERAL] PostgreSQL on Windows x64

Hi, Does PostgreSQL can run on Windows x64? If yes, which version? Thanks, G -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Using syslog on pg for Windows

On Jan 4, 11:22 pm, [EMAIL PROTECTED] ("Jeff Larsen") wrote: > On Jan 4, 2008 8:33 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > > > > > > On Wed, Jan 02, 2008 at 11:17:52PM -0800, Goboxe wrote: > > > Hi, > > > > What are required

[GENERAL] Using syslog on pg for Windows

So try to update postgresql.conf syslog_facility = 'x.x.x.x' or syslog_facility = '@x.x.x.x' But it still does not work. Any tips? Thanks, Goboxe ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Partitioned tables & Slony

Hi, What need to be taken care of when replicating data from partitioned tables? I have several master tables that are inherited by date either daily, weekly and monthly. How to automate addition of newly created child tables into Slony cluster? Thanks, Goboxe ---(end

Re: [GENERAL] Partitioned tables & Slony

Thanks Chris. How do I use *.sh & *.ik files? Goboxe On Dec 19, 12:17 am, Chris Browne <[EMAIL PROTECTED]> wrote: > Goboxe <[EMAIL PROTECTED]> writes: > > What need to be taken care of when replicating data from partitioned > > tables? > > > I have sev

[GENERAL] Trigger in partitioned table

Hi, When adding sets of new child tables to a artitioned table, I need to update the triggers with new dates added as new condition. See sample below. My question is, what will happen if the update to the trigger happen at the same time as insert operation to the master table? CREATE OR REPLACE

[GENERAL] print command in sproc

Hi, What is the equivalent MSSQL 'print' command in pg sproc? Thanks, G ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Partitioned tables, rules, triggers

Josh, Thanks for sharing a very good info on partitioning. On Oct 5, 10:08 pm, [EMAIL PROTECTED] ("Josh Tolley") wrote: > On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote: > > > Hi, > > > I have two questions on the above: > > > 1. I found in some p

[GENERAL] Partitioned tables, rules, triggers

Hi, I have two questions on the above: 1. I found in some postings recommended to use triggers instead of rules. Is this documented somewhere? 2. When using trigger, any examples on how to update the trigger dynamically when tables are added or deleted from the partitioned? Thanks, Amin -

Re: [GENERAL] Auto-partitioning?

"use consumer called table_dispatcher"... could you elaborate this further on how to do this? Thanks, G On Aug 22, 3:27 pm, [EMAIL PROTECTED] ("Asko Oja") wrote: > Hi > > Just a hint. > We do this auto-partitioning with PgQ. Instead of writing records into table > we push them into queue and use

Re: [GENERAL] Partitioned table limitation

On Oct 3, 4:00 am, [EMAIL PROTECTED] ("paul rivers") wrote: > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:pgsql-general- > > [EMAIL PROTECTED] On Behalf Of Goboxe > > Sent: Monday, October 01, 2007 11:26 AM > > To: [EMAIL PROTECTED] &g

Re: [GENERAL] Partitioned table limitation

On Oct 2, 1:38 am, [EMAIL PROTECTED] ("paul rivers") wrote: > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:pgsql-general- > > [EMAIL PROTECTED] On Behalf Of Goboxe > > Sent: Monday, October 01, 2007 2:18 AM > > To: [EMAIL PROTECTED]

Re: [GENERAL] Partitioned table limitation

> > I've played around with as many as 1,000 child tables. By then, the > planning time becomes noticeably longer than for a single table, but > the response time is still so much faster that it's worth it. Note > I'm talking only a fraction of a second planning time, even at 1,000 > tables. > >

[GENERAL] Partitioned table limitation

Hi, Are there any limitations on number of child tables that can be use in partitioned table? I am currently having weekly partitioned tables (using partitioned view in SQL Server) that I kept for 2 years. In total, there will be 52 * 2 = 104 tables exist at one time in the partition. I am mig