On Thu, Jul 24, 2008 at 6:51 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Dave Page <[EMAIL PROTECTED]> writes:
>>> What are you using it for that you need it to be present at install
>>> time?
>
>> The linker hardcodes library paths into exes and libs. We examine
>> these paths at install time using
About LGPL - I don't know.
But the license is not a problem, this code is totally freeware (because too
simple).
LGPL is just my favorite license type for years. :-)
I'll change this if you prefer another license and explain, why (why BSD?
BSD is the PostgreSQL license?)
On Wed, Aug 13, 2008 at
Try to use
SELECT ARRAY(SELECT t_data FROM THETABLE WHERE t_ref_id = '1') AS v;
In PHP you may fetch all matched values as a single string and then - use
explode() to split it into values (possibly with later stripslashes).
It is much faster than fetching a thousands of rows.
On Thu, Aug 7, 200
Hi there,
we are running a fresh Postgres 8.3 installation with a single
database with about 80GB of data.
After a while the whole system memory is eaten up and every
operation becomes very slow. Shortly after a system reboot
and even without sending queries against the database the
whole system
Daneel wrote:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql initdb
I get
"se:
Hello all, long time no chit-chat on the PG mailing list. We're upgrading from
8.0.3 to 8.3 and found that some stored procedures utilizing int_agg that we
had left over from 7.3 had terrible performance. No problem, using ANY() we're
able to regain that performance, more or less, and at the s
Sir,
Please get me PostgreSQL psql tutorial.
With regards,
P.Yesu
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql initdb
I get
"se: [FAILED]".
H
Hello all,
I have a big database in which much information is stored in TEXT type
columns (I did this initially because I did not want to limit the
maximum size of the string to be stored)... but...
.. let's say I choose an upper limit (p.ex. 200) for the string sizes
and I start a fresh database
On Aug 12, 2008, at 3:53 AM, Willy-Bas Loos wrote:
reproduced it on:
"PostgreSQL 8.3.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
4.2.3 (Ubuntu 4.2.3-2ubuntu7)"
3 rows with index, 2 rows without.
can not reproduce it on:
- "PostgreSQL 8.1.10 on i486-pc-linux-gnu, compiled by GCC cc (GCC
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>> Gregory Stark <[EMAIL PROTECTED]> writes:
>>> I'm not sure if there's a fundamental reason why there has to be an
>>> index that
>>> exactly matches the foreign key or not -- offhand I can't think of one.
>>
>> The reason why is that t
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi All,
>
> on numerous times I had fell onto postgress complaining, that I try to
> create foreign key, pointing to a set not embraced within a unique key
> constraint.
>
> Here is the case:
>
> CREATE TABLE one (id int not null unique
On 12/08/2008 17:20, Porkodi Yesu wrote:
Please get me PostgreSQL psql tutorial.
http://www.postgresql.org/docs/8.3/static/app-psql.html
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
G
Hello
array_append is relative slow. You can use SRF function for someone (I
am not sure if it's your case, but maybe).
postgres=# create or replace function buida(m int) returns int[] as
$$declare r int[] = '{}'; begin for i in 1..m loop r := r || i; end
loop; return r; end $$ language plpgsql st
On Sat, 2008-08-09 at 04:59 -0400, Fouad Zaryouh wrote:
> Hi Aravind,
>
> Run the following query
>
> SELECT relname, reltuples, relpages * 8 / 1024 AS "MB" FROM pg_class
> ORDER BY relpages DESC;
>
>
>
> relname = table name
> relpages = size in MB
> reltuples = number of rows.
>
> Hope this
>
>
> Bonus question - if I rewrite the first FOR loop as:
>
>
>
> RETURN QUERY SELECT connection_id, connection_type_id, connector_node_id,
> connector_node_type_id, connectee_node_id,
>
> connectee_node_type_id, current, timestamp, $2
> + 1 FROM connections
>
>
Habari,
I am new to SQl and I am looking for as an sql tutorial, maybe with a
bias to Postgresql. I have been reading the Postgresql documentation
tutorial I am finding it okay but I would like something with excercises
at the end of a chapter, so that I can at least test myself ;). Does
anyboby k
On 2008-08-13 10:06, Bartels, Eric wrote:
> After a while the whole system memory is eaten up and every
> operation becomes very slow.
Show us:
- output of "free" command, when server gets slow.
- output of "ps v --sort=-size | head -10"
- output of "ps auxww | grep postgres"
- in terminal st
In response to "Bartels, Eric" <[EMAIL PROTECTED]>:
> Hi there,
>
> we are running a fresh Postgres 8.3 installation with a single
> database with about 80GB of data.
>
> After a while the whole system memory is eaten up and every
> operation becomes very slow. Shortly after a system reboot
> a
In response to Joao Ferreira <[EMAIL PROTECTED]>:
> Hello all,
>
> I have a big database in which much information is stored in TEXT type
> columns (I did this initially because I did not want to limit the
> maximum size of the string to be stored)... but...
>
> .. let's say I choose an upper li
With Postgres appears that TEXT is preferred over varchar(N)
http://archives.postgresql.org/pgsql-general/2006-03/msg01522.php
Any other DB (e.g. Oracle) would suggest varchar as column only stores the
length of the variable (variable character length..) vs any of the fixed length
datatype(s)
Hi,
In order to check the plan of PreparedStatement,
I'm going to analyze the output of debug_print_plan.
But, since its output is very complicated, it's difficult
to analyze it.
Please let me know the method and tool which analyze it
easily.
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPOR
On Wed, Aug 13, 2008 at 5:20 AM, Dmitry Koterov <[EMAIL PROTECTED]> wrote:
> About LGPL - I don't know.
> But the license is not a problem, this code is totally freeware (because too
> simple).
> LGPL is just my favorite license type for years. :-)
>
> I'll change this if you prefer another license
On Wed, Aug 13, 2008 at 10:06:37AM +0200, Bartels, Eric wrote:
> After a while the whole system memory is eaten up and every
> operation becomes very slow. Shortly after a system reboot
> and even without sending queries against the database the
> whole system memory is consumed after some time.
On Wed, Aug 13, 2008 at 5:30 AM, kinuthiA muchanE <[EMAIL PROTECTED]> wrote:
> Habari,
> but I would like something with excercises
> at the end of a chapter, so that I can at least test myself ;). Does
> anyboby know of a link with a good tutorial?
I like sqlzoo.net. It is an interactive websi
On Wed, Aug 13, 2008 at 4:06 AM, Bartels, Eric <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> we are running a fresh Postgres 8.3 installation with a single
> database with about 80GB of data.
>
> After a while the whole system memory is eaten up and every
> operation becomes very slow. Shortly after a
Daneel <[EMAIL PROTECTED]> writes:
> When I run
> service postgresql initdb
> I get
> "se: [FAILED]".
> However, /var/lib/pqsql/data is created and user postgres owns it.
Is there anything in /var/lib/pgsql/pgstartup.log ? How about the
main /var/log/messages file?
re
Dear all
I'd really appreciate a little advice here - I'm designing a PG
database to manage a scientific dataset.
I've these fairly clear requirements:
1. Multiple users of varying skill will input data.
2. Newly inserted data will be audited and marked good / bad
3. We must have a dataset that i
Daneel escribió:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql initdb
I get
"se
On Tue, Aug 12, 2008 at 9:25 AM, Daneel <[EMAIL PROTECTED]> wrote:
> While going through
> http://wiki.postgresql.org/wiki/Detailed_installation_guides
> and typing
> service postgresql start
> as root I got
> "/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
> initialize the clus
PLEASE DON'T WRITE TO THIS LIST WITH A FAKE EMAIL ADDRESS.
It's been discussed before, but it's rude and counterproductive. Just
set up a filter / account that drops everything coming in, but don't
stick the rest of us with your broken email behaviour
On Tue, Aug 12, 2008 at 9:25 AM, Daneel <[EM
Daneel escribió:
Daneel wrote:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql i
On Tue, Aug 12, 2008 at 10:20 AM, Porkodi Yesu <[EMAIL PROTECTED]> wrote:
> Sir,
> Please get me PostgreSQL psql tutorial.
honestly, the \? and \h are all you need to get started. After that
and the docs, if you're not getting something, ask here. It's pretty
simple, not like oracle or
Martin Gainty wrote:
> With Postgres appears that TEXT is preferred over varchar(N)
> http://archives.postgresql.org/pgsql-general/2006-03/msg01522.php
Implementation-wise, they are exactly the same, modulo length checking.
--
Alvaro Herrerahttp://www.CommandProm
At 12:04p -0400 on Tue, 12 Aug 2008, Joao Ferreira wrote:
> I'm a bit lost here. I'm currently executing VACUUM FULL _and_ REINDEX
> (tbls & idxs) every week.
>
> Should I keep the REINDEX and drop VACUUM FULL ?
>
> How do I iterate to a better approach ?
It might behoove you to read the Notes
On Wed, Aug 13, 2008 at 12:41:41PM -0400, Kevin Hunter wrote:
> Roughly, VACUUM simply reclaims/frees disk space, while VACUUM FULL
> additionally reorganizes disk usage. I'm still don't know *why* this
> leads to index bloat, however, just that it does. I must defer that
> explication to a Postg
I'm a little confused about how to use a column alias in the where
clause of a query. I'm sure the answer is something simple, but I
haven't found anything searching through Google or from reading the docs.
I inherited a table that used to store the name of a facility director
as the actual n
> Because VACUUM FULL needs to move stuff around in the table which means it
> need to mess around with the indexes (adding new entries). Ordinary
> VACUUM only needs to delete stuff so doesn't cause anywhere near as
> many problems.
so in the event that I really end up running VACUUM FULL o
Bartels, Eric wrote:
In addition to info others have requested, the output of the following
may be useful:
select name,setting,source from pg_settings where not source = 'default';
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
At 11:06a -0400 on Wed, 13 Aug 2008, Scott Marlowe wrote:
> [psql is] pretty simple, not like oracle or mysql's CLI interface.
Though I'd substitute 'pretty simple' with 'friendly', let me just say:
"Amen, amen, amen!"
Every time I use either of their CLIs, I sorely miss psql. Thank you
psql de
On Wed, Aug 13, 2008 at 10:47:17AM -0600, Jeff Ross wrote:
> I'm a little confused about how to use a column alias in the where
> clause of a query. I'm sure the answer is something simple, but I
> haven't found anything searching through Google or from reading the docs.
You can't. Conceptually
At 12:53p -0400 on Wed, 13 Aug 2008, Martijn van Oosterhout wrote:
> On Wed, Aug 13, 2008 at 12:41:41PM -0400, Kevin Hunter wrote:
>> Roughly, VACUUM simply reclaims/frees disk space, while VACUUM FULL
>> additionally reorganizes disk usage. I'm still don't know *why* this
>> leads to index bloat,
Martijn van Oosterhout wrote:
On Wed, Aug 13, 2008 at 10:47:17AM -0600, Jeff Ross wrote:
I'm a little confused about how to use a column alias in the where
clause of a query. I'm sure the answer is something simple, but I
haven't found anything searching through Google or from reading the docs
> > Right now you need operating system profiling tools to figure all this >
> > out. If you were using the latest development rev of PostgreSQL on >
> > Solaris/FreeBSD/MacOS, you might collect this information with dtrace, but
> > > none of that helps on the 8.1/Linux combo you're running. Ma
Hi,
I am converting a database to PostgreSQL. I use ODBC to create the
PostgreSQL database and copy the data.
The database says that it's bool implementation is char(1), just as
PostgreSQL does. I can copy te data OK, but I would like to change the
actual type of the column from char(1) to bool.
On Wed, Aug 13, 2008 at 01:16:03PM -0400, Kevin Hunter wrote:
> Hmm. I get the reorganization bit, but so what? Since VACUUM FULL
> already has an exclusive lock, what prevents it from updating the
> indexes in-place to point to the new physical disk location? Why does
> it need to create extra
At 2:44p -0400 on Wed, 13 Aug 2008, Martijn van Oosterhout wrote:
> Or how about not doing VACUUM FULL at all. It's not a command that
> should be run regularly in most situations.
Heh, fair enough. My questions were rather academic anyway. :-)
I appreciate it, Martijn!
Kevin
--
Sent via pgs
Done.
Now it's BSD licensed. :-)
On Wed, Aug 13, 2008 at 4:57 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 13, 2008 at 5:20 AM, Dmitry Koterov <[EMAIL PROTECTED]> wrote:
> > About LGPL - I don't know.
> > But the license is not a problem, this code is totally freeware (because
> to
Martijn van Oosterhout wrote:
...
AIUI, people know VACUUM FULL sucks and that in the cases where it
really helps CLUSTER is faster anyway and doesn't have the index
problems. The TODO list reference several discussions on the topic.
Or, failing that, what's the reason to not issue a REINDEX CO
Dear all,
I want to know if is possible I install SVN (subversion control version) on
postgresql. if is possible, is my idea the best?
I need to discover links (site) where I can find good pratice information
about svn. Because I found a big volume of information about svn and I can't
discover wh
PostgreSQL uses CVS.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rodrigo
Faccioli
Sent: Wednesday, August 13, 2008 1:31 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PostgreSQL and SVN - help me...
Dear all,
I want to know if is possible I install SVN (subversio
On 13/08/2008 21:30, Rodrigo Faccioli wrote:
I want to know if is possible I install SVN (subversion control version)
on postgresql. if is possible, is my idea the best?
I'm not sure what you mean
If you want to use PostgreSQL as a back-end for Subversion, I don't
think you can - SVN use
Tino Wildenhain escribió:
> Which makes me think if the solution would be to just run CLUSTER under
> the hood when VACUUM FULL is requested. Would that introduce any
> other problems?
The difference is that CLUSTER requires double the disk space in table +
indexes. VACUUM FULL has no such requi
I'm more a fan of centos, but have to give grudging respect to the
latest couple of versions of ubuntu server. Once you learn the new
way of doing things, it's quite easy to keep happy.
The version of Ubuntu Server I looked at one one of the first versions.
I am sure that Ubuntu has improved
I need to write an import function with enough isolation from apache
daemon.
Code has no input other than cvs files and a signal about when to
start the import.
The sql code that will be executed will be static.
I may end up writing a mini-daemon that just start a SQL script or
just pool from cron
On Aug 13, 2008, at 4:25 PM, Ivan Sergio Borgonovo wrote:
I need to write an import function with enough isolation from apache
daemon.
Code has no input other than cvs files and a signal about when to
start the import.
The sql code that will be executed will be static.
I may end up writing a mi
Kevin Hunter <[EMAIL PROTECTED]> writes:
> Hmm. I get the reorganization bit, but so what? Since VACUUM FULL
> already has an exclusive lock, what prevents it from updating the
> indexes in-place to point to the new physical disk location? Why does
> it need to create extra bloat?
Crash safety.
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> You can't. Conceptually, the result of the SELECT is not visible until
> *after* the WHERE clause has executed, so having the where clause
> depend on the select won't work.
It's not only conceptual. Consider
SELECT 1/x FROM mytab WHER
"Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> The database says that it's bool implementation is char(1), just as
> PostgreSQL does. I can copy te data OK, but I would like to change the
> actual type of the column from char(1) to bool. Is that possible without
> copying the column to a tempora
Tom Lane escribió:
> Crash safety. The basic process in vacuum full is:
>
> * detect that there is room in a lower-numbered page to move the
> physically last tuple to.
>
> * put a copy of the last tuple there. Mark the last tuple itself
> as deleted by the VACUUM.
Hmm, I've seen people doing
William Temperley wrote:
> Dear all
>
> I'd really appreciate a little advice here - I'm designing a PG
> database to manage a scientific dataset.
> I've these fairly clear requirements:
>
> 1. Multiple users of varying skill will input data.
> 2. Newly inserted data will be audited and marked go
Rodrigo Faccioli wrote:
> Dear all,
>
> I want to know if is possible I install SVN (subversion control version) on
> postgresql. if is possible, is my idea the best?
I'm assuming you're trying to say that you want to host the backend
storage for a svn repository in PostgreSQL.
If so ... why? Wh
I am having a problem with escaping characters after upgrading to 8.3. I
have changed the postgresql.conf file to contain:
standard_conforming_strings = on
I do not get the error:
nonstandard use of \\ in a string literal
anymore but now I am having a problem escaping certain characters like
Warren Bell <[EMAIL PROTECTED]> writes:
> I am having a problem with escaping characters after upgrading to 8.3. I
> have changed the postgresql.conf file to contain:
> standard_conforming_strings = on
> ...
> I am not escaping this character in my code. I am assuming that the
> driver is escapin
Hi Tom,
On Wed, 2008-08-13 at 21:27 -0400, Tom Lane wrote:
> "Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> > The database says that it's bool implementation is char(1), just as
> > PostgreSQL does. I can copy te data OK, but I would like to change the
> > actual type of the column from char(1)
Hi all,
thank you very much for your quick response and your support.
It seems we found the culprit. The shown memory consumption (top, free
-m)
was a false trace. As Bill said it is not a bad thing that the systems
uses
the available memory...
The culprit in this case slowing down Postgres was
Interesting. After some toying around I've figured out that this produces
"ERROR: structure of query does not match function result type":
RETURN QUERY SELECT connection_id, connection_type_id, connector_node_id,
connector_node_type_id, connectee_node_id,
connectee_node_typ
Interesting. After some toying around I've figured out that this produces
"ERROR: structure of query does not match function result type":
RETURN QUERY SELECT connection_id, connection_type_id, connector_node_id,
connector_node_type_id, connectee_node_id,
connectee_node_typ
Hi all..how can i mirroring table in postgresql?
Let say i have a transaction table updated everyday, i want to mirror that
table so that the other table only store the latest updated day records..
I hope you can understand my question..
Thanks in advance
--
View this message in context:
http:/
searchelite wrote:
> Hi all..how can i mirroring table in postgresql?
> Let say i have a transaction table updated everyday, i want to mirror that
> table so that the other table only store the latest updated day records..
> I hope you can understand my question..
It sounds like what you want is t
Hello,
I'm having the same issues as dvs had in message thread
http://archives.postgresql.org/pgsql-general/2008-05/msg01117.php as I want
to be able to use the result from an INSERT INTO table(...) VALUES(...)
RETURNING new_row_ID.
I would ideally like to be able to capture the RETURNING v
Just a thought
Why can't you create a temporary table from your dynamic query and use that
temp table in the for loop.
Thnx,
Gnanavel
- Original Message -
From: "Sathish Duraiswamy" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Cc: "Willy-Bas Loos" <[EMAIL PROTECTE
Hi Sathish,
I too mentioned the same thing. I have changed my code and checked ...but
not got that worked.
Here is the code which I finally got worked !!!
CREATE OR REPLACE FUNCTION fun_orderreport(pmorderid integer, pmcompanyid
integer, pmeventid integer)
RETURNS SETOF orderreport AS
$B
73 matches
Mail list logo
