On Tue, Nov 16, 2004 at 10:39:10AM +1100, Harvey, Allan AC wrote:
> mill2=> explain select value from history where pointname = 'MILL2-SPEED' and
> dt < now() - interval '5 minutes'\g
We were looking for the output from "explain analyze select "
With EXPLAIN ANALYZE we can see how realistic
Bjørn T Johansen wrote:
> When does using schemas make sense? Is it more effective or is it
> just to make a database more manageable?
They are just a logical hierarchy that allows you to organize your
databases in more or less manageable ways. There is no performance or
other physical benefit.
Anatoly Okishev wrote:
How the function written on pl/pgsql can be called by the function
written on plperl.
Error is:
error from function: Undefined subroutine
&Safe::Root2::get_national_code called.
You probably need to be calling "SELECT get_national_code(...)" to access
it via a standard q
Which means that sometimes they do not return the correct value - if you
have a trigger that inserts another record you will not get the right value.
MSSQL has @@IDENTITY and SCOPE_IDENTITY() to handle this case, I'm new to
pgsql so I don't know if it has anything like that.
Jerry
"Richard Hux
SELECT "date" FROM "table" WHERE "color" = 'red' ORDER BY "date" DESC LIMIT
1;
Don't worry about names, just quote your identifiers. They will stand out
and you can use anything you want.
Jerry
"Michael Glaesemann" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Scott,
>
> On No
On 11/15/2004 5:05 PM, ON.KG wrote:
Hi!
Description:
VMware 4.0
Main host is WinXP Pro (on FAT32)
and Guest Host is WinXP Pro (on NTFS)
I hope you're running the guest with fully preallocated virtual disks.
Any FAT inconsistency caused by a system crash could destroy your entire
guest otherwise.
Tom, Michael,
Thanks for your interests. My original post was scant
on detail as I was unsure if I had found the right place.
It appears I have, so...
Version is 7.4.5
Table size these tests were carried out on:-
mill2=> select count(*) from history\g
count
258606
(1 row)
Before in
When does using schemas make sense? Is it more effective or is it just to make a
database more manageable?
Regards,
BTJ
--
---
Bjørn T Johansen
[EMAIL PROTECTED]
---
I run these commands automatically every night:
vacuumdb -a -z -U postgres
reindexdb -a -U postgres
Is there a way to temporarily disable all other
connections to Postgres until these operations are
complete? The operations take a while (about 20
minutes) and connections really pile up, sometimes
[EMAIL PROTECTED] (Karim Nassar) writes:
> On Sun, 2004-11-07 at 21:16, Christopher Browne wrote:
>> None of these systems _directly_ address how apps would get pointed to
>> the shifting servers.
>
>> Something needs to be "smart enough" to point apps to the right place;
>> that's something to th
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> [EMAIL PROTECTED] (Jim Seymour) writes:
> > I recently upgraded from 7.4.2 to 7.4.6 and have run into a new
> > problem. As frequently as not, maybe even most times, when I "q" out
> > of paging the output of a query in psql: Instead of just quitting that
>
I've searched unsuccessfully on google and the archives for a technical
comparison of Oracle and PostgreSQL.
Is there any free and recent comparison that covers more than just the
basic differences.
Thanks,
Nadeem
signature.asc
Description: This is a digitally signed message part
Have you configured postgresql
to work with tcp/ip ?
http://www.postgresql.org/docs/current/static/postmaster-start.html
Succes
Estienne
ON.KG wrote:
Hi!
Description:
VMware 4.0
Main host is WinXP Pro (on FAT32)
and Guest Host is WinXP Pro (on NTFS)
On Guest Host - PostgreSQL 8.0-beta2-dev3
From Ma
Give the IP Address of your connecting client in the pg_hda.conf file
and restart postgres.
Thanks !
- goutam
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of ON.KG
> Sent: Monday, November 15, 2004 5:06 PM
> To: [EMAIL PROTECTED]
> Subject: [GENER
Hi!
Description:
VMware 4.0
Main host is WinXP Pro (on FAT32)
and Guest Host is WinXP Pro (on NTFS)
On Guest Host - PostgreSQL 8.0-beta2-dev3
From Main host i'm trying to connect to PostgreSQL to Guest host
But as a result i'm receiving next message:
Connection Refused (0x274D/10061)
Is the
Try this,
Set conn = New ADODB.Connection
Conn.open "DNS=SAP_PG;uid=postgres"
Set rsE = Conn.Execute(updateSQL)
Where updateSQL is your update statement.
Check permissions for updates/write for the user you are connecting.
- Goutam
> -Original Message-
> From: [EMAIL PROTECTED]
> [m
Peter Eisentraut wrote:
Jim Seymour wrote:
"echo $?" after it happens yields "141." There is no "141" in
/usr/include/sys/errno.h.
Exit code 141 means signal 141 - 128 = 13 = SIGPIPE. I haven't finished
thinking what that means in this case, though ...
I would expect it means the pipe between t
[EMAIL PROTECTED] (Jim Seymour) writes:
> I recently upgraded from 7.4.2 to 7.4.6 and have run into a new
> problem. As frequently as not, maybe even most times, when I "q" out
> of paging the output of a query in psql: Instead of just quitting that
> query, I get dumped straight out of psql. To
On 2004.11.15 10:42 Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> In 7.3 I was able to do:
> ALTER DATABASE babase SET "TimeZone" TO 'Nairobi';
> a nice Posix TZ value (FYI UTC+3 w. no daylight savings time).
I think the usual spelling for this zone name is 'Africa/Nairobi'.
Certainl
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> In 7.3 I was able to do:
> ALTER DATABASE babase SET "TimeZone" TO 'Nairobi';
> a nice Posix TZ value (FYI UTC+3 w. no daylight savings time).
> In 7.4 this no longer works.
I don't believe it worked in 7.3 either, but before 7.4 we didn't really
detec
Jim Seymour wrote:
> "echo $?" after it happens yields "141." There is no "141" in
> /usr/include/sys/errno.h.
Exit code 141 means signal 141 - 128 = 13 = SIGPIPE. I haven't finished
thinking what that means in this case, though ...
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Mark,
There is a net.kkkOOk trying to disrupt our list with scatology. A good
time is not being had by any. The kkkOOk is spoofing email headers to look
like valid users. We can do little but ignore the juvenile.
Rick
Hi,
Environment:
SunOS 5.7 Generic_106541-29 sun4u sparc SUNW,UltraSPARC-IIi-Engine
Postgresql-7.4.6
Build config: --with-java --enable-thread-safety
gcc version 3.3.1
less-381
readline-4.3
$ echo $PAGER
/usr/local/bin/less
$ echo $LESS
-e
I recently
Hi,
In 7.3 I was able to do:
ALTER DATABASE babase SET "TimeZone" TO 'Nairobi';
a nice Posix TZ value (FYI UTC+3 w. no daylight savings time).
In 7.4 this no longer works. I see some UTC+3 time zones
in the 7.4 docs, but how am I to know that they correspond
to Kenyan time, especially with respect
Title: I'm sure a good time was had by many...
A cathartic time, to be sure. However, could we at least limit the scatology to the *body* of the messages? It's very difficult explaining to one's boss as he looks over your shoulder that yes, indeed, this *is* a serious support list. Thanks.
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Mon, Nov 15, 2004 at 04:25:59PM +1100, Harvey, Allan AC wrote:
>> I created an index on the dt column, ran ANALYSE then,
>> EXPLAIN for some queries.
>> The returned plan was always sequential search.
> Could you post a query and the EXPLAIN ANALYZE ou
Hi all,
I'm using postgresql 7.4.2 and could not create
relationships between subclases. I hava a EER model
where the superclass Person has subclasses like
Customers. When I try to create a relationship between
Customers and other relations the database won't let
me. Is that correct and if so, whe
Thank you very much, that is exactly what I was looking for.
Daron Ryan.
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Monday, 15 November 2004 8:05 PM
To: Daron
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Visual Studio and Postgresql
Daron wrote:
> Hi,
>
>
On Mon, 15 Nov 2004 11:38:29 +0100, Stefano Bonnin
<[EMAIL PROTECTED]> wrote:
>
> Only a simple question
>
> I have a table with
>
> primarykey(field1,field2,field3)
>
> and I want to execure a query like
>
> select * from my_table where field1 = some_value
>
> if I define an index on f
Firstly, please don't send email in only HTML, it tends to get them
marked as spam.
> SPAM: Hit! (3.2 points) HTML-only mail, with no text version
Anyway, as to your question:
> Im planning on using OID for referencing in certain part of the
> system i am building as in this case using normal p
Only a simple question
I have a table with
primarykey(field1,field2,field3)
and I want to execure a query like
select * from
my_table where field1 = some_value
if I define an index on field1, I increase the
query performace or not?
Thanks
Holger Klawitter wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
I haven't found a way to set the client encoding of a psql connection other
then "\encoding" which is arkward for batch processing. As .psqlrc is being
ignored during batch processing and the internal encoding is bein
Daron wrote:
Hi,
Can anyone suggest any websites that might help with connecting
visual studio dot net (I would like to see it running using server
explorer if possible) to postgresql. I am planning to write some
client applications in VB or C#.
Best place to start is with the .Net data provid
suon wrote:
> pgsql-general I am a new user for pgsql.I has a question is, does
> pgsql(7.5 for win32) has a jdbc or a odbc ? If have ,how can i take
> it ? thank for your replying.
There is no 7.5 - version 8.0 is in beta-testing though.
There are links for jdbc/odbc on the homepage of http://ww
Anatoly Okishev wrote:
How the function written on pl/pgsql can be called by the function
written on plperl.
Error is:
error from function: Undefined subroutine
&Safe::Root2::get_national_code called.
You probably need to be calling "SELECT get_national_code(...)" to
access it via a standard q
Holger Klawitter wrote:
> Shouldn't psql honour the current locale setting (LC_CTYPE) or/and
> have a command line option to set the encoding?
The environment variable PGCLIENTENCODING serves this purpose.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
I haven't found a way to set the client encoding of a psql connection other
then "\encoding" which is arkward for batch processing. As .psqlrc is being
ignored during batch processing and the internal encoding is being set
*after* "-v", I
37 matches
Mail list logo
