I need to build up a minimal e-commerce website on a host that is
already running postgresql.
Requirement is minimal. Usual configurable pretty standard
couple of paying/shipping system and popular enough to find
cheap/free skins and very basic cms feature to display no more than
4-5 pages.
This
is it the same case with 8.3.6 ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, 6 Feb 2009, milos.ba...@gmail.com wrote:
Can we use on-line backup
(http://www.postgresql.org/docs/8.1/static/backup-online.html) using
pg_start_backup and place backup segments onto a tape device directly,
without using the disk storage temporarily (because we have 1,5 TB
database)?
Im not sure if this is the right place to ask about dbi_link. If not please
forward it there.
Im trying to create a dbi_link between Oracle and postgresql. i nistalled
all the necessary perl packages
And I had run dbi_link.sql and it completed without any errors
This is sql that I use to connect
Check out the "log_statement" option in the postgresql.conf file
(there's an entire section (18.7) in the docs about logging).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Jason Long wrote:
> Is there any way to have Postgres preserve the case of tables and column
> names in queries without having to use quotes for columns with mixed case?
No.
PostgreSQL folds to lower-case (the SQL standard specifies upper-case
iirc) to provide case-insensitivity.
--
Richard H
Is there any way to have Postgres preserve the case of tables and column
names in queries without having to use quotes for columns with mixed case?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
On Fri, 2009-02-06 at 15:09 +, Adam Witney wrote:
> Has v8.2.12 been released? it is in the download file browser
> section,
It will be officially announced tomorrow.
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gu
On Fri, 6 Feb 2009, James Dooley wrote:
Richard, I was refereing to the plainto_tsquery
Oleg, I only need colasque if any of those columns can be null, which is not
the case here. Correct?
yes, but for safety and generality I'd use coalesce.
Regards,
Oleg
___
Richard, I was refereing to the plainto_tsquery
Oleg, I only need colasque if any of those columns can be null, which is not
the case here. Correct?
Has v8.2.12 been released? it is in the download file browser section,
but not on the home page of the website
thanks
adam
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
BTW, Oleg I don't need colasque since those values can't be null.
On Fri, Feb 6, 2009 at 4:11 PM, Oleg Bartunov wrote:
> James,
>
> syntax is documented on
>
> http://www.postgresql.org/docs/8.3/static/textsearch-tables.html#TEXTSEARCH-TABLES-SEARCH
> and in the Introduction
> http://www.pos
James Dooley wrote:
>
> Now everything is working, I added my config to
>
> plainto_tsquery('my_config', 'cars')
>
> and I get results back. I find that strange though since I set the default
> to be by config, but appearantly that was just temporary and for the PID
> that changed it. Running fr
On Fri, Feb 6, 2009 at 4:01 PM, Richard Huxton wrote:
> James - don't repeat the whole of the previous message in your replies,
> trim it to the relevant part. The message is already archived on the list.
>
> James Dooley wrote:
> > Oleg, but I am only interested in whether or not the syntax of m
James,
syntax is documented on
http://www.postgresql.org/docs/8.3/static/textsearch-tables.html#TEXTSEARCH-TABLES-SEARCH
and in the Introduction
http://www.postgresql.org/docs/8.3/static/textsearch-intro.html#TEXTSEARCH-MATCHING
text-search operator was specified for tsvector @@ tsquery.
You di
James - don't repeat the whole of the previous message in your replies,
trim it to the relevant part. The message is already archived on the list.
James Dooley wrote:
> Oleg, but I am only interested in whether or not the syntax of my
> search-query is correct.
>
> Having created the index as I m
Oleg, but I am only interested in whether or not the syntax of my
search-query is correct.
Having created the index as I mentioned above, would the correct way of
searching and using that index be
... AND (title || '' || description || '' || name) @@ plainto_tsquery('car')
or should it be as Ric
Jennifer Trey wrote:
I am new to postgreSQL and I am running queries from JAVA and would
like to see what queries are being run.
How can I achieve that ? I am running PostgreSQL 8.3 on Windows and
like using pgAdmin to do most things.
Open PG admin from the menu bar Tools->Server Status-
James Dooley wrote:
> Hi again,
>
> I have set my configuration as default and I have created a GIN index on
> three columns, like this
>
> create index textsearch_index on products using gin(strip( to_tsvector(
> 'my_config', title || '' || description || '' || name)))
>
> Searching these colum
I am new to postgreSQL and I am running queries from JAVA and would like to
see what queries are being run.
How can I achieve that ? I am running PostgreSQL 8.3 on Windows and like
using pgAdmin to do most things.
Jennifer Trey
milos.ba...@gmail.com wrote:
> Hi!
>
> I have few question regarding new PostgreSQL database installation.
>
> The potential installation will have to manage over 1.5 TB of data.
>
> Since our customers have an increasing demand for high availability, we
> decided to try with PostgreSQL's concep
James,
you provide us a little useful information. If you really want help
you need to provide all information about your setup, sample queries and
explain analyze, test data illustrated your problem.
I, personally, usually prefer to have copy-pasteable information.
I think we all are quite bus
Hi!
I have few question regarding new PostgreSQL database installation.
The potential installation will have to manage over 1.5 TB of data.
Since our customers have an increasing demand for high availability, we
decided to try with PostgreSQL's concept of warm standby database
(http://www.postg
Hi again,
I have set my configuration as default and I have created a GIN index on
three columns, like this
create index textsearch_index on products using gin(strip( to_tsvector(
'my_config', title || '' || description || '' || name)))
Searching these columns the way I have
... AND (title || '
Alvaro Herrera wrote:
A trivial, stupid implementation is perhaps not too difficult. The
problem is getting the smarts right, i.e. an optimized version. You
certainly don't want to be executing a query against a large table for
every INSERT on another one, for example; it's better if if you can
It's documented,
test=# select strip( to_tsvector('simple','to be or not to be'));
strip
--
'be' 'or' 'to' 'not'
(1 row)
On Fri, 6 Feb 2009, James Dooley wrote:
Hi,
How can I turn off the positioning since I won't be needing it.
SELECT to_tsvector('english','in t
Hi,
How can I turn off the positioning since I won't be needing it.
SELECT to_tsvector('english','in the list of stop words');
to_tsvector
'list':3 'stop':5 'word':6
I don't need to store the positions as shown in the example because I rank
according to date
James,
what dictionary you tried ?
Notice, adding option to the affix file won't help you any case if
dictionary doesn't use it.
Oleg
On Fri, 6 Feb 2009, James Dooley wrote:
In
http://www.postgresql.org/docs/8.3/interactive/textsearch-dictionaries.html
it mention this feature for support on
In
http://www.postgresql.org/docs/8.3/interactive/textsearch-dictionaries.html
it mention this feature for support on splitting compound words.
Adding the line
compoundwords controlles z
to the affix file returns an error
ERROR: wrong affix file format for flag
29 matches
Mail list logo
