I know WAL is new but how do you manage the WAL files. Do they need to get
deleted everytime you back up the db? What is the best way to backup a
Wharehouse? A transaction system? What do you do with the WAL files in
each case? Is there an option to not use WAL logs? Currently I'm just
us
Looking for a ERD tool that support pgsql. Anyone know of any?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Can I put transactions and cursors into functions? As soon as I put BEGIN;
and COMMIT; wrapping an insert statement within a function, I get
errors. Do these programs need to reside outside of the database?
---(end of broadcast)---
TIP 3: if po
How do you get the server into production state?
What does production state mean?
What parms need to be set for production state in the
postgresql.conf file or other file?
---(end of broadcast)---
TIP 1: subscribe and
I am converting an 8 digit number to a date. I don't see a postgres
function to do it direct, but two functions seems like I'm on the right
track, to_char and to_date. Individually I get them to work, but when I
combine them I get the wrong answer. see below. Can anyone help in
getting the
, '') from 2 for
8), 'mmdd');
to_date
2002-01-01
(1 row)
At 03:13 PM 4/3/02 -0800, Chris Pesko wrote:
>I am converting an 8 digit number to a date. I don't see a postgres
>function to do it direct, but two functions seems like I'
Thanks. That seems a better way to go.
At 03:47 PM 4/3/02 -0800, Stephan Szabo wrote:
>On Wed, 3 Apr 2002, Chris Pesko wrote:
>
> > Never mind. Just figured it out. Need to grab the substring from 2 for 8
> > from the to_char result because it holds character number 1 rese
