In a query, there is something like
order by count(id)/age
where both id and age are the integer data type.
>From a query result, I believe the operation count(id)/age yields a integer. I
>need it in real data type. After searching the online document, I haven't
>found any related informatio
I try to understand how the D&T information is stored/presented in PG. In the
application, the data is reported as
Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time
But, in the DB, it is stated as
2006-04-09 14:40:53.093-07
It doesn't seen right to me. Both are on the same box and the date
Thanks for your reply, Martijn. And see below.
> On Sun, Apr 09, 2006 at 12:07:50PM -0800, Wei Wei wrote:
> > I try to understand how the D&T information is stored/presented
> > in PG. In the application, the data is reported as
> >
> > Sun Apr 09 12:40:52 P
Thanks for your response, Tom.
And please see the below.
> > In the application, the data is reported as
> >
> > Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time
> >
> > But, in the DB, it is stated as
> >
> > 2006-04-09 14:40:53.093-07
> >
> > It doesn't seen right to me. Both are on the sa
When I install the 9.0.x version on my Window Visita Laptop, I get the error. The "Windows Scripting Host" is up. So it is not the topic of this article: http://1stopit.blogspot.com/2011/01/postgresql-83-and-84-fails-to-install.html
How to resolve this problem?
Thanks.
- w
Forwarded message
From: Wei
Date: May 20, 2011
Subject: [GENERAL] Unable to Install - "unable to write inside TEMP environment
variable path"
To: pgsql-general@postgresql.org
When I install the 9.0.x version on my Window Visita Laptop, I get the e
Can anyone help?
On May 20, 2011, Wei wrote:
Forwarded message From: Wei <wei...@lycos.com>Date: May 20, 2011Subject: [GENERAL] Unable to Install - "unable to write inside TEMP environment variable path"To: pgsql-general@postgresql.orgWhen I install the
When I install the 9.0.x version on my Window Visita Laptop, I get the error.
The "Windows Scripting Host" is up. So it is not the topic of this
article: http://1stopit.blogspot.com/2011/01/postgresql-83-and-84-fails-to-install.html
How to resolve this problem?
--
Sent via pgsql-general mail
;'1 second''::INTERVAL;
END;
' LANGUAGE 'plpgsql';
Basically the function takes two parameters, and add the second one (as
days) onto the first one (as timestamp without timezone)
I don't really like this implementation. Is there a more concise way to
do this?
address:
Liou's House Chinese Restaurant
1245 Jacklin Rd
Milpitas, CA 95035
(408) 263-9888
- Jiani & Wei
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I found some posts be developers discussing this issue last Jan. and Nov..
See link below.
http://search.postgresql.org/search?m=1&q=cache+lookup+failed+for+relation
&l=&d=&s=
But have not been able to find any suggestion on how an end user can use
to get around this problem. Basically, we ha
, feel free
to email Wei Zheng (wzheng at cs dot rutgers dot edu).
Thanks for your time,
Wei Zheng
PhD student, Vivo Research Group (http://vivo.cs.rutgers.edu)
Rutgers University
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
I am trying to connect to machine A (192.168.1.155) from a different
machine B (192.168.1.180), with password transmitted as a MD5 string.
I have the following lines in my pg_hba.conf file.
hostall all 192.168.1.180 255.255.255.1md5
I created a database user "test_user
On Thu, 2006-10-12 at 15:38 -0400, Wei Weng wrote:
> I am trying to connect to machine A (192.168.1.155) from a different
> machine B (192.168.1.180), with password transmitted as a MD5 string.
>
>
> I have the following lines in my pg_hba.conf file.
>
> hostall
On Thu, 2006-10-12 at 15:50 -0400, Tom Lane wrote:
> Wei Weng <[EMAIL PROTECTED]> writes:
> > I have the following lines in my pg_hba.conf file.
> > hostall all 192.168.1.180 255.255.255.1md5
>
> Not relevant to your immediate problem, but:
e, all 3 strings are different)
Why the difference? Is there something missing ??
Thanks
Wei
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
EXPLAIN ANALYZE will hang)
My question is : Is my suspicion correct? And would upgrading to 8.0 (or
any later 8.x version of postgresql) help with my specific demand?
I am using PostgreSQL 7.4.13.
Thanks
Wei
---(end of broadcast)---
TIP 9: In
Dear all,
I am intending to use JMX to enable my application to be monitored by
the NMS. I am wondering is there any SNMP agent already build-up for
postgres DB and can be plugged into the JMX environment ?
I have found that a project for implementing a postgres db SNMP agent
(http://pgfoundry.o
Dear all,
I am intending to store the files inside the postgres DB using the
type text (all the files will be pre-encode into base64. The reason
for not using the type bytea as I encountered some undesired
format(the original file alignment can't be preserved) while
extracting the content and dis
l time=0.037..6084.385 rows=211286 loops=1)
Total runtime: 6520.499 ms
what else can I improve? Thanks in advance
Wei
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Forgot to mention the version I am using.
PostgreSQL 7.4.13
Thanks
On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote:
> I have a table that has roughly 200,000 entries and many columns.
>
> The query is very simple:
>
> SELECT Field1, Field2, Field3... FieldN F
I am running this in the same machine as the database though.
Thanks
On Tue, 2006-12-05 at 16:02 -0500, Jan de Visser wrote:
> On Tuesday 05 December 2006 3:56 pm, Wei Weng wrote:
> > I have a table that has roughly 200,000 entries and many columns.
> >
> > The
On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote:
> I have a table that has roughly 200,000 entries and many columns.
>
> The query is very simple:
>
> SELECT Field1, Field2, Field3... FieldN FROM TargetTable;
>
> TargetTable has an index that is Field1.
>
I thi
Is there any OSS solutions (stable) for postgresql replication for
postgresql 8.0?
Sincerely,
Wei Weng
---(end of broadcast)---
TIP 6: explain analyze is your friend
chine
so I really hope that I could run 7.1.3 and 7.4.1 on the same machine and
run his code on 7.1.3 while developing pl/pgsql on 7.4.1. Now can anyone
give a hand on whether this can be done, and if so, can you give me a little
direction on how to do this?
Many thanks,
do I come up a way to access
binary commands of
both versions quickly without adding absolute path infront of those of
7.4.1?
Many thanks,
Wei
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Peter Alberer" <[EMAIL PROTECTED]>
Cc: &quo
In that case, how do I RAISE NOTICE a text variable such as:
DECLARE tempstring text;
BEGIN
RAISE NOTICE tempstring;
END
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Wei Wang" <[EMAIL PROTECTED]>; "pgsql" <[EMAIL PRO
Hi, does anyone know how to get the schema information
of a table. More specifically, I would like to know
1. which field(s) are primary keys?
2. the data type of each field of a table?
3. If a field is a foreign key, what field/table it
is referring to.
Thanks.
Wei
Is there a function interface to get this information
other than from "psql" comman line interface?
Thanks.
Wei
--- Janning Vygen <[EMAIL PROTECTED]> wrote:
> Am Mittwoch, 26. Mai 2004 00:36 schrieb Wei Shi:
> > Hi, does anyone know how to get the schema
> infor
This is great. Thanks.
Wei
--- Mike Mascari <[EMAIL PROTECTED]> wrote:
> Wei Shi wrote:
> > Is there a function interface to get this
> information
> > other than from "psql" comman line interface?
>
> If you start psql with the '-E' switch, y
30 matches
Mail list logo
