Michael Fuhr <[EMAIL PROTECTED]> writes:
> Maybe a warning that the specified timezone wouldn't be in effect
> on the given date?
No thanks. It is not wrong for example to refer to EST all year round.
regards, tom lane
---(end of broadcast)---
On 17 Oct 2004 01:24:27 -0400, Greg Stark <[EMAIL PROTECTED]> wrote:
> Uh, not in Postgres. Perhaps you're thinking of another database system?
> In fact I suspect it's slowing down your system somewhat.
>
> --
> greg
So, there is no locking taking place during inserts at all? Or updates?
Also,
On Oct 16, 2004, at 5:56 PM, Monte Milanuk wrote:
I read the post above about deleting the group info as well; that
allowed me to create a user 'postgres' via the Account Manager.
Figure I'll have to twiddle the home dir and shell and whatnot via
NetInfo. How do I make that user not visible in
John DeSoi wrote:
I think that would be the easiest approach (delete the account and
recreate it from the command line). Hopefully this will give you a setup
similar to the original one if you don't want postgres in the login
menu. Once you have it in NetInfo, you can set it up like the other
i
Title: Re: [GENERAL] OS X Install
At 8:09 PM -0400 10/15/04, Nathan Mealey wrote:
I am trying to
install PostgreSQL on OS X 10.3, using the package from Entropy.ch.
The installation instructions there, as well as anywhere else I have
seen them on the net, say to create a user (using the System
P
I need to increase the number of connections to PostgreSQL 7.2.1.
I have tried changing the value of max_connections
in Postgresql.conf. It was commented out (as are all other
entries except "tcpip_socket = true"). Setting it to any other
value that the default 32 resulted in the serv
On Mon, 2004-10-18 at 11:15, Edwin New wrote:
> I have tried changing the value of max_connections in
> Postgresql.conf. It was commented out (as are all other entries
> except "tcpip_socket = true"). Setting it to any other value that the
> default 32 resulted in the server failing to restart.
Edwin New <[EMAIL PROTECTED]> writes:
>I need to increase the number of connections to PostgreSQL 7.2.1.
>
>
>I have tried changing the value of max_connections in
>Postgresql.conf. It was commented out (as are all other entries
>except "tcpip_socket = true"). Setting it to any o
What error do you get when the server fails to restart? It sounds like
it could be a kernel resource issue. See:
http://www.postgresql.org/docs/7.4/static/kernel-resources.html
-tfo
On Oct 17, 2004, at 8:15 PM, Edwin New wrote:
I need to increase the number of connections to PostgreSQL 7.2.1.
I
Title: RE: [GENERAL] How to increase number of connections to 7.2.1
It was the shared buffers. Thanks to everyone for your quick and accurate responses.
Regards,
Edwin.
-Original Message-
From: Doug McNaught [mailto:[EMAIL PROTECTED]]
Sent: Monday, 18 October 2004 11:45 AM
To:
I *think* I'm seeing "vacuum analyze" queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?
My settings:
#vacuum_cost_delay = 0# 0-1000 milliseconds
#vacuum_cost_page_hit = 1
A few comments --
On Fri, 15 Oct 2004 20:09:42 -0400
Nathan Mealey <[EMAIL PROTECTED]> wrote
> I am trying to install PostgreSQL on OS X 10.3, using the package from
> Entropy.ch. The installation instructions there, as well as anywhere
> else I have seen them on the net, say to create a user
dear sir,
i am trying to create view with following query
create view salesQ as
select * from sales, customer where sales.customerkey
= customer.customerkey;
it is giving
ERROR: column "customerkey" duplicated
create view salesQ as
select sales.*, customer.* from sales, customer where
sales.c
On Sun, 17 Oct 2004, Simon Moses wrote:
> dear sir,
> i am trying to create view with following query
This has nothing to do with JDBC or Java, so it should not be sent to the
JDBC list.
> create view salesQ as
> select * from sales, customer where sales.customerkey
> = customer.customerkey;
On Mon, 2004-10-18 at 14:49, Ed L. wrote:
> I *think* I'm seeing "vacuum analyze" queries launched automatically on an
> 8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
> Is this something new in 8.0 and to be expected?
No.
> #vacuum_cost_delay = 0# 0-1000 mi
Sim Zacks wrote:
I would use 2 left joins and use the where condition to make sure one
of them is true, such as:
select big_table.* from
big_table left join little_table as l1 on big_table.y1=l1.y and
l1.x=10
left join little_table as l2 on big_table.y2=l2.y and l1.x=10
where l1.p_key is not null a
Mike Mascari wrote:
Sim Zacks wrote:
I would use 2 left joins and use the where condition to make sure one
of them is true, such as:
select big_table.* from
big_table left join little_table as l1 on big_table.y1=l1.y and
l1.x=10
left join little_table as l2 on big_table.y2=l2.y and l1.x=10
where l1
Mike,
You are probably correct, I was thinking in English, not SQL. That's
what happens when I bang code too early in the morning.
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Mike
* Ken Tozier <[EMAIL PROTECTED]> [2004-10-17 00:25:07 -0400]:
> So, assuming there's no "quantity" field defined in the "cart" table,
> if 3 apples, 2 oranges and 1 head of lettuce were purchased on a
> specific shopping trip, I would do something like this?
If you need a quantity field, add o
* Steven Klassen <[EMAIL PROTECTED]> [2004-10-17 01:52:47 -0700]:
> xinu=> select * from items_types_view;
> id | item_name | type_name
> +---+---
> 1 | Apple | fruit
> 2 | Orange| fruit
> 3 | Brocolli | fruit
> 4 | Lettuce | fruit
> (4 rows)
And after I fi
When a timestamp string input contains a timezone abbreviation (CDT,
PST, etc), which timezone offset is used? The input date's or today
date's? The result on my computer suggests the latter.
# create table ts (ts timestamptz);
# insert into ts values ('2004-10-17 00:00:00 CDT'); -- UTC-5
# inse
Thanks again Stephen
It helps to see a problem you understand defined in a language you
don't. I've got a handhold now.
Ken
On Oct 17, 2004, at 4:52 AM, Steven Klassen wrote:
* Ken Tozier <[EMAIL PROTECTED]> [2004-10-17 00:25:07 -0400]:
So, assuming there's no "quantity" field defined in the "ca
On Sun, Oct 17, 2004 at 04:45:45PM +0700, David Garamond wrote:
> When a timestamp string input contains a timezone abbreviation (CDT,
> PST, etc), which timezone offset is used? The input date's or today
> date's? The result on my computer suggests the latter.
>
> # create table ts (ts timestam
On Fri, Oct 08, 2004 at 09:52:00AM -0400, Tom Lane wrote:
> The infrastructure needed for this is finally present in 8.0, ie we have
> the timezone data available, but actually teaching AT TIME ZONE about it
> didn't get done in time. Likely it will appear in 8.1 (especially if
> you step up and d
24 matches
Mail list logo
