All,
I found the problem. I see
at postrges.org that in 7.4.3
the "money" data type is
no longer being used ( deprecated ).
I'll replace it with am decimal instead.
thanks,
Terry
Terr
Everyone,
Just ran across an odd situation.
I have defined a field:
amount | money| not null default ''
Works fine until the dollar amounts get
very large - into the tens of millions.
At that point, the actual amount stored
Anyone know this list member,
who was kind enought to reply?
Original Message
Subject: Re: [ADMIN] Location of a new column
Date: Thu, 8 Apr 2004 06:58:56 -0700
From: "scott" <[EMAIL PROTECTED]>
To: "Terry Hampton" <[EMAIL PROTECTED]&g
All,
I thought this was answered before, but I
could not find anything in my saved email.
I need to ALTER a table to add a new column.
I want the new column to be between two existing
columns, however. Didn't I see mention of
an "AFTER" paramet
All,
select attname, atttypmod, atttypid from pg_attribute where
attrelid=3701787 and attnum > 0;
returns:
attname | atttypmod | atttypid
-+---+--
acct_name | 132 | 1043
grp |54 | 1043
name | 260 | 10
Hello Jaime,
I think you're on the right track but have gotten some
concepts possibly confused.
As I remember, the original email asked if Postgres
could be run in a "raw" mode. Another submitter
told us that it can not. ( Did I read t
Hello Jaime,
I think you're on the right track but have gotten some
concepts possibly confused.
As I remember, the original email asked if Postgres
could be run in a "raw" mode. Another submitter
told us that it can not. ( Did I read that
Is it possible to configure Postgres,
or to start PG daemons so that it
operates in a transaction mode by default ?
We do a lot of work at the PG prompt, and I'd
like to have one additional "safety net" - to manual
commit all SQL's. Sure - I can "begin w
Bruno,
Excellent advise !
thanks to all,
terry
Bruno Wolff III wrote:
On Thu, Dec 18, 2003 at 15:48:14 -0500,
Terry Hampton <[EMAIL PROTECTED]> wrote:
OOPS! This group is quick and
Original Message
Subject: [ADMIN] Quick Question Please
Date: Thu, 18 Dec 2003 15:30:41 -0500
From: Terry Hampton <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
All,
Seem to be having a brain lock.
What is the method or syntax to return
a list of column names for a given tabl
All,
Seem to be having a brain lock.
What is the method or syntax to return
a list of column names for a given table name ?
many thanks for your quick help,
Terry
--
Terry L. Hampton
Program Manager
LimaCorp, LLC. www.limacorp.com
513.587.1874
-
Hello Marie,
In most of my tables, I have the same
two columns:
lastupdateTIMESTAMP not null default
('now'::text)::timestamp(8),
createdateTIMESTAMP not null default
('now'::text)::timestamp(8)
"crea
scott.marlowe wrote:
Please note that this is not necessarily true. If my server has been up a
while and I stop/restart the postmaster, it may have a fairly high id
number and it is quite possible that in x number of days time, the
children will be created with a wrapped pid which is lower than
ique
degree of " strength " and purpose. No - the higher value
is not a more powerfull kill.To more smoothly manage
a UNIX system, use the appropriate kill signal value. You'll
avoi
All,
My CEO has asked for a PostgreSQL White Paper
to give to a Client.Before I start typing - anyone
have one or can point me to one ?
Many thanks ( and thanks for the info this group provides ),
Terry Hampton
15 matches
Mail list logo