I am currently running Version 9.3.10 of postgres with RHEL 6. I am going
to upgrade my O/S soon to RHEL 7. Do I need to upgrade to version 9.4.x of
postgres?
Paul Tilles
My
question is this: Is there a way I can verify the physical disk size of
a row? I'd like to compare the size of one row on this database to
another "healthy" database.
Thanks for any help you can provide!
Paul Tilles
Thanks in advance to the Community for your help.
Paul TIlles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have an executable which uses ecpg which was created on a system using
postgres version 8.2.6. I sent it to a site with version 8.4.7
installed. The executable fails with a memory fault.
Is there a problem doing this?
Paul Tilles
--
Sent via pgsql-general mailing list (pgsql-general
Where can I find a list of changes for Version 8.4 of postgres?
Paul Tilles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
current_timestamp to be UTC?
Paul Tilles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
The result of the subtraction of the the two timestamps is not correct.
What's going on?
TIA.
Paul Tilles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
31.9.1) describes the functions risnull and
rsetnull. These are the names of the original Informix functions. Are
they available for use through ecpg?
As always, TIA.
Paul Tilles
---(end of broadcast)---
TIP 3: Have you checked our extensive
We would like to use the 8.2 version of postgres with our next software
build. The next 8.2 version will contain a software patch which is
critical to our needs. When is the next release of 8.2 expected to occur?
As always, TIA.
Paul Tilles
---(end of broadcast
#x27;dtime_t'
How should we fix this?
Paul Tilles
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
by a database rename
caused the rename to fail in some cases. I had to add a loop with a
"sleep" followed by a check if the database was open.
We are using postgres Version 7.4.8.
TIA.
Paul Tilles
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Tom,
Thank you. That works.
My psql does not allow me to leave off the trailing `.
It is my typing that is the problem.
Paul
Tom Lane wrote:
Paul Tilles <[EMAIL PROTECTED]> writes:
What I really want to do is the following:
\set local_site `echo $FXA_LOCAL_SITE
do is the following:
\set local_site `echo $FXA_LOCAL_SITE
UPDATE table_name SET office_id = :local_site;
This results in the message
column "xxx" does not exist
Is there any way that I can use the value of the FXA_LOCAL_SITE env
variable in my UPDATE stat
Yes. That works. I think that the parser should work properly either way.
Paul
Bruce Momjian wrote:
Paul Tilles wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint
postgres has a problem parsing a "not equal negative value".
Anybody know if this is fixed in later versions?
Paul Tilles
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
I am looking to install the new Postgres V7.4 on RedHat Linux 7.2.
Is there an RPM available? If so, where?
TIA,
Paul Tilles
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
16 matches
Mail list logo
