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
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
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
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
> 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
> 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
> 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 -
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
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
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;
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
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
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:
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
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 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
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 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
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
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
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
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
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 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
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 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
..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.
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
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
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 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 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
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
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
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
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:
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
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
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
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
> 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
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
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
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
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
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
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
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
>
> 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
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
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
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
53 matches
Mail list logo
