I use Npgsql for client/server applications
you can view the manual at: http://npgsql.projects.postgresql.org/
docs/manual/UserManual.htm
On 23 Jul 2007, at 22:47, longlong wrote:
hi,all
i have a local system with windows xp.
i want to use c# to connect with a postgresql database running in
First of all, thanks for all the suggestions.
put a SERIAL primary key on the table
Or:
Maybe add OIDs to the table, and delete based on the OID number?
No, this is not acceptable, it adds overhead to the insertions. Normally
the overhead will be small enough, but on occasions it is
Hello All,
I am having PostgreSQL server 8.2.0 running on Redhat Linux .
I want to install PgAdmin GUI on the Linux Server.
can anybody please guide me to the appropriate documantation and the
prerequisite required for the same .
Thanks In Adavnce
With Reagrds
Ashish...
On 7/24/07, Ashish Karalkar [EMAIL PROTECTED] wrote:
Hello All,
Hi Ashish,
I am having PostgreSQL server 8.2.0 running on Redhat Linux .
I want to install PgAdmin GUI on the Linux Server.
Why would you want to introduce an extra load on
the server if the GUI will run just as fine on a client
Hello list,
I'm using pgsql 8.2.4 and I have this query which is sooo slow but I
can seem to figure out why.
It is using the appropriate indexes but there is something wrong with
the nested loops.
I'm running auto vacuum so the statistics should be up to date. I've
increase the
On Saturday 21 July 2007 Tom Lane's cat, walking on the keyboard, wrote:
Beyond that, the GEQO chapter provides several references, and IMHO
you should not be all that resistant to looking into the source code.
Even if you don't read C well, many of the files provide a wealth of
info in the
Hi ,
I am trying to connect to postgres on Win 2003 server std version but I
keep on getting an error . Are you sure the server is running and that
connections for the client's IP address have been enabled . The Win
2003 is a 64 bit edition.
I am sure of my settings. I have installed on a
Fst Procurement wrote:
Hi ,
I am trying to connect to postgres on Win 2003 server std version but I
keep on getting an error . Are you sure the server is running and that
connections for the client's IP address have been enabled . The Win
2003 is a 64 bit edition.
I am sure of my settings.
We configured the unix_socket_directory in postgresql.conf to point to a
folder in a xfs filesystem.
The problem is that pg_ctl tries to start the daemon but after 1 minute
it gives up with the following message: could not start postmaster.
The strange thing is that the postmaster is there, up
Don't forget to cc: the list
Fst Procurement wrote:
Netstat has the following two entries.
Local addressForeign address.
fstserver1:2359 fstserver1.fst.co.za:5432
fstserver1:5432
Hello, I guess I've stuck upon one problem with (I guess) implicit
casting varchar to text...
Basically it looks like planner makes better use of
WHERE ... IS NOT NULL indexes if either you explicitly
put text as a column type or that you cast the column
to ::text when making index.
Here's a
I have just listened to Josh Berkus on FLOSS regarding postgresql. It was
suggested that postgresql has advantages over other databases when it comes
to reporting. Why is this?
On Fri, 20 Jul 2007 18:24:03 -0400, [EMAIL PROTECTED] (Mitchell
Vincent) wrote:
in [EMAIL PROTECTED]
This project is of great interest to me as I am looking for a
easier-to-deploy database server and I've always loved PostgreSQL. the
PGInstaller project
On Tue, Jul 24, 2007 at 10:40:16AM +0200, Henrik Zagerholm wrote:
I'm using pgsql 8.2.4 and I have this query which is sooo slow but I
can seem to figure out why.
It is using the appropriate indexes but there is something wrong with
the nested loops.
I'm running auto vacuum so the
If index
CREATE UNIQUE INDEX toode_toode_unique_pattern_idx
ON firma1.toode
USING btree
(lower(toode::text) text_pattern_ops);
is dropped, this error does not occur.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Hi all,
I would like to change a sub-string in a text-field by using
UPDATE tablename SET
fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string)
WHERE (fieldname like '%old_sub_string%')
In priniciple, it works. However, only one occurence of old_sub_string
is replaced and further
This error occurs only when lowercase character ä is used.
Other accented characters does not cause the error.
Andrus.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Sun, 22 Jul 2007 09:12:00 +0100, [EMAIL PROTECTED] (Dave Page)
wrote:
in [EMAIL PROTECTED]
--- Original Message ---
From: Mitchell Vincent [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: 20/07/07, 23:24:03
Subject: [GENERAL] PGInstaller Project
This project is of
Dawid Kuroczko [EMAIL PROTECTED] writes:
ALTER TABLE foo ALTER COLUMN i TYPE text;
EXPLAIN SELECT * FROM foo WHERE i=17;
QUERY PLAN
-
Bitmap Heap Scan on foo (cost=12.14..554.42
SELECT * FROM firma1.toode WHERE toode LIKE 'ä%'
causes error:
ERROR: invalid memory alloc request size 2147483648
SQL state: XX000
How to fix ?
Andrus.
toode column type is char(20) and it is primary key.
toode table has index:
CREATE UNIQUE INDEX toode_toode_unique_pattern_idx
ON
On Jul 23, 6:11 am, [EMAIL PROTECTED] (Raymond O'Donnell) wrote:
On 23/07/2007 11:04, Andy Dale wrote:
The posgres command in the loop should look like so (not sure about the
password):
As I understand it, you supply the password via a pgpass file - you
can't include it on the command
Henrik Zagerholm [EMAIL PROTECTED] writes:
I'm using pgsql 8.2.4 and I have this query which is sooo slow but I
can seem to figure out why.
Seems the core of the problem is the misestimation here:
- Index Scan using
tbl_file_idx on tbl_file
am Mon, dem 23.07.2007, um 7:50:35 -0700 mailte [EMAIL PROTECTED] folgendes:
Hi all,
I would like to change a sub-string in a text-field by using
UPDATE tablename SET
fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string)
WHERE (fieldname like '%old_sub_string%')
In
On Mon, Jul 23, 2007 at 07:50:35AM -0700, [EMAIL PROTECTED] wrote:
I would like to change a sub-string in a text-field by using
UPDATE tablename SET
fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string)
WHERE (fieldname like '%old_sub_string%')
In priniciple, it works.
On Jul 23, 2007, at 9:50 AM, [EMAIL PROTECTED] wrote:
fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string)
Add a 'g' flag:
fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string, 'g')
From the end of a paragraph in 9.7.3 just before 9.7.3.1:
The flags parameter is an
Hi Richard,
Thanks for all your help. It is working. I think.- not sure - I removed
PgAdmin 1.7 from my computer and now everything is working. Got it
somewhere on the net. Can't remember where.
Moral of the story . Beware where you obtain software
regards,
Jimmy
On 7/24/07, Gregory Stark [EMAIL PROTECTED] wrote:
Dawid Kuroczko [EMAIL PROTECTED] writes:
ALTER TABLE foo ALTER COLUMN i TYPE text;
EXPLAIN SELECT * FROM foo WHERE i=17;
QUERY PLAN
Denis Gasparin [EMAIL PROTECTED] writes:
We configured the unix_socket_directory in postgresql.conf to point to a
folder in a xfs filesystem.
I don't think pg_ctl can deal with nondefault settings of
unix_socket_directory, because it does not make any attempt to parse the
postmaster's
Hi,
I saw the page on silent installation of postgres, but I want to be able to
uninstall postgres when my product is uninstalled, silently. I couldn't find
the product ID anywhere, which is the method I'm using for uninstalling the JRE.
Any help on how to uninstall silently would be great.
Dawid Kuroczko [EMAIL PROTECTED] writes:
Now, if we:
# EXPLAIN ANALYZE SELECT t FROM foo WHERE t='X17';
QUERY PLAN
---
Seq Scan on foo
How about using the following?
delete from table
where ctid in (select ctid from table limit num);
I actually checked this out before starting this thread, and the plan
looked like:
explain delete from my_table where ctid in (select ctid from my_table
limit 10);
Csaba Nagy wrote:
First of all, thanks for all the suggestions.
put a SERIAL primary key on the table
Or:
Maybe add OIDs to the table, and delete based on the OID number?
No, this is not acceptable, it adds overhead to the insertions. Normally
the overhead will be small enough, but on
On 7/24/07, Gregory Stark [EMAIL PROTECTED] wrote:
Dawid Kuroczko [EMAIL PROTECTED] writes:
Now, if we:
# EXPLAIN ANALYZE SELECT t FROM foo WHERE t='X17';
QUERY PLAN
Dawid Kuroczko [EMAIL PROTECTED] writes:
If I may suggest it -- try to run the queries yourself. You will find the
problem lies not in the statistics.
I was more concerned that there might be other discrepancies between the
commands in the email and the actual commands you're running.
Unfortunately the stuff that makes a ctid=value nice doesn't seem to be
used when you're doing an in. It's possible that a function that does
something like
for rec in select ctid from my_table limit 10 loop
delete from my_table where ctid=rec.ctid;
end loop
might do okay, but I haven't
Steve Wampler wrote:
I'd like to update from 8.1.9 to 8.2.4 to take advantage of
the multiple value INSERT but don't see at least two of the
RPMs for 8.2.4 that I need.
...
I need the Java and Python interfaces supplied with
(from 8.1.9):
postgresql-jdbc-8.1.4-1.centos.1
select current_database();
current_database
--
test2
Is there a way to use that result from current_database() into something
like:
alter database CURRENT_DATABASE() set search_path=myschema,public;
I have some generic scripts that I am preparing for several databases. Most
On 24/07/2007 15:19, Fst Procurement wrote:
Thanks for all your help. It is working. I think.- not sure - I removed
PgAdmin 1.7 from my computer and now everything is working. Got it
somewhere on the net. Can't remember where.
1.7 was a development version of pgAdmin, so you must have got a
Setting PGHOST solved the problem!
It was not clear to me that pg_ctl is actually a client and it doesn't
read the configuration from postgresql.conf
Thank you,
Denis
Tom Lane ha scritto:
Denis Gasparin [EMAIL PROTECTED] writes:
We configured the unix_socket_directory in postgresql.conf
Francisco Reyes wrote:
select current_database();
current_database
--
test2
Is there a way to use that result from current_database() into something
like: alter database CURRENT_DATABASE() set search_path=myschema,public;
I have some generic scripts that I am preparing for
Stephan Szabo [EMAIL PROTECTED] writes:
Unfortunately the stuff that makes a ctid=value nice doesn't seem to be
used when you're doing an in.
Yeah, see the header comments in tidpath.c:
* There is currently no special support for joins involving CTID; in
* particular nothing corresponding to
Gregory Stark [EMAIL PROTECTED] writes:
Running it myself I do see the same behaviour in 8.3. I'm not sure whether
this is something we expect to work or not though.
It looks like it might be relatively easy to fix, but I haven't dug down
to find exactly where things go wrong. Presumably
On Tue, 2007-07-24 at 18:19, Tom Lane wrote:
[ thinks for a bit ... ] Actually, you can do it as of 8.2 or so,
by abusing the ScalarArrayOp stuff: turn the subquery into an array.
An example in the regression database:
regression=# explain update tenk1 set ten=ten+1
regression-# where
Hello,
I can't seem to make a request inside a plpgsql function use an index,
basically I have something like this:
CREATE TABLE T1 (f VARCHAR(100));
/* db is created with utf8 locale hence 2 indicies */
CREATE INDEX ix_t1_f ON T1
USING btree ((lower(f)::text) text_pattern_ops);
CREATE INDEX
Csaba Nagy [EMAIL PROTECTED] writes:
Unfortunately the stuff that makes a ctid=value nice doesn't seem to be
used when you're doing an in. It's possible that a function that does
something like
for rec in select ctid from my_table limit 10 loop
delete from my_table where ctid=rec.ctid;
On Tue, 24 Jul 2007, Gregory Stark wrote:
Csaba Nagy [EMAIL PROTECTED] writes:
Unfortunately the stuff that makes a ctid=value nice doesn't seem to be
used when you're doing an in. It's possible that a function that does
something like
for rec in select ctid from my_table limit 10
Dawid Kuroczko [EMAIL PROTECTED] writes:
Basically it looks like planner makes better use of
WHERE ... IS NOT NULL indexes if either you explicitly
put text as a column type or that you cast the column
to ::text when making index.
I've applied a patch for this.
On Tue, 24 Jul 2007, Csaba Nagy wrote:
How about using the following?
delete from table
where ctid in (select ctid from table limit num);
I actually checked this out before starting this thread, and the plan
looked like:
explain delete from my_table where ctid in (select ctid
Try asking on the Slony list.
On Jul 21, 2007, at 12:02 AM, angga erwina wrote:
Hi, All
i want to replicate my DB with one master and two
Slave over VPN with bandwidth 64Kbps and my DB
125MB..what is the best interval timeout and time to
check interval..for this time, i use default..any one
On Jul 21, 2007, at 5:49 AM, Siah wrote:
Designing my application, I was wondering if having my primary keys
(to be indexed) with VARCHAR brings performance down significantly? My
own test didn't show much difference. Thinking about it though, I'd
guess Integer Indexing should be much quicker
On Jul 18, 2007, at 6:25 PM, [EMAIL PROTECTED] wrote:
Eecently, I have downloaded the postgresql-8.1.9.tar.gz from the
official website,and then I install in my linux System ,whose gcc
version is 2.9.6.Although I can install it successfully,then result
version I check is 7.2.1~£¬and how can this
Something this detailed would best be asked on -hackers.
On Jul 21, 2007, at 7:53 PM, Teju wrote:
Hi,
I am trying to understand the function of spool
structure in btree index creation. I understand that
there are 2 of
them, one for the itups to be sorted and the other
for
dead tuples.
Moving to -bugs.
On Jul 23, 2007, at 9:02 AM, Woody Woodring wrote:
I have a table in our DB that functions as a queue with a SERIAL
column for
its primary key. At 4am this weekend I started getting the error:
ERROR: integer out of range
Which was attributed to the sequence incrementing
On Jul 18, 2007, at 2:16 PM, Steve Crawford wrote:
Does PostgreSQL use an existing index, if possible, when creating a
partial index?
By way of background, we have some nightly bulk processing that
includes
a couple of 15-30 million row tables. Most of the processing is only
looking at
Joe L wrote:
Hi,
I saw the page on silent installation of postgres, but I want to be able
to uninstall postgres when my product is uninstalled, silently. I
couldn't find the product ID anywhere, which is the method I'm using for
uninstalling the JRE.
Any help on how to uninstall
Jim Nasby [EMAIL PROTECTED] writes:
Check the source code, but I'm 99% certain that CREATE INDEX doesn't consider
any existing indexes. While what you're describing is theoretically possible,
it's not a very common use-case, so it's rather unlikely to get worked on
unless other folks show
We're migrating from a 7.4 (Linux AS2.1) system to an 8.1.5 (Linux RHEL4
X64) system.
In 7.4, we used tsearch (txtidx fields) on some tables.
When we attempt to load the indexes for those fields in 8.1.5, we get a
strange SEGV.
\d historyticket
[cut]
short_summary_idx | txtidx
I don't know about partial indexing, but in a similar situation to what you
describe, I have resorted to special tables designed specifically to hold one
day's worth of data and to support our daily processing. I'd put the daily
data into specific tables, with all the requisite indeces, and
Robert Landrum [EMAIL PROTECTED] writes:
We're migrating from a 7.4 (Linux AS2.1) system to an 8.1.5 (Linux RHEL4
X64) system.
In 7.4, we used tsearch (txtidx fields) on some tables.
When we attempt to load the indexes for those fields in 8.1.5, we get a
strange SEGV.
Can you provide a
Tom Lane wrote:
8.1.5 isn't exactly the latest, but I don't see any relevant-looking
gist or tsearch2 fixes in the CVS history since then, so this may still
be a live bug.
As it turns out, tsearch is considered obsolete, and I should be using
tsearch2.
Talk about being behind the times...
On Jul 22, 2007, at 11:27 PM, novnov wrote:
The answer may or many not be very postgres specific but...what are
some
possible routes that I could take to allows users to upload data
from excel
into a postgres via a website? I've never tried anything like this
before.
Are there standard
I would recomend MS Access/ODBC.
It works very fine both with linked Excel spreadsheets and PostgreSQL
tables.
Therefore, you can easily automate data import from Excel to PostgreSQL via
Acess.
- Original Message -
From: Steve Atkins [EMAIL PROTECTED]
To: pgsql-general General
Andrus [EMAIL PROTECTED] writes:
SELECT * FROM firma1.toode WHERE toode LIKE 'ä%'
causes error:
ERROR: invalid memory alloc request size 2147483648
SQL state: XX000
This looks like a problem already reported, and patched here:
PostgreSQL 8.1.9
CentOS 4.5
I have setup postgresql to use ssl and have configured and restarted the
service without error. I am connecting a web app from a remote httpd host
and I would like to verify that the connection between these two machines
is indeed employing ssl for the application in
James B. Byrne wrote:
PostgreSQL 8.1.9
CentOS 4.5
I have setup postgresql to use ssl and have configured and restarted the
service without error. I am connecting a web app from a remote httpd host
and I would like to verify that the connection between these two machines
is indeed employing ssl
When using a function I need to parse each value as argument, e.g.
myFunction(arg1, arg2, ..., arg999)
However, if I can guarantee that the function will only be used with a
certain table, can I then omit the arguments and letting the function
refer to the table columns directly?
In that
How can I obtain this non-argument-requiring function feature?
I solved it myself: Define the function using composite types
(http://www.postgresql.org/docs/8.2/interactive/xfunc-sql.html)
---(end of broadcast)---
TIP 4: Have you searched our
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/24/07 14:48, Gregory Stark wrote:
[snip]
The main use case for it is actually REINDEX. Since you already have an index
which contains precisely the records you want to index and already in order
too.
The main disadvantage is that it's
On 7/21/07, Siah [EMAIL PROTECTED] wrote:
Hi,
Designing my application, I was wondering if having my primary keys
(to be indexed) with VARCHAR brings performance down significantly? My
own test didn't show much difference. Thinking about it though, I'd
guess Integer Indexing should be much
i was successful to install Npgsql and with it i can connect the local
machine .
but when i try a remote connection i got some problem:
first ,the connection was rejected by the remote host.
then, i edited the pg_hba.conf and postgresql.conf file.the error was
change:
FATAL:F:missing or
longlong wrote:
i was successful to install Npgsql and with it i can connect the local
machine .
but when i try a remote connection i got some problem:
first ,the connection was rejected by the remote host.
then, i edited the pg_hba.conf and postgresql.conf file.the error was
change:
71 matches
Mail list logo