[GENERAL] Help with join syntax sought

to include it in the GROUP BY clause as well. Any help is welcomed. -- *** 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

Re: [GENERAL] Help with join syntax sought

that returns every distinct combination of base, quote, timestamp, and type, then what? Unless I am missing something then I still have too many rows for those currencies with more than one type. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn

Re: [GENERAL] Help with join syntax sought

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

[GENERAL] Would like an explanation of these error messages.

; pg_restore: [archiver (db)] could not execute query: ERROR: schema public already exists Command was: CREATE SCHEMA public; WARNING: errors ignored on restore: 2 --- -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte

[GENERAL] No return from trigger function

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

Re: [GENERAL] No return from trigger function

On Wed, April 8, 2009 16:05, hubert depesz lubaczewski wrote: On Wed, Apr 08, 2009 at 03:59:22PM -0400, James B. Byrne wrote: EXCEPTION WHEN unique_violation THEN -- NULL -- do nothing RETURN NULL; -- AFTER trigger results are ignored anyway END

Re: [GENERAL] No return from trigger function

On Wed, April 8, 2009 16:06, Tom Lane wrote: James B. Byrne byrn...@harte-lyne.ca writes: I just need another set of eyes to see whatever it is that I am overlooking. The RETURN is inside the EXCEPTION clause. You really need two BEGINs here, one for the outer function body and one

Re: [GENERAL] INSERT or UPDATE TRIGGER

-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

Re: [GENERAL] INSERT or UPDATE TRIGGER

done something wrong. Is there some way of getting PG to tell me what it is doing? -- *** 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

Re: [GENERAL] INSERT or UPDATE TRIGGER

I am testing the trigger function that I wrote. Is there a way to increase the logging detail level for just a single database instance? The manual indicates not, but just in case I am misreading things I am asking here? -- *** E-Mail is NOT a SECURE channel *** James B

Re: [GENERAL] INSERT or UPDATE TRIGGER

On Tue, April 7, 2009 16:07, Tom Lane wrote: You might find it more useful to add some elog(LOG) statements to the trigger body. Thank you again. I will go through section 44.2 tonight. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn

[GENERAL] INSERT or UPDATE

in straight SQL? Should it be straight SQL if possible? What should the function return, if anything? Fairly basic stuff I am sure but somewhat mystifying for me at the moment. Any help would be appreciated. -- *** E-Mail is NOT a SECURE channel *** James B. Byrne

Re: [GENERAL] INSERT or UPDATE

*** 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

Re: [GENERAL] INSERT or UPDATE

*** 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

Re: [GENERAL] INSERT or UPDATE

if the function handles a failed insert then if the function occurs inside a transaction then that transaction fails and is rolled back regardless? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte Lyne Limited http

[GENERAL] Rule or Function and Trigger?

? If one looks at things from a code maintenance standpoint it appears the the function and trigger approach is preferable. Is it? Opinions? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte Lyne Limited http

Re: [GENERAL] nulls

*** 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

[GENERAL] nulls

reached on the matter. What is the best way to proceed? -- *** 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

Re: [GENERAL] nulls

On Thu, March 12, 2009 12:00, Richard Huxton wrote: James B. Byrne wrote: The basic issue is episodic duration, expressed as columns named dt_effective_from and dt_superseded_after. Both are datetime types containing values normalized to utc. If it's unknown use null. in some

Re: [GENERAL] How are locks managed in PG?

itself. I think that to describe either OS or commercial software as better or worse is misleading. The most that can be said is that each approach serves a different purpose and exists in a different environment. -- *** E-Mail is NOT a SECURE channel *** James B. Byrne

[GENERAL] Backup using GiT?

to warrant this approach? Comments? (not my my sanity, please) -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario

Re: [GENERAL] does postgresql works on distributed systems?

In-Reply-To: : [EMAIL PROTECTED] On: Thu, 05 Jun 2008 09:03:14 +0300, Volkan YAZICI [EMAIL PROTECTED] wrote: BTW, can you comment on the activity of the OpenSSI project. A project with a dead main page (see http://openssi.org) doesn't smell good to me. Are there any alive support in the

[GENERAL] Rules to provide a virtual column

to do this. Can someone show me how this could be accomplished? And, can someone correct my use of current_date in the example given above if require? Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited

Re: [GENERAL] MySQL to Postgres question

between versions. Surely this is not the case? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario

Re: [GENERAL] Functional Index Question

the right thing to do. Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757

[GENERAL] Functional Index Question

guy. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] 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

[GENERAL] Approaches for Lookup values (codes) in OLTP application

*** James B. Byrnemailto:[EMAIL PROTECTED] 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 ---(end of broadcast

Re: [GENERAL] Approaches for Lookup values (codes) in OLTP application

is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] 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 ---(end of broadcast

Re: [GENERAL] Approaches for Lookup values (codes) in OLTP application

the qualifying rows back and the index would be usable in this case, whereas if the code value came first in the composite key then the index would be useless for this query. Have I got this more or less straight? -- *** E-Mail is NOT a SECURE channel *** James B. Byrne

Re: [GENERAL] Help with pre-loaded arbitrary key sequences

that I originally had. I was simply wondering if the built-in sequencer could handle this case or whether I need to roll my own. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9

Re: [GENERAL] Help with pre-loaded arbitrary key sequences

is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] 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 ---(end

Re: [GENERAL] Help with pre-loaded arbitrary key sequences

. Many thanks. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] 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

[GENERAL] Help with pre-loaded arbitrary key sequences

to get quick answers to questions that may be far more involved than I realize. Sincerely, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905

[GENERAL] CentOS-5 PostgreSQL 8.1.9 server instrumentation

.sql which pgadmin3 indicates as necessary to enable these features. yum whatprovides does not provide any useful information either. sincerely, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http

Re: [GENERAL] Primary Key

more, or less, coercive than many other programming conventions. Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241

[GENERAL] UTF-8 encoding

to the user as perfectly sensible text. Sincerely, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario

Re: [GENERAL] pg_dump on local Windows, pg_restore on Linux?

are doing and what programs will be impacted. If set then LC_ALL overrides all of the individual LC_ settings. Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9

Re: [GENERAL] ssl connections to postgresql

to increasing the key size for a host connection from 256 and, if so, how is this done? Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1

Re: [GENERAL] ssl connections to postgresql

. Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] 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

Re: [GENERAL] ssl connections to postgresql

On Wed, July 25, 2007 03:13, Albe Laurenz wrote: James B. Byrne wrote: I would like to verify that the connection between these two machines is indeed employing ssl for the application in question. If you set log_min_messages and log_min_error_statement to debug5, you will get something

[GENERAL] ssl connections to postgresql

version so the favour of a direct reply in addition to any sent to this list is requested Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive

<    1   2