I've never used it but what about:
https://developer.sugarcrm.com/2012/08/03/like-postgresql-and-want-to-use-it-with-sugarcrm-check-out-a-new-community-project/
Cheers,
George
On 13/12/2016 2:24 PM, Joshua D. Drake wrote:
On 12/13/2016 12:19 PM, John R Pierce wrote:
On 12/13/2016 10:19 AM, Jo
On 30/11/2016 9:16 PM, John R Pierce wrote:
On 11/30/2016 3:01 PM, George Weaver wrote:
I have set up 2 instances of PostgreSQL 9.6 on the same Windows
server. I noticed when I ran initdb for the second instance that it
did not create a pg_log folder in the new cluster, and that all
logging
Good afternoon,
I have set up 2 instances of PostgreSQL 9.6 on the same Windows server.
I noticed when I ran initdb for the second instance that it did not
create a pg_log folder in the new cluster, and that all logging is going
to the pg_log folder in the original cluster.
Is it possible t
Hi Kanakaraju,
This is a long shot but in case "case" matters, on all my computer the
variable is "ComSpec".
And I assume you added it as a System variable...
Cheers,
George
On 13/10/2016 6:24 AM, Karre, Kanakaraju (US - Hyderabad) wrote:
I have been trying to install Postgresql server on
- Original Message -
From: Gavin Flower
On 27/08/15 00:03, Vincent de Phily wrote:
On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:
Actually I would suggest standardising on singular names, not JUST
because that this the standard I prefer! :-)
But (also) because:
1. Si
- Original Message -
From: Bret Stern
I use odbc in a windows environment.
No complaints, can do inserts, select, updates, joins, execute stored
procedures
with little fuss...more than fast enough for my purposes.
There are some issues with 32/64 bit odbc depending on your relat
able thing to try.
On Fri, 13 Feb 2015 08:10:54 -0600
"George Weaver" wrote:
Hi Glenn,
No, and neither did I receive any responses.
I did find the following reference that 9.4 is officially not supported
on
XP, Server 2003 or Vista, however I have not seen anything "officia
ld | GIS Analyst | Information Services
Forestry Commission
Unknown error while running <>
postgresql_installer_dc46cfee2c\getlocales.exe
From:"George Weaver"
To:"pgsql-general"
Subject:Unknown error while running <>
postgresql_installer_dc46cfee2c\get
Sorry for the late reply...life interefered...
From: Jim Nasby
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I have a program that uses ODBC to connect to Excel and extract
data using SQL queries. The
Hi Adrian,
From: "Adrian Klaver"
Subject: Re: [GENERAL] "Ungroup" data for import into PostgreSQL
On 01/15/2015 04:56 PM, Jim Nasby wrote:
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I
Hi Adrian,
From: "Adrian Klaver"
Subject: Re: [GENERAL] "Ungroup" data for import into PostgreSQL
On 01/15/2015 04:56 PM, Jim Nasby wrote:
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I
Hi List,
Trying to install PostgresSQL 9.4.1 on Window XP Pro Service Pack 3.
Installation is aborted with the following error:
Unknown error while running C:\Documents and Settings\George Weaver\Local
Settings\Temp\postgresql_installer_dc46cfee2c\getlocales.exe
bitrock_installer.log
Hi Adrian,
From: "Adrian Klaver"
Subject: Re: [GENERAL] "Ungroup" data for import into PostgreSQL
On 01/15/2015 04:56 PM, Jim Nasby wrote:
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I
Sorry for the late reply...life interefered...
From: "Jim Nasby"
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I have a program that uses ODBC to connect to Excel and extract
data using SQL que
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I have a program that uses ODBC to connect to Excel and extract data
using SQL queries. The program then inserts the data into a PostgreSQL
table.
The challenge with this particular spreadsheet is that i
- Original Message -
From: Steve Atkins
I suspect you have standard_conforming_strings set to off (it defaults to
on in 9.1), possibly for backwards compatibility to support an app you’re
using that’s not been updated, possibly accidentally.
You're right - it was off (now On). Th
Actually, I found that the double backslashes are required whether the E
is
used or not:
You must be using a relatively old PG version then. Default behavior
since around 9.1 has been that backslashes aren't special except
in E'' strings.
Hmm.
development=# select version();
Hi All,
From: James Cloos
The E'' syntax eats your backslashes. For that version, try just:
SELECT REGEXP_REPLACE(LOWER('300 North 126th Street'),'(\d)(st|nd|rd|th)',
'\1', 'g');
Actually, I found that the double backslashes are required whether the E is
used or not:
development=# se
From: Ian Lawrence Barwick
- Original Message - From: Steve Atkins
On Feb 28, 2014, at 2:43 PM, George Weaver wrote:
>Maybe this?
>select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)',
>'\1', 'gi');
Hi Steve,
- Original Message -
From: Steve Atkins
To: pgsql-general
Sent: Friday, February 28, 2014 4:17 PM
Subject: Re: [GENERAL] Replacing Ordinal Suffixes
On Feb 28, 2014, at 2:04 PM, George Weaver wrote:
Hi list,
I'm stumped.
I am trying to use Regexp_Replace to replace or
- Original Message -
From: Steve Atkins
On Feb 28, 2014, at 2:43 PM, George Weaver wrote:
>Maybe this?
>select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)',
>'\1', 'gi');
Hi Steve,
Thanks, but no luck:
sele
From: Steve Atkins
On Feb 28, 2014, at 2:04 PM, George Weaver wrote:
> Hi list,
>
> I'm stumped.
>
> I am trying to use Regexp_Replace to replace ordinal suffixes in addresses
> (eg have '126th' want '126') for comparison purposes. So fa
s positive lookbehind expressions
(which are actually (?<=foo), not (?!foo)), but you can get the same
effect by capturing the number with (\d) and then outputting it again
with the \1.
Paul
On Fri, Feb 28, 2014 at 2:04 PM, George Weaver wrote:
Hi list,
I'm stumped.
I am trying to
Hi list,
I'm stumped.
I am trying to use Regexp_Replace to replace ordinal suffixes in addresses (eg
have '126th' want '126') for comparison purposes. So far no luck.
I have found that
SELECT REGEXP_REPLACE(LOWER('300 North 126th Street'), '(?!/D)(st|nd|rd|th)',
'', 'g');
regexp_replace
-
- Original Message -
From: David Johnston
>The condition (WHEN) in a case cannot be a set. You have to make the
>expression always resolve to a single row/value.
>I'd suggest creating a regexp_matches_single(...) function that calls
>regexp_matches(...) in a sub-select so that no matc
Good morning,
I've have solved my problem in another way, but I am curious as to why I am
getting the following error.
The following returns a boolean value a expected:
development=# SELECT LENGTH(ARRAY_TO_STRING(
REGEXP_MATCHES('12-70510','^[0-9,0-9.0-9]+')
development(#
- Original Message -
From: Stephen Brearley
Having been able to successfully connect to Postgres using both Navicat and
pgAdmin, I then moved my \data_old back to the \9.2 folder on the D: drive,
and modified the registry reference to point to this location..however I
can't see my o
- Original Message -
From: Stephen Brearley
I need someone to please look at my error log which I posted nearly six
weeks ago, and tell me what is wrong.
Are you trying to tell us how to help you? Or are you looking for help?
Since my e-mail suggesting that you work to get Postg
From: Stephen Brearley
To: pgsql-general@postgresql.org
Sent: Wednesday, July 17, 2013 5:41 AM
Subject: [GENERAL] FW: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400,
re-installation failure
The Problem
On re-installing Postgres, I have not been able to get it to work. During
re-installa
- Original Message -
From: Igor Romanchenko
>On Fri, Nov 9, 2012 at 9:21 PM, George Weaver wrote:
>>Hi Everyone,
>>I have a view made up of a local query unioned with a view comprised of a
>>dblink query.
>>If the dblink query cannot establish a conne
Hi Everyone,
I have a view made up of a local query unioned with a view comprised of a
dblink query.
If the dblink query cannot establish a connection, I get the "could not connect
to server" error and the whole view fails.
Setting fail_on_error to false does not work in this situation.
Is th
- Original Message -
From: Adrian Klaver
On 03/15/2012 09:17 AM, George Weaver wrote:
Hi All,
I am trying to use COPY to import postgresql logs into a postgresql
database for further review and sorting.
Are you using the CSV format to log to the Postgres log?:
http
Hi All,
I am trying to use COPY to import postgresql logs into a postgresql database
for further review and sorting.
The problem I'm encountering happens when COPY hits a blank row:
development=# COPY log
development-# FROM
'D:/PostgreSQL/9.1/pg_log/postgresql-2012-03-15_093730.log'
develo
Hi Everyone,
I want to thank all those that contribute to the PostgeSQL project for such
an awesome and professional product.
I started working with 7.2 on Windows (via cygwin), then 7.3, then to 8 and
8.1.
I have been using the 8.3 branch since it first came out.
This week I downloaded 9.
Original Message From: Dmitry Koterov
I need to create an auto-increment field on a table WITHOUT using
sequences:
You may get some ideas at http://www.varlena.com/GeneralBits/130.php
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
- Original Message -
From: Geoffrey Becker
I'm relatively new to postgres. I've got a Visual Basic (VB)
application that i would like to connect to a Postgres database using
ODBC . Both the VB application and postgres are on my laptop and both
work beautifully independent of each ot
From: Peter Geoghegan
Subject: Re: [GENERAL] Case Insensitive Foreign Key Constraint
I would probably just have a check constraint that prevented the
relevant PK field from being lower case in the first place. I had to
do that recently, but my approach reflected the business rules.
This is wh
Hi all,
Is there a way to have text-type foreign keys be case insensitive?
development=# CREATE TABLE foo (foo text PRIMARY KEY);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for
table "foo"
CREATE TABLE
development=# INSERT INTO foo VALUES ('foo');
INSERT 0 1
dev
Hi all,
I have the following (very simplified) scenario:
CREATE DOMAIN orderstatus AS text NOT NULL DEFAULT 'Open';
ALTER DOMAIN orderstatus ADD CONSTRAINT orderstatus_valid
CHECK (VALUE IN ('Open', 'Shipped', Cancelled'));
CREATE TABLE orders ( orderno serial
- Original Message -
From: "Bill Moran"
To: "George Weaver"
Cc: "pgsql-general"
Sent: Friday, May 08, 2009 9:45 AM
Subject: Re: [GENERAL] Remote access
In response to "George Weaver" :
[snip]
I have clients with web-based servers which u
Hi Andrew,
Interesting! Thanks for the detail.
George
- Original Message -
From: Andrew Gould
To: George Weaver
Cc: pgsql-general
Sent: Friday, May 08, 2009 9:57 AM
Subject: Re: [GENERAL] Remote access
On Fri, May 8, 2009 at 9:37 AM, George Weaver wrote:
Andrew
Hi Andrew,
Hi,
I have a client with a main office and a branch office about 90 miles
away.
They have a server at the main office but it is not a web server.
What would be the best solution for them to access a PostgreSQL database
located at the main office from the branch office?
I a
Andrew Gould in reponse to George Weaver wrote:
Hi Andrew,
Hi,
I have a client with a main office and a branch office about 90 miles
away.
They have a server at the main office but it is not a web server.
What would be the best solution for them to access a PostgreSQL database
From: "A. Kretschmer"
In response to George Weaver :
Hi,
I have a client with a main office and a branch office about 90 miles
away.
They have a server at the main office but it is not a web server.
What would be the best solution for them to access a PostgreSQL database
loca
Hi,
I have a client with a main office and a branch office about 90 miles away.
They have a server at the main office but it is not a web server.
What would be the best solution for them to access a PostgreSQL database
located at the main office from the branch office?
I am not "network savvy"
- Original Message -
From: "Howard Cole"
If you use Npgsql (.NET library) rather than ODBC - there are functions
for reading large objects into memory.
Cool!
I've been meaning to have a look at Npgsql - maybe this is the nudge I need!
Thanks,
George
--
Sent via pgsql-general
From: "Alvaro Herrera"
George Weaver wrote:
But if I try to find the same for lo_read I get:
development=# \df+ lo_read
alvherre=# \df loread
Listado de funciones
Schema | Nombre | Tipo de dato de salida | Tipos de datos de
Hi,
The PostgreSQL manual indicates that:
"There are server-side functions callable from SQL that correspond to each
of the client-side functions described above."
In psql I can get the argument data types for lo_open:
development=# \df+ lo_open
- Original Message -
From: "Konsta Tiihonen" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 23, 2008 5:29 AM
Subject: Re: [GENERAL] F-Secure and PostgreSQL
Konsta Tiihonen wrote:
> Hi,
>
> after some research a month ago I found out that there is some issue
> between the software F-secur
Hi Everyone,
Many years ago I created a domain with a char(4) datatype.
Now in my wisdom I would like to change this to a text datatype, but I can't
see any way of altering the type of a domain.
I have experimented with backing up the database and manually editing the
dump file to change the
- Original Message -
From: Jasbinder Singh Bali
To: pgsql-general@postgresql.org
Sent: Monday, July 16, 2007 3:55 PM
Subject: [GENERAL] Capturing return value of a function
I was wondering what would the function return if insert fails.
I want it to return 'success' upon a succes
On Thursday, May 10, 2007 6:07 AM David Gagnon wrote
I have a string array(Compte[]) and I need to create the following string
statement to populate a temporary table
statement := ' INSERT INTO T_CR1 ( CRNUM, CRMONT, CSGLNUM, CRDATE)
SELECT CRNUM, CSGLNUM, CRMONT, CRDATE
Original Message From Guy Rouillier
http://www.postgresql.org/docs/techdocs.71. Color me dumb, but I can't
figure a way to download the document "Apache 2.0, Tomcat 5.5, WARs &
PostgreSQL 8.1 JDBC DataSources on Windows XP". When I click on the link
to the document, it just brings me back t
Original Message From Andy Dale
Hi,
testdb=# SELECT film_name, xpath_list(description, 'year') FROM filminfo;
film_name | xpath_list
--- +
Casablanca | 1942
Rear Window | 1954
The Godfather | 1972
Test film | 1973,1972
It would seem reasonable i
Margaret Gillon offered the following kind support:
We had to run a special utility from Windows...
I will email instructions our admin put together...
Hi Margaret,
I heard from my client this morning and that did the trick!
Thanks again for you help,
Regards,
George
---
Stefan Berglund wrote:
foo WHERE (ID = 53016 OR ID = 27 OR ID = 292 OR ID = 512) or I could
alternatively pass the string of IDs ('53016,27,292,512') to a table
returning function which TABLE is then JOINed with the table I wish to
Stefan,
The user selections will be in some sort of list. C
A client has PostgreSQL 8.2.1 installed on a Windows 2000 server.
The time on the server is correct but PostgreSQL is returning a time 1 hour in
advance. In other words, it the server time is 1:00 pm, PostgreSQL is
returning 2:00 pm. Both the PostgreSQL server and Windows server have been
reb
From: "Tomi N/A"
And the .bat file script?
The .bat script is of no importance:
So be it...
it's a windows-related problem
Is the Task Scheduler service running? (Start > Settings > Control Panel >
Administrative Tools > Services - Task Scheduler?).
If the Task Scheduler service is r
From: "Tomi N/A"
> At this point, I decided to try a much more primitive approach: using
> a windows scheduled task running a .bat or .cmd script which in turn
> calls pg_dump.
It might be helpful if you provided the exact pg_dump command you are
trying
to use, as well as the text of the .ba
From: "Tomi N/A"
At this point, I decided to try a much more primitive approach: using
a windows scheduled task running a .bat or .cmd script which in turn
calls pg_dump.
It might be helpful if you provided the exact pg_dump command you are trying
to use, as well as the text of the .bat file
On Thursday, January 25 Furesz Peter wrote:
>How can I loop a PL/PgSQL recorset variable? The example:
>DECLARE
>v_tmp_regi RECORD;
>v_tmp RECORD;
>BEGIN
> SELECT * INTO v_tmp_regi FROM sulyozas_futamido sf WHERE
>sf.termekfajta_id=
> a_termekfajta_id AND sf.mar
- Original Message From: "Magnus Hagander"
What configure command did you run, exactly?
configure --without-zlib
I did solve the problem(?) by downloading the full distribution and using it
rather than the base distribution. With the full distribution everything
worked just as expecte
Hi all,
I have installed version 8.2.1 and downloaded the source tree in order to
compile a number of C-functions.
I have been compiling from source for contrib files and c-functions since
version 7.3 without problem.
I downloaded postgresql-base-8.2.1.tar.gz and unzipped it into the PostgreSQ
Original Message From: Moritz Bayer
>But still the question:
>Is it possible to put a loop into a loop? Or doesn't it make sense at all?
I'm not sure what the OP was about, but Yes, it it possible to put a loop into
a loop. See:
http://www.postgresql.org/docs/8.2/static/plpgsql-control
Original Message From Bob Pawley
Here's the url
http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm
Bob,
The above documentation is circa version 7.0.
It might be easier to use the current PostgreSQL official documentation.
See for example:
http://www.postgresql.org/docs/8.2/sta
- Original Message From: "Thomas H.", etc.
Thank you all for your replies and suggestions. I apologize for not
replying earlier but the client is located several hours away and I have not
been back to the site until yesterday.
Here's an update of the situation (PostgreSQL 8.1.5 on Window
Original Message -From: "RPK" <[EMAIL PROTECTED]>
I want to perform database backup (pgdump) from within VB.NET. Can it be
done?
I have an application developed using VB.NET that backs up the database
every 12 hours using a small batch file containing both a vacuum and pg_dump
backup script.
Hi Thomas
netstat -a -n
Cool!
And -o gives me the pid of the process which I can match with processes
through the Task Manager...
when another program is occupying the port, it would probabyl not make
much difference, except if the pgsql service is started before the other
tool.
maybe
From: "Jim Nasby"
Hmm... are you sure there isn't already something listening on port 5435?
Hi Jim,
How might I determine this?
Would this make a difference when the system is rebooted vs manually
restarting the server?
Thanks,
George
---(end of broadcast)-
- Original Message -
From: "Charles Ambrose" <[EMAIL PROTECTED]>
Is there a way that I could create a trigger that logs the changes
(updates, deletes) of a table? I mean, I want to put in a table the
changes to any table in a database and also put in the table the column
that was m
- Original Message -
From: Harald Armin Massa
Hi Harald,
>I guess your service is not running after rebooting? You can check this via
>services.msc
This is what is confusing me - the service IS running after rebooting, but does
not appear to be listening on port 5435. If I simply re
Hi everyone,
I recently installed PostgreSQL (Version 8.1.5.1) using the MSI installer on a
Windows Server 2000 system.
I ran the installer logged in under an Administrator account, and set the
service account to postgres.
During the installation process, when it came time to run initdb, the i
I had the same success using 7.3.2 with Cygwin:
e=# SELECT functest1('A','B'), functest1(null,'B'), functest2('A','B'),
functest2(null,'B');
functest1 | functest1 | functest2 | functest2
---+---+---+---
A | B | A | B
(1 row)
e=# select ve
It works in 7.3.2.
George
- Original Message -
From:
Elielson Fontanezi
To: pgsql-general ; pgsql-sql
Sent: Wednesday, July 30, 2003 10:52
AM
Subject: [SQL] ALTER TABLE ... DROP
CONSTRAINT
Hi
all!
Who can tell me what postgres version supports
74 matches
Mail list logo