Re: [GENERAL] Installation Size showing huge size in postgres installed on windows os

2015-03-19 Thread Raymond O'Donnell
;> >> I feel neither the installation or the small postgres databases I would have >> created use 121GB. >> >> Any reason why it shows 121GB > > Could you share with us \l+ command in psql session ? Also, see what Windows reports as the space taken up by the install

Re: [GENERAL] Load Data with COPY

2015-03-24 Thread Raymond O'Donnell
SV file? - if so, delete it and try again. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] :Posgres - performance problem

2015-03-25 Thread Raymond O'Donnell
onsistency if I forget update/export/import on 1 or more > table. It is terrible. You could create a view specifically for export, which would gather together data from all the tables. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing

Re: [GENERAL] check data for datatype

2015-03-27 Thread Raymond O'Donnell
m where ~ http://www.postgresql.org/docs/9.4/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP HTH, Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.

Re: [GENERAL] Best way to migrate a 200 GB database from PG 2.7 to 3.6

2015-04-15 Thread Raymond O'Donnell
fline all the time. > Is there another possibility to migrate a database with 200 GB ? Those version numbers aren't correct... current PG major versions run from 9.0 to 9.4. I don't think there was ever any version less than 6 (though I could be wrong). Ray. -- Raymond O'Donn

Re: [GENERAL] Moving Specific Data Across Schemas Including FKs

2015-04-23 Thread Raymond O'Donnell
integrity? I'd create the tables in the new schema without the FK constraints, copy the data, then add the constraints afterwards. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to y

Re: [GENERAL] Moving Specific Data Across Schemas Including FKs

2015-04-23 Thread Raymond O'Donnell
On 23/04/2015 19:08, Raymond O'Donnell wrote: > On 23/04/2015 18:09, Cory Tucker wrote: >> I have the need to move a specific set of data from one schema to >> another. These schemas are on the same database instance and have all >> of the same relations defined. The

Re: [GENERAL] Restarting DB after moving to another drive

2015-05-11 Thread Raymond O'Donnell
matically if they are not in use by other > services or programs” Hi there, Sounds like you're on Windows - you can get more information from PostgreSQL's own logs, which by default on Windows are in a directory called pg_log under the data directory. Ray. -- Raymond O'Donn

Re: [GENERAL] Restarting DB after moving to another drive

2015-05-11 Thread Raymond O'Donnell
lays with Windows, I've no idea I'd guess that changing the drive letter might well cause Bad Things to happen. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscripti

Re: [GENERAL] Between with a list of ranges possible ?

2015-05-29 Thread Raymond O'Donnell
able where number * 3 between start_value3 and end_value3; If they're all the same table, just use OR: ... where (number * 3 between start_value1 and end_value1) or (number * 3 between) etc. Or am I missing something? Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.

Re: [GENERAL] My postgres is not logging anymore

2015-06-18 Thread Raymond O'Donnell
ion_size = 10MB The comments in postgresql.conf indicate that log_destintion and logging_collector, at least, need to be set as above to generate log files. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] My postgres is not logging anymore

2015-06-18 Thread Raymond O'Donnell
On 18/06/2015 13:13, Maila Fatticcioni wrote: > On 06/18/2015 11:48 AM, Raymond O'Donnell wrote: >> On 18/06/2015 10:34, Maila Fatticcioni wrote: >>> Hello. I have a postgres cluster made by two nodes with OS Ubuntu >>> 14.04. About two weeks ago I did a minor updat

Re: [GENERAL] PL/pgSQL: How to return two columns and multiple rows

2015-06-18 Thread Raymond O'Donnell
> RETURN; > END; > $$ language 'plpgsql'; > > mydb=> select myfunc('foo','bar'); You need to do: select * from myfunc('foo','bar'); Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] timestamp check

2015-07-11 Thread Raymond O'Donnell
name='US/Eastern'),'-MM-DD > HH24'||':'||'MI'||':'||'SS')::timestamptz; > > it's not displaying timezone..any help..? > Because TIMESTAMPTZ - TIMESTAMPTZ = INTERVAL, not TIMESTAMPTZ. Also, why on earth are you do

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Raymond O'Donnell
g? And if not in the official documentation is it in the wiki? session_user, current_timestamp and current_user are all functions, not magic constants: http://www.postgresql.org/docs/9.4/static/functions-datetime.html http://www.postgresql.org/docs/9.4/static/functions-info.html I hop

Re: [GENERAL] timestamp check

2015-07-13 Thread Raymond O'Donnell
> > it's not displaying timezone..any help..? Hi there, This question was answered a few days ago, but perhaps you didn't see it. The reason you don't get timezone information is that subtracting two timestamps results in an interval value. See table 9-27 on this page: h

Re: [GENERAL] I lost my password

2015-07-27 Thread Raymond O'Donnell
"postgres" (or whatever user you used to connect): alter role postgres with password 'whatever'; Don't forget to edit pg_hba.conf once again and set "trust" back to "md5' (and re-start the service). Finally, note that the "postgres" user is the

Re: [GENERAL] I lost my password

2015-07-27 Thread Raymond O'Donnell
e are tons of documentation and examples out there - Google is your friend. Qt's own documentation is very good. For plain C, read PostgreSQL's own docs: http://www.postgresql.org/docs/9.4/static/libpq.html Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via

Re: [GENERAL] pghba.conf

2015-08-03 Thread Raymond O'Donnell
coming from 192.168.02.64, whereas you specified 127.0.0.1 in pg_hba.conf. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] PostgreSQL Developer Best Practices

2015-08-26 Thread Raymond O'Donnell
ember having them!!!) >> Oh, so you name your tables 'fish' and 'crow' instead of 'school' and >> 'murder' ? Such wasted opportunities :p >> > ??? A school of fish and a murder of crows... wonderfully evocative collective nouns. Ray

Re: [GENERAL] table dependencies

2015-09-07 Thread Raymond O'Donnell
On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote: > No worries. > > I found a way. > Would you share it, for the archives? Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

[GENERAL] Selecting pairs of numbers

2015-10-05 Thread Raymond O'Donnell
ection. There's probably something simple that I'm just not seeing If anyone's interested, these numbers represent channels and pistons on the combination system of a largish pipe organ... it's for a hobby project. Many thanks in advance! Ray. -- Raymond O'

Re: [GENERAL] Selecting pairs of numbers

2015-10-05 Thread Raymond O'Donnell
On 05/10/2015 19:53, Adrian Klaver wrote: > On 10/05/2015 11:39 AM, Raymond O'Donnell wrote: >> Hello all, >> >> I have an SQL problem which ought to be simple, but I can't get my head >> around it. >> >> I have pairs of integers - let's call

Re: [GENERAL] Selecting pairs of numbers

2015-10-05 Thread Raymond O'Donnell
ften a geometrical solution to an algebraic problem. Thanks! Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] Selecting pairs of numbers

2015-10-05 Thread Raymond O'Donnell
On 05/10/2015 20:08, Adrian Klaver wrote: > On 10/05/2015 12:00 PM, Raymond O'Donnell wrote: >> On 05/10/2015 19:53, Adrian Klaver wrote: >>> On 10/05/2015 11:39 AM, Raymond O'Donnell wrote: >>>> Hello all, >>>> >>>> I have

Re: [GENERAL] Hierarchical Query Question (PHP)

2015-10-30 Thread Raymond O'Donnell
mals ( id serial, taxonid integer, -- use the lookup table parentid integer, -- use the lookup table constraint mammals_taxon_fk foreign key (taxonid) references taxon(taxonid) ); If parentid also references taxon.taxonid, add a similar constraint for it too, Ray. -- Raymond O&#

Re: [GENERAL] Hierarchical Query Question (PHP)

2015-10-30 Thread Raymond O'Donnell
#x27;t visible, you can make it visible under the "View" menu. As a bonus, you can select a block of SQL and only the selected code will get executed. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] Selectively Importing Data

2015-10-31 Thread Raymond O'Donnell
1] http://www.postgresql.org/docs/9.4/static/datatype-numeric.html#DATATYPE-SERIAL [2] http://www.pgadmin.org/support/list.php -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] MediaWiki + PostgreSQL is not ready for production?

2016-07-20 Thread Raymond O'Donnell
On 20/07/16 16:57, John DeSoi wrote: On Jul 18, 2016, at 11:47 PM, John R Pierce wrote: Drupal even tried to offer a database API so plugin developers wouldn't touch SQL directly, but too many ignored it. I have been using Drupal with PostgreSQL for more than 10 years without too many probl

Re: [GENERAL] please remove outdated site from 2005

2016-09-04 Thread Raymond O'Donnell
On 04/09/16 19:33, Lukas Lehner wrote: Hi when I use a search engine for the term "Postgres Certification" this page shows up https://www.postgresql.org/about/news/333/ please remove that, very much outdated. The referenced link doesn't exist anymore (404 No such domain) In all fairness, th

Re: [GENERAL] Installing 9.6 RC on Ubuntu

2016-09-14 Thread Raymond O'Donnell
On 13/09/16 19:03, Steve Crawford wrote: I'm trying to install 9.6 RC1 on Ubuntu 16.04 Xenial on my laptop and it seems broken. Installation of 9.6 RC1 on Centos was straightforward by comparison - just add the 9.6 yum package and install. Unfortunately Ubuntu seems second-class by comparison.

Re: [GENERAL] isnull() function in pgAdmin3

2016-10-03 Thread Raymond O'Donnell
On 03/10/16 14:39, dudedoe01 wrote: What is the most feasible way to emulate the below MySQL function into postgreSQL. Since the isnull() function is no longer supported in 9.6 version. I have tried every trick in the hat to get the desired results. Still 'RPG INV' doesn't show only the other two

Re: [GENERAL] Generic way to test input arguments

2016-10-17 Thread Raymond O'Donnell
On 17/10/16 16:40, said assemlal wrote: Hello, I am looking for a way to test generically input arguments to raise an exception if one is either null or empty. I was thinking to create a function who takes an array to check them but not sure if it's really good. It's not clear what you want t

Re: [GENERAL] PHP-Shop with PostgreSQL

2016-11-08 Thread Raymond O'Donnell
On 08/11/16 18:24, Joshua D. Drake wrote: Hello, Drupal + Ubercart should service your needs. +1 to what the others said about Drupal + Ubercart: easy to set up, but very customisable too if you need to. There are a number of freely-available themes which are aimed at online shops and work v

Re: [GENERAL] Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)

2016-11-10 Thread Raymond O'Donnell
On 10/11/16 10:34, Juliano wrote: Hi, I'm trying to import some data from a MS SQL Server 2014 sequential database to Postgresql using dbi-link. Have you tried the foreign data wrapper for MS SQL Server? It's here: https://wiki.postgresql.org/wiki/Foreign_data_wrappers#Specific_SQL_Database

Re: [GENERAL] About the MONEY type

2016-11-30 Thread Raymond O'Donnell
I seem to remember that it was actually deprecated at some point - this is going back quite a few years. This was later reversed, though I don't know why. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] No select privileges when not connecting from login postgres

2016-12-03 Thread Raymond O'Donnell
://wiki.postgresql.org/wiki/Apt Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] How to loop through multi-dimentional array in PL/PGSQL

2016-12-09 Thread Raymond O'Donnell
is there any other way to access, i am getting null for product_list[i][0]; By default, PostgreSQL uses 1-based arrays (i.e. no [0] slot), so maybe that's your problem. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgs

Re: [GENERAL] How to loop through multi-dimentional array in PL/PGSQL

2016-12-09 Thread Raymond O'Donnell
On 09/12/16 10:42, Raymond O'Donnell wrote: On 09/12/16 06:35, VENKTESH GUTTEDAR wrote: Hello, Please help me in accessing multi-dimentional array in postgresql PL/PGSQL. for i in array_lower(product_list, 1) .. array_upper(product_list, 1) LOOP product_list[i][0];

Re: [GENERAL] Multidimentional array access

2016-12-09 Thread Raymond O'Donnell
On 09/12/16 15:30, Tom Lane wrote: As of 9.6 you could use the shorthand array_value = Eg[i][:] regards, tom lane I hadn't spotted that - very handy - will go and read up on it. :-) Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -

Re: [GENERAL] [OT] Postgresql and PHP

2016-12-23 Thread Raymond O'Donnell
rray($ipsrc)); if(!$query) { print error...} Are you sure it's failing? Try this: if ($query === false) { } PHP has funny ideas about what's true and false. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@pos

Re: [GENERAL] Fwd: I could not see any row in audit table

2017-01-25 Thread Raymond O'Donnell
"select count(*) from ...", or something else? Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] Why is table not found?

2017-01-31 Thread Raymond O'Donnell
DROP INDEX "Raum_RaumID_idx"; CREATE INDEX "Raum_RaumID_idx" ON "Raum" USING btree ("RaumID"); But psql tells me "Raum" is not existent: egon@xfEinzel ~ $ psql Hausrat psql (9.3.15) Type "help" for help. Hausrat=# SELECT * FROM Raum;

Re: [GENERAL] (solved) R: Very strange problem on index

2017-02-02 Thread Raymond O'Donnell
this, but did you run ANALYZE on the table after creating it? - Depending on how you created the table, the statistics needed by the planner may or may not have been up to date. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgs

Re: [GENERAL] Querying same lookup table with multiple columns based on another view

2015-11-17 Thread Raymond O'Donnell
type out your column names - I'm only guessing without seeing the DDL, but it sounds as if a column called macro_lookup_id exists in more than one table. You'll need to do something like this: select sample.macro_lookup_id as col_name_1, macroscopic.macro_lookup_id as col_name_2

Re: [GENERAL] Querying same lookup table with multiple columns based on another view

2015-11-17 Thread Raymond O'Donnell
ist - thanks!] You'd better show us your table structures - we're only guessing otherwise. However, I think typing efficiency isn't important, but rather what your application needs to do with the data - you only type the query once. :-) -- Raymond O'Donnell :: Galway :: Ireland

Re: [GENERAL] Querying same lookup table with multiple columns based on another view

2015-11-17 Thread Raymond O'Donnell
ro_lookup_id) MATCH SIMPLE > ON UPDATE CASCADE ON DELETE RESTRICT. > > In 9.3 is there an alter constraint option or do I have to drop the > constraint and add the new one? I just had a quick look at the docs for 9.3: http://www.postgresql.org/docs/9.3/static/sql-altertable

Re: [GENERAL] Text parameter is treated as sql query in postgresql function

2016-01-12 Thread Raymond O'Donnell
t; pde.deleted = ''''N'''' and > p.deleted = ''''N'''' and > pt.deleted = ''''N'''' and > de.local_date between ''''$2'''' and ''''$3'''' and I missed whatever passed upthread, but at a guess I'd say all the quoting is causing problems here. Why not use the quote_ident() and quote_literal() functions? By the same token, I don't think you need to put quotation marks around the parameters. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] Possible to dump/load a database from within psql?

2016-01-25 Thread Raymond O'Donnell
On 25/01/2016 10:16, Brian Cardarella wrote: > Is it possible, and if so how, to dump and then load a database to/from > a file from within a psql connection? You can use the COPY command to do a table at a time, but you'll get just the data - you won't get permissions etc. R

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread Raymond O'Donnell
ly unique in their respective tables, having additional serial and domain_id columns seems like overkill. Why not ditch them and use the domain name and username as the primary keys? Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] query from two tables & concat the result

2016-02-03 Thread Raymond O'Donnell
with "d.id" (partly my mistake, I missed that the column is called "id" and not "domain_id" in the domains table). Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] query from two tables & concat the result

2016-02-03 Thread Raymond O'Donnell
On 03/02/2016 13:57, arnaud gaboury wrote: > On Wed, Feb 3, 2016 at 2:19 PM, Raymond O'Donnell wrote: >> On 03/02/2016 13:11, arnaud gaboury wrote: >> >>> Hum hum... >>> -- >>> SELECT u.use

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread Raymond O'Donnell
t null, password text not null, domain_name text not null, created timestamp with time zone not null default now(), constraint users_pk primary key (username, domain_name), constraint users_domains_fk foreign key (domain_name) references domains(domain_name) ); And then your query would look somethi

Re: [GENERAL] Please let me know the latest PostgreSQL version available on Solaris 11?

2016-04-08 Thread Raymond O'Donnell
://www.postgresql.org/download/solaris/ -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] Bypassing NULL elements in row_to_json function

2016-04-08 Thread Raymond O'Donnell
s in the row_to_json function and > include only the fields that are non-null? You could use a CTE to filter out the nulls (not tested - I haven't used JSON in PG (yet!)): with no_nulls as ( select ... from my_table where whatever is not null ) select row_to_json() from no_nulls;

Re: [GENERAL] Allow disabling folding of unquoted identifiers to lowercase

2016-05-08 Thread Raymond O'Donnell
readable when you use long table / fiel names. I reckon this is just a matter of style... I use underscores to make long names readable... create table my_table_with_a_really_long_name; and it works fine. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via p

Re: [GENERAL] Release Notes Link is broken on the website

2016-05-12 Thread Raymond O'Donnell
postgresql.org/docs/9./static/release-9-6.html ^^^ Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] Thoughts on "Love Your Database"

2016-05-17 Thread Raymond O'Donnell
o upstream bugs in wxWidgets, over which the pgAdmin team has no control (hence pgAdmin 4). Having said all that, I've rarely had any trouble with pgAdmin 3 on Windows 7 and XP, Ubuntu and Debian; just a very occasional crash (maybe one every six months). Ray. -- Raymond O'Donnell

Re: [GENERAL] archive_command during database shutdown

2016-05-25 Thread Raymond O'Donnell
On 25/05/16 20:57, Jeff Janes wrote: On Wed, May 25, 2016 at 10:31 AM, Sameer Kumar wrote: On Thu, 26 May 2016, 1:25 a.m. Jeff Janes, wrote: I've recently wanted to run a different archive_command during database shutdown than during normal operations. In particular, if the normal archive

Re: [GENERAL] SQL Manager 2007 for PostgreSQL released

2007-05-28 Thread Raymond O'Donnell
all the time and am very happy with it. Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(e

[GENERAL] 8.3

2007-05-29 Thread Raymond O'Donnell
pful. Thanks, Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 4: Have you s

Re: [GENERAL] 8.3

2007-05-29 Thread Raymond O'Donnell
On 30/05/2007 00:11, Guy Rouillier wrote: I'm not one of the developers, but I found the following information here http://www.postgresql.org/developer/roadmap: That's great - thanks. Ray. ------- Raymond O'Donnell, Di

[GENERAL] PHP sucks!! - was: persistent db connections in PHP

2007-06-16 Thread Raymond O'Donnell
es; I'd like to see something similar in PHP. Apologies if this is off-topic for this list, but I'm curious as to why others reckon that PHP sucks. Ray. ------- Raymond O'Donnell, D

Re: [GENERAL] persistent db connections in PHP

2007-06-20 Thread Raymond O'Donnell
#x27;t pg_pconnect supposed to recycle a pooled connection? Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- -

Re: [GENERAL] Proposed Feature

2007-06-23 Thread Raymond O'Donnell
braries or DLLs (unless you create them yourself, of course). That does mean that a Win32 GUI app will be around 300k or so minimum. Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Irel

Re: [GENERAL] minimum function

2007-06-23 Thread Raymond O'Donnell
ion minimum(a1 integer, a2 integer) returns integer as $$ begin if a1 < a2 then return a1; else return a2; end if; end; $$ language plpgsql; - and then you can call it in one line: select minimum(5, 4); Ray. --- R

Re: [GENERAL] Image Archiving with postgres

2007-06-28 Thread Raymond O'Donnell
this list in the last eighteen months or so about storing binary files in a database vs storing them in the filesystem - you may find it useful to have a look through the archives. Ray. --- Raymond O'Donnell, Director of Music, G

Re: [GENERAL] i need a rad/ide open source for work with postgresql

2007-06-28 Thread Raymond O'Donnell
are for making front-end GUIs (for the most part), whereas PostgreSQL is a database. Have you looked at pgAdmin? Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROT

Re: [GENERAL] date time function

2007-06-28 Thread Raymond O'Donnell
58 days 21:10:36.748 (1 row) Of course, you'll need to decide how to handle the part of a day left over. HTH, Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Irel

Re: [GENERAL] how to: psql -U user --password password ?

2007-07-03 Thread Raymond O'Donnell
instead of using jdbc/odbc. Also, if the files you're importing were created by pg_dump, they'll contain various "backslash" commands that are psql-specific, so you *have* to re-import them via psql. HTH, Ray. -----

[GENERAL] Mugs 'n stuff

2007-07-03 Thread Raymond O'Donnell
Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Mugs 'n stuff

2007-07-04 Thread Raymond O'Donnell
I'll pass them on. Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] ---

Re: [GENERAL] blobs

2007-07-04 Thread Raymond O'Donnell
On 04/07/2007 17:34, Cesar Alvarez wrote: is there a way to store pictures or executables in postgres?? http://www.postgresql.org/docs/8.2/static/datatype-binary.html --- Raymond O'Donnell, Director of Music, Galway Cath

Re: [GENERAL] catalog location

2007-07-07 Thread Raymond O'Donnell
separate "Catalogs" node in the treeview on the left. HTH, Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, I

Re: [GENERAL] Windows Vista not working

2007-07-09 Thread Raymond O'Donnell
elp. Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Windows Vista not working

2007-07-09 Thread Raymond O'Donnell
On 09/07/2007 18:33, Raymond O'Donnell wrote: I you have a look through the (reasonably recent) archives of this list, Whoops - that should have been "If you" - sorry for any confusion. Ray. ------- Raymond O'

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Raymond O'Donnell
ption? - this forces a password prompt. Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Raymond O'Donnell
file? Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] Need help with bash script and postgresql

2007-07-23 Thread Raymond O'Donnell
Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Need help with bash script and postgresql

2007-07-23 Thread Raymond O'Donnell
. Usage: psql [OPTIONS]... [DBNAME [USERNAME]] Output format options: -P VAR[=ARG]set printing option VAR to ARG (see \pset command) Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EM

Re: [GENERAL] Need help with bash script and postgresql

2007-07-23 Thread Raymond O'Donnell
On 23/07/2007 14:51, Perry Smith wrote: Ah... I knew that. I always assume it does, then it doesn't work, then I look at the man page. Sorry. Been there, still wearing the t-shirt! :-) Ray. --- Raymond O'Donnell, D

Re: [GENERAL] Connection error

2007-07-24 Thread Raymond O'Donnell
got a snapshot from the pgAdmin site. The current stable version is 1.6, and 1.8 is in beta. Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL

Re: [GENERAL] PG Admin

2007-07-31 Thread Raymond O'Donnell
Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- T

Re: [GENERAL] Linux distro

2007-08-01 Thread Raymond O'Donnell
ted in people's comments. This machine will be running PostgreSQL and nothing else, and I'll probably compile Postgres from source. Ray. ------- Raymond O'Donnell, Director of Music, Ga

Re: [GENERAL] date ranges

2007-08-04 Thread Raymond O'Donnell
date, etc... check (the_date >= '1900-01-01' and the_date <= '2020-12-31') ); Then you just need to handle in your application the error raised when someone enters an incorrect date. HTH, Ray. ------- Raymo

Timestamp in pg_dump output, was Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Raymond O'Donnell
oint. :-) Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner wil

Re: Timestamp in pg_dump output, was Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Raymond O'Donnell
. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Raymond O'Donnell
up database. Do the backup from a shell script that names the output file with the current date/time. Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROT

[GENERAL] SQL question: checking all required items

2007-08-10 Thread Raymond O'Donnell
ther words, how do I select those rows in "people" which don't have a corresponding row in "items_for_people" for *each* row in "items" which has is_required=true? Many thanks, Ray. ------- Raymond O

Re: [GENERAL] SQL question: checking all required items

2007-08-10 Thread Raymond O'Donnell
. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: Timestamp in pg_dump output, was Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Raymond O'Donnell
On 10/08/2007 19:10, Tom Lane wrote: Use the "verbose" option. [/me tries it out] That'll do nicely - thanks. Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Irel

Re: [GENERAL] SQL question: checking all required items

2007-08-11 Thread Raymond O'Donnell
ving count(*) = ..." to "having count(*) >= ..." to allow for people having other items in addition to the required ones. Ray. ------- Raymond O'Donnell, Director of Music, Galway Ca

Re: [GENERAL] SQL question: checking all required items

2007-08-11 Thread Raymond O'Donnell
required items, whatever else they may have. Comments and improvements are welcome! Thanks for the help, Ray. ----------- Raymond O'Donnell, Director of Music, Galway Cathe

Re: [GENERAL] winxp failed installation problem

2007-08-12 Thread Raymond O'Donnell
ler package inside the zip won't work. Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---

[GENERAL] Repeat posts

2007-08-17 Thread Raymond O'Donnell
it. Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)---

Re: [GENERAL] Finding my database

2007-08-17 Thread Raymond O'Donnell
ump.html HTH, Ray. ------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- T

Re: [GENERAL] Finding my database

2007-08-17 Thread Raymond O'Donnell
On 17/08/2007 13:32, Raymond O'Donnell wrote: Was the previous installation of Postgres also 8.2? If not - if it was an earlier version - I'd put the old version back, point it at the data directory, then use pg_dump to export the data if you want to upgrade at that point. I me

Re: [GENERAL] Repeat posts

2007-08-17 Thread Raymond O'Donnell
.just curious. - Thanks for explaining. Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of

Re: [GENERAL] Where are the Server error logs

2007-08-17 Thread Raymond O'Donnell
. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 2:

Re: [GENERAL] Finding my database

2007-08-18 Thread Raymond O'Donnell
le people can help. Ray. ----------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 9: In versions below 8.0, the p

  1   2   3   4   5   6   7   8   9   10   >