uch the
same on any RHEL derived distro regardless of the package.
Good luck.
--
*** 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
Hamilto
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 p
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 super
On Thu, February 21, 2013 13:23, Merlin Moncure wrote:
> On Thu, Feb 21, 2013 at 11:48 AM, James B. Byrne
> 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
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 templ
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 Broc
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 tem
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" writes:
>>>> PG::Error: ERROR: encoding "UTF8" does not match locale
>>>> "en...@-mmm-dd.utf-8"
>>>> DETAIL: The chosen LC_CTYPE setting requires enco
On Fri, December 14, 2012 17:40, Tom Lane wrote:
> "James B. Byrne" writes:
>> PG::Error: ERROR: encoding "UTF8" does not match locale
>> "en...@-mmm-dd.utf-8"
>> DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1&quo
ge
# strings
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
So, w
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 fir
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 startu
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.
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 = 'p
1299)
using socket file "/tmp/.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-l
uired 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 ***
Ja
tension in that database continues to show
the plpgsql owner as postgres. psql on the other hand
shows the new language owner 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
means that only the superuser
can restore databases in 9.1 or build them from scripts;
unless the default template is altered. Is this desired?
What then does GRANT CREATE DATABASE mean in 9.1 then? It
is certainly at odds with the behaviour in 8.x releases.
--
*** E-Mail is NOT a SECURE
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
>
ALTER EXTENSION plpgsql OWNER TO devl;
ERROR: syntax error at or near "OWNER"
LINE 1: ALTER EXTENSION plpgsql OWNER TO devl;
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte & Lyne Limited http://w
DATABASE.
>
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.
Thereafter, the db owner must explicitly add it back in
where required. So, the default would be no exte
| postgres | 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 &a
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 OWN
;
ALTER EXTENSION plpgsql
OWNER TO postgres;
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
t;OWNER"
SQL state: 42601
Character: 25
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
On Mon, February 27, 2012 15:44, Tom Lane wrote:
> "James B. Byrne" 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.
>
>
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_
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_dum
On: Fri, 24 Feb 2012 07:33:01 -0800, Adrian Klaver
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
T 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 maili
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?
>> Alternati
-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
[archiver (db)] COPY failed: ERROR: invalid
input syntax for type bytea
CONTEXT: COPY wiki_content_versions, line 1, column data:
"\x68312e205b5b57696b6953746172747c48617274652026204c796e65204c696d697465642053746172745d5d0d0a0d0a0d..."
WARNING: errors ignored on restore: 4
--
***
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
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
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
hannel ***
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
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
gt; - Bill Thoen
I believe that what you are trying to do is called
relational algebra division. Take a look at these
references and see if either fits your needs:
http://en.wikipedia.org/wiki/Relational_algebra#Division_.28.C3.B7.29
http://www.cs.arizona.edu/~mccann/research/divpresentation.pdf
The Well-Grounder
Rubist" by David A. Black before you go 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
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 gener
ttps://github.com/rails/rails/issues/544
--
*** 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
dapter gem.
--
*** 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
the system. However, leaving untouched expected_by
values that are less than the infinite value is doable and is a
better approach.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte & Lyne Limited http://www.har
Or we choose for the default
value a fixed date far, far into the future.
+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.
--
***
are 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: +
s known 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
Ham
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
0 NOT NULL,
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
g a browse through these.
--
*** 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
re if this sort of thing crops 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
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 (p
s,
--
*** 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
t; s2.somecolumn
> )
>
I can see the motivation for something 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
terials I have to hand. I cannot believe that I am the
first 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. Byrn
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
ses, even 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
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
w running 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.
The message that I 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
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=on
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 inf
l.conf ssl option to on and
restarting 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
On Sat, December 4, 2010 01:11, Tom Lane wrote:
> "James B. Byrne" 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
On Wed, December 1, 2010 16:54, Tom Lane wrote:
> "James B. Byrne" 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
>> conne
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
*** 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
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
start the server before I try
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. Byrnemailt
On Wed, December 1, 2010 16:54, Tom Lane wrote:
> "James B. Byrne" 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
s
> that
> the data directory tree wasn't correctly labeled as postgresql_db_t.
> Maybe a restorecon would have helped?
>
> regards, tom lane
>
I tried a restorecon as suggested by sealert at the first error. It
had no effect insofar as I could determin
n
anyone here clue me in as to what 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, Ontari
==
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 Lim
On Thu, November 25, 2010 21:58, Robert Treat wrote:
> On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne
> wrote:
>>
>
> 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
r with the software
maintainers.
On the other hand, if there is another cause of this then I would
like to have that information as well.
Sincerely,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte & Lyne Limited
clause comparing a date 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
>
> BTW it seems 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. Byrnema
On Fri, July 10, 2009 18:48, Scott Marlowe wrote:
> On Fri, Jul 10, 2009 at 2:13 PM, James B.
> Byrne wrote:
>>
>> 2009-07-10 15:59:17 EDT hll_theheart_test 216.185.71.24(49133)
>> hll_theheart_db_admin : LOCATION: exec_simple_query,
>> postgres.c:1
close to the
very top of the run 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. Byrnemail
w what 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 075
art_db_admin : LOCATION: exec_simple_query,
postgres.c:1105
2009-07-10 15:59:17 EDT hll_theheart_test 216.185.71.24(49133)
hll_theheart_db_admin : LOG: 0: duration: 0.782 ms statement:
SELECT * FROM "currencies"
The client program that receives this result reports that there
ne. Is there a server
side technique that I can use which will tell me what data this
statement returned or if it found nothing?
In any case, I see the INSERTS and I can find NO DELETES at all. Is
there any other way to remove some or all data from a table?
--
*** E-Mail is NOT a
RE 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-general@
correct.
If anything is obviously wrong, or even mildly suspicious, I would
appreciate 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
H
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...@hart
E currency_exchange_rates ADD COLUMN 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
g here? Have I missed something dead
obvious?
--
*** 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
the best of my
ability 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. Byrne
der one roof, so to
speak, and begin checking things 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 90
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 Lim
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
ot;-server" 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 90
:
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
Is my appreciate correct?
--
*** 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
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
ther
hand, in case I 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-
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 cu
-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 p
"2009-05-19 20:40:00" "CLSE" 0.843100
and if requested for the 5 most recent then I want to see this:
CAD AUD "2009-05-19 20:40:00" "CLSE" 1.131200
CAD AUD "2009-05-19 16:15:00" "NOON" 1.146300
CAD AUD "2009-05-17 20:4
1 - 100 of 141 matches
Mail list logo