On 13 Aug 2012, at 1:15, Stefan Keller wrote:
> 2012/8/9 Alban Hertroys wrote:
>> You're referencing "p" as a table, not as a table-alias, because you
>> select FROM p.
>
> That's true but sorry that I can see any difference between
> referencing a table or a table alias.
I don't think SQL allo
Hello Friends,
I would like to migrate postgresql 8.0 to 8.3. Please suggest me the best
way of restoring my backup.
In which format should I take the backup and how should I restore the data.
Does it require to write any sql script. will it create any problems in
migrating 8.0 to 8.3.
Looking f
Hi everyone,
Is there any admin here of the brazillian postgresql site and mailing list?
Already have some days that is offline.
Any news?
tks in advance.
quickinfo wrote:
> I would like to migrate postgresql 8.0 to 8.3. Please suggest me the
best way of restoring my backup.
>
> In which format should I take the backup and how should I restore the
data. Does it require to write
> any sql script. will it create any problems in migrating 8.0 to 8.3.
F
On 08/13/2012 08:40 PM, quickinfo wrote:
Hello Friends,
I would like to migrate postgresql 8.0 to 8.3. Please suggest me the
best way of restoring my backup.
If at all possible, use the 8.3 version of pg_dump to make a new backup
from your 8.0 server, rather than trying to restore a dump fro
On Sat, Aug 11, 2012 at 7:05 AM, jan zimmek wrote:
> hi,
>
> i am looking into json support of the upcoming 9.2 release and have a
> question about the row_to_json function. is there a way to specify the column
> aliases of a nested composite row without creating a custom type ?
>
> here is an e
big thanks, this is exactly what i was looking for.
jan
Am 13.08.2012 um 17:58 schrieb Merlin Moncure :
> On Sat, Aug 11, 2012 at 7:05 AM, jan zimmek wrote:
>> hi,
>>
>> i am looking into json support of the upcoming 9.2 release and have a
>> question about the row_to_json function. is there
Hey Everyone,
With my investigations into our streaming slave having a continuously
growing pg_xlog directory (
http://archives.postgresql.org/pgsql-general/2012-08/msg00124.php) I think
I've hit upon what's going on.
Using pg_controldata I've found that our streaming slave hasn't run a
check
Apologies for the awkward title. I haven't quite thought of the right way
to describe my problem, which may be why I've had a hard time figuring out
how to solve it. I have a list of program start/stop times, and I want to
know how long each run takes to complete. The thing that's really trippin
On Mon, Aug 13, 2012 at 05:28:24PM -0700, Carey Tilden wrote:
> how to solve it. I have a list of program start/stop times, and I want to
> know how long each run takes to complete. The thing that's really tripping
> me up is there are gaps in the sequence. I've figured out how to collapse
> th
On Mon, Aug 13, 2012 at 5:53 PM, Andrew Sullivan wrote:
> On Mon, Aug 13, 2012 at 05:28:24PM -0700, Carey Tilden wrote:
>
> > how to solve it. I have a list of program start/stop times, and I want
> to
> > know how long each run takes to complete. The thing that's really
> tripping
> > me up is
On Aug 13, 2012, at 20:28, Carey Tilden wrote:
> Apologies for the awkward title. I haven't quite thought of the right way to
> describe my problem, which may be why I've had a hard time figuring out how
> to solve it. I have a list of program start/stop times, and I want to know
> how long
On Mon, Aug 13, 2012 at 6:01 PM, David Johnston wrote:
> On Aug 13, 2012, at 20:28, Carey Tilden wrote:
>
> > Apologies for the awkward title. I haven't quite thought of the right
> way to describe my problem, which may be why I've had a hard time figuring
> out how to solve it. I have a list
On Aug 13, 2012, at 21:22, Carey Tilden wrote:
>
>
> On Mon, Aug 13, 2012 at 6:01 PM, David Johnston wrote:
> On Aug 13, 2012, at 20:28, Carey Tilden wrote:
>
> > Apologies for the awkward title. I haven't quite thought of the right way
> > to describe my problem, which may be why I've had
On Mon, Aug 13, 2012 at 7:05 PM, David Johnston wrote:
> On Aug 13, 2012, at 21:22, Carey Tilden wrote:
>
> On Mon, Aug 13, 2012 at 6:01 PM, David Johnston wrote:
>
>> On Aug 13, 2012, at 20:28, Carey Tilden wrote:
>>
>> > Apologies for the awkward title. I haven't quite thought of the right
I have a CTE-based query in which I retrieve hourly intervals between two
given timespans. My query works as following:
Getting start and end datetimes (let's say 07-13-2011 00:21:09 and
07-31-2011 21:11:21) get the hourly total query values between the hourly
intervals (in here it's from 00 to 21
Dear Sir,
We are in process of evaluating the PostgreSQL static report. So wanted to know
if there is any available result for pc-lint on latest source code of
PostgreSQL (preferably on 9.2 Beta 3).
Thanks and Regards,
Kumar Rajeev Rastogi
Cell No - +91 8971367787
On Saturday, August 27, 2011 4:26:59 PM UTC-6, Darren Duncan wrote:
> Kenneth McDonald wrote:
> > Unfortunately, "initdb" has not been installed into a directory on the shell
> > search path, and I can't find it by inspecting other likely places. I do
> > like
> > OS X, but sometimes its unique ap
18 matches
Mail list logo
