After much thought, I think I did something lame with a PAM file
somewhere a while back, causing root to use a passwd when su'ing. I'll
look into it.
Phillip
Phillip Harrington wrote:
Hello,
[EMAIL PROTECTED] root]# service postgresql start
Starting postgresql service: Password:
su: incorrect p
hello
how i recognize the data type of any field
except \d table_name;
there is a function of libpq library for recognize field type
but it returns a number not a name of the data type so how i know the
name with the help of this number.
recv_interger_number = PQftype(resultant_pointer,field_n
Hi Ashok;
Check the documentation on the system catalogs. You can look up types
there, etc. using joins from the system catalogs.
Something like
SELECT typname FROM pg_types WHERE oid IN (SELECT atttypid FROM pg_attribute
WHERE attname = 'column_name' AND attrelid = (SELECT oid FROM pg_class WHE
Is it possible to make a schema change to a dumped backup? I've
un-tarred the file and edited toc.dat and restore.sql, but when I
attempt to pg_restore the re-tarred file, I get an archiver out of
memory error.
This whole issue arose when I set a default in a table row equal to a
value that
We currently have multiple databases running different versions of
postgresql ranging from version 7.1 to 7.3. When we create users in 7.3
databases, it encrypts their passwords with md5, which is not supported
in 7.1. Is there some way to force postgresql 7.3 to use the old crypt
encryption for pa
Kris Kiger <[EMAIL PROTECTED]> writes:
> This whole issue arose when I set a default in a table row equal to a
> value that a plpgsql function returns (ie the table default =
> functionname(variable)). However, after exploration of the dump files,
> it appears that pg_restore tries to restore t
Kenny Drobnack <[EMAIL PROTECTED]> writes:
> We currently have multiple databases running different versions of
> postgresql ranging from version 7.1 to 7.3. When we create users in 7.3
> databases, it encrypts their passwords with md5, which is not supported
> in 7.1. Is there some way to force po
On Wed, 2003-12-31 at 12:20, Tom Lane wrote:
> Kenny Drobnack <[EMAIL PROTECTED]> writes:
> > We currently have multiple databases running different versions of
> > postgresql ranging from version 7.1 to 7.3. When we create users in 7.3
> > databases, it encrypts their passwords with md5, which is
Hi Vishal,
usage of floating poing arithmetic is a taboo in financial calculations.
This what the decimal type has been created for. Never ever use float.
Ciao, Toni
Sai Hertz And Control Systems wrote:
Dear all ,
I would like to share my concerns about the IEEE 754 specification and
floatin