functions such as SQLColumns. It is just
SQLPrimaryKeys that is causing me grief at the moment.)
Cheers and thanks,
Stephen.
Stephen Davies Consulting
[EMAIL PROTECTED
of snafu.
(BASIS also has the advantage that it can automagically index almost
any form of BLOB to the word/phrase/sentence level if it is stored in
the database.)
Cheers,
Stephen Davies
"John Henderson" [EMAIL PROTECTED] wrote:
Hi,
It seems that the issue with large objects is "
t's backup repaired things so I am
wondering what could have happened in between to cause this strange
phenomenon.
Cheers and thanks,
Stephen Davies
========
Stephen Davies Consulting [EMAIL PROTECTED
Oops! Sorry.
7.0.2 and Linux.
The database is accessed from a VB5 app via ODBC.
Stephen
On Mon, 26 Mar 2001 21:38:09 -0600, Larry Rosenman said:
* Stephen Davies [EMAIL PROTECTED] [010326 21:36]:
Hello again.
I have just had to restore a database from backup because the majority
but the actual SQL create table
etc syntax?
Cheers and thanks,
Stephen Davies
Stephen Davies Consulting [EMAIL PROTECTED]
Adelaide, South Australia. Voice: 08-8177 1595
Computing
handed.
Cheers and thanks,
Stephen Davies
Stephen Davies Consulting [EMAIL PROTECTED]
Adelaide, South Australia. Voice: 08-8177 1595
Computing Network solutions
?
(and where is it documented?)
Cheers and thanks,
Stephen Davies
Stephen Davies Consulting [EMAIL PROTECTED]
Adelaide, South Australia. Voice: 08-8177 1595
Computing
hits succeed but cases with 35 hits miss.
The spread of hits does not seem to be relevant.
Is this a bug or am I missing some configuration option?
TIA,
Stephen Davies
--
This email is for the person(s) identified above
Attached is the document in question.
Searches for norwegian, thesaurus and statement give good results. A
search for database gives the plain text from the beginning.
Cheers and thanks,
Stephen Davies
On Thursday 21 February 2008 20:08, Richard Huxton wrote:
Stephen Davies wrote:
G'day
to use or
disseminate this email or its contents.
Stephen Davies ConsultingVoice: 08-8177 1595
Adelaide, South Australia. Fax: 08-8177 0133
Computing Network solutions. Mobile:0403 0405 83
Interesting. I hadn't seen that section before.
As I said in my original post: Is this a bug or am I missing some
configuration option.
I shall investigate the stuff in 12.8.
Any suggestions as to where to start?
Thanks,
Stephen Davies
On Thursday 21 February 2008 20:50, Richard Huxton wrote
that the above indicates a bug somewhere.
Cheers and thanks,
Stephen Davies
On Thursday 21 February 2008 20:50, Richard Huxton wrote:
Stephen Davies wrote:
Attached is the document in question.
Searches for norwegian, thesaurus and statement give good results.
A search for database gives
.
Cheers,
Stephen
On Thursday 21 February 2008 22:30, Richard Huxton wrote:
Stephen Davies wrote:
I just spotted the difference between your test and mine.
My query says:
select ts_headline(abstract,to_tsquery('english','database'),'minWords =
99, maxWords = 999') from document where
.
Weird!
Stephen
On Friday 22 February 2008 19:33, Richard Huxton wrote:
Stephen Davies wrote:
OK. The first level explanation is that my default config is simple.
Aha! Actually, that's the whole explanation.
This explains the different query results as english reduces database
to
ts_headline.
If ts_headline had the ability to use that pre-parsed ts_vector, my problem
would never have arisen - and the performance of ts_headline would be
improved.
Cheers and thanks,
Stephen
On Friday 22 February 2008 20:00, Richard Huxton wrote:
Stephen Davies wrote:
Not quite
for your help with this.
Cheers,
Stephen Davies
On Friday 22 February 2008 20:45, Richard Huxton wrote:
Stephen Davies wrote:
Unfortunately, my link to the box with the test database is down due to
lack of maintenance by our local telco (Telstra) but I think that I also
missed the optional config
. Is there a date
for this?
Cheers and thanks,
Stephen
Davies
On Friday 22 February 2008 22:54, Oleg Bartunov wrote:
On Fri, 22 Feb 2008, Stephen Davies wrote:
H!
I think I now understand the ts position better, thank you.
Part of my problem has been that I am used to the functionality
using the information in the
index.
Things like thesaurus expansion in queries are handled by adding AND/OR
constructs.
All operators support wild cards in query terms.
HTH,
Stephen
On Saturday 23 February 2008 21:48, Oleg Bartunov wrote:
On Sat, 23 Feb 2008, Stephen Davies wrote
--
=
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia.Mobile:040 304 0583
Records Collections Management.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
.
Cheers and thanks,
Stephen
On 08/10/14 14:32, Tom Lane wrote:
Stephen Davies sdav...@sdc.com.au writes:
I am in the process of migrating a bunch of databases and associated CGI
scripts from 9.1.4 to 9.3 (and from 32-bit to 64-bit).
The database migration has been successful but I have an issue
migrating to CentOS 7 so I
simply disabled this too and all came good.
Cheers and thanks,
Stephen
On 08/10/14 23:49, Adrian Klaver wrote:
On 10/07/2014 09:10 PM, Stephen Davies wrote:
The permissions on the socket are 777 owner/group postgres.
I installed the 9.3 onto the Centos 7 server using
Yes but that would have involved changing hundreds of CGI scripts. Dropping
the private tmp was easier.
On 11/10/14 07:01, Jim Nasby wrote:
FWIW, you could also use an IP connection to Postgres instead of the local
socket.
On 10/8/14, 6:34 PM, Stephen Davies wrote:
This is not the same issue
missed in the
migration.
Cheers and thanks,
Stephen
--
=
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia.Mobile:040 304 0583
Records
Nope. All went very smoothly apart from these grant issues.
On 14/10/14 01:57, Jeff Janes wrote:
On Sun, Oct 12, 2014 at 9:11 PM, Stephen Davies sdav...@sdc.com.au
mailto:sdav...@sdc.com.au wrote:
I am in the process of migrating several PostgreSQL databases from a
32-bit V9.1.4
No. Just pg_dump and pg_restore/postgis_restore.pl.
On 13/10/14 22:24, Vick Khera wrote:
On Mon, Oct 13, 2014 at 12:11 AM, Stephen Davies sdav...@sdc.com.au wrote:
I have fixed this by manually granting access where necessary but wonder
whether the original issue is a bug or something that I
of the
migrations next week. I shall watch carefully for any grant errors.
Cheers,
Stephen
On 14/10/14 10:05, Adrian Klaver wrote:
On 10/13/2014 04:27 PM, Stephen Davies wrote:
Nope. All went very smoothly apart from these grant issues.
I think what Jeff was after was any error messages related to the grant
Thanks for that. I shall use it when I do the repeat migration.
Cheers,
Stephen
On 14/10/14 10:21, Adrian Klaver wrote:
On 10/13/2014 04:28 PM, Stephen Davies wrote:
No. Just pg_dump and pg_restore/postgis_restore.pl.
Roles(users) are global to a cluster so they will not be picked up
for your input
--
=
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia.Mobile:040 304 0583
Records Collections Management
s
stocks
template1
ok
lc_collate cluster values do not match: old "en_US.UTF-8", new "en_AU.UTF-8"
Failure, exiting
How can I recover from here?
Cheers and thanks,
Stephen Davies
--
Sent via pgsql-general mailing list
On 31/10/15 13:32, Tom Lane wrote:
Stephen Davies <sdav...@sdc.com.au> writes:
I have just upgraded from Fedora 21 to 22.
This included an upgrade of PostgreSQL from 9.3 to 9.4 which causes postmaster
to fail because the existing databases are still at 9.3.
As suggested, I then ran post
use pdftotext in my CGI.
--
=========
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia.Mobile:040 304 0583
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
, but
functional indexes also make that less important
On Sat, Feb 20, 2016 at 1:10 AM, Stephen Davies <sdav...@sdc.com.au
<mailto:sdav...@sdc.com.au>> wrote:
On 20/02/16 00:24, Bruce Momjian wrote:
On Fri, Feb 19, 2016 at 02:49:16PM +0100, s d wrote:
On 19 F
On 08/10/16 17:16, Thomas Kellerer wrote:
Stephen Davies schrieb am 08.10.2016 um 02:57:
A follow-up question.
Once the bytea column is populated, how best to display the content in a
web page?
I have :
byte [] imgB;
ResultSet rs = st1.executeQuery("select pic from part where pno='
I am trying to use the import_bytea function described in various list posts
(PG version 9.3.14) in a jsp.
I get an error saying that only the super user can use server-side lo_import().
If I change the Java connection to use user postgres, the function works but I
would prefer not to do
On 07/10/16 18:48, Thomas Kellerer wrote:
Stephen Davies schrieb am 07.10.2016 um 09:12:
I am trying to use the import_bytea function described in various list posts
(PG version 9.3.14) in a jsp.
I get an error saying that only the super user can use server-side lo_import().
If I change
On 07/10/16 19:24, Thomas Kellerer wrote:
Stephen Davies schrieb am 07.10.2016 um 10:46:
You can store the contents of a file in a bytea using plain JDBC no lo_import()
required
String sql = "insert into images (id, image_data) values (?,?)";
Connection con = ;
Fil
On 07/10/16 19:24, Thomas Kellerer wrote:
Stephen Davies schrieb am 07.10.2016 um 10:46:
You can store the contents of a file in a bytea using plain JDBC no lo_import()
required
String sql = "insert into images (id, image_data) values (?,?)";
Connection con = ;
Fil
On 29/09/16 05:47, jotpe wrote:
Does anybody know a Software for generating graphical entity relation models
from existing postgresql databases?
Best regards Johannes
I like SchemaSpy.
--
=
Stephen Davies Consulting
On 23/12/16 16:20, Günce Kaya wrote:
Hi All,
I'm looking for an ER Data Modeller tool for postgresql. I use Navicat Premium
for postgresql and the tool has a modeller but I would like to display a
database modeller that belonging to a tables of an schema under a database.
If I use Navicat for
The following query give the error:
select
id,title,dtype,source,used_for,ts_headline('english',content,to_tsquery('english','
ma waterflux'),'minWords = 99, maxWords = 999') from info where clob @@
to_tsquery('english',' ma waterflux') order by title,dtype,source,used_for;
ERROR: syntax
40 matches
Mail list logo