On Dec 12, 2006, at 16:43 , Richard Huxton wrote:
Anton wrote:
While without DESC query goes faster... But not so fast!
=# explain analyze SELECT DISTINCT ON (login_id) login_id,
collect_time AS dt FROM n_traffic ORDER BY login_id collect_time;
QUERY PLAN
--
> >> 1. Convert PDF to file with e.g xpdf
> >> 2. Insert parsed text to a table of your choice.
> >> 3. Make vectors from the text.
> >
> > Actually, if you're not going to use the headline()
> function, you cna
> > just store it directly in a vector, cutting down on the size
> > requirements.
>
Anton wrote:
While without DESC query goes faster... But not so fast!
=# explain analyze SELECT DISTINCT ON (login_id) login_id,
collect_time AS dt FROM n_traffic ORDER BY login_id collect_time;
QUERY PLAN
--
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> In article <[EMAIL PROTECTED]>,
> wheel <[EMAIL PROTECTED]> wrote:
>
> % I copied all of the database 'parts' to the new 'base' directory. I am
> % not sure how carefully anyone has read what I wrote. But it's so simple
> % what I'm a
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> Uh, do you have the entier /data directory tree? If so, just restore
> the directory start it up a binary.
>
>
> >>>
> >>> Yes I have the entire dir/file set. But what does "If so, just restore
> >>> the directory
Hi. With this table (about 800 000 rows):
=# \d n_traffic
Table "public.n_traffic"
Column|Type | Modifiers
--+-+--
login_id | integer | not n
Hello All,
I am getting following error when tried to install PG
8.2 on Windows -XP from PG binary installation pack
"Internal account lookup failure: No mapping between
account names and security ID was done"
The account is created by installer itself.
can anyone explain where iam going wrong
on the link:
http://www.postgresql.org/docs/8.2/static/rules-update.html
you will notice that from items are repeated. Is this correct?
...
FROM shoelace_arrive shoelace_arrive, shoelace_ok shoelace_ok,
shoelace_ok *OLD*, shoelace_ok *NEW*,
shoelace shoelace, shoelace *OLD*,
Glen Parker <[EMAIL PROTECTED]> writes:
> I guess the best question I can see is, under what circumstances is the
> directory name in pg_tablespace actually used?
It isn't used (except by pg_dumpall) ... what counts is where the
symlink in $PGDATA/pg_tblspc points.
> I have a scenario where I wa
Greetings,
I was wondering if it's possible to get any of the metadata from the NEW
and OLD constructs in a trigger or view rule? Specifically, I'd like to
get the column name or identifier anywhere the new record differs from
the old record (i.e. NEW.column_X <> OLD.column_X). Any advice would
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Mon, 2006-12-11 at 10:18, Jonathan Ellis wrote:
>> I have a table of log messages. They are mostly in the 100-200
>> character length, which apparently isn't large enough for PG to want
>> to compress it (length == octet_length). I really need to sav
Gurus,
I hope I can make this clear somehow... Anyway... This all involves PG
8.1.4 on a 64-bit FC5 box.
Select version() says "PostgreSQL 8.1.4 on x86_64-redhat-linux-gnu,
compiled by GCC x86_64-redhat-linux-gcc (GCC) 4.1.0 20060304 (Red Hat
4.1.0-3)".
I guess the best question I can se
On Mon, 2006-12-11 at 17:50 -0600, Kirk Wythers wrote:
> SELECT count (*) returns 33,061,700
>
> met_data=# SELECT count(*) FROM climate, sites, solar WHERE
> climate.id = sites.id AND solar.id = sites.id AND climate.year = 1999;
> --
> 33061700
> (1 row)
>
> However attempting the join
On Dec 11, 2006, at 1:43 PM, Tom Lane wrote:
Kirk Wythers <[EMAIL PROTECTED]> writes:
I have an database (pg 8.1.0 on OS X) where a three table inner-join
gives the following errors:
psql(606) malloc: *** vm_allocate(size=8421376) failed (error code=3)
psql(606) malloc: *** error: can't all
Thank you.
Thats the technical view. I was hoping for a more generel overview - as if I
knew absolutely nothing about geometric types and their uses.
(Which is close to the truth.)
Geometric Types (and GIS) for dummies would be ideal.
Bob
- Original Message -
From: Shoaib Mir
On Mon, 2006-12-11 at 10:18, Jonathan Ellis wrote:
> I have a table of log messages. They are mostly in the 100-200
> character length, which apparently isn't large enough for PG to want
> to compress it (length == octet_length). I really need to save disk
> space. I can store it as a bytea and
You should be able to use something like this in a bash script:
psql -U postgres -hMYSERVER --quiet --no-align --field-separator ' ' -t -c
"SELECT servername,instanceport from server where serverclass = 3 and
isactive = 'True'" Admin |
while read -a SVRDATA ;do
echo "name: ${SVRDATA[0]} port:
>> 1. Convert PDF to file with e.g xpdf
>> 2. Insert parsed text to a table of your choice.
>> 3. Make vectors from the text.
>
> Actually, if you're not going to use the headline() function, you cna
> just store it directly in a vector, cutting down on the size
> requirements.
What size requiremen
On Mon, 2006-12-11 at 09:18 -0700, Jonathan Ellis wrote:
> I have a table of log messages. They are mostly in the 100-200
> character length, which apparently isn't large enough for PG to want
> to compress it (length == octet_length). I really need to save disk
> space. I can store it as a byte
The question of concatentation using NULLs comes up enough that I have
added an item to an existing FAQ entry for it, patch attached.
---
stroncococcus wrote:
> Hello!
>
> When I try to fill an array with the concatenation
I have a table of log messages. They are mostly in the 100-200
character length, which apparently isn't large enough for PG to want
to compress it (length == octet_length). I really need to save disk
space. I can store it as a bytea and compress it manually (zlib level
1 compression gives about
> 1. Convert PDF to file with e.g xpdf
> 2. Insert parsed text to a table of your choice.
> 3. Make vectors from the text.
Actually, if you're not going to use the headline() function, you cna
just store it directly in a vector, cutting down on the size
requirements. Just insert to the to_tsvector
1. Convert PDF to file with e.g xpdf
2. Insert parsed text to a table of your choice.
3. Make vectors from the text.
Cheers,
11 dec 2006 kl. 18:23 skrev Philip Johnson:
Do you know what kind of table should I use ?
Is there a shell script or a php script that does the work ?
regards
-M
sslmode=require did the trick. Thanks!
Dave Page wrote:
John McCawley wrote:
Where would I go to find the connection string settings to turn it
on? I have dug around quite a bit, and tried everything I have found,
but nothing seems to work, and the docs included with the driver
don't seem
PostgreSQL is simply very granular about what it lets you dump. The major
point to realize is that pg_dump is useful for getting your data schema and
data, and pg_dumpall will capture data schema, data, and most database instance
configurations. Pg_dumpall has access to *global* objects, such
John McCawley wrote:
Where would I go to find the connection string settings to turn it on? I
have dug around quite a bit, and tried everything I have found, but
nothing seems to work, and the docs included with the driver don't seem
to cover it.
The easy method is to setup a DSN as required,
Where would I go to find the connection string settings to turn it on? I
have dug around quite a bit, and tried everything I have found, but
nothing seems to work, and the docs included with the driver don't seem
to cover it.
Dave Page wrote:
John McCawley wrote:
I did a few searches on the
John McCawley wrote:
I did a few searches on the mailing list, and checked the documentation
of psqlODBC, and I'm confused as to the current status of SSL support in
psqlODBC. From the mailing list, it appears that the Open Source driver
does not fully support SSL, and I would need to use the
I did a few searches on the mailing list, and checked the documentation
of psqlODBC, and I'm confused as to the current status of SSL support in
psqlODBC. From the mailing list, it appears that the Open Source driver
does not fully support SSL, and I would need to use the commercial ODBC
drive
Thanks for your answers.
I guess it means that I have to issue Alter database after restore
than.
I find this a little scary because this is something that I just
realised now and wouldn't have thought beforehand. Seems to me that to
make an exact copy of a single db it isn't enough to use pg_back
Hello,
I would like to create a shell script that would populate two variables with
the return of a SELECT statement that would return two attributes...
For example...
#!/bin/bash
SERVER_NAMES=`psql Admin -Upostgres -hMYSERVER -t -c"SELECT servername,
instanceport from server where serverclas
Scott Marlowe wrote:
I didn't come away with that impression from the toad web site. Note
that I'm not a user, and not a huge fan or anything. But, according to
this page, toad supports lots of databases besides oracle:
http://www.quest.com/toad_data_modeler/release_information.aspx
tha
> When I read the docs about RULEs I remember seeing that an unqualified RULE
> was needed otherwise PG wouldn't know that the operation was complete and
> would fail. I haven't used them, but I believe that you have two options:
> - use a RULE with your filtering conditions AND add an unqualifie
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> I have a view joining two tables with a (1 to 1) relationship. I am trying
> to create two update rules (1 rule for each table in the view). To
> accomplish this I am trying (unsuccessfully) to use the where condition
> syntax of the update rules
"Yonatan Ben-Nes" <[EMAIL PROTECTED]> writes:
> Hi all, I need to decide which data type should I make for monetary values,
> shall I use Numeric data type to hold values like "9.52" or is it better to
> keep it as an integer with value in cents like "952"? I know that at the
> manual it's writte
Thanks for the link Scott.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/12/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, 2006-12-11 at 10:12, Tony Caduto wrote:
> Shoaib Mir wrote:
> > Thanks Scott, just confirmed it from TOAD's review at
> >
http://www.pcsoftla
On Mon, 2006-12-11 at 10:12, Tony Caduto wrote:
> Shoaib Mir wrote:
> > Thanks Scott, just confirmed it from TOAD's review at
> > http://www.pcsoftland.com/development-tools/databases/toad-for-sql-server.htm
> >
> >
> > "Plus the SQL editor will actually function with any ODBC database
> > connec
Kirk Wythers <[EMAIL PROTECTED]> writes:
> I have an database (pg 8.1.0 on OS X) where a three table inner-join
> gives the following errors:
> psql(606) malloc: *** vm_allocate(size=8421376) failed (error code=3)
> psql(606) malloc: *** error: can't allocate region
> psql(606) malloc: *** set a
You can use the PostgreSQL docs for that purpose at -->
http://www.postgresql.org/docs/8.2/static/functions-geometry.html
For more details you can go through PostGIS (http://postgis.refractions.net/)
for that purpose...
Hope this helps...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.co
Any chance we could block this idiot?
On 10 Dec 2006 at 12:22, Al_Dev wrote:
> All the countries/governments immediately pass legislation to make
> Linux compulsory(mandatory) subject in all schools from K to
> 12th-grade and all undergraduate /graduate degrees.
>
> Linux is foundation for othe
I have an database (pg 8.1.0 on OS X) where a three table inner-join
gives the following errors:
psql(606) malloc: *** vm_allocate(size=8421376) failed (error code=3)
psql(606) malloc: *** error: can't allocate region
psql(606) malloc: *** set a breakpoint in szone_error to debug
out of memory
On Mon, 2006-12-11 at 10:06, Tom Lane wrote:
> "SunWuKung" <[EMAIL PROTECTED]> writes:
> > It seems to me that if I dump and restore a database as a new db I need
> > to manually issue
> > ALTER DATABASE dbname SET search_path=schema1, schema2;
> > to get back the search_path of the original db.
>
I would like to learn the basics of PostgreSQL geometric types.
Can someone point to a simple explanation of how it works (preferably within
the PostgreSQL database) how it is being used and any drawing system that would
display the results?
Thanks in advance.
Bob Pawley
Do you know what kind of table should I use ?
Is there a shell script or a php script that does the work ?
regards
> -Message d'origine-
> De : [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] De la part de Hannes Dorbath
> Envoyé : lundi 11 décembre 2006 12:21
> À : pgsql-gen
postgres=# select (101::integer)/(2::integer);
?column?
--
50
postgres=# select (1.01::numeric)/(2::numeric);
?column?
0.5050
Rounding errors are something you will need to deal with whether you use
INTEGER or NUMERIC fields. You
Actually it was not me who was looking for a query builder, but yes in the
past I did some research with PostgreSQL so was just trying out if anyone
was able to use TOAD with it.
Lightning Admin looks good to me, good work.
Let me know in case you need help while adding on EnterpriseDB support t
Shoaib Mir wrote:
Thanks Scott, just confirmed it from TOAD's review at
http://www.pcsoftland.com/development-tools/databases/toad-for-sql-server.htm
"Plus the SQL editor will actually function with any ODBC database
connection, thus it supports many other popular databases like Oracle,
DB2
I have a view joining two tables with a (1 to 1) relationship. I am trying to
create two update
rules (1 rule for each table in the view). To accomplish this I am trying
(unsuccessfully) to use
the where condition syntax of the update rules.
Basically, I only want to update a table if the colu
"SunWuKung" <[EMAIL PROTECTED]> writes:
> It seems to me that if I dump and restore a database as a new db I need
> to manually issue
> ALTER DATABASE dbname SET search_path=schema1, schema2;
> to get back the search_path of the original db.
ALTER DATABASE and ALTER USER commands are handled by pg
Hi all,
I need to decide which data type should I make for monetary values, shall I
use Numeric data type to hold values like "9.52" or is it better to keep it
as an integer with value in cents like "952"?
I know that at the manual it's written about the Numeric data type that "It
is especially
It seems to me that if I dump and restore a database as a new db I need
to manually issue
ALTER DATABASE dbname SET search_path=schema1, schema2;
to get back the search_path of the original db. I
s this realy the case or I am doing something wrong and there is a way
to have the backup-restore do t
Thanks Scott, just confirmed it from TOAD's review at
http://www.pcsoftland.com/development-tools/databases/toad-for-sql-server.htm
"Plus the SQL editor will actually function with any ODBC database
connection, thus it supports many other popular databases like Oracle, DB2,
Informix, Ingres, Acce
On 12/11/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>>I've looked it up and can confirm what Tom said, TOAD works with
>>PostgreSQL, you just have to make sure you get the right version.
Does that one uses ODBC for connection? If possible can you please tell me
the version of TOAD to use w
>Did you try DROP OWNED BY? It revokes privileges (as well as
>dropping objects owned by said role).
Thank you. That was exactly the *easy* soluton I'd been missing. I swear
I read the page in the manual for "DROP OWNED" several times, hoping to
see something like "Any privileges granted to the
>>
>> That sounds very promising. I'll take a look there.
>
>I may be wrong about the table name but certainly drop role uses some
>set of system tables to do it's work. :)
THANKS for your help, Stephen. Once I've reassigned ownership
I can then easily find out privilege dependencies using
pg_
On Sat, 2006-12-09 at 13:19 +0500, Shoaib Mir wrote:
> I guess TOAD uses OCI to interact with the database so there might be
> problems connecting TOAD with PostgreSQL...
I've looked it up and can confirm what Tom said, TOAD works with
PostgreSQL, you just have to make sure you get the right versi
Do the following:
ldconfig
Once that is done show me the output for:
ldconfig -p | grep libreadline
and
locate libreadline.so.5
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/11/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
I did it however i get the same error message
Further testing has revealed that, indeed, PG 8.2 speeds up
our use of child tables !
The query in question went down from 10 minutes to *under a
second* just by running against 8.2 :-)
Now, that's some gain !
Thanks to the PostgreSQL developers.
Karsten,
GNUmed team
On Sun, Dec 10, 2006 at
> I am trying to install Postgre 8.2.0 on my mc FC4
>
> first i installed the libs
>
> next when i tried installing: postgresql-8.2.0-2PGDG.i686.rpm
> it gave me this error:
>
> error: Failed dependencies:
> libreadline.so.5 is needed by postgresql-8.2.0-2PGDG
>
> please tell me wha
On Mon, Dec 11, 2006 at 01:34:17PM +0100, H.J. Sanders wrote:
> > I would also suggest using a *coded* gender, not "male",
> > "female" strings which will make gender-based calculations a
> > lot easier down the road.
>
> Which will also make it easier to have a "multi-langual" solution.
Which, p
> Hallo,
>
> I have a large amount of time based events to aggregate, with a finite
> list of possible events.
> the events are logged one at the time:
>
> timestamp_1 : event_1
> timestamp_2 : event_2
> timestamp_3 : event_1
> ...
>
> My idea is to prepare the data before to import them in ord
>
> I would also suggest using a *coded* gender, not "male",
> "female" strings which will make gender-based calculations a
> lot easier down the road.
Which will also make it easier to have a "multi-langual" solution.
Henk Sanders
---(end of broadcast)--
On Fri, Dec 08, 2006 at 04:50:16PM +0100, Alban Hertroys wrote:
> Why not use unicode symbols 0x2640 and 0x2642?
A clever idea, however, it does not cover
transsexual, female phenotype
transsexual, male phenotype
hermaphrodite, intersexual phenotype
which we (GNUmed, that is) need to support in
Hi,
we have a parent table root_item with a few common fields
(one is a text field) from which a whole bunch of child
tables derives.
We need to run queries against the text field across the
whole bunch of child tables. What naturally comes to mind is
to run the query against root_item.text_field
I did it however i get the same error message
should i reboot?
thanks
surabhi
From: Shoaib Mir [mailto:[EMAIL PROTECTED]
Sent: Mon 12/11/2006 4:34 PM
To: surabhi.ahuja
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] installation problem, for Postgres
The case here is that he might be using a RPM which is for FC5 and been used
on FC4 which is why it keeps on looking for so.5 as libreadline.so.5 is the
updated libreadline.so.4 in FC5.
I have tried making symlinks (workaround) in the past and that worked for me
this way when I used a FC5 built R
You just need software that extracts the text from it. Search google for
pdf2txt and others. Printer drivers that try to get text from anything
are available as well.
On 11.12.2006 11:41, Philip Johnson wrote:
I'm using Postgresql 8.1.5
Tsearch2 is installed and runs well
I'd like to use ts
Shoaib Mir wrote:
Logged in as 'root' user do the following:
ln -s /usr/lib/libreadline.so.4 /usr/lib/libreadline.so.5
And then continue with the installation
I'm no RPM expert, but doesn't a failed RPM dependency require that you
install the correct RPM rather than adding probably-incom
I'm using Postgresql 8.1.5
Tsearch2 is installed and runs well
I'd like to use tsearch2 to index PDF files.
Do someone has a detailed process to implement that?
Logged in as 'root' user do the following:
ln -s /usr/lib/libreadline.so.4 /usr/lib/libreadline.so.5
And then continue with the installation
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/11/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
the o/p for ldconfig -p | grep
the o/p for ldconfig -p | grep libreadline
it is
ibreadline.so.4 (libc6) => /usr/lib/libreadline.so.4
thanks,
regards
Surabhi
From: Shoaib Mir [mailto:[EMAIL PROTECTED]
Sent: Mon 12/11/2006 4:26 PM
To: surabhi.ahuja
Cc: pgsql-general@postgresql.org
Subject: R
Can you show me the output for:
ldconfig -p | grep libreadline
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/11/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
I am trying to install Postgre 8.2.0 on my mc FC4
first i installed the libs
next when i tried installing: postgre
I am trying to install Postgre 8.2.0 on my mc FC4
first i installed the libs
next when i tried installing: postgresql-8.2.0-2PGDG.i686.rpm
it gave me this error:
error: Failed dependencies:
libreadline.so.5 is needed by postgresql-8.2.0-2PGDG
please tell me what to do
thanks,
regard
Hi
I had installed Postgres 8.1.5 , , 64 bit server running on FC4.
I had seen that the performance is much slower than the corresponding 32 bit one
Why is it so? (i have donr explain analyse, before performing the tests, also
the num of rows etc were similar)
Another thing that i want to me
Good morning,
I would like to remove diacritic from string like 'žluťoučký kůň'
(UTF-8) and transform it into 'zlutoucky kun'. I have used function
convert(); and SQL_ASCII as destination encoding.
Converted string still contains diacritic:
SELECT convert('žluťoučký kůň','UTF8','SQL_ASCII')
arr
75 matches
Mail list logo
