From: Adrian Klaver
To: pgsql-general@postgresql.org
Cc: Postgre Novice
Sent: Thu, December 10, 2009 10:23:21 PM
Subject: Re: Fw: [GENERAL] ERROR: could not open relation with OID 59132
On Wednesday 09 December 2009 11:34:39 pm Postgre Novice wrote:
>
Can someone please share some light on this
- Forwarded Message
From: Postgre Novice
To: pgsql-general@postgresql.org
Sent: Wed, December 9, 2009 5:23:18 PM
Subject: [GENERAL] ERROR: could not open relation with OID 59132
Hello ,
after google search i havent found any
Hello ,
after google search i havent found any solution or clue for this specific case:
Background:
Postgresql: 8.3.0
select version();
version
PostgreSQL 8.3.
Hello Peeps,
I'd like to take this opportunity to wish you nice helpful bunch my
warm greetings. Hope you have a fantastic time and looking forward to
learn more in the new future.
Novice tgurl ;-)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
2008/12/11 Mark Morgan Lloyd <[EMAIL PROTECTED]>:
> I wonder if I could ask a question which might be marginally off-topic: how
> do people assemble multiple lines of text into a row in a table?
>
> I've got a number of cases where I've got a file containing some sort of
> activity log, where a seq
omg - how embarrassing.
so sorry :(
2008/11/20 brian <[EMAIL PROTECTED]>:
> novice wrote:
>>
>> 2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>:
>>>
>>> On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]>
>>> wrote:
>
2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>:
> On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
>> sorry I get nothing :(
>
> Of course not. None of the dates you gave in the example overlap.
>
But it should still have the 1st entry wi
2008/11/20 brian <[EMAIL PROTECTED]>:
> novice wrote:
>>
>> 2008/11/20 Adam Rich <[EMAIL PROTECTED]>:
>>>
>>> select call.call_id,
>>> call.datetime,
>>> mobile_custodian.user_id,
>>> call.mobile_no
&
2008/11/20 Adam Rich <[EMAIL PROTECTED]>:
>> Now user Ben has passed his mobile to user Josh and we issued Josh his
>> mobile on 2008-10-15.
>>
>> 1. Is it possible for me to write a query that will have the fields
>>
>> call.call_id,
>> call.datetime,
>> mobile_custodian.user_id,
>> call.mobile_no
Hi,
We have two tables.
select * from
mobile_custodian;
custodian_id | user_id | issue_date | return_date | mobile_no
--+-++-+-
4 | Ben | 2008-10-11 | 2008-10-13 | 09455225998
5 |Josh | 2008-10-15 |
Firstly, thank you very much to all advice that has been passed
through. These groups have thought me many new tricks and I wish all
of you the best.
Now, I'm trying to create a schema for mobile phone custodian and
billing system. Any advice would be greatly appreciated, I've
included a schema
2008/8/15 novice <[EMAIL PROTECTED]>:
> Hi,
> I have a table
>
> select id, config_id, start_day, end_day, start_time, end_time from config;
>
> id | config_id | start_day | end_day | start_time | end_time
> -+---+---+-++---
Hi,
I have a table
select id, config_id, start_day, end_day, start_time, end_time from config;
id | config_id | start_day | end_day | start_time | end_time
-+---+---+-++--
1 | 101 | Mon | Sun | 08:30:00 | 18:00:00
2 |
Thanks Tom! I already solved the problem by putting "127.0.0.1
localhost" in /etc/hosts file..
On Nov 2, 12:04 am, [EMAIL PROTECTED] (Tom Lane) wrote:
> novice <[EMAIL PROTECTED]> writes:
> > I just installed postgres-8.2 using the command line
> > apt-get instal
Hi guys,
I just installed postgres-8.2 using the command line
apt-get install postgres-8.2 and it seems the installation went ok,
but when it tries to start postgres , it fails with this error message
below...
(by the way I am running ubuntu fiesty and on an amazon ec2-image).
Any ideas what is wr
On 07/09/2007, Filip Rembiałkowski <[EMAIL PROTECTED]> wrote:
> 2007/9/5, Raj A <[EMAIL PROTECTED]>:
> > correction:
> >
> > > The result I'm expecting for the above to be
> > >
> > >notification_time| finished_time | actual
> > > +--
correction:
> The result I'm expecting for the above to be
>
>notification_time| finished_time | actual
> ++-
2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+10 | 01:20:00
> 2007-07-07 12:30:00+10 | 2007-07-09 07
Hello All,
SELECT notification_time, finished_time, sum(finished_time -
notification_time) as actual
FROM log
GROUP BY notification_time, finished_time;
gives me:
notification_time| finished_time | actual
++-
20
I am trying to record the following entries into a table. I'm curious
to know if there's an efficient/effective way of doing this? This
entries come from an ancient datalogger (note: separated by space and
uses YY/MM/DD format to record date)
Plain file sample.dat
3665 OK BS 07/08/1
Many many thanks for all the advice =)
On 21/08/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Aug 20, 2007, at 19:52 , novice wrote:
>
> > Try 2: Here are my DDLs & DMLs
>
> Thanks for the data. It looks like the data you provided in the first
> s
Try 2: Here are my DDLs & DMLs
-- Start
CREATE TABLE record
(
record_id integer PRIMARY KEY,
record_date timestamp with time zone NOT NULL
);
INSERT INTO record(record_id, record_date) VALUES ('1', '2007-07-23 11:30:37');
INSERT INTO record(record_id, record_date) VALUES ('2', '2007-07-27 1
;, 24, 2)||substr("data", 32, 6) as
inspection_date
On 13/08/07, novice <[EMAIL PROTECTED]> wrote:
> Thanks again guys =)
> I've managed to use temp table to load the data and create new table/s
> Now, how do I convert a text field with 'YY/MM/DD' to date
Thanks again guys =)
I've managed to use temp table to load the data and create new table/s
Now, how do I convert a text field with 'YY/MM/DD' to date field 'DD/MM/YY'?
On 13/08/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Paul Lambert <[EMAIL PROTECTED]&
Thank you! That was exactly what I was looking for =)
On 13/08/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
> Paul Lambert wrote:
> > novice wrote:
> >> I'm using pg version 8.2.4. What is the best method to load this data?
> >> I have just a little over
| timestamp with time zone |
On 13/08/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> novice <[EMAIL PROTECTED]> writes:
> > I'm having trouble loading the date field. Should I convert it first
> > or should I be using a text processor before loading the data in?
>
What is the best method to load the following?
I'm having trouble loading the date field. Should I convert it first
or should I be using a text processor before loading the data in?
3665 OK SM 07/07/13 06:09
5162 OK SM 07/02/12 06:10
3665 OK SM 07/06/19 06:10
26 matches
Mail list logo