to_char bug?

Terry Lee Tucker · *nix forums addict Joined: 03 Mar 2005 Posts: 68

This caught my eye the other day, but didn't take the time to examine it. I
find that I am now very interested in it. Could you please elaborate on your
method and how this works?

TIA

On Sunday 27 February 2005 05:37 pm, Jay Guerette saith:

Terry Lee Tucker · *nix forums addict Joined: 03 Mar 2005 Posts: 68

Tom,

Do you feel this is a safe method for disabling triggers in the rare cases
where one finds that it is prudent to do that? Do you think that the column,
"reltriggers", is permanent fixture in pg_class? What is your advice on this?

TIA

On Monday 28 February 2005 03:22 pm, Tom Lane saith:

Hrishikesh Deshmukh · *nix forums beginner Joined: 01 Mar 2005 Posts: 48

Hi All,

A question about "joins" i have 17 tables in my postgres-DB how does
one perform a join on these many tables!!! :(

Thanks,
H

On Tue, 1 Mar 2005 08:42:57 -0600, James Thompson <jamest@ajrs.com> wrote:

Tino Wildenhain · *nix forums Guru Wannabe Joined: 03 Mar 2005 Posts: 177

Am Donnerstag, den 03.03.2005, 14:35 -0500 schrieb Hrishikesh Deshmukh:

Sean Davis · *nix forums Guru Wannabe Joined: 01 Mar 2005 Posts: 172

On Mar 3, 2005, at 4:36 PM, Tino Wildenhain wrote:

John Gray · *nix forums beginner Joined: 03 Mar 2005 Posts: 11

On Thu, 03 Mar 2005 07:59:14 +0000, Mario Splivalo wrote:

Hrishikesh Deshmukh · *nix forums beginner Joined: 01 Mar 2005 Posts: 48

Hi,
I want to do a 17 table join! Sad

But a general idea will help.

Thanks,
H

On Thu, 3 Mar 2005 16:56:13 -0500, Sean Davis <sdavis2@mail.nih.gov> wrote:

Robby Russell · *nix forums beginner Joined: 03 Mar 2005 Posts: 17

On Thu, 2005-03-03 at 18:00 -0500, Hrishikesh Deshmukh wrote:

Geoffrey · *nix forums beginner Joined: 04 Mar 2005 Posts: 31

Terry Lee Tucker wrote:

Bearden Barnes · *nix forums beginner Joined: 04 Mar 2005 Posts: 1

See the following article in Microsoft's Knowledgebase which describes how
to get to the system accounts in Windows XP Home. It specifically addresses
changing the Windows administrator password, but as long as you follow the
directions you should see the postgres account along with administrator and
other system accounts.

Cannot Change the Password for the Administrator Account in User Accounts in
Control Panel
Article ID : 298252
http://support.microsoft.com/default.aspx?scid=kb;en-us;298252
<http://support.microsoft.com/default.aspx?scid=kb;en-us;298252>

--Bearden Barnes

-----Original Message-----
From: Hagop H. [mailto:HagopH@hotpop.com]
Sent: Friday, March 04, 2005 4:08 PM
To: PGSQL-novice@postgresql.org; PGSQL-cygwin@postgresql.org;
PGSQL-admin@postgresql.org; PGSQL-general@postgresql.org
Subject: [ADMIN] PostgreSQL installation problem on Windows XP Home

I know that my problem is due to my carelessness and ignorance, but I didn't
think that installing PostgreSQL would cause a state of affairs not easily
reversed. Please excuse the length of the following narrative.

When installing PostgreSQL 8.0.1 on my laptop running Windows XP Home (SP2),
I let the installer create the postgres account and generate a password. I
didn't write down the password. I figured that if the installer was going to
generate a random password, it would store it in some configuration or log
file and not ask me for it. I was wrong. (Perhaps a warning for idiots like
me would be appropriate in the MSI installer file?) When I went to connect
to the template1 database, PGAdmin III asked me for the postgres account
password, which I was unable to provide.

Normally this wouldn't be a problem. I figured I'd just start up Control
Panel and change the postgres account password. Unfortunately, Windows XP
Home doesn't provide any obvious tools to change a system account password.
I only know how to change user account passwords. Control Panel's User
Accounts tool is useless for this problem.

I uninstalled PostgreSQL, thinking that reinstalling it might help. I tried
removing the postgres account to no avail. My only indication that the
postgres account still exists is the Windows Services administration
utility. I know of no method to delete the account. Microsoft's Knowledge
Base provided no help. Windows XP Professional contains a tool called Local
Users and Groups (lusrmgr.msc) that allows the administrator to change any
account's password. Windows XP Home cannot run that program.

When I reinstall PostgreSQL, I am asked for the postgres account password. I
know I could rename the postgres account name to postgres1 or something
else, but I don't know if that will create any further issues for me. I
could also upgrade the laptop's OS to XP Pro in order to change the postgres
account password, but that feels like using a sledgehammer to cut diamonds.

I certainly bear most of the blame. It would be too easy to bash Microsoft
for this. I also wish that PostgreSQL's installer did not auto-generate
passwords that cannot be changed. None of what I went through was necessary.

If someone could tell me either how to delete the postgres account or change
its password, I would appreciate the assistance.

Regards,

Hagop Hagopian

Hagop Hagopian · *nix forums beginner Joined: 06 Mar 2005 Posts: 1

Sorry.

I didn't know which list best served general installation questions for the
Windows version. My question has been answered. Thanks for your attention.

Regards,

Hagop

-----Original Message-----
From: Reini Urban [mailto:rurban@x-ray.at]
Sent: Sunday, March 06, 2005 7:27 AM
To: Hagop H.
Cc: PGSQL-cygwin@postgresql.org
Subject: Re: [CYGWIN] PostgreSQL installation problem on Windows XP Home

Please don't post to the cygwin list issues not related to cygwin.
You installed the native win32 version.

Installation problems should go to the general list only.
See http://www.postgresql.org/community/lists/

Hagop H. schrieb:

NTPT · *nix forums beginner Joined: 06 Mar 2005 Posts: 3

Ok. Let,s have a some model scenarios . Let it be a web server with some
embedded language like PHP.

1: Multiprocess server (Like Apache 1.x ) : Each process use one persistent
connection. Right ? One proces can serve only one request in present
time. Right ? When request is finished, process hold your connection open
and awaiting a new request. From the point of view of the transactions it is
OK, because transactions over one persistant connection are "serialized" by
nature.

2: One process, but multiple threads . If each thread have your separate db
connections, it is ok, it is like previous example, just substitute word
"process" by word "thread"

3: One process, multiple threads, all threads share the same one persitant
connection. Because one thread serve one request in present time, but
threads can run "concurently" (AFIAK ), I am affraid, that multiple
transactions over the single connection in this scenario will result a
complette mess. I am right ?

Please execuse my wrong english.

----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "NTPT" <ntpt@seznam.cz>
Cc: "Postgres General" <pgsql-general@postgresql.org>
Sent: Wednesday, February 09, 2005 11:45 AM
Subject: Re: [GENERAL] More concurent transaction over single connection

Magnus Hagander · *nix forums Guru Wannabe Joined: 06 Mar 2005 Posts: 158

A couple of comments:

pgadmin asked you for the postgres database account. NOT for the service
account. The postgres database account is never autogenerated, it is
always entered during the installation (on the initdb page).

To change a users password in any windows version, inculding XP Home,
run:
net user accountname newpassword

If it's a domain account, just add "/DOMAIN" at the end.

If you want to delete it, as others has pointed out already, just run
"net user accountname /delete".

I beleive there are also third-party tools available to do this in a
GUI, but I don't know of any specific tool I can point you at.

//Magnus

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Hagop H.
Sent: den 4 mars 2005 22:08
To: PGSQL-novice@postgresql.org; PGSQL-cygwin@postgresql.org;
PGSQL-admin@postgresql.org; PGSQL-general@postgresql.org
Subject: [ADMIN] PostgreSQL installation problem on Windows XP
Home

I know that my problem is due to my carelessness and ignorance,
but I didn't think that installing PostgreSQL would cause a state of
affairs not easily reversed. Please excuse the length of the following
narrative.

When installing PostgreSQL 8.0.1 on my laptop running Windows XP
Home (SP2), I let the installer create the postgres account and generate
a password. I didn't write down the password. I figured that if the
installer was going to generate a random password, it would store it in
some configuration or log file and not ask me for it. I was wrong.
(Perhaps a warning for idiots like me would be appropriate in the MSI
installer file?) When I went to connect to the template1 database,
PGAdmin III asked me for the postgres account password, which I was
unable to provide.

Normally this wouldn't be a problem. I figured I'd just start up
Control Panel and change the postgres account password. Unfortunately,
Windows XP Home doesn't provide any obvious tools to change a system
account password. I only know how to change user account passwords.
Control Panel's User Accounts tool is useless for this problem.

I uninstalled PostgreSQL, thinking that reinstalling it might
help. I tried removing the postgres account to no avail. My only
indication that the postgres account still exists is the Windows
Services administration utility. I know of no method to delete the
account. Microsoft's Knowledge Base provided no help. Windows XP
Professional contains a tool called Local Users and Groups (lusrmgr.msc)
that allows the administrator to change any account's password. Windows
XP Home cannot run that program.

When I reinstall PostgreSQL, I am asked for the postgres account
password. I know I could rename the postgres account name to postgres1
or something else, but I don't know if that will create any further
issues for me. I could also upgrade the laptop's OS to XP Pro in order
to change the postgres account password, but that feels like using a
sledgehammer to cut diamonds.

I certainly bear most of the blame. It would be too easy to bash
Microsoft for this. I also wish that PostgreSQL's installer did not
auto-generate passwords that cannot be changed. None of what I went
through was necessary.

If someone could tell me either how to delete the postgres
account or change its password, I would appreciate the assistance.

Regards,

Hagop Hagopian

Michael Fuhr · *nix forums Guru Joined: 02 Mar 2005 Posts: 674

On Thu, Feb 24, 2005 at 04:20:03PM -0500, Bruce Momjian wrote:

Richard Huxton · *nix forums Guru Joined: 01 Mar 2005 Posts: 522

NTPT wrote:

Google