my google-fu lead me to the following receipts:
- create HTML documentation as single file, use Calibre to convert
- use downloadable HTML-documentation, convert via Calibre (minor
problems are reported, as in "wrong order of sections")
- download PDF and convert via Calibre
- download PDF and put
On 04/04/11 1:47 AM, Harald Armin Massa wrote:
my google-fu lead me to the following receipts:
- create HTML documentation as single file, use Calibre to convert
- use downloadable HTML-documentation, convert via Calibre (minor
problems are reported, as in "wrong order of sections")
- download P
On 4 April 2011 09:52, John R Pierce wrote:
> On 04/04/11 1:47 AM, Harald Armin Massa wrote:
>>
>> my google-fu lead me to the following receipts:
>>
>> - create HTML documentation as single file, use Calibre to convert
>> - use downloadable HTML-documentation, convert via Calibre (minor
>> proble
>
> So my question: has anyone found a best practice solution to convert
> the PostgreSQL documentaiton into a kindle-friendly format? Or has
> even an .azw file downloadable somewhere?
>
> Best wishes,
>
> Harald
You could always send the pdf file and get it converted to kindle format,
free of
Hello,
I am cleaning up a database and I have a list of unused tables, views and
column
and I want to drop these entities.
I have the following constraints:
* The database is live and thats mean I need to be able to revoke the
changes
as quick and possible.
* I need to rest
On 04/04/11 3:47 AM, salah jubeh wrote:
I am cleaning up a database and I have a list of unused tables, views
and column and I want to drop these entities.
suppose that table b depends on a, and let us say that other tables
depends on b.
doesn't this dependency cancel the 'unused' pa
Original-Nachricht
> Datum: Sun, 03 Apr 2011 16:25:35 +0200
> Von: Thomas Kellerer
> An: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Table lock while adding a column and clients are
> logged in
> Sven Haag wrote on 03.04.2011 16:13:
> >
> > Original-Nachricht
Most probably it is . I have just analysed the dependency for one level. and I
am planning to do the restore for also one level. i.e suppose that c-->b -->a
if I dropped a and turned out that a is used for some reasons, I will restore a
and b only without c.
I want to do that for the followi
On 04/04/2011 11:47 AM, salah jubeh wrote:
What will happen if
1. dropped table a
2. insert data on b and the other relations
3. restore table a and it's dependency (table b).
Simple advice would be to create a script on an offline system for
testing - when you are happy with the results - do
On Mon, Apr 4, 2011 at 5:40 AM, Howard Cole wrote:
> On 04/04/2011 11:47 AM, salah jubeh wrote:
>
> What will happen if
>
> 1. dropped table a
> 2. insert data on b and the other relations
> 3. restore table a and it's dependency (table b).
>
> Simple advice would be to create a script on an offli
I have recently transferred data from 8.4 to 9.0 and now only my
superuser has read access to the large objects.
(The transfer was done using pg_dump version 9.0).
The large objects have all transferred, the problem is just the
permissions, - but how do I set up the permissions for the large o
> A pseudo code demonstrate it:
>
> select * from pg_index_columns where index_name = 'x2'
>
> Ordinal ColNameIsAsc
> 1 a False
> 2 b True
>
> Have PGSQL same information?
>
>
AFAIK, you can pull that information from 'in
CHAR(11), the conference on Clustering, High Availability, Replication
will be held in Cambridge, UK on 11-12 July 2011.
http://www.char11.org/
Early bird bookings are available now by card or paypal only.
Call for Speakers is now open: please send your talk proposals to
spea...@char11.org by Apr
On 4/4/2011 6:12 AM, Howard Cole wrote:
I have recently transferred data from 8.4 to 9.0 and now only my
superuser has read access to the large objects.
(The transfer was done using pg_dump version 9.0).
The large objects have all transferred, the problem is just the
permissions, - but how do I
On Sun, Apr 3, 2011 at 11:43 PM, Annamalai Gurusami
wrote:
> On 2 April 2011 11:17, John R Pierce wrote:
>
>> what you describe is neither postgres nor SQL
>>
>> perhaps you should look at a storage engine like BerkeleyDB
>
> I hope that not everybody dismisses this mail thread because of the
> a
Annamalai Gurusami writes:
> On 2 April 2011 11:17, John R Pierce wrote:
>> what you describe is neither postgres nor SQL
>> perhaps you should look at a storage engine like BerkeleyDB
> I hope that not everybody dismisses this mail thread because of the
> above response. We are deriving our pr
Thank you all, I will take that in account
From: Scott Marlowe
To: Howard Cole
Cc: salah jubeh ; pgsql-general@postgresql.org
Sent: Mon, April 4, 2011 1:44:28 PM
Subject: Re: [GENERAL] Pg_restore and dump -- General question
On Mon, Apr 4, 2011 at 5:
On Monday, April 04, 2011 6:47:44 am Andy Colson wrote:
> On 4/4/2011 6:12 AM, Howard Cole wrote:
> > I have recently transferred data from 8.4 to 9.0 and now only my
> > superuser has read access to the large objects.
> >
> > (The transfer was done using pg_dump version 9.0).
> >
> > The large o
On Mon, Apr 4, 2011 at 9:31 AM, Tom Lane wrote:
> Annamalai Gurusami writes:
>> On 2 April 2011 11:17, John R Pierce wrote:
>>> what you describe is neither postgres nor SQL
>>> perhaps you should look at a storage engine like BerkeleyDB
>
>> I hope that not everybody dismisses this mail thread
Merlin Moncure writes:
> On Mon, Apr 4, 2011 at 9:31 AM, Tom Lane wrote:
>> So really you should be looking at some other DBMS if you want an
>> embedded implementation. It'd be nice if PG could be all things to all
>> people, but it can't; and this is one of the things it can't be.
> That's a p
I receive a long string (about 1 per second) than content many information and
for the moment it is directly inserted in the database (1 column).
I have to treat the hole string every time i need information in it.
Now, I want split the sting and save the informations in differents fields.
I have
On 04/04/11 8:47 AM, Marc-André Goderre wrote:
1- Program a trigger function detecting the orginal insert, split the
string and fill the other field.
2- Program a web service for receiving the string, split it and insert
the informations in the db.
Witch is the fastest one (in performance)
I receive a long string (about 1 per second) than content many information. For
the moment it is directly inserted in the database (1 column).
I have to treat the hole string every time i need information in it.
Now, I want split the sting and save the informations in differents fields.
I have 2
On 4/4/2011 9:19 AM, Howard Cole wrote:
On 04/04/2011 2:47 PM, Andy Colson wrote:
permissions, - but how do I set up the permissions for the large
objects?
I had the same problem. and there is no grant all... there is the new
DO though. That's what I used, a simple DO expression to iterate and
Andy Colson writes:
> On 4/4/2011 9:19 AM, Howard Cole wrote:
>> Thanks Andy. As a temporary measure I am going to use the server
>> configuration variable lo_compat_privileges when I work out how to use
>> it. For the longer term, could I borrow your script for the DO :)
> I dont seem to have it
..horribly documented, inefficient, user-hostile, impossible to maintain
interpreted language..
to whom might you be alluding to
???
Martin
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich.
On 04/04/11 12:07 PM, Martin Gainty wrote:
..horribly documented, inefficient, user-hostile, impossible to
maintain interpreted language..
to whom might you be alluding to
I only used a few of those adjectives, and prefixed them by
hypothetical. to be honest, I would expect most languages c
John R Pierce Monday 04 April 2011 21:20:51
> On 04/04/11 12:07 PM, Martin Gainty wrote:
> > ..horribly documented, inefficient, user-hostile, impossible to
> > maintain interpreted language..
> > to whom might you be alluding to
>
> I only used a few of those adjectives, and prefixed them by
> h
On 3. April 2011, Joshua D. Drake wrote:
> On Sat, 2 Apr 2011 19:26:56 +0200, "Henry C."
wrote:
> > On Sat, April 2, 2011 14:17, Jens Wilke wrote:
> >> Nevertheless since at least 8.4 IMO there's no need to bother
> >> with manual vacuum any more.
>
> Uhh, this is entirely untrue. There are plent
When using pipe separated xpath statements to fill multiple columns of
output, there is no guarantee of correlation among the columns of the
rows returned.
Using locally built 9.0.3 (--with-libxml)
I'm dealing with an element which has one fixed attribute (@page-layout)
and either (@collecti
On Monday 04 April 2011 21:07:38 Martin Gainty wrote:
> ..horribly documented, inefficient, user-hostile, impossible to maintain
> interpreted language.. to whom might you be alluding to
> ???
Probably something starting with P.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On 04/04/11 12:12 PM, Leif Biberg Kristensen wrote:
Probably something starting with P.
Pascal?
Prolog??
PL/I ? ! ?
:)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi guys,
I have a problem with the implicit "FOR SHARE" lock which postgres seems to get
on the referenced record when there is a foreign key.
I'm using postgres 8.3.3 from debian packages.
Here is a sample database structure and commands to reproduce.
-- Test database structure
CREATE TABLE p
What does the results in col 'List of schemas Access privileges'
indicate? Are those three results split by the '/' char? What
are the three sections? What is 'postgres+'
Can't find this explained in the docs.
template1-# \dn+ pg_catalog
List of schemas
Name
On Apr 5, 2011, at 2:31 AM, Ray Stell wrote:
> What does the results in col 'List of schemas Access privileges'
> indicate? Are those three results split by the '/' char? What
> are the three sections? What is 'postgres+'
>
> Can't find this explained in the docs.
>
> template1-# \dn+ pg_ca
Rob Sargent writes:
> When using pipe separated xpath statements to fill multiple columns of
> output, there is no guarantee of correlation among the columns of the
> rows returned.
Yeah, this is a known problem mentioned in our TODO list. Nobody has
any idea how to persuade libxml to do that
On 04/04/2011 03:12 PM, Tom Lane wrote:
Rob Sargent writes:
When using pipe separated xpath statements to fill multiple columns of
output, there is no guarantee of correlation among the columns of the
rows returned.
Yeah, this is a known problem mentioned in our TODO list. Nobody has
any
Hi,
I'm willing to contact a PostgreSQL developer working in Holland. I
know that this is not the main reason of this list.
Please contact-me by e-mail.
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
On Monday 04 April 2011 21:20:51 John R Pierce wrote:
> On 04/04/11 12:07 PM, Martin Gainty wrote:
> > ..horribly documented, inefficient, user-hostile, impossible to
> > maintain interpreted language..
> > to whom might you be alluding to
>
> I only used a few of those adjectives, and prefixed th
On 04/05/2011 04:18 AM, Edoardo Serra wrote:
Hi guys,
I have a problem with the implicit "FOR SHARE" lock which postgres seems to get
on the referenced record when there is a foreign key.
I'm using postgres 8.3.3 from debian packages.
[snip]
At this point, client1 gives the following error:
configuration variable lo_compat_privileges when I work out how to use
it. For the longer term, could I borrow your script for the DO :)
I dont seem to have it anymore... but here is a re-created, untested
version.
do $$
delcare r record;
begin
for r in select loid from pg_catalog.pg_large
Hey folks,
So, I'm working on a little application to help me with my
budget. Yeah, there are apps out there to do it, but I'm having
a good time learning some more too. :)
I get paid every other Friday. I thought, for scheduling
purposes in this app, that I would take a stab at writing
It is a very simplistic approach since you do not take into account
holidays. But if it meets your needs what you want is the modulo operator (
"%"; "mod(x,y)" is the equivalent function ) which performs division but
returns only the remainder.
N % 14 = [a number between 0 and (14 - 1)]
N = 7;
On 04/04/2011 07:12 PM, C. Bensend wrote:
Hey folks,
So, I'm working on a little application to help me with my
budget. Yeah, there are apps out there to do it, but I'm having
a good time learning some more too. :)
I get paid every other Friday. I thought, for scheduling
purposes in
generate_series(date '2001-01-05', date '2020-12-31', interval '2 weeks')
will return every payday from jan 5 2001 to the end of 2020 (assuming
the 5th was payday, change the start to jan 12 if that was instead).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
> It is a very simplistic approach since you do not take into account
> holidays. But if it meets your needs what you want is the modulo operator
> (
> "%"; "mod(x,y)" is the equivalent function ) which performs division but
> returns only the remainder.
>
> N % 14 = [a number between 0 and (14 -
> Not sure if your needs are like mine, but here is the function I use. It
> stores the date in a config table, and rolls it forward when needed. It
> also calculates it from some "know payroll date", which I'm guessing was
> near when I wrote it? (I'm not sure why I choose Nov 16 2008.) for m
> generate_series(date '2001-01-05', date '2020-12-31', interval '2 weeks')
>
>
> will return every payday from jan 5 2001 to the end of 2020 (assuming
> the 5th was payday, change the start to jan 12 if that was instead).
And THERE is the winner. I feel like an idiot for not even
considering ge
Running 9.0.2 on Centos.
I just discovered this in my production error log. Starting about 45
minutes ago, I got 70 of these, within 2 seconds:
28652 2011-04-04 21:47:29 EDT [33]WARNING: PD_ALL_VISIBLE flag was
incorrectly set in relation "pg_toast_49338181" page 16820
These warnings were im
Thank goodness I'm still in development! I'm trying to use pg_restore with
a dump created with pg_dump. But it keeps failing with segmentation or
general protection faults. My restore command is:
$ sudo -u postgres pg_restore -d mydatabase -j8 mydatabase.dmp
I've now tried five times, and gott
On 05/04/11 11:18, Chris Curvey wrote:
> This is on Ubuntu 10.10 server, 64-bit on Intel. I'm running Postgres
> 9.0.3, 64-bit from the ppa repository.
>
> What can I do to help the developers find the root cause of this? I'm
> happy to run a debug version, or find a corefile, or whatever I can
hi
was pointed to the fact that security definer functions have the same
default privileges as normal functions in the same language - i.e. if
the language is trusted - public has the right to execute them.
maybe i'm missing something important, but given the fact that security
definer functions
53 matches
Mail list logo