HI all,
apologize me for my stupid questions but I'd like to better understand how
mvcc works. Now, each tuple has xmin (insert xid) and xmax (delete/update
xid). In short each transaction with xmin<=xid<=xmax can see such tuple,
otherwise it cannot (of course beeing xmin and xmax different tran
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:
FA
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
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 qui
-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
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 li
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 way
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
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 q
"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:
http://archives.postgresql.org/pgsql-committers/2007-05/ms
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"
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 modu
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...
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
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 the
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
"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
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
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 prior-
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 pa
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.
Now
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
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 and
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
ha
On Tue, 24 Jul 2007, Csaba Nagy wrote:
> > How about using the following?
> >
> > delete from
> > where ctid in (select ctid from limit );
> >
>
> I actually checked this out before starting this thread, and the plan
> looked like:
>
> > explain delete from my_table where ctid in (select cti
"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, Gregory Stark wrote:
> "Csaba Nagy" <[EMAIL PROTECTED]> writes:
>
> >> Unfortunately the stuff that makes a ctid= 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
"Csaba Nagy" <[EMAIL PROTECTED]> writes:
>> Unfortunately the stuff that makes a ctid= 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.
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 INDE
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-# whe
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 th
Stephan Szabo <[EMAIL PROTECTED]> writes:
> Unfortunately the stuff that makes a ctid= 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 b
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 sev
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.
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
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
c
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
postgresql-pytho
> Unfortunately the stuff that makes a ctid= 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'
"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.
R
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
>
--
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,
> How about using the following?
>
> delete from
> where ctid in (select ctid from limit );
>
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);
"Dawid Kuroczko" <[EMAIL PROTECTED]> writes:
> Now, if we:
>
> # EXPLAIN ANALYZE SELECT t FROM foo WHERE t='X17';
>QUERY PLAN
> ---
> Seq Scan on foo (cost=0
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.
T
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 postgr
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
> ---
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 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 o
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. H
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%')
>
> I
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_
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 c
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 firma1
"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.
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
>>
>> T
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
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 not
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?
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
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 (http://pgfoundry.org/projects/pgin
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?
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 s
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 fstserver1.fst.co.za:2359
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 an
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
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
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
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 statistics
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 clien
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...
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 noticeabl
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
72 matches
Mail list logo
