hi,
Berend Tober wrote, On 2/7/2005 22:20:
I encountered what looks like unusually sorting behavior, and I'm wondering if
anyone can tell me if this is supposted to happen (and then if so, why) or if
this is a bug:
CREATE TABLE sample_table
(
account_id varchar(4),
account_name varchar(25)
)
WI
Thank you Mike, that should save me tons of time. I was dreading trying to
find all the dependencies, every time I want to make a change.
This way isn't perfect, but if it will do the job, that's what I need.
"Mike Rylander" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Wed, 2
Can anyone help me with this problem?
I have installed postgresql-7.2.1 and am trying to compile one of the
test programs from the directory src/test/examples.
I am running an old version of SCO Openserver 5
I am using the following command:
cc testlibpq.c -I/usr/local/pgsql/include -L/usr/local
Hi!
I was wondering if any external projects get bundled into the Postgres
release, e.g. JDBC, etc. I'd like to get a better sense of the process. How
are decisions made as to which external projects to bundle, and who is
responsible for the quality/interoperability of those projects with the
core
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
This can be easily done with pl/pgsql, visit the documentation at
http://www.postgresql.org/docs/7.3/interactive/programmer-pl.html
OT: seems like this is a questionnaire/survey application, yes?
- -
Jonel Rienton
http://blogs.road14.com
When I try to run something with PostrgreSQL (libpq) in Borland C++
Builder, it does not run and write errors like "[Linker Error]
Unresolved external '_PQconnectdb' referenced from C:\PROGRAM
FILES\BORLAND\CBUILDER6\PROJECTS\UNIT1.OBJ". Does anybody know how to
fix it?
Thanks
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Tue, Feb 08, 2005 at 12:58:34AM -0500, Tom Lane wrote:
>> I'm too tired to work out an example, but I think this probably doesn't
>> work in general: the xmax on the version of the row you can see might
>> not correspond to a live transaction, but that
On Tue, Feb 08, 2005 at 12:58:34AM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> >
> > I think you can infer that a process is working with a row in some
> > manner (UPDATE, SELECT FOR UPDATE) by looking at the row's xmax
> > column and checking pg_locks to see if any process
Title: RE: [GENERAL] Problem performing a restore of a data schema in Windows
Hi John
Thanks for the suggestion. It worked perfectly.
Thanks
Kind Regards,
Shaun Clements
-Original Message-
From: John DeSoi [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2005 04:21 PM
To: Shaun Cl
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Mon, Feb 07, 2005 at 03:08:12PM -0800, Tim Vadnais wrote:
>> If I select a row for update, is there anyway that someone can query to see
>> if that row has been 'selected for update' and by whom?
> I think you can infer that a process is working with
On Mon, 7 Feb 2005, Larry Rosenman wrote:
Oleg Bartunov wrote:
Read
http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm
Oleg
On Mon, 7 Feb 2005, Martijn van Oosterhout wrote:
Would you have a suggestion to index the following query:
SELECT domain,message,'1' as truth FROM bla
Robby Russell wrote:
Sincerely,
Joshua D. Drake
Command Prompt, Inc.
503-667-4564
It hasn't been updated since May 2004 though. :-/
Hmm... Well there must be another home for it then because
it is set to be the default database api for 5.1. Ahh now I see
it is already been pushed into the PHP
On Mon, 2005-02-07 at 14:02 -0800, Joshua D. Drake wrote:
> Hello,
>
> Has anyone seen the following:
>
> http://pecl.php.net/package/PDO
>
> The description from the site:
>
> PDO provides a uniform data access interface, sporting advanced features
> such as prepared statements and bound para
On Mon, 7 Feb 2005, Steve Atkins wrote:
A functional btree index on reverse(domain) might get you what you're
looking for.
[snip]
I wound up doing the following:
--
-- Name: reverse(text); Type: FUNCTION; Schema: public; Owner: ler
--
CREATE FUNCTION reverse(text) RETURNS text
AS $_$
DECLARE
or
On Mon, Feb 07, 2005 at 03:08:12PM -0800, Tim Vadnais wrote:
>
> If I select a row for update, is there anyway that someone can query to see
> if that row has been 'selected for update' and by whom?
I think you can infer that a process is working with a row in some
manner (UPDATE, SELECT FOR UPD
On Mon, Feb 07, 2005 at 03:16:51PM -0600, Larry Rosenman wrote:
> SELECT domain,message,'1' as truth FROM blacklist
> WHERE somedomain ~* '(?:.+\.|)' || domain || '\$')
>
> The somedomain is actually a constant passed in from Exim (it's the sender's
> righthand
> Side of an E-Mail address).
>
>
On Mon, 7 Feb 2005, Berend Tober wrote:
> I encountered what looks like unusually sorting behavior, and I'm wondering if
> anyone can tell me if this is supposted to happen (and then if so, why) or if
> this is a bug:
If you ran initdb with a locale such as en_US, a result like what you got
is ex
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- -
PostgreSQL RPM Set Update
2005-02-08
Version(s): 8.0.1, 7.4.7, 7.3.9, 7.2.7
- -
- ---
Title: a SELECT FOR UPDATE question
Hi,
If I select a row for update, is there anyway that someone can query to see if that row has been 'selected for update' and by whom?
Then I'd like to know if the session that 'SELECT(ed) FOR UPDATE' dies, will the server release the locked row?
Than
On Mon, 7 Feb 2005 19:34:52 -0300, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> Any reason you don't use a single table? Also, please post the EXPLAIN
> ANALYZE of your query.
My main reason was experimental evidence showed a massive drop in
performance with 6 indexes (the number needed from a que
On Mon, Feb 07, 2005 at 01:59:16PM -0500, Christopher Petrilli wrote:
> I have a "master table" called events, and 10 subtables which are
> created using this:
>
> CREATE TABLE events001 ( ) INHERITS (events) WITHOUT OIDS;
>
> I then build all the indexes on it, including a column called "src
On Mon, 07 Feb 2005 13:51:46 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> Well your first email didn't explain that you were doing the below :)
In the first email I was not doing the insert. I was executing a psql script:
$ psql -e -f groupdup.psql ks2
This was the groupdup.psql script:
Hello,
Has anyone seen the following:
http://pecl.php.net/package/PDO
The description from the site:
PDO provides a uniform data access interface, sporting advanced features
such as prepared statements and bound parameters. PDO drivers are
dynamically loadable and may be developed independently f
On Mon, Feb 07, 2005 at 16:20:36 -0500,
Berend Tober <[EMAIL PROTECTED]> wrote:
>
> SELECT * FROM sample_table ORDER BY 1;
>
> account_id,account_name
> 100,First account
> 110,Second account
> *115,Fifth account
> 120,Third account
> *125,Fourth account
>
> I would expect to see
>
> account_
Clodoaldo Pinto wrote:
On Mon, 07 Feb 2005 09:32:47 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
Any advice on how to avoid it?
Use a cursor.
Same thing using a cursor:
Well your first email didn't explain that you were doing the below :)
The cursor will help you with large data pulls from a
On Mon, 07 Feb 2005 09:32:47 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
>
> >
> > Any advice on how to avoid it?
>
> Use a cursor.
>
Same thing using a cursor:
declare
rdata record;
begin
truncate table usuarios2;
for rdata in
select distinct on (data) data
from usuarios
loop
ins
On Mon, Feb 07, 2005 at 03:16:51PM -0600, Larry Rosenman wrote:
> Oleg Bartunov wrote:
> > Read
> > http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm
> >
> > Oleg
> > On Mon, 7 Feb 2005, Martijn van Oosterhout wrote:
> Would you have a suggestion to index the following query:
I encountered what looks like unusually sorting behavior, and I'm wondering if
anyone can tell me if this is supposted to happen (and then if so, why) or if
this is a bug:
CREATE TABLE sample_table
(
account_id varchar(4),
account_name varchar(25)
)
WITHOUT OIDS;
INSERT INTO sample_table VALU
Oleg Bartunov wrote:
> Read
> http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm
>
> Oleg
> On Mon, 7 Feb 2005, Martijn van Oosterhout wrote:
Would you have a suggestion to index the following query:
SELECT domain,message,'1' as truth FROM blacklist
WHERE somedomain ~* '(?:
On Sat, 2005-02-05 at 15:03, Jan Wieck wrote:
> On 2/4/2005 5:56 AM, Mike Nolan wrote:
>
> >> If you have so much update load that one server cannot accomodate that
> >> load, then you should wonder why you'd expect that causing every one
> >> of these updates to be applied to (say) 3 servers woul
On Mon, Feb 07, 2005 at 11:07:16AM -0800, TJ O'Donnell wrote:
> I understand the value of indexes and of ANALYZE for the efficient use of
> them.
> In the following statement, you can see that the index scan is being used.
> Even though it takes 80 seconds (for a 1.25 million row table), it is
> m
I understand the value of indexes and of ANALYZE for the efficient use of them.
In the following statement, you can see that the index scan is being used.
Even though it takes 80 seconds (for a 1.25 million row table), it is
much faster than without the index.
But, if I repeat this search, it speed
Read http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm
Oleg
On Mon, 7 Feb 2005, Martijn van Oosterhout wrote:
On Mon, Feb 07, 2005 at 09:28:24AM -0800, CG wrote:
As I was exploring ways to optimize my application's use of the database, which
has to run the horrid "SELECT *
I have a "master table" called events, and 10 subtables which are
created using this:
CREATE TABLE events001 ( ) INHERITS (events) WITHOUT OIDS;
I then build all the indexes on it, including a column called "src_ip":
CREATE INDEX events001_src_ip_idx ON events001(src_ip);
Then I populat
Just a small note to thank David Fetter, Michael Fuhr, Bricklen Anderson,
Scott Marlowe, Karl O. Pinc, and Christopher Browne for their support and
for helping me to understand a little bit more about PostgreSQL (I won't say
Postgre anymore).
Ignacio.
-
Hello CG,
Monday, February 7, 2005, 10:28:24 PM, you wrote:
C> Return-Path: <[EMAIL PROTECTED]>
C> Delivered-To: [EMAIL PROTECTED]
C> Received: (qmail 15486 invoked from network); 7 Feb 2005 17:36:10 -
C> Received: from svr4.postgresql.org (66.98.251.159)
C> by ns.vpcit.ru with SMTP; 7 Feb
On Mon, Feb 07, 2005 at 09:28:24AM -0800, CG wrote:
> As I was exploring ways to optimize my application's use of the database,
> which
> has to run the horrid "SELECT * FROM table WHERE field LIKE '%value%';" in
> places, I thought this solution could be built upon to allow for an easier
> deploy
CG <[EMAIL PROTECTED]> writes:
> Tsearch2 is fantastic, but it works best for fields that contain
> words. I have to sift through alphanumeric identification numbers.
Can't you adjust tsearch2's notion of what is a word? Sure seems like
that would be easier than reinventing this wheel ...
Hi,
I see there's been some discussion about cascading
GRANTS to implicitly created sequences.
Regardless, a heads-up in the documentation could be
a nice thing to have, noting that permissions will
have to be created (or not) for the implicit seqeuences.
I _should_ know better, but just got bit by
Howard Cole wrote:
Hi,
I have succussfully managed to install tsearch2 and can use it happily
with selects, ts_vectors etc. My only problem is when using a trigger in
the form suggested in the intro documentation.
The trigger calls a function "tsearch2" which takes the tsvector column
name, and
Once upon a time there was an FTI contrib module that split up a varchar field
into little bits and placed them into an FTI table to facilitate a full text
index search. It was like being able to do a "SELECT * FROM table WHERE field
LIKE '%value%';" and have it search an index!
It was a great ide
Feb 7 16:30:25 s1 kernel: Free swap:0kB
Feb 7 16:30:25 s1 kernel: 258032 pages of RAM
Feb 7 16:30:25 s1 kernel: 28656 pages of HIGHMEM
Feb 7 16:30:25 s1 kernel: 3138 reserved pages
Feb 7 16:30:26 s1 kernel: 14914 pages shared
Feb 7 16:30:26 s1 kernel: 551 pages swap cached
Feb 7
Hy List,
I have a problem with this Query :
SELECT * FROM lifsch WHERE l_dokunr IS NOT NULL ORDER BY l_dokunr;
CIMSOFT=# ANALYSE lifsch;
ANALYZE
CIMSOFT=# EXPLAIN ANALYSE SELECT * FROM lifsch WHERE l_dokunr IS NULL;
QUERY PLAN
--
Hi,
I have succussfully managed to install tsearch2 and can use it happily
with selects, ts_vectors etc. My only problem is when using a trigger in
the form suggested in the intro documentation.
The trigger calls a function "tsearch2" which takes the tsvector column
name, and the names of colum
On Mon, Feb 07, 2005 at 03:10:58PM +0100, Konference wrote:
>
> is here somebody who works with PostgreSQL in PHP? I have a PL/SQL
> function, which can raise an exception. I am not able to catch _only_
> exception error message in PHP. I can parse "Warning: pg_query():
> Query failed: ERROR: Exce
I had an Out of Memory error while running this query in psql over a
170 million rows table:
select
data,
usuario,
sum(pontos),
sum(wus)
from usuarios
group by data, usuario
FC2 PG 7.4.6 1GB mem
Linux s1 2.6.9-1.11_FC2 #1 Sun Jan 2 15:49:30 EST 2005 i686 athlon
i38
[EMAIL PROTECTED] (Pailloncy Jean-Gerard) writes:
> I suppose (because I never used it) that there is a speed boost.
I would suppose (because synchronization has substantial costs) that
there is more than likely _no_ material improvement in performance.
"Clustering" can only provide material perf
On Feb 7, 2005, at 8:22 AM, Shaun Clements wrote:
psql -U username -d db1 > filename.dmp
Try
psql.exe -U username -d db1 -f filename.dmp
If it does not work, paste the output from the terminal so we can see
what error you have. Are you sure filename.dmp is a plain text dump? If
not, you need to u
Hello,
is here somebody who works with PostgreSQL in PHP? I have a PL/SQL
function, which can raise an exception. I am not able to catch _only_
exception error message in PHP. I can parse "Warning: pg_query():
Query failed: ERROR: Exception error string. in..." but I think, it is
not "clear" solut
You do realize that any multimaster replication system, that is
designed to avoind complex business process structure based conflict
resolution mechanisms, necessarily has to be based on 2 phase commit
or similar? So your global write transaction throughput will be
limited by the latency of you
Hi,
Can u please try with the following command:
pg_dump -s dbname >DumpFileName.dmp
or
pg_dump -s -u dbname >DumpFileName.dmp
For the second, you will be asked for username & password.
Regards,
Sandeep
Shaun Clements wrote:
Hi All
Im having a problem restoring a data schema on Postgres 8.01 fo
Title: RE: [GENERAL] Problem performing a restore of a data schema in Windows
Yeah, thats right.
Sorry, Typo.
Any suggestions.
Kind Regards,
Shaun Clements
-Original Message-
From: Shridhar Daithankar [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2005 03:33 PM
To: Shaun Clements
On Monday 07 Feb 2005 6:52 pm, Shaun Clements wrote:
> Im having a problem restoring a data schema on Postgres 8.01 for Windows.
> Im using the following command
> psql -U username -d db1 > filename.dmp
Shouldn't that be
psql -U username -d db1 < filename.dmp
Shridhar
-
Title: Problem performing a restore of a data schema in Windows
Hi All
Im having a problem restoring a data schema on Postgres 8.01 for Windows.
Im using the following command
psql -U username -d db1 > filename.dmp
This should have restored the schema from the file, filename.dmp to the dat
On Mon, 7 Feb 2005 12:34:39 +0100, Victor SpÃng Arthursson
<[EMAIL PROTECTED]> wrote:
>
> 2005-02-04 kl. 20.36 skrev Mike Rylander:
>
> > How about:
> >
> > SELECT r.* FROM opskrifter r JOIN opskrifter_content c ON (r.nummer =
> > c.opskrift) JOIN opskrifter_ingredienser i ON (c.ingrediens = i.id
2005-02-04 kl. 20.36 skrev Mike Rylander:
How about:
SELECT r.* FROM opskrifter r JOIN opskrifter_content c ON (r.nummer =
c.opskrift) JOIN opskrifter_ingredienser i ON (c.ingrediens = i.id)
WHERE EXISTS ( SELECT l.relid FROM languages l WHERE l.relid =
i.betegnelse GROUP BY l.relid HAVING COUNT(D
> On Feb 4, 2005, at 8:34 AM, Ben-Nes Yonatan wrote:
>
>>> On Fri, Feb 04, 2005 at 09:27:08AM +0200, Ben-Nes Yonatan wrote:
Hi all,
Does anyone know if PostgreSQL got a function which work like
load_file() of mySQL?
>>>
>>> I am not quite sure what load_file() does, but check th
On Fri, 4 Feb 2005, Jim Wilson wrote:
regards, tom lane
We\'d like to be able to take out a connection without risking
postmaster going
down and thus losing all uncommitted data.
Unfortunately the whole world isn\'t encapsulated in Postgres
transactions or we
would never have to worry about unco
Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.Richard Huxton wrote:
sid tow wrote:> HI> > I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns
59 matches
Mail list logo
