[GENERAL] Transactions and insertion ordering

ny ways to make this work a little more intuitively? Basically I guess I want to be able to model a queue effectively. James ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Importing data

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 14 Aug 2003 18:48:43 -0500, Andrew L. Gould wrote: >> >> What you're looking for is COPY: >> >> http://www.postgresql.org/docs/7.3/static/sql-copy.html >> Thanks! That was it. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www

[GENERAL] Copy From with "null" data

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I am attempting to import data from a text file (tab-delimited) that has NULL fields of the form "(NULL)". (The source dbms does not have DUMP command.) According to the v7.3 docs (http://www.postgresql.org/docs/7.3/static/sql-copy.html): n

Re: [GENERAL] OT: HEADS-UP: viral storm out there

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 22 Sep 2003 20:06:56 +0530, Shridhar Daithankar wrote: >I had excess of 300 spam >mails to delete between friday night 9PM and monday morning 11AM. Usually that >is limited to 10-15 over week end. > Is that all? Lucky you. - -- jimoe at

Re: [GENERAL] Recomended FS

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 21 Oct 2003 18:56:52 +1300, Mark Kirkwood wrote: > >Note that even including the card, this is a very cheap setup. > Yes, this is the single advantage of IDE vs SCSI. If the price of the storage system is the *only* consideration, IDE is the

Re: [GENERAL] Recomended FS

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 26 Oct 2003 16:24:17 +1300, Mark Kirkwood wrote: >I would conclude that it not *always* the case that power failure >renders the database unuseable. > >I have just noticed a similar posting from Scott were he finds the cache >enabled case ha

[GENERAL] Unable to install DBD module

Hello, I am trying to install the DBD module and having some problems... -When trying to install 'DBD-Pg-0.95.tar.gz' I receive the following error after running 'perl Makefile.PL': "... Please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !" -When trying to install 'DBD-Pg-0.73-

[GENERAL] \l+ dumps core

I installed the postgresql-7.0.2-2 RPM downloaded from postgres.org, but \l+ always dumps core: % psql Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or t

[GENERAL] GNUe Forms 0.0.5 Released

of "usefullmaybe" :) You can find the python source code, rpms, and win32 version as well as some outdated screenshots at www.gnue.org Take Care James ([EMAIL PROTECTED]) ->->->->->->->->->->->->->->->->->->---<-<-<-<

[GENERAL] Working with large text blocks

t appear a good idea, or maybe I just don't understand. Can anyone point me in the right direction? Clinton James

[GENERAL] GNUe Forms 0.0.5 Released

as well as some outdated screenshots at www.gnue.org Take Care James ([EMAIL PROTECTED]) ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson13

Re: [GENERAL] GUI Interfaces

db is postgresql. You can get it from the download section of www.gnue.org. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

[GENERAL] Vacuum analyze keeps hanging (RedHat 6.2, PG 7.03)

/0.11u sec. NOTICE: Index referer_log_date_idx: Pages 159; Tuples 24306: Deleted 0. CPU 0.01s/0.08u sec. -- My system RedHat 6.2 PostgreSQL 7.03 PIII 500 MHz, 320 MB memory - JT James Thornton, http://jamesthornton.com ---(end

[GENERAL] Another "why am I not using the indicies?"

James #select version(); version -- PostgreSQL 7.1rc4 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 (1 row) #CREATE TABLE ld ( billmonth CHAR(4), cust_num CHAR(8), location CHAR(4

[GENERAL] IpcMemoryCreate: shmget failed (Invalid argument)

3, and I assume that you'll want to need to know my OS... [postgres@roam pgsql]$ uname -a Linux roam 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 i686 unknown (RedHat 6.2) Thanks. - JT ____ James Thornton, http://jamesthornton.com -

[GENERAL] Re: IpcMemoryCreate: shmget failed (Invalid argument)

James Thornton wrote: > I get this error when trying to start postgres with a block size > the > default of 64... > > [postgres@roam pgsql]$ /usr/local/pgsql/bin/postmaster -B 2000 -D > /usr/local/pgsql/data > IpcMemoryCreate: shmget failed (Invalid argument) key=543

Re: [GENERAL] make[2]: *** [psql] Error 1

s is a compiler option that will tell the linker to link in the ncurses routines. Hope this helps...james |

[GENERAL] Oracle vs Postgresql

? Why switch to postgresql? I'd really appreciate peoples thoughts on this. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

[GENERAL] Max length of a field name

I know I've read this is the docs but I can't find it now that I need it. What's the max length of a field name. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-&

Re: [GENERAL] Postgre superuser?? (fwd)

up a unique group for each user anyway as it doesn't hurt anything and in some cases it can be usefull. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

[GENERAL] postgres and PERL

I have written a program which queries a fairly large table with "GROUP BY" & "ORDER BY". The queries are taking a while to complete. It seems like the connection to the database is timing out before the results are returned. Any suggestions? -James

[GENERAL] Sharing DB connections between programs

suggestions you may have are greatly appreciated. Thank you. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

Re: [GENERAL] clean database

> > What's the clean command called? (To clean the db?) > Vacuum >Ryan

RE: [GENERAL] info on people running postgre

will not be alone in depending upon postgresql. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

Re: [GENERAL] Strange behaviour ?

> Se telecom italia aggiungesse uno scatto al giorno ad ogni abbonato, dal > primo Gennaio avrebbe rubato 668.954.000.000 Lire. > --- > Daniele Orlandi - Utility Line Italia - http://www.orlandi.com > Via Mezzera 29/A - 20030 - Seveso (MI) - > / James Boorn [EMAIL PROTECTED] - "All right, brain, I don't like you and you don't like me - so let's just do this and I'll get back to killing you with beer." -- Homer Simpson /

Re: [GENERAL] clean database

t;> >> What's the clean command called? (To clean the db?) >> >> Ryan >> > >If you want to remove all databases then use 'destroydb'. >If you want to remove tables in database then use 'drop table'. > Sometimes you clean the house, sometimes you burn the whole house down (-; ...james

Long - More info on project Was Re: [GENERAL] Would this project beof interest to anyone?

ava components are certainly welcome, I just didn't think it fit the bill for the core library. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

Re: [GENERAL] Embedded SQL in 'C' (cursors)

d for ecpg usage. IIRC There is an example of cursor usage in one of .pgc files. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

Re: [GENERAL] 6.5.1 possibly lost rows

nce a sequence generator is read it immediately increments. There is no way to roll that back due to the fact that other processes could have read the sequence generator after your process did and incremented it even further. ->->->->->->->->->->->->->->->

[GENERAL] Tough question from a potential user.

rocessing/data streaming/clustering? 4) What are the hardware requirements?   Any information related to *any* of these questions would be greatly appreciated. We're against a wall here, and I am the lone voice/proponent is this conflict.  Feel free to email me directly, if you wish.  

[GENERAL] Trig functions in manual

c |m raised to the power of n (1 row) Thanks, James ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

[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 D

Re: [GENERAL] ssl connections to postgresql

either 1024 or 2048. 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

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_statemen

Re: [GENERAL] ssl connections to postgresql

ch again raises a question that I posed earlier: Is there any benefit 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 &

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

L on a CentOS system unless you know exactly what you 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] Ha

[GENERAL] UTF-8 encoding

ates data stored by a UTF-8 database instance have its character encoding be UTF-8 or provide a means to convert it before submitting it to the DBMS. Otherwise you will get encoding errors when attempting to write data that otherwise appears to the user as perfectly sensible text. Since

Re: [GENERAL] Primary Key

teger keys but now I really do not consider them any 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 B

[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

[GENERAL] Help with pre-loaded arbitrary key sequences

sh 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

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

; That is close to the idea 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 Limite

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

own iterator and do a repetitive select when on the incrementally proposed values until an opening is found then insert the new entry and update the iterator next value accordingly. Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PR

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

erver. > > File attached. > 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

[GENERAL] PGError: ERROR: missing FROM-clause entry for table

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

Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table

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

[GENERAL] PG84 and SELinux

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

[GENERAL] PG_ERROR 42501 permissions error

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

Re: [GENERAL] PG84 and SELinux

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

Re: [GENERAL] PG84 and SELinux

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

Re: [GENERAL] PG84 and SELinux

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

[GENERAL] Dumping a table from one database and adding it to another

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

Re: [GENERAL] Dumping a table from one database and adding it to another

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

Re: [GENERAL] PG84 and SELinux

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

Re: [GENERAL] PG84 and SELinux

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

Re: [GENERAL] PG84 and SELinux

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

Re: [GENERAL] PG84 and SELinux

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

Re: [GENERAL] PG84 and SELinux

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

[GENERAL] PG84 and SSL on CentOS-5.5 was PG84 and SELinux

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

Re: [GENERAL] PG84 and SSL on CentOS-5.5 was PG84 and SELinux

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

Re: [GENERAL] PG84 and SSL on CentOS-5.5 was PG84 and SELinux

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.

[GENERAL] Set new owner on cloned database

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

Re: [GENERAL] Set new owner on cloned database

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

[GENERAL] Ad hoc report writer

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

[GENERAL] Getting a sample data set.

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

Re: [GENERAL] Getting a sample data set.

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

Re: [GENERAL] Getting a sample data set.

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

[GENERAL] Screencasts for PostgreSQL

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

[GENERAL] How to approach dynamic status reporting

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

Re: [GENERAL] Screencasts for PostgreSQL

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

[GENERAL] NULL value vs. DEFAULT value.

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

Re: [GENERAL] NULL value vs. DEFAULT value.

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

[GENERAL] Passing infinity as a timestamp value in Ruby

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

[GENERAL] Alternative to psql -c ?

out looking for instances of transaction instructions in advance but I have seen that PostgreSQL does not do this naively; it uses the lexer. Is there another way? Regards, James -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Alternative to psql -c ?

On Wed, 25 Jun 2014 10:09:18 -0400 Andrew Sullivan wrote: > On Wed, Jun 25, 2014 at 02:43:25PM +0100, James Le Cuirot wrote: > > > The cookbook currently uses PQexec so multiple SQL commands are > > wrapped in a transaction unless an explicit transaction > > instruction

Re: [GENERAL] Alternative to psql -c ?

On Wed, 25 Jun 2014 10:24:53 -0400 Andrew Sullivan wrote: > On Wed, Jun 25, 2014 at 03:16:19PM +0100, James Le Cuirot wrote: > > Same problem as stdin, the transactional behaviour is different. > > There is the --single-transaction option but as the man page says... > >

Re: [GENERAL] Alternative to psql -c ?

On Wed, 25 Jun 2014 16:42:53 +0200 hubert depesz lubaczewski wrote: > On Wed, Jun 25, 2014 at 4:37 PM, James Le Cuirot > wrote: > > > On Wed, 25 Jun 2014 10:24:53 -0400 > > Andrew Sullivan wrote: > > > > > On Wed, Jun 25, 2014 at 03:16:19PM +0100, James L

Re: [GENERAL] Alternative to psql -c ?

On Wed, 25 Jun 2014 09:04:44 -0700 Tom Lane wrote: > James Le Cuirot writes: > > hubert depesz lubaczewski wrote: > >> Perhaps you can explain what is the functionality you want to > >> achieve, as I, for one, don't understand. Do you want transactions? > &

Re: [GENERAL] Alternative to psql -c ?

t it. Some of these may contain transactional statements and these will not work properly if wrapped in a big BEGIN/COMMIT. Having said that, Tom Lane has suggested that we should not rely on the existing transactional behaviour so maybe we'll need to be more explicit about whether we actually

Re: [GENERAL] Alternative to psql -c ?

scripting-lang, which may != $their-fav-scripting-lang. Chances are that this would be Ruby in both cases but not every system packages the pg gem and that leads to the build-essential headache. > PS: Complex multi-statement executor calls are somewhat nuanced in > their own ways and I would b

Re: [GENERAL] Alternative to psql -c ?

On Wed, 25 Jun 2014 17:30:15 +0200 hubert depesz lubaczewski wrote: > On Wed, Jun 25, 2014 at 5:18 PM, James Le Cuirot > wrote: > > > > Also - I have no idea what "peer authentication" has to do with Pg > > > gem - care to elaborate? The gem is for client

Re: [GENERAL] Alternative to psql -c ?

On Thu, 26 Jun 2014 07:23:02 -0500 Merlin Moncure wrote: > On Thu, Jun 26, 2014 at 4:30 AM, James Le Cuirot > wrote: > > On Wed, 25 Jun 2014 13:21:44 -0500 > > Merlin Moncure wrote: > > > >> > The cookbook currently uses PQexec so multiple SQL commands

Re: [GENERAL] Alternative to psql -c ?

On Thu, 26 Jun 2014 11:02:09 -0700 Tom Lane wrote: > James Le Cuirot writes: > > This got me wondering what Rails uses. I dug into ActiveRecord and > > found that apart from the odd call to PQexec with hardcoded single > > statements, it uses PQsendQuery. The libpq do

Re: [GENERAL] Alternative to psql -c ?

On Thu, 26 Jun 2014 15:00:56 -0700 Tom Lane wrote: > James Le Cuirot writes: > > Tom Lane wrote: > >> PG is not capable of executing queries that are not in > >> transactions, so yes, PQsendQuery will create a single-statement > >> transaction if you hav

[GENERAL] Howto see template objects in PGAdmin3

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

Re: [GENERAL] Howto see template objects in PGAdmin3

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

[GENERAL] Need help extripating plpgsql

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

Re: [GENERAL] Need help extripating plpgsql

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

Re: [GENERAL] Need help extripating plpgsql

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

Re: [GENERAL] Need help extripating plpgsql

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

Re: [GENERAL] Need help extripating plpgsql

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

Re: [GENERAL] Build RPM from Postgres Source

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

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

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

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

application validation data as opposed to business state data. -- *** 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, Ont

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

posite 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. Byrnemailto:[EMAIL PROTECTED] Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Dr

[GENERAL] Functional Index Question

d? Not a regexp 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 Ca

Re: [GENERAL] Functional Index Question

tter but I am considering moving theses sorts of purification routines into the DBMS because I feel that is where they really belong. However, the prevailing sentiment of the community surrounding Rails seems to hold otherwise so I wonder if this is really the right thing to do. Regards, -- **

Re: [GENERAL] MySQL to Postgres question

such tables could be changed simply by dumping and reloading the database as in an upgrade between versions. Surely this is not the case? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:[EMAIL PROTECTED] Harte & Lyne Limited http://

[GENERAL] Rules to provide a virtual column

e" based upon the SELECT criteria given above. However, I am unsure if this is in fact possible and, if so, how 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

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] Backup using GiT?

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, Ont

<    1   2   3   4   5   6   7   >