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 er
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 m
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=&
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 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 the
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 this.
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
, but
functional indexes also make that less important
On Sat, Feb 20, 2016 at 1:10 AM, Stephen Davies 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 February 2016 at 14:19, Bruce M
FWIW, I just 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 m
On 31/10/15 13:32, Tom Lane wrote:
Stephen Davies 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 postgresql-setup --upgrade but
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
for your input
--
=
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia.Mobile:040 304 0583
Records & Collections Manage
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 by
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
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 wrote:
I have fixed this by manually granting access where necessary but wonder
whether the original issue is a bug or something that I have missed in the
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 mailto:sdav...@sdc.com.au>> wrote:
I am in the process of migrating several PostgreSQL databases from a
32-bit V9.1.4 environment to a
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
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
his before 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 se
.
Cheers and thanks,
Stephen
On 08/10/14 14:32, Tom Lane wrote:
Stephen Davies 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 with psql
connections
--
=
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
g are supported without reparsing the
original text (which might be gigabytes); just 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 20
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
k you again 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 th
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:
> >
should work - but it doesn't. The "simple" version does; despite
the above.
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! Actu
only work properly when no configuration is
specified - regardless of the default setting.
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:
&
#x27;,'thesaurus')
from document where clob @@ to_tsquery('english','thesaurus')
also returns the "correct" result.
I suggest that the above indicates a bug somewhere.
Cheers and thanks,
Stephen Davies
On Thursday 21 February 2008 20:50, Richard Huxton wrote:
&
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,
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 2
ebruary 2008 19:19, Richard Huxton wrote:
> Stephen Davies wrote:
> > I am a bit puzzled by the output of ts_headline (V8.3) for different
> > queries.
> >
> > It seems that the difference is in the number of occurrences of the
> > criterion words. If the number of hits is
cument".
I have seen cases with up to 20 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 ema
7.1.2?
(and where is it documented?)
Cheers and thanks,
Stephen Davies
Stephen Davies Consulting [EMAIL PROTECTED]
Adelaide, South Australia. Voice: 08-8177 1595
Comp
heavy handed.
Cheers and thanks,
Stephen Davies
Stephen Davies Consulting [EMAIL PROTECTED]
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network
actual SQL create table
etc syntax?
Cheers and thanks,
Stephen Davies
Stephen Davies Consulting [EMAIL PROTECTED]
Adelaide, South Australia. Voice: 08-8177 1595
Computing
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 datab
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 PROT
rt 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
might I find the patch?
Cheers and thanks,
Stephen.
========
Stephen Davies Consulting
[EMAIL PROTECTED]
Adelaide, South Australia. Voice:
61-8-82728863
Computing & Net
base to a PostgreSQL mirror
and the very first customer for this tool has several tables with 8 fields in
their primary key. Sod's Law:-((
Cheers and thanks,
Stephen.
========
Stephen Davies Consulting
Am I correct in believing that there is a limit of seven columns in a
multi-filed index?
If so, is it possible to increase this limit (to at least eight) ?
Cheers and thanks,
Stephen.
Stephen Davies Consulting
Byron Nikolaidis wrote:
>
> Stephen Davies wrote:
>
> > Hello again.
> >
> > Does the SQLPrimaryKeys facility work with 6.3.2 and ODBC 6.30.0249?
> >
> > If so, could someone please send me the declaration and a sample of usage.
> >
> > If n
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
44 matches
Mail list logo