On 7 February 2012 06:43, Lockas 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.
--
Sent via pgsql-gen
<<< text/html; charset="utf-8": Unrecognized >>>
<>
Hi Michael,
The mailing list address is pgsql-general@postgresql.org I believe.
Brett
On 7 February 2012 14:28, 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. I
> tried to sign up agai
<<< text/html; charset="utf-8": Unrecognized >>>
<>
On 7 February 2012 15:03, 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 two accounts. Find some
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 wit
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 ba
On Tue, Feb 7, 2012 at 8:03 AM, 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
> to step through the item
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
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:
http://postgresql.1045698.n5.nabble.com/Save-and-load-jpg-in-a-PostgreSQL-database-tp3249969p5
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 l
Madhu S R 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.
http://andreas.scherbaum.la/blog/archives/100-Log-Tabl
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 e
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", "dp
On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts 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 have try sayi
Hello
http://www.postgresql.org/about/news/1351/
Regards
Pavel Stehule
2012/2/8 sunpeng :
> 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
--
Sent via pgsql-gen
Thanks guys its sorted.
Both your suggestions worked :-)
Scott Marlowe wrote:
> On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts 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
19 matches
Mail list logo
