Scott Ribe wrote:
You mean rsync the "data" folder, or the entire PG folder?
I meant the data folder.
To be clearer: Do you mean that the folder you backed up is the folder
with the file "PG_VERSION" in it, and all its contents?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql
Scott Marlowe wrote:
>
> On Fri, Jul 24, 2009 at 5:02 PM, Brian A.
> Seklecki wrote:
> > All:
> >
> > Any suggestions on how-to, or comments on a potential NFR, to disable
> > non-superuser's from viewing the database list via \l?
>
> So, is this a misguided attempt at security through obscurity,
> can we see an explain analyze at least?
>
Hi,
Well, it won't be necessary - I mean it looks just like the explain I
sent in my first post.
BUT I found the real cause of my problem - the "fk2" field from my
example had not only an index, but it was also a foreign key to
another table.
I believe t
Im using the same...
FOR record_or_row IN query LOOP
at the beginning of a function and at the end of a function. Is there
a way to save the query results in a RECORD[] type so that I don't
have to run the query twice?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
On 25 Jul 2009, at 11:36, MS wrote:
can we see an explain analyze at least?
Hi,
Well, it won't be necessary - I mean it looks just like the explain I
sent in my first post.
What first post? The only thing I can find is a reference in a message
by you from yesterday, to a two-year old post
On Sat, Jul 25, 2009 at 02:36:19AM -0700, MS wrote:
> I believe the update took so long because pgsql was checking if the
> changes don't break the referential integrity.
> So - problem solved, postgres good. ;) But isn't there a way to make
> some bulk operations without having to drop indexes/FKs
On Fri, Jul 24, 2009 at 11:42:07PM -0700, Nick Boutelier wrote:
> Im using the same...
>
> FOR record_or_row IN query LOOP
>
> at the beginning of a function and at the end of a function. Is there
> a way to save the query results in a RECORD[] type so that I don't
> have to run the query twice?
On Sat, Jul 25, 2009 at 2:42 AM, Nick Boutelier wrote:
> Im using the same...
>
> FOR record_or_row IN query LOOP
>
> at the beginning of a function and at the end of a function. Is there
> a way to save the query results in a RECORD[] type so that I don't
> have to run the query twice?
yes (in po
Bill Moran schrieb:
Scott Marlowe wrote:
On Fri, Jul 24, 2009 at 5:02 PM, Brian A.
Seklecki wrote:
All:
Any suggestions on how-to, or comments on a potential NFR, to disable
non-superuser's from viewing the database list via \l?
So, is this a misguided attempt at security through obscurity
Jan-Erik schrieb:
On 24 Juli, 23:22, a.w...@netzmeister-st-pauli.de (Andreas Wenk)
wrote:
Hi,
I was thinking about that and in my opinion the approach to let the
database do that is the wrong direction. Sure you can do a lot with
regexp_split_to_table or regexp_split_to_array but they are kind
On Sat, Jul 25, 2009 at 2:53 PM, Andreas
Wenk wrote:
>> I mean, didn't Apple just kill someone for letting their new iPhone
>> design leak?
>
> this is now going off topic - but what do you mean with your last sentence?
Please don't quote an entire message if you're only responding to part
of it.
On Sat, Jul 25, 2009 at 8:45 AM, Sam Mason wrote:
> On Sat, Jul 25, 2009 at 02:36:19AM -0700, MS wrote:
>> I believe the update took so long because pgsql was checking if the
>> changes don't break the referential integrity.
>> So - problem solved, postgres good. ;) But isn't there a way to make
>>
Hey,
I'm having some problems when inserting special characters into a
column. Here's the table:
--
Table "public.users_history_ip"
Column |Type | Modifiers
+---
Craig Ringer writes:
> To be clearer: Do you mean that the folder you backed up is the folder
> with the file "PG_VERSION" in it, and all its contents?
Careful --- there are multiple PG_VERSION files scattered around in a
Postgres data directory tree. Your comment is correct with respect
to the
Andrew Radamis writes:
> ERROR: invalid page header in block 43 of relation "pg_attribute"
At this point I think you should assume you've got serious hardware
problems. Get hold of some memory and disk test programs and see what
you can find out.
regards, tom lane
--
Greg Stark schrieb:
On Sat, Jul 25, 2009 at 2:53 PM, Andreas
Wenk wrote:
I mean, didn't Apple just kill someone for letting their new iPhone
design leak?
this is now going off topic - but what do you mean with your last sentence?
Please don't quote an entire message if you're only respondin
If I receive a form via POST or PUT with with mulitple variables, files,
application/json, others, is there anywhere in the environment to test he mime
type of each variable?
POST /en/html/dummy.php HTTP/1.1
Host: www.explainth.at
User-Agent: Mozilla/5.0 (Windows;en-GB; rv:1.8.0.11) Gecko/20070
Hi all;
I'm trying to restore from a tar of the filesystem on a debian box and I get
xlog errors.
I suspect I need to run pg_resetxlog but I cannot find it anywhere, where would
I find pg_resetxlog on a debian box that was installed via the deb packages ?
or how do I get it ?
Thanks in adv
On Sat, Jul 25, 2009 at 12:55 PM, Kevin
Kempter wrote:
> Hi all;
>
> I'm trying to restore from a tar of the filesystem on a debian box and I get
> xlog errors.
>
> I suspect I need to run pg_resetxlog but I cannot find it anywhere, where
> would
> I find pg_resetxlog on a debian box that was inst
On Sat, Jul 25, 2009 at 5:23 AM, Bill Moran wrote:
> Scott Marlowe wrote:
>>
>> On Fri, Jul 24, 2009 at 5:02 PM, Brian A.
>> Seklecki wrote:
>> > All:
>> >
>> > Any suggestions on how-to, or comments on a potential NFR, to disable
>> > non-superuser's from viewing the database list via \l?
>>
>> S
On Saturday 25 July 2009 13:02:52 Scott Marlowe wrote:
> On Sat, Jul 25, 2009 at 12:55 PM, Kevin
>
> Kempter wrote:
> > Hi all;
> >
> > I'm trying to restore from a tar of the filesystem on a debian box and I
> > get xlog errors.
> >
> > I suspect I need to run pg_resetxlog but I cannot find it any
On Sat, Jul 25, 2009 at 1:08 PM, Kevin
Kempter wrote:
> On Saturday 25 July 2009 13:02:52 Scott Marlowe wrote:
>> On Sat, Jul 25, 2009 at 12:55 PM, Kevin
>>
>> Kempter wrote:
>> > Hi all;
>> >
>> > I'm trying to restore from a tar of the filesystem on a debian box and I
>> > get xlog errors.
>> >
>
On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote:
> On Sat, Jul 25, 2009 at 1:08 PM, Kevin
>
> Kempter wrote:
> > On Saturday 25 July 2009 13:02:52 Scott Marlowe wrote:
> >> On Sat, Jul 25, 2009 at 12:55 PM, Kevin
> >>
> >> Kempter wrote:
> >> > Hi all;
> >> >
> >> > I'm trying to restore from
Hi,
I was trying to use information from the pg_stats view, when I remembered that 8.4 now has the cool
unnest function.
However I can't seem to get this to work with a column defined as anyarray.
So my query is:
select histogram_bounds
from pg_stats
where tablename = 'my_table'
and attname
On Sat, 2009-07-25 at 22:24 +0200, Thomas Kellerer wrote:
> I was trying to use information from the pg_stats view, when I remembered
> that 8.4 now has the cool
> unnest function.
>
> However I can't seem to get this to work with a column defined as anyarray.
It's generally hard to work with v
Jeff Davis wrote on 25.07.2009 22:44:
It's generally hard to work with values of type anyarray. You have to
cast them to text and then to a normal array type.
For example:
select unnest(histogram_bounds::text::oid[]) from pg_stats where
tablename='pg_amop' and attname='amopopr';
G
Kevin Kempter wrote:
> I suspect I need to run pg_resetxlog but I cannot find it anywhere, where
> would
> I find pg_resetxlog on a debian box that was installed via the deb packages
> ?
> or how do I get it ?
It's under /usr/lib/postgresql/8.3/bin
Best regards,
--
Daniel
PostgreSQL-p
On Sat, 2009-07-25 at 22:54 +0200, Thomas Kellerer wrote:
> Do I understand this correctly that by casting it first to text, I
> effectively create a new array
> the same way I create one, when I supply a literal like '{1,2,3}'::text[]
Similar, but not quite the same. '{1,2,3}'::text[] is actual
Kevin Kempter writes:
> On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote:
>> Did you rsync the pg_xlog and pg_clog (i.e. EVERYTHING under data/) or
>> just the base directory? You really need to do an rsync of
>> everything, not most everything.
> we rsync'ed EVERYTHING (the entire director
Jeff Davis writes:
> So, my strategy will only work if the array type you're trying to cast
> to has a cast from text.
As of (IIRC) 8.3, every type does have a cast from text.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
On Sat, Jul 25, 2009 at 11:12:15AM -0700, Dennis Gearon wrote:
> If I receive a form via POST or PUT with with mulitple variables,
> files, application/json, others, is there anywhere in the environment
> to test he mime type of each variable?
?? this doesn't seem particularly related to PG! Anyw
Scott Marlowe wrote:
>
> On Sat, Jul 25, 2009 at 5:23 AM, Bill Moran wrote:
> > Scott Marlowe wrote:
> >>
> >> On Fri, Jul 24, 2009 at 5:02 PM, Brian A.
> >> Seklecki wrote:
> >> > All:
> >> >
> >> > Any suggestions on how-to, or comments on a potential NFR, to disable
> >> > non-superuser's from
Alban Hertroys wrote:
> On 25 Jul 2009, at 11:36, MS wrote:
>
>>> can we see an explain analyze at least?
>>>
>>
>> Hi,
>> Well, it won't be necessary - I mean it looks just like the explain I
>> sent in my first post.
>
> What first post? The only thing I can find is a reference in a message
> by
On Sat, Jul 25, 2009 at 1:30 PM, Kevin
Kempter wrote:
> On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote:
>> On Sat, Jul 25, 2009 at 1:08 PM, Kevin
>>
>> Kempter wrote:
>> > On Saturday 25 July 2009 13:02:52 Scott Marlowe wrote:
>> >> On Sat, Jul 25, 2009 at 12:55 PM, Kevin
>> >>
>> >> Kempter
Sorry,
pgsql-general? php-general? who can tell the difference while your eyes are
still focusing from long hours on the comptuer?
Sorry guys.
PS, no wonder it didn't show up or get answered from the php guys ;-)
wrote>
Subject: Re: Content-Type in form variables
Message-ID: <20090726012447.
On Saturday 25 July 2009 20:05:14 Scott Marlowe wrote:
> On Sat, Jul 25, 2009 at 1:30 PM, Kevin
>
> Kempter wrote:
> > On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote:
> >> On Sat, Jul 25, 2009 at 1:08 PM, Kevin
> >>
> >> Kempter wrote:
> >> > On Saturday 25 July 2009 13:02:52 Scott Marlowe w
On Sat, Jul 25, 2009 at 9:48 PM, Kevin
Kempter wrote:
> On Saturday 25 July 2009 20:05:14 Scott Marlowe wrote:
>> On Sat, Jul 25, 2009 at 1:30 PM, Kevin
>>
>> Kempter wrote:
>> > On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote:
>> >> On Sat, Jul 25, 2009 at 1:08 PM, Kevin
>> >>
>> >> Kempter
37 matches
Mail list logo
