On 7 February 2012 06:43, Lockas w_war...@hotmail.com wrote:
OK .. my offending line number is 4533
How can i remove it while copying ?
You can remove it before copying or after, but not while.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
--
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
Hi Michael,
The mailing list address is pgsql-general@postgresql.org I believe.
Brett
On 7 February 2012 14:28, mgo...@isstrucksoftware.net wrote:
First, I'm sorry I hijacked this message but I'm having problems sending
any emails to this list and I'm also not getting anything returned.
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
On 7 February 2012 15:03, mgo...@isstrucksoftware.net wrote:
How do I convert this to PostGres. I'm getting a error
ERROR: syntax error at or near (
LINE 23: set chr = substr(lfeid,idx,1);
Assuming you are writing this as pl/pgsql code, the way you do your
variable assignments is wrong on
On Monday, February 06, 2012 10:31:51 pm Dave Potts wrote:
I am running Ubuntu 11.04, I have Postgres 8.4 and 9.1 installed.
My default when I say psql it connects to postgres 8.4
ie I set export PGCLUSTER=9.1/main
it connects to 9.1
Q. How can I connect to 9.1 by default without
On Monday, February 06, 2012 9:43:35 pm Lockas wrote:
OK .. my offending line number is 4533
How can i remove it while copying ?
As others have said if it is just the one line remove it manually and then do
the COPY.
If there are many lines and if you will dealing with this on a recurring
On Tue, Feb 7, 2012 at 8:03 AM, mgo...@isstrucksoftware.net wrote:
I have a SQL statement that I'm trying to convert from a SQL Anywhere
function, but I'm getting a error. Can't seem to figure out why. Is the
substring usage incorrect and if it is how do I accomplish this. I'm trying
Hi,
I need to log the statements executed for a list of tables. It will be Data
Modification statements like INSERT/UPDATE/DELETE on any of these tables.
Please let me know if this is possible in postgres logging.
Regards,
Madhu
On Τρι 07 Φεβ 2012 07:05:00 John R Pierce wrote:
On 02/03/12 5:53 PM, Rodrigo E. De León Plicet wrote:
Author's followup:
http://drcoddwasright.blogspot.com/2012/02/damn-you-damocles.html
his links hardly seem related to his proclamations.
From the guy's blog:
Shameless Plug
I know a
Hi all,
I'm developing Joomla's PostgreSQL database driver that (I hope) will
be included soon in this CMS [1] [2].
During my developing time I've found a big problem, not yet resolved,
about SOUNDEX function, adopted for recent added code.
I know that SOUNDEX is present inside contrib module, but
C# Insert image
http://net-informations.com/csprj/dataset/cs-insert-image.htm
C# retrieve image
http://net-informations.com/csprj/dataset/cs-retrieve-image.htm
bn.
--
View this message in context:
On Feb 7, 2012, at 5:42 AM, Madhu S R wrote:
I need to log the statements executed for a list of tables. It will be Data
Modification statements like INSERT/UPDATE/DELETE on any of these tables.
Please let me know if this is possible in postgres logging.
Yes, this possible. You can set
Madhu S R s_r_ma...@yahoo.co.in wrote:
Hi,
I need to log the statements executed for a list of tables. It will be Data
Modification statements like INSERT/UPDATE/DELETE on any of these tables.
Please let me know if this is possible in postgres logging.
On Mon, Feb 6, 2012 at 23:48, 84.le0n 84.l...@gmail.com wrote:
Now the problem is, how can I enable SOUNDEX inside database ? Is
there a way to use it without running contrib files ?
This is a bit ugly, but you could write the function yourself in the
PL/pgSQL procedural language, which is
On 07/02/12 17:08, Dave Potts wrote:
Hi Chris
Thanks for the suggestion, I tried a making the changes are you suggest,
I still getting an error from Postgres ie
define(PG_OPTIONS , --cluster=9.1/main);
define(PG_DB , tripe);
define(PG_HOST, localhost);
define(PG_USER, dp42);
On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts dave.po...@pinan.co.uk wrote:
I have two versions of postgres installed, 8.4 and 9.1 installed on the
same machine
To connect to my 9.1 database, I defined the envromental variable
PGCLUSTER=9.1/main
and use psql to connect via php pg_connect
I
Hello
http://www.postgresql.org/about/news/1351/
Regards
Pavel Stehule
2012/2/8 sunpeng blueva...@gmail.com:
Hi,Friends,
I would like to study parallel query, also hope to implement a parallel
db, are there any other open source parallel query engine like pgpool?
Thanks!
peng
--
Thanks guys its sorted.
Both your suggestions worked :-)
Scott Marlowe wrote:
On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts dave.po...@pinan.co.uk wrote:
I have two versions of postgres installed, 8.4 and 9.1 installed on the
same machine
To connect to my 9.1 database, I defined the
19 matches
Mail list logo