select version()
PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo
Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)
I have a table with UNC filename values (windows), such as
\\server\dir\fname.txt
I am running a like query to find all files on a
This is how version below 8.2 used to handled backslashes, but with 8.2 you
can now handle the backslashes using a setting in the postgresql.conf file:
standard_conforming_strings (boolean)
This controls whether ordinary string literals ('...') treat backslashes
literally, as specified in the
thanks for responding. Meanwhile I found out that ist was my own fault. A newly
installed insert trigger fired unexpectedly and caused the error. Now I'm
redesigning my functions to make them smaller so that errors can be found
easier. Sometimes I wish there was something like a debugger for
You can give EnterpriseDB PL Debugger a try, details for its usage can be
found at -- http://www.enterprisedb.com/documentation/debugger.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/14/07, Marcel Gsteiger [EMAIL PROTECTED] wrote:
thanks for responding. Meanwhile I
Tom Lane a écrit :
=?UTF-8?B?U3TDqXBoYW5lIFNjaGlsZGtuZWNodA==?= [EMAIL PROTECTED] writes:
My goal is to migrate to 8.2.1. definitely. But as you said it, I do not
want to recreate unwanted index when migrating. I want to drop them BEFORE.
But, I can't just do a drop index command. It
PostgreSQL handles each connection in a dedicated process, so you won't get
better performance for a single connection by adding more CPUs (I mean,
beyond the benefit of having the postmaster and the specific connection
running in separate CPUs). This means that a query will not be resolved by
On Fri, Jan 12, 2007 at 10:58:36PM +0100, Martijn van Oosterhout wrote:
On Fri, Jan 12, 2007 at 10:16:22PM +0100, Jiří Němec wrote:
I would like to remove diacritical marks from a string in a SQL query.
I tried to convert a UTF8 string to ASCII but it doesn't work for me.
SELECT
On Wed, Jan 10, 2007 at 10:43:46PM +0100, Martijn van Oosterhout wrote:
On Tue, Jan 09, 2007 at 10:39:05PM -0800, kmohan wrote:
I am trying to export my spatial data from postgres to shae using pgsql2shp
command.
When i keyed in the syntax pgsql2shp -f pl dcmms plss
It is showing
Does the spec leave implementation of indexes on the substr() function
less than one undefined? By mistake, I had a substr() invocation with
an initial index of zero (would be nice if all the computer languages of
the world could agree to a single definition.) Oracle silently treats
this the
Marcel Gsteiger [EMAIL PROTECTED] writes:
Sometimes I wish there was something like a debugger for PL/PGSQL with
breakpoints, single step, variable watching...
Take a look at http://pgfoundry.org/projects/edb-debugger/
... it's beta but without users it won't get better.
The front page says
Marcel Gsteiger [EMAIL PROTECTED] writes:
Sometimes I wish there was something like a debugger for PL/PGSQL with
breakpoints, single step, variable watching...
Take a look at http://pgfoundry.org/projects/edb-debugger/
... it's beta but without users it won't get better.
The front page
Guy Rouillier [EMAIL PROTECTED] writes:
Does the spec leave implementation of indexes on the substr() function
less than one undefined?
SQL99 defines the result of
character substring function ::=
SUBSTRING left paren character value expression FROM start
position
Simon Riggs wrote:
On Fri, 2006-12-29 at 20:25 -0300, Alvaro Herrera wrote:
Christopher Browne wrote:
Seems to me that you could get ~80% of the way by having the simplest
2 queue implementation, where tables with size some threshold get
thrown at the little table queue, and tables above
Hi All,
We have an intermittent problem where PQexec does not seem to return
even though the server seems to have sent the results.
From the gdb output , the sql statement can be seen, and from the log,
the result can be seen to be sent. Both process are running on the same
machine.
I am having trouble with to_tsquery when the query is all stop words.
Rather than return everything as a match, it returns nothing with the
notice:
NOTICE: Query contains only stopword(s) or doesn't contain lexem(s), ignored
What is the best way to check for this, I was hoping to be able to
Hi all,
Is it possible to back up only part of my database for example from tables
which have data from April to July 2006, if so what will be the command for
that.
Thanks a lot in advance
Roopa
-
It's here! Your new message!
Get new email alerts
Roopa,
You can use the command pg_dump to backup specific tables. But you
won't be able to
restrict the backup to specific rows. (You can always create a separate
table just for backups,
and dump just that table).
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Hi Adam,
Thanks a lot for your immediate reply. can you please tell me how to use the
command pg_dump to backup specific tables. Thanks a lot in advance.
Regards
Roopa
Adam Rich [EMAIL PROTECTED] wrote:
Roopa,
You can use the command pg_dump to backup specific tables.
roopa perumalraja wrote:
Hi Adam,
Thanks a lot for your immediate reply. can you please tell me how to use
the command pg_dump to backup specific tables. Thanks a lot in advance.
pg_dump --help
Regards
Roopa
Adam Rich [EMAIL PROTECTED] wrote:
Roopa,
You can
Shane wrote:
No - a *core* is another cpu, basically you will have 2 or 4 cpu's in
the one physical package.
HT creates 2 virtual cpu's sharing the same cpu resources but the
cores are seperate cpu's in themselves.
The Quad-core will only benefit you more if you have more users
20 matches
Mail list logo