-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
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/
---
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
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
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
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
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
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
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
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,
>
>
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
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
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.
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
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
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
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/
"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
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
[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
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
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
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
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
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
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
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
>
[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
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
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]
---
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
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.
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
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
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
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.
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
37 matches
Mail list logo
