On 12/13/10 11:25 PM, Sven Krosse wrote:
Dear all,
I am looking for a mechanism to load a specific file into an existing
database. The file is a CTM (Compact Topic Maps Syntax ) file and I
have written a CTM parser in plpgsql which works fine. The main
problem is, that I have to load the file
Dear all,
I am looking for a mechanism to load a specific file into an existing
database. The file is a CTM (Compact Topic Maps Syntax ) file and I have
written a CTM parser in plpgsql which works fine. The main problem is,
that I have to load the file into memory and sent a query to database
postgres 8.2.17
I am trying out the crosstab function (tablefunc contrib) for reporting
needs and I'm having a problem.
I have customers and products and the data is the quantity purchased. I
am grouping by customername, productname in the source sql. My category
sql depends if I want the prod
On Tue, 2010-12-14 at 12:38 +0600, AI Rumman wrote:
> Can anyone tell me please where I can get the postgresql 9 devel rpms?
http://yum.pgrpms.org
or, directly:
http://yum.pgrpms.org/9.0/
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repos
Can anyone tell me please where I can get the postgresql 9 devel rpms?
On Mon, 13 Dec 2010 23:06:32 -0600, tuanhoanganh
wrote:
I have program work with bytea, this field store image. Program work
well in
postgresql 8.3.9 but error in postgresql 9.0
I don't know if this is your problem, but bytea changed in Postgres 9.0.
Could you try enabling "set bytea_ou
I have program work with bytea, this field store image. Program work well in
postgresql 8.3.9 but error in postgresql 9.0
Here is code to write image to database
FileStream srcStream = new FileStream(file_name, FileMode.Open,
FileAccess.Read);
byte[] arrImage = new byte[srcStream.Length];
int read
I have program work with bytea, this field store image. Program work well in
postgresql 8.3.9 but error in postgresql 9.0
Here is code to write image to database
FileStream srcStream = new FileStream(file_name, FileMode.Open,
FileAccess.Read);
byte[] arrImage = new byte[srcStream.Length];
int read
On 12/13/10 6:32 PM, ray joseph wrote:
I used a System DSN and it worked.
Now to figure out what to do with it.
BTW, what are some of the considerations for choosing DSN types System,
File, User?
all three do the same thing in the end, they specify a ODBC database
connection.
the system DSN
> -Original Message-
> From: Susan Cassidy [mailto:scass...@stbernard.com]
> Sent: Monday, December 13, 2010 2:06 PM
> To: ray; pgsql-general@postgresql.org
> Subject: RE: [GENERAL] Defining a Connection String in Windows XP
>
> >Ray,
> >
> >Thank you for responding. OK, that was my first
>Ray,
>
>Thank you for responding. OK, that was my first trip into DSN setup
>and I got lost:
>The first step is to choose and existing MS driver for an Office app
>or 'Add' one from this 'User DSN' tab. The other tabs are:
>System dSN, File DSN, Drivers, Tracing, and Connection Pooling.
>I did n
On 13/12/2010 19:30, ray wrote:
Thank you for responding. OK, that was my first trip into DSN setup
and I got lost:
The first step is to choose and existing MS driver for an Office app
or 'Add' one from this 'User DSN' tab. The other tabs are:
System dSN, File DSN, Drivers, Tracing, and Connect
On Dec 13, 1:15 pm, r...@iol.ie ("Raymond O'Donnell") wrote:
> On 13/12/2010 18:46, ray wrote:
>
> > I do not know if I should leave the {PostgreSQL} as is or should it be
> > replaced with something.
> > For Server, the connection is on the same machine so I would think the
> > value should be loc
On 13/12/2010 18:46, ray wrote:
I do not know if I should leave the {PostgreSQL} as is or should it be
replaced with something.
For Server, the connection is on the same machine so I would think the
value should be ‘localhost’ (without quotes).
Yes, that's right.
For Database, I don’t know i
I would like to learn how to set a connection string.
I am running pgsql 9.0 on an XP. I found a list of connection string
examples:
» dotConnect for PostgreSQL (former Core Labs PostgreSQLDirect)
(PgSqlConnection)
» Npgsql (NpgsqlConnection)
» PostgreSQL OLE DB Provider
» .NET Framework Data Pro
Am Montag 13 Dezember 2010, um 14:47:03 schrieb Adarsh Sharma:
> > mv pg_xlog pg_xlog_old
> But me server fail to start and there is empty log in startup.log. I also
Hi,,
you have to move the contents from the old to the new pg_xlog directory as
well.
HTH, Jens
--
Sent via pgsql-general mail
I dont find way to create cluster... with example:
psql -l
teste1 |admin| LATIN1
teste2 | postgres | SQL_ASCII
teste3| admin2| UTF8
-bash-3.1$ psql --ver
On Mon, Dec 13, 2010 at 6:27 AM, Devart wrote:
> With new versions of dotConnect ADO.NET Data providers - dotConnect for
> Oracle 6.00, dotConnect for MySQL 6.00, dotConnect for PostgreSQL 5.00, and
> dotConnect for SQLite 3.00 –
It's too bad that you don't support modern versions of Oracle and
New versions of Devart ADO.NET Data Providers with improved capabilities of
ORM solution and advanced Model-First and Database-First support in ORM
model designer.
Devart has recently announced the release of the new versions of dotConnect
Data Providers, the database connectivity solutions built
On Dec 7, 2010, at 2:10 AM, Tom Lane wrote:
> Andy Colson writes:
>> Can someone post what the synonyms will do? And what will be synonym'able?
>
>> (cuz JD said: SYNONYMS work for things that aren't a table.
>> then tgl said: synonyms for non-table things was pretty much rejected.
>
> Well,
On Dec 13, 2010, at 12:03 PM, Jasen Betts wrote:
> On 2010-12-07, Andy Colson wrote:
>
>> I think it covers parts. In both you can create an alias to a table,
>> both of which you can fire off insert/update/delete. I assume in PG you
>> could have different permissions for the table and the
On Mon, Dec 13, 2010 at 10:00 AM, Tom Lane wrote:
> Flag i
> specifies case-insensitive matching, while flag g specifies
> replacement of each matching substring rather than only the first
> one. Other supported flags are described in Table 9-19.
Thanks. Quite well hidden in plain sight
On 2010-12-13 13.24, Henrique de Lima Trindade wrote:
Hi Peter,
Your example works perfectly. But, I need Your help with on another situation.
We're trying to create a plpgsql function with the expression. But, I'm getting
a syntax error:
-
create or replace function sp_remov
Vick Khera writes:
> speaking of regular expressions... the other day I was trying to find
> where the 'flags' option to regexp_replace() is described, but I
> cannot find it in the 9.0 manual in any obvious place. it is not
> described in the string functions section, nor in the regexp section.
Hi all,
Im try install postgres 9.0 on rhel
and I try install cluster with 2 options of databases LATIN1 and UTF-8.
It's possible?
Paulo
> I'm not aware of any database where I can influence the on-disk order directly
Hello,
You may want to export your main tables using COPY instead of pg_dump.
Doing this, you could disorder your tables, e.g. with hashtext:
COPY (select * from foo order by hashtext(some_col) )TO
Getting a co
Not at all. He wanted a way to influence the on-disk order of the rows
in a table, so he could make sure they were not left in the order of
insertion. That should be possible with CLUSTER. From the documentation:
"When a table is clustered, it is physically reordered based on the
index informat
On Mon, Dec 13, 2010 at 7:24 AM, Henrique de Lima Trindade
wrote:
> Your example works perfectly. But, I need Your help with on another situation.
> We're trying to create a plpgsql function with the expression. But, I'm
> getting a syntax error:
You're using $$ quoting for the function, and $$
Hi Peter,
Your example works perfectly. But, I need Your help with on another situation.
We're trying to create a plpgsql function with the expression. But, I'm getting
a syntax error:
-
create or replace function sp_remove_small_words( ptext text ) returns text
immutable as
$$
I have a table ( named test) with following strucuture
ID, lang, Name, Name_en, Name_de
http://postgresql.1045698.n5.nabble.com/file/n3303131/Capture.jpg
I want to do a full text seach on the table. I can create a ts_vector and
store in another column by gin_tsvector = tsvector('de', Titel_de
On Mon, Dec 13, 2010 at 8:47 AM, Adarsh Sharma wrote:
> But me server fail to start and there is empty log in startup.log. I also
> checked my permissions and directories are owned by postgres user.
So there are absolutely no warnings emitted to the screen or anywhere
else? Seems very very unlik
On Mon, Dec 13, 2010 at 4:26 AM, Hampus Wessman
wrote:
> CLUSTER should be able to do that for you. See
> http://www.postgresql.org/docs/9.0/static/sql-cluster.html.
>
That's the exact opposite of what he wished to accomplish.
The only thing I can suggest is to do random order of updates, perhap
On Fri, Dec 10, 2010 at 5:59 PM, Peter Eisentraut wrote:
> select regexp_replace('Tommy Lee Jones', $$\y\w{2,3}\y$$, ' ', 'g' );
>
speaking of regular expressions... the other day I was trying to find
where the 'flags' option to regexp_replace() is described, but I
cannot find it in the 9.0 manua
Dear all,
I am doing some Performance tuning in Pgsql. I have changed several
Parameters in postgresql.conf file. Now I want to change my pg_xlog
directory to another disk.
I followed the below steps :
cd /hrd2-p/postgres_data
/etc/init.d/postgresql-8.4 stop
mkdir -p /opt/pg_xlog
chown -R
2010/12/13 pasman pasmański
> 2010-12-13 11:19:35 CET FATAL: the database system is starting up
>
>
>
And the question is???
btw, this is quite normal behaviour when postgres is starting and someone
wants to connect.
regards
Szymon Guz
2010-12-13 11:19:35 CET FATAL: the database system is starting up
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 2010-12-06, Florian Weimer wrote:
> * Tom Lane:
>
>> Florian Weimer writes:
>>> The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty
>>> helpful for getting human-readable strings in psql. It seems this
>>> functionality was removed in PostgreSQL 9.0. Was this an accident or
On 2010-12-07, Andy Colson wrote:
> I think it covers parts. In both you can create an alias to a table,
> both of which you can fire off insert/update/delete. I assume in PG you
> could have different permissions for the table and the alias, which I
> assume you can do in oracle.
>
> If we
On Sun, Dec 12, 2010 at 09:49:52PM -0800, savio rodriges wrote:
> Hello,
>
> We are facing very HIGH memory utilization on postgreSQL server and need help.
which number from all of what's below is making you worried?
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog
On 2010-12-13 09:12, Jan Kesten wrote:
I'm not aware of any database where I can influence the on-disk order
directly, but there may be some hints I'm probably missing (even a
vacuum full will only compact the datafile as far as I know but not
reoder it accoring to an index or something).
CLUSTE
On Sun, Dec 12, 2010 at 9:57 PM, Adarsh Sharma wrote:
>
> Sorry Sir, but I simply followed your steps. I think those are sufficient.
> But my server didn't start after these changes. Here are my steps :
>
> cd /hrd2-p/postgres_data
> /etc/init.d/postgresql-8.4 stop
> mkdir -p /opt/pg_xlog
> chown
> Can you please explain why? ( just curious, this seems a very strange
> requirement )
I'm on some research for election systems - an interesting field. On one
hand there is a requirement of realiablility, so there is the need for
stable and proven software and backups of systems for example. On
42 matches
Mail list logo
