.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via
***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql-general
created databases would have all of their components owned by the
database owner.
How do I resolve this problem?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley
On Thu, February 21, 2013 12:38, James B. Byrne wrote:
I am trying, without success, to create a PG-9.2 database without
including the plpgsql extension. I have tried specifying template0
and the database is nonetheless created with plpgsql. I have deleted
plpgsql from template1 and the new
On Thu, February 21, 2013 13:23, Merlin Moncure wrote:
On Thu, Feb 21, 2013 at 11:48 AM, James B. Byrne
byrn...@harte-lyne.ca wrote:
On Thu, February 21, 2013 12:38, James B. Byrne wrote:
I am trying, without success, to create a PG-9.2 database without
including the plpgsql extension. I
On Thu, February 21, 2013 16:02, Adrian Klaver wrote:
On 02/21/2013 12:14 PM, James B. Byrne wrote:
The current arrangement is not really satisfactory as it requires
either separate template databases for each userid granted the
DBCREATE role or the superuser role has to be granted in place
On Thu, February 14, 2013 06:23, Guillaume Lelarge wrote:
On Tue, 2013-02-12 at 15:32 -0500, James B. Byrne wrote:
PG-9.2
PGAdmin3-1.16.0
I am attempting to do this from inside PGAdmin3 but I find that I no
longer see either template0 or template1 in the object tree. Where
are they found
template0 to
the test software.
I am attempting to do this from inside PGAdmin3 but I find that I no
longer see either template0 or template1 in the object tree. Where
are they found?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
On Sun, December 16, 2012 15:13, Tom Lane wrote:
James B. Byrne byrn...@harte-lyne.ca writes:
PG::Error: ERROR: encoding UTF8 does not match locale
en...@-mmm-dd.utf-8
DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1.
This is what I see on the host running postgresql-9.2
On Fri, December 14, 2012 17:40, Tom Lane wrote:
James B. Byrne byrn...@harte-lyne.ca writes:
PG::Error: ERROR: encoding UTF8 does not match locale
en...@-mmm-dd.utf-8
DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1.
: CREATE DATABASE hll_th_forex_test ENCODING = 'UTF8
/.s.PGSQL.5432?
2012-12-14 09:13:41 EST: LOCATION: CreateLockFile, miscinit.c:822
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561
On Fri, December 14, 2012 09:40, Adrian Klaver wrote:
On 12/14/2012 06:26 AM, James B. Byrne wrote:
I wish to run an instance of PG-9.2 concurrently with our production
version (9.1). I have changed the listening port number.
listen_addresses = 'pgsql-dbms.hamilton.harte-lyne.ca, localhost
On Fri, December 14, 2012 09:52, Adrian Klaver wrote:
Assuming an RPM install, see Devrims reply.
Might one inquire as to why it is necessary to override the
configuration file in the startup script?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
On Fri, December 14, 2012 10:21, James B. Byrne wrote:
On Fri, December 14, 2012 09:52, Adrian Klaver wrote:
Assuming an RPM install, see Devrims reply.
Might one inquire as to why it is necessary to override the
configuration file in the startup script?
This is a patch for /etc/init.d
On Fri, December 14, 2012 10:21, James B. Byrne wrote:
This is a patch for /etc/init.d/postgresql-9.2 to retrieve the port
from the postgresql.conf file and override the default setting if it
A slight, but important, correction that handles leading white space
in the first selection
for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
So, what is going wrong here?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn
.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via
EXTENSION plpgsql OWNER TO devl;
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1
On Tue, February 28, 2012 12:52, Adrian Klaver wrote:
On 02/28/2012 09:50 AM, James B. Byrne wrote:
Sigh. I will have to think on this before changing
anything.
To my mind, the most straight-forward way of dealing
with
this is to remove the language from template1
altogether
.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql
as expected.
By the way. Thank you very much for your assistance with
this. It is greatly appreciated.
Regards,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley
by the pg_dump file
because of the ownership of the extension which triggered
this entire discussion.
I have removed plpgsql from template1 on all the systems
affected. The tests now run against 9.1 fine.
Regards,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
On: Fri, 24 Feb 2012 07:33:01 -0800, Adrian Klaver
adrian.kla...@gmail.com wrote:
On Friday, February 24, 2012 7:16:47 am James B. Byrne
wrote:
CentOS-5.7
RoR-3.1.1
Pg-9.1
I am trying to run a test suite against Pg-9.1 for a
RoR-3.1.1 based application. When I run the test DB
setup task
On Mon, February 27, 2012 13:54, Adrian Klaver wrote:
On 02/27/2012 08:51 AM, James B. Byrne wrote:
The options seem to be run the script as the owner of
the
plpgsql EXTENSION or do not include the comment.
How does one instruct pg_dump not to include the COMMENT
for the plpgsql extension
On Mon, February 27, 2012 14:30, Adrian Klaver wrote:
On 02/27/2012 08:51 AM, James B. Byrne wrote:
The options seem to be run the script as the owner of
the
plpgsql EXTENSION or do not include the comment.
How does one instruct pg_dump not to include the COMMENT
for the plpgsql
On Mon, February 27, 2012 15:44, Tom Lane wrote:
James B. Byrne byrn...@harte-lyne.ca writes:
1. Can the comments be suppressed?
No.
2. Why is this an error in the first place?
Because you're not running the script as superuser.
regards, tom lane
Why
So, as I am unfamiliar with the EXTENSION syntax, what is
wrong with the preceding statement? What is the correct
syntax?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
;
So, why is the plpgsql extension in test owned by postgres
and not by devl to begin with?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox
On Mon, February 27, 2012 16:37, Adrian Klaver wrote:
On Monday, February 27, 2012 1:23:22 pm James B. Byrne
wrote:
Obviously, I am missing something important here. The
database in question is created thusly:
CREATE DATABASE test
WITH OWNER = devl
ENCODING = 'UTF8
| UTF8 |
| | |
(5 rows)
Collation, C-Type and Access Privileges columns removed.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http
channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql
-1.14.0-3.rhel5.i86_64 or why it is not
available from pgdgrpm.org?
Regards,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
On Tue, January 10, 2012 09:28, Adrian Klaver wrote:
On Tuesday, January 10, 2012 6:17:27 am James B. Byrne
wrote:
My question: Is their a way to specify a pg_dump option
to retain compatibility with a lower version pg
database?
Alternatively, can one install a higher level pg_dump
syntax for type bytea
CONTEXT: COPY wiki_content_versions, line 1, column data:
\x68312e205b5b57696b6953746172747c48617274652026204c796e65204c696d697465642053746172745d5d0d0a0d0a0d...
WARNING: errors ignored on restore: 4
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
in his inbox.
Does anyone here know if there is reason why CentOS-5 has
the i386 package built for pgadmin3 v1.14.1 but not the
x86_64? Or does it exist and I am simply not finding it?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte
are likely to be using five
years from now I am soliciting informed option over which
option is considered a better choice for the long term.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http
based user ACLs is
sufficient.
I really want to get a sense of how prevalent using GRANT
PRIVILEGE, beyond the minimum required, is. And this
seems like a very good place to discover it. Again, please
reply off-list if you wish.
--
*** E-Mail is NOT a SECURE channel ***
James B
On Fri, December 9, 2011 12:13, James B. Byrne wrote:
Just to clarify the question. What I am asking basically
comes down to if separate user ids are added for most
individuals that access the database or not.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
that is
fine with me.
Thanks,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561
://www.cs.arizona.edu/~mccann/research/divpresentation.pdf
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton
much further into your
project.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1
On Fri, May 13, 2011 13:04, James B. Byrne wrote:
I have opened an issue for this with the ActiveRecord folks.
https://github.com/rails/rails/issues/544
This has been addressed by the AR team and is committed to master.
+-Infinity support for dates is slated for general release with
RoR
***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list
of but should provide for.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
.
+Infinity was chosen as a default to avoid the complexities of
dealing with NULL logic in SELECTS. I suppose that the simplest
solution is to go with a date of -12-31 and treat that value
like infinity.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
to anyone here then I would like to learn of
it.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario
,
weight_mass_net_uom character varying(3)
DEFAULT ' '::character varying NOT NULL,
. . .
);
My question is: Why am I getting a NULL exception? Should I only
specify DEFAULT and drop the NOT NULL constraint?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
On Tue, March 8, 2011 10:09, Scott Ribe wrote:
On Mar 8, 2011, at 7:54 AM, James B. Byrne wrote:
My question is: Why am I getting a NULL exception?
Because you're trying to insert NULL explicitly?
Yes, that is the problem. Evidently RoR's ActiveRecord helpfully
converts a string
-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general
up elsewhere and, if so, how is
it handled?
Sincerely,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario
channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql
person to require this sort of thing of SQL so if anyone can
point me to a reference that explicitly sets out how to accomplish
this I would greatly appreciate it.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne
like DISTINCT ON. I take it
that this syntax is peculiar to PostgreSQL?:
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql-general
with PostgreSQL?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E
whatever, remains owned by the
original owner. Is there no way to change the owner everywhere in
the cloned database using cretedb? Or am I constrained to do a dump
all and restore?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte
it it did
seem a bit convoluted. The REASSIGN OWNED BY seems the more
sensible approach.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905
installed
Might there be a problem between the server being compiled for i386
and openssl for i686? I cannot for the life of me determine what
configuration problem causes this error.
On Fri, December 3, 2010 16:04, James B. Byrne wrote:
When I try to start the server with ssl
presently get makes no sense at all to
me.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax
with ssl enabled.
Many thanks for the hints and suggestions. They did in fact
eventually point me in the right direction.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9
the server no longer causes any error.
Than you all for the help.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton
On Mon, December 6, 2010 13:29, James B. Byrne wrote:
The problem was an expired pki certificate. When we first used ssl
for pg we did not have our private CA set up. So we generated a
self-signed certificate. That certificate expired this past July
and I infer that while 8.1 did
On Sat, December 4, 2010 01:11, Tom Lane wrote:
James B. Byrne byrn...@harte-lyne.ca writes:
I wrote too soon. What I did was uncomment the ssl option. I
neglected to change the setting from off to on.
When I try to start the server with ssl=on it fails with this
error:
Auto
On Thu, December 2, 2010 15:32, James B. Byrne wrote:
On Thu, December 2, 2010 15:23, Devrim GÜNDÜZ wrote:
On Wed, 2010-12-01 at 16:54 -0500, Tom Lane wrote:
AFAIK, the Red Hat RPMs work out-of-the-box with SELinux;
They should -- we are using the same routines for initdb'ing.
I will do
On Wed, December 1, 2010 16:54, Tom Lane wrote:
James B. Byrne byrn...@harte-lyne.ca writes:
Earlier today I attempted to upgrade a production server
from 8.1 to 8.4 using the pgdg-84-centos.repo. I say
attempted because I could never get it to support ssl
connections
again. If there was just something odd about the SELinux contexts
on that particular host then that should clear it up. I will report
whichever way it goes thereafter.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte
and column layouts in the new database.
Is there a way to load the data dumped from a single table in one
database into a new, possibly differently named, table in a
different database, using PG utilities?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql
==
allow postgresql_t var_lib_t:dir rmdir;
allow postgresql_t var_lib_t:file { write getattr link read unlink
append };
Is this to be expected?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited
I am doing wrong?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
?
regards, tom lane
I tried a restorecon as suggested by sealert at the first error. It
had no effect insofar as I could determine.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http
On Wed, December 1, 2010 16:54, Tom Lane wrote:
James B. Byrne byrn...@harte-lyne.ca writes:
Earlier today I attempted to upgrade a production server from 8.1
to
8.4 using the pgdg-84-centos.repo. I say attempted because I
could
never get it to support ssl connections
***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql-general
On Thu, November 25, 2010 21:58, Robert Treat wrote:
On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne
byrn...@harte-lyne.cawrote:
Looks to me like the problem is you are trying to ORDER BY columns
in
ca_customs_entry, but there is no such table for that (don't
confuse
to a numeric expression such
as the one above?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario
B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql-general
is going on.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
this result reports that there are
no rows returned. So where did they go?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
log, which seems congruent with the one ROLLBACK
just before the very end.
Evidently, all this test processing takes place within a single,
never completed, transaction.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte
there are no rows. That is the problem. The question
begging an answer is: where are the rows added in the immediately
previous INSERTS?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte
necessary to clarify that LOCATION lines correspond
to the LOG/NOTICE/WARNING/ERROR line immediately _above_ it, not
the one below.
So noted, with thanks.
Regards,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne
a nudge in the right direction. This issue at least has
no overlong dates.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561
***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
effective_from
timestamp without time zone;
ALTER TABLE currency_exchange_rates ALTER COLUMN effective_from SET
STORAGE PLAIN;
ALTER TABLE currency_exchange_rates ALTER COLUMN effective_from SET
NOT NULL;
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
On Tue, June 30, 2009 14:07, Tom Lane wrote:
It's the eight-digit year field that it's unhappy with ...
Duuuh! I suppose that it would...
Thanks,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited
out from that initial point.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561
to recollect, the owner of the development and test
databases had dbcreate privileges.
If the problem persists under the cygwin environment then I will
revisit the native pg installation for testing.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn
:
pg_config.exe, pg_dump.exe and pg_dumpall.exe but no initdb.exe
anywhere. Is there something about initdb that I do not understand
or some reason why it would not form part of the cygwin
installation?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn
in it.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent
***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general mailing list (pgsql-general
Found it. The cygwin executables for postgres are installed under
/usr/sbin, which is NOT in the PATH thus the problem, and the
obvious solution.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited
-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql
Given a datetime column, not null, is there a single syntax that
permits searching for all dates in a given year, year+month, and
year+month+day such that a single parameterised query can handle all
three circumstances?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
was doing something out of ignorance that was
notoriously wrong, it seemed best to ask.
Regards,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive
-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
Sent via pgsql-general
On Wed, May 20, 2009 13:07, James B. Byrne wrote:
This seems to be working. I had to take a different approach as I
had misapprehended GROUP BY completely.
SELECT *
FROM currency_exchange_rates AS xchg1
WHERE id
IN (
SELECT id
FROM currency_exchange_rates as xchg2
WHERE
1.151300
CAD AUD 2009-05-16 20:40:00 CLSE 1.142100
CAD USD 2009-05-19 20:40:00 CLSE 0.843100
CAD USD 2009-05-19 16:15:00 NOON 0.864400
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited http://www.harte
1 - 100 of 141 matches
Mail list logo