we are running redhat version 7.3.6-1 for EL AS3. most
of our db can be analyised by your tool. bot only one
is not. if we dump this one, init a db, then import
with template1, things are ok and your tool can be
used against this new db.
any suggestions?
please
cheng
--- Martijn van
On Sat, Jun 05, 2004 at 18:50:56 +0200,
Bambero [EMAIL PROTECTED] wrote:
GRANT for row access ?
It looks like you may be expecting individuals to own rows. I didn't
read that into your original post. GRANTing appropiate rights could allow
a table owner to be able to INSERT, UPDATE and DELETE
From Day One I have been using money in all of my tables, sigh, I guess
it is time to change...
Any suggestions on what to change to and how to conveniently
do the transformation. Anything to watch out for?
I have about 6 tables and the largest only has about 3300 rows.
Jerry
Trying to portupgrade my PHP 4.3.6
packagewith PostgreSQL 7.4.2 support and getting this error below. Trying
to setup postgresql with Heimdal Kerberos 5 support, believe I have, but not
tried anything with it, yet.
/usr/local/lib/libpq.so: undefined reference to
hi!
i have searched a lot in these pgsql-groups and on the internet, but
found no really helpful information for my problem.
the famous error
database xyz is being accessed by other users
is my problem.
i use postgesql 7.3.2 and zope 2.6.1 (python 2.1.3).
i want to create and drop databases.
Hi all,
I am a bit confused about the method
java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this
return? If this returns true, are nulls considered as the highest
value? Or does this mean that nulls comes first when sorted in
ascending order (opposite in meaning to the
Albretch wrote:
After RTFM and googling for this piece of info, I think PostgreSQL
has no such a feature.
Why not?
. Isn't RAM cheap enough nowadays? RAM is indeed so cheap that you
could design diskless combinations of OS + firewall + web servers
entirely running off RAM. Anything needing
Vikas Rana wrote:
Hi all,
I am a bit confused about the method
java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this
return? If this returns true, are nulls considered as the highest
value? Or does this mean that nulls comes first when sorted in
ascending order
Sir,
I am a development engineer in network application
I have a problem regarding upgrading my database
the problem is how do I transfer the contents from one table in a
database from one server to postgresql database table in another
server.
the data contents is in few MB.
can you suggest me an
This has nothing to do with triggers, it has to do with not being able
to defer UNIQUE constraints. The classic solution is:
update SET column = -column;
update SET column = -column+1;
Thanks for the reply.
Is changing query the only way to do this in postgres?
I would expect some more.
Hi, I'm not sure if this is the correct group for this question, but
I'll post it hoping that it is.
I'm loading several ~15 million row files into a table using the COPY
command. Apparently one of the rows, about 6 million in, has an invalid
entry. This is causing the COPY command to fail, so
[EMAIL PROTECTED] (brijesh) wrote:
Sir,
I am a development engineer in network application
I have a problem regarding upgrading my database
the problem is how do I transfer the contents from one table in a
database from one server to postgresql database table in another
server.
the data
Is it possible to turn off the $ and , that appear in money formatted
columns so I can dump the table in a numeric format?
The man page hints that lc_monetary controls the formatting but I
cannot find any clues on what to do...
Apparently money cannot be cast to anything.
I don't think it will
It's true, PostgreSQL can only check a unique contraint at the time the
row is inserted and can't defer it to the end of the statement due to
the way they are implemented (using the indexes). Sure, there has been
talk about it but I don't think anyone has done it yet.
The thing is that for the
14 matches
Mail list logo