Re: [GENERAL] Postgresql.conf

2007-01-23 Thread A. Kretschmer
am Tue, dem 23.01.2007, um 20:48:28 -0800 mailte Benjamin Smith folgendes: > Andreas, > > Would you mind explaining what you mean by "localized object names" and why > it > might be bad? Or where I might go to learn more? > > Thanks, Tino wrote this ;-) Btw.: Fullquote below make its harder

Re: [GENERAL] Example of RETURNING clause to get auto-generated keys from INSERT

2007-01-23 Thread Adam Rich
Let's say you have a table with "id, value" columns. And your normal query would be this: INSERT into mytable (id,value) values (1,"foo"),(2,"bar"); Your new query would be like this: INSERT into mytable (id,value) values (1,"foo"),(2,"bar") RETURNING id; And you would get a result back with

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread Benjamin Smith
Andreas, Would you mind explaining what you mean by "localized object names" and why it might be bad? Or where I might go to learn more? Thanks, -Ben On Tuesday 23 January 2007 07:38, Tino Wildenhain wrote: > A. Kretschmer schrieb: > > am Tue, dem 23.01.2007, um 10:12:13 -0500 mailte Brand

Re: [GENERAL] Example of RETURNING clause to get auto-generated keys from INSERT

2007-01-23 Thread Alvaro Herrera
Ken Johanson wrote: > -support multiple values, ie. insert int tbl (a,b) values (1,2),(3,4), > should return a result with 2 rows containing the new keys (one for each > column the users declares). > -query the values atomically (so that insert by another client won't > skew the curval / sequen

[GENERAL] Example of RETURNING clause to get auto-generated keys from INSERT

2007-01-23 Thread Ken Johanson
Greetings, I am looking into possibly contributing some code for one of the existing PG drivers, that will allow us to, after INSERT, get a ResultSet containing the server generated keys (sequences or other). I've been told that (short of implementing a new V4 server protocol) the most effect

Re: [GENERAL] Date Questions

2007-01-23 Thread Bruno Wolff III
On 01/23/07 17:22, Robert Sanford wrote: > > January 07 of 2007 is a Sunday. Based on the documentation I would > expect that date to be the first day of the second week of the year > 2007. That's not what I'm getting. When I run: Read the 'week' documentation carefully. ISO weeks start on Monday

Re: [GENERAL] Date Questions

2007-01-23 Thread Robert Sanford
Every app has its joyful inconsistencies and learning them is part of the process... So if I'm currently doing a GROUP BY date_part(week, datecolumn) in a view and I really want to be using the DOW convention I need to write a customized get_sunday_week_num (date) to make everything consistent. O

Re: [GENERAL] dump desde dentro de una base

2007-01-23 Thread Alvaro Herrera
Fernando De Pedro wrote: > Disculpen por la pregunta pero con postgres puedo sacar un dump > desde dentro de la base y obtener lo mismo que con pg_dump Sales de la base y ejecutas pg_dump. ... No, no hay ninguna forma de hacerlo. -- Alvaro Herrerahttp://www

Re: [GENERAL] [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)

2007-01-23 Thread Alvaro Herrera
Jorge Godoy wrote: > elein <[EMAIL PROTECTED]> writes: > > > Is there still a problem here? Does anyone know what the > > problem was? I have no trouble accessing varlena.com, > > but I am not a good tester for that. > > > > I was out of town during this thread but my machine did not > > go down

Re: [GENERAL] psql substitution variables

2007-01-23 Thread Merlin Moncure
On 24 Jan 2007 00:21:44 +0100, Harald Fuchs <[EMAIL PROTECTED]> wrote: In article <[EMAIL PROTECTED]>, "Merlin Moncure" <[EMAIL PROTECTED]> writes: > can anybody think of of a way to sneak these into dollar quoted > strings for substitution into create function? Can't you put the psql call i

Re: [GENERAL] [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)

2007-01-23 Thread Jorge Godoy
elein <[EMAIL PROTECTED]> writes: > Is there still a problem here? Does anyone know what the > problem was? I have no trouble accessing varlena.com, > but I am not a good tester for that. > > I was out of town during this thread but my machine did not > go down, but my isp could have. > You cou

Re: [GENERAL] [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)

2007-01-23 Thread elein
Is there still a problem here? Does anyone know what the problem was? I have no trouble accessing varlena.com, but I am not a good tester for that. I was out of town during this thread but my machine did not go down, but my isp could have. You could have emailed me [EMAIL PROTECTED] ---elein [

[GENERAL] Calling all SoCal PostgreSQL Users!

2007-01-23 Thread Josh Berkus
PG community of Southern California: PostgreSQL will have a booth at Southern California Linux Expo (SCALE5x) in three weeks.  The booth will be run by Gavin Roy and Daniel Ceregatti of our LA community, and David Fetter and I will be helping staff it. http://www.socallinuxexpo.org/scale5x/ It

Re: [GENERAL] Date Questions

2007-01-23 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/23/07 17:22, Robert Sanford wrote: > It appears to me that there is some inconsistency in the date > calculations for my PostgreSQL install (version 8.0 on Win32). > > January 07 of 2007 is a Sunday. Based on the documentation I would > expect t

Re: [GENERAL] Date Questions

2007-01-23 Thread Tom Lane
"Robert Sanford" <[EMAIL PROTECTED]> writes: > It appears to me that there is some inconsistency in the date > calculations for my PostgreSQL install (version 8.0 on Win32). extract(DOW) follows the convention that the week starts on Sunday, but extract(WEEK) uses the ISO convention, which include

Re: [GENERAL] psql substitution variables

2007-01-23 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, "Merlin Moncure" <[EMAIL PROTECTED]> writes: > can anybody think of of a way to sneak these into dollar quoted > strings for substitution into create function? > would i would ideally like to do is (from inside psql shell) > \set foo 500 > create function bar() r

[GENERAL] Date Questions

2007-01-23 Thread Robert Sanford
It appears to me that there is some inconsistency in the date calculations for my PostgreSQL install (version 8.0 on Win32). January 07 of 2007 is a Sunday. Based on the documentation I would expect that date to be the first day of the second week of the year 2007. That's not what I'm getting. Whe

[GENERAL] copy schema X to schema Y in the same DB

2007-01-23 Thread johnf
Hi, I would like to copy a schema X to a new schema Y within the same database. Is this possible? -- John Fabiani ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Problems compiling from source

2007-01-23 Thread codeWarrior
It sort of looks like you are trying to compile a Windows distro of the source code on a 'Nix box to me... -- Regards, Gregory P. Patnude Vice President - Applications & Innovations Group iDynaTECH, Inc 120 North Pine Street STC - Suite 162 Spokane, WA 99202 (509) 343-3104 [voice] http://www

[GENERAL] dump desde dentro de una base

2007-01-23 Thread Fernando De Pedro
Estimados, Disculpen por la pregunta pero con postgres puedo sacar un dump desde dentro de la base y obtener lo mismo que con pg_dump Gracias Saludos - Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected to friends.

[GENERAL] how to read bytea field

2007-01-23 Thread marcelo Cortez
folks help me ,i cant read bytea type field's. how to convert bytea to text or varchar ? when using bytea types? any clue be appreciated best regards mdc __ Preguntá. Respondé. Descubrí. Todo lo que

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread Bruno Wolff III
On Tue, Jan 23, 2007 at 14:15:23 -0500, Jeremy Haile <[EMAIL PROTECTED]> wrote: > But there are ways that we could optimize count(*) queries for specific > circumstances right? Obviously this isn't trivial, but I think it would > be nice if we could maintain a number of rows count that could be

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Martijn van Oosterhout
On Wed, Jan 24, 2007 at 02:17:53AM +0800, Erick Papadakis wrote: > Cpanel team takes care of all of this. All it takes is for someone > like pgsql to wake up, smell the coffee, and get over the ignorance > about a platform that is the most prevalent in the web hosting world. > Cpanel is used by mil

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread Martijn van Oosterhout
On Tue, Jan 23, 2007 at 02:15:23PM -0500, Jeremy Haile wrote: > But there are ways that we could optimize count(*) queries for specific > circumstances right? Obviously this isn't trivial, but I think it would > be nice if we could maintain a number of rows count that could be used > when performi

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Andrew Kroeger
Erick Papadakis wrote: Right now, if I wish to contribute to the documentation, how do I make it relevant? Look at MySQL docs, or PHP manual. I can leave comments in a context-relevant manner -- e.g., check at the bottom of page: http://sg.php.net/manual/en/ref.pgsql.php. Have you seen the "int

[GENERAL] IPC resource managements on Solaris 10

2007-01-23 Thread Brusser, Michael
The management of the IPC resources on Solaris 10 has changed (it now involves the /etc/project file) I wonder if someone can point me to a white-paper or any other information for configuring shared resources (semaphores, shared memory, etc) for Postgresql on Solaris 10. Thanks, Michael. --

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread Merlin Moncure
On 1/23/07, Laurent Manchon <[EMAIL PROTECTED]> wrote: Hi, I have a slow response of my PostgreSQL database 7.4 using this query below on a table with 80 rows: select count(*)from tbl; PostgreSQL return result in 28 sec every time. although MS-SQL return result in 0.02 sec every time

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread Jeremy Haile
But there are ways that we could optimize count(*) queries for specific circumstances right? Obviously this isn't trivial, but I think it would be nice if we could maintain a number of rows count that could be used when performing a count(*) on the whole table (no where clause). I don't know i

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread Bruno Wolff III
On Tue, Jan 23, 2007 at 10:12:13 -0500, Brandon Aiken <[EMAIL PROTECTED]> wrote: > Out of curiosity, has the COUNT(*) with no WHERE clause slowness been > fixed in 8.x? Or is it still an issue of "there's no solution that > won't harm aggregates with WHERE clauses"? Probably not in the sense th

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Frank Finner
How about using "updatedb" before using whereis or locate? Regards, Frank. On Wed, 24 Jan 2007 01:18:20 +0800 "Erick Papadakis" <[EMAIL PROTECTED]> thought long, then sat down and wrote: > Where is pg_hba.conf? > > I tried find and whereis commands, but could not find it. > > Thanks for any

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Frank Finner
I use PostgreSQL now since about 10 years, a long time on SuSE-Linux, since about 2 years on CentOS, also on RedHat, NetBSD and Solaris, and I never had any problems with installation or initialization or documentation. Simply follow the few steps at the beginning of the INSTALL file included wi

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Joshua D. Drake
Martijn van Oosterhout wrote: > On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote: >> I am not speaking of exotic platforms like some obscure fork of POSIX >> or something. I am speaking of Cpanel/WHM with Linux (CentOS in my >> case) which must be hosted on hundreds of thousands of w

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Erick Papadakis
I think it's some sort of serum they inject into semi-skilled i.t. workers that makes them arrogant and spout off random poorly constructed off topic posts on professional mailing lists while asking for help in the same breath. Fortunately, I never went to college and missed my shot. You clear

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Erick Papadakis
Setting aside the fact that I don't even know what Cpanel is, I'm not sure how this is practical. How many versions of Cpanel are there and which versions of postgres do they ship? If Cpanel releases a new version, do the postgresql docs needs to be updated? Cpanel team takes care of all of thi

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Merlin Moncure
On 1/23/07, Martijn van Oosterhout wrote: On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote: > I am not speaking of exotic platforms like some obscure fork of POSIX > or something. I am speaking of Cpanel/WHM with Linux (CentOS in my > case) which must be hosted on hundreds of thou

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Martijn van Oosterhout
On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote: > I am not speaking of exotic platforms like some obscure fork of POSIX > or something. I am speaking of Cpanel/WHM with Linux (CentOS in my > case) which must be hosted on hundreds of thousands of webservers > around the world. Sett

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Tino Wildenhain
Erick Papadakis schrieb: Correct. Also you will find nearly no stuff about using apt-get and rpm, which are some of the most used package systems on Linux on postgresql.org . And nothing about emerge, which is central to Gentoo Linux. And no real documentation to ports, which is prevalent on Fr

Re: [GENERAL] Password encryption method

2007-01-23 Thread Bruno Wolff III
On Tue, Jan 23, 2007 at 09:01:56 -0800, Richard Troy <[EMAIL PROTECTED]> wrote: > > On Mon, 22 Jan 2007, Bruno Wolff III wrote: > > On Mon, Jan 22, 2007 at 20:25:48 +0100, > > Bertram Scharpf <[EMAIL PROTECTED]> wrote: > > > > > > What I want to do is the following: > > > > > > 1. Login in f

Re: [GENERAL] Password encryption method

2007-01-23 Thread Bruno Wolff III
On Tue, Jan 23, 2007 at 09:44:28 +0100, Bertram Scharpf <[EMAIL PROTECTED]> wrote: > Hi Bruno, > > Am Montag, 22. Jan 2007, 23:11:41 -0600 schrieb Bruno Wolff III: > > If the web server is running on the same machine as the DB, > > then consider using ident authentication and connecting using do

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Erick Papadakis
Correct. Also you will find nearly no stuff about using apt-get and rpm, which are some of the most used package systems on Linux on postgresql.org . And nothing about emerge, which is central to Gentoo Linux. And no real documentation to ports, which is prevalent on FreeBsd. PostgreSQL.org has e

Re: [GENERAL] CREATE FUNCTION Fails with an Insert Statement in it

2007-01-23 Thread A. Kretschmer
am Tue, dem 23.01.2007, um 11:51:00 -0500 mailte Jasbinder Singh Bali folgendes: > I have created the following function : > > > CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text) > RETURNS bool AS > $BODY$ > INSERT INTO tbl_xyz > (unmask_id,email_from) > VALUES ($1,$2) > $BODY$ >

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Harald Armin Massa
pg_hba.conf is within the PostgreSQL data directory. That directory can be put everywhere by the installation routine. usual places: - on windows per default below \programme\postgresql\8.2\data - within linux often below /var I tried find and whereis commands, but could not find it. Either

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Erick Papadakis
Where is pg_hba.conf? I tried find and whereis commands, but could not find it. Thanks for any pointers. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining colum

Re: [GENERAL] CREATE FUNCTION Fails with an Insert Statement in it

2007-01-23 Thread Merlin Moncure
On 1/23/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: I have created the following function : CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text) RETURNS bool AS $BODY$ INSERT INTO tbl_xyz (unmask_id,email_from) VALUES ($1,$2) $BODY$ LANGUAGE 'sql' VOLATILE; when i try to c

[GENERAL] CREATE FUNCTION Fails with an Insert Statement in it

2007-01-23 Thread Jasbinder Singh Bali
I have created the following function : CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text) RETURNS bool AS $BODY$ INSERT INTO tbl_xyz (unmask_id,email_from) VALUES ($1,$2) $BODY$ LANGUAGE 'sql' VOLATILE; when i try to create this fucntion by running this script, i get the following

[GENERAL] PostgreSQL 8.2 utilities with Java app on Windows XP

2007-01-23 Thread Michael Schmidt
Folks, Although this is not really a JDBC problem, I initially posted it on the JDBC group because I thought the Java folks would be there. I got no response, so am posting here. I have a PostgreSQL Java client CRUD GUI app that does backup and restore by running pg_dump and pg_restore with a

Re: [GENERAL] Password encryption method

2007-01-23 Thread Richard Troy
On Mon, 22 Jan 2007, Bruno Wolff III wrote: > On Mon, Jan 22, 2007 at 20:25:48 +0100, > Bertram Scharpf <[EMAIL PROTECTED]> wrote: > > > > What I want to do is the following: > > > > 1. Login in from a program on a client as a particualar user. > > For this case you shouldn't need to do anythi

[GENERAL] psql substitution variables

2007-01-23 Thread Merlin Moncure
can anybody think of of a way to sneak these into dollar quoted strings for substitution into create function? would i would ideally like to do is (from inside psql shell) \set foo 500 create function bar() returns int as $$ declare baz int default :foo; [...] that would eliminate the need

[GENERAL] PostgreSQL 8.1: createdb: xflush error ?

2007-01-23 Thread Steven De Vriendt
Hi, I'm trying to make a new database, yet when I try to do this I get the following error: ERROR: xlog flush request 0/827520 is not satisfied --- flushed only to 0/80D7B8 CONTEXT: writing block 5 of relation 1663/16893/1259 Can someone give me a clue of what it means ? Regards, Steven

Re: [GENERAL] Performance with very large tables

2007-01-23 Thread Jan van der Weijde
Hi Bruno, Good to read that your advice to me is the solution I was considering! Although I think this is something PostgreSQL should solve internally, I prefer the WHERE clause over a long lasting SERIALIZABLE transaction. Thanks, Jan -Original Message- From: Bruno Wolff III [mailto:[EM

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-23 Thread Tom Lane
Csaba Nagy <[EMAIL PROTECTED]> writes: > On Tue, 2007-01-23 at 15:43, Tom Lane wrote: >> All such code takes exclusive lock on the table, so the above >> explanation is impossible. > Well, in that case it must be some other bug as it is readily > reproducible here. My nightly integration has this

Re: [GENERAL] Regular expressions and arrays and ANY() question

2007-01-23 Thread David Fetter
On Tue, Jan 23, 2007 at 09:30:49AM -0500, Tom Lane wrote: > Martijn van Oosterhout writes: > > If you created such a function, and made an operator with it that > > was a communtator of LIKE (call it "is liked by"), would the > > planner be smart enough to split the ANY and commutate it to the > >

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-23 Thread Csaba Nagy
On Tue, 2007-01-23 at 15:43, Tom Lane wrote: > Csaba Nagy <[EMAIL PROTECTED]> writes: > > The responsible code is in src/backend/commands/trigger.c, and I > > think it only happens if you manage to create/drop a new trigger (which > > also could be a FK trigger created by a new foreign key referenc

[GENERAL] Subject: Postgres processes have a burst of CPU usage

2007-01-23 Thread Subramaniam Aiylam
Hello all, I have a setup in which four client machines access a Postgres database (8.1.1) running on a Linux box. So, there are connections from each machine to the database; hence, the Linux box has about 2 postgres processes associated with each machine. I am using the JDBC driver (postgre

Re: [GENERAL] Tracking database activity

2007-01-23 Thread Erik Jones
Tom Lane wrote: Erik Jones <[EMAIL PROTECTED]> writes: ... I was previously under the impression that by tracking age(datfrozenxid) in pg_database over time I'd be able to know how many transactions were processed in a certain amount of time. However, I've seend that pg_stat_database.xact_

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread Tino Wildenhain
A. Kretschmer schrieb: am Tue, dem 23.01.2007, um 10:12:13 -0500 mailte Brandon Aiken folgendes: Out of curiosity, has the COUNT(*) with no WHERE clause slowness been fixed in 8.x? Or is it still an issue of "there's no solution that won't harm aggregates with WHERE clauses"? I will try it:

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Merlin Moncure
On 1/23/07, Erick Papadakis <[EMAIL PROTECTED]> wrote: Doesn't work: - psql -U postgres > psql: FATAL: Ident authentication failed for user "postgres" - psql -U postgres -W > psql: FATAL: Ident authentication failed for user "postgres" that is saying you need to have the password to log

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Harald Armin Massa
Erick, - psql -U postgres > psql: FATAL: Ident authentication failed for user "postgres" Nice. This gives us some more information about what kind of client authorization is configured by cpanel. You can read everything about client-autorisation on: http://www.postgresql.org/docs/8.2/inte

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread A. Kretschmer
am Tue, dem 23.01.2007, um 10:12:13 -0500 mailte Brandon Aiken folgendes: > Out of curiosity, has the COUNT(*) with no WHERE clause slowness been > fixed in 8.x? Or is it still an issue of "there's no solution that > won't harm aggregates with WHERE clauses"? I will try it: scholl=# \timing Tim

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Tom Lane
"Erick Papadakis" <[EMAIL PROTECTED]> writes: > Doesn't work: > - psql -U postgres psql: FATAL: Ident authentication failed for user "postgres" su to postgres, then psql will let you in. Or you can RTFM about changing the default authentication method ... regards, t

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Tino Wildenhain
Erick Papadakis schrieb: Doesn't work: - psql -U postgres > psql: FATAL: Ident authentication failed for user "postgres" - psql -U postgres -W > psql: FATAL: Ident authentication failed for user "postgres" Would appreciate some insights. Where's the step by step guide to make this work? C

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Erick Papadakis
Please don't top-post, it disturbes the flow of the communication. Interesting. I prefer getting to the point an author is making. There's documentation about that too, at the end of the installation instructions IIRC. I did not see them. Please point me? I'd deeply appreciate it. This

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Erick Papadakis
Doesn't work: - psql -U postgres > psql: FATAL: Ident authentication failed for user "postgres" - psql -U postgres -W > psql: FATAL: Ident authentication failed for user "postgres" Would appreciate some insights. Where's the step by step guide to make this work? Cpanel/WHM and Plesk are TH

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Alban Hertroys
Erick Papadakis wrote: > Thanks Thomas. Please don't top-post, it disturbes the flow of the communication. > But: > > - "psql" at the command says > > psql: FATAL: database "root" does not exist > > - "psql -d postgres" at the command says > > psql: FATAL: role "root" does not exist > > Ho

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread Brandon Aiken
Out of curiosity, has the COUNT(*) with no WHERE clause slowness been fixed in 8.x? Or is it still an issue of "there's no solution that won't harm aggregates with WHERE clauses"? -- Brandon Aiken CS/IT Systems Engineer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Harald Armin Massa
Erick, psql -U postgres should help. I hope you remembered the password you gave to the database superuser while installing... best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python:

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Erick Papadakis
Thanks Thomas. But: - "psql" at the command says > psql: FATAL: database "root" does not exist - "psql -d postgres" at the command says > psql: FATAL: role "root" does not exist How should I create the first database, or the first user etc? The links you suggested are all *after* I login t

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-23 Thread Tom Lane
Csaba Nagy <[EMAIL PROTECTED]> writes: > The responsible code is in src/backend/commands/trigger.c, and I > think it only happens if you manage to create/drop a new trigger (which > also could be a FK trigger created by a new foreign key referencing that > table, as in our case) exactly between tha

Re: [GENERAL] Regular expressions and arrays and ANY() question

2007-01-23 Thread Tom Lane
Martijn van Oosterhout writes: > If you created such a function, and made an operator with it that was a > communtator of LIKE (call it "is liked by"), would the planner be smart > enough to split the ANY and commutate it to the normal order? No, at least not as of 8.2, because ANY translates as

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-23 Thread Csaba Nagy
On Tue, 2007-01-23 at 14:49, Brandon Aiken wrote: > Nevertheless, the database should be able to handle any combination of > syntactically correct SQL statements without throwing errors and > maintaining the database in a consistent state. If what you're saying > is right, the error thrown here is

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Thomas Kellerer
On 23.01.2007 15:10 [EMAIL PROTECTED] wrote: Now what? 1. Where's the interactive shell? http://www.postgresql.org/docs/8.2/static/app-psql.html > How can I start creating a database, http://www.postgresql.org/docs/8.2/static/app-createdb.html creating users, testing things out? http://ww

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread erick . papa
There are a couple of PostgreSQL tutorials around the web to make it work with WHM. I have followed them. Downloaded the *.rpm files and installed them. Then gone into my WHM (https://myserver:2087) and enabled the config, and set up the postgres user with an "su" command "adduser postgres". Now

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-23 Thread Brandon Aiken
Nevertheless, the database should be able to handle any combination of syntactically correct SQL statements without throwing errors and maintaining the database in a consistent state. If what you're saying is right, the error thrown here is not a user configuration error, but an RDBMS implementati

Re: [GENERAL] show all record between two date after group by and aggrigation...

2007-01-23 Thread Chad Wagner
On 1/23/07, Jorge Godoy <[EMAIL PROTECTED]> wrote: > select cal.date, coalesce(foo.x, 0) AS x > from (select (date_trunc('day', current_timestamp) + (s.s * interval '1 > day'))::date AS date > from generate_series(1,365) AS s) AS cal > left join foo ON cal.date = foo.create_date; Why

Re: [GENERAL] Problems compiling from source

2007-01-23 Thread George Weaver
- Original Message From: "Magnus Hagander" What configure command did you run, exactly? configure --without-zlib I did solve the problem(?) by downloading the full distribution and using it rather than the base distribution. With the full distribution everything worked just as expecte

Re: [GENERAL] show all record between two date after group by and aggrigation...

2007-01-23 Thread Jorge Godoy
"Chad Wagner" <[EMAIL PROTECTED]> writes: > Most people do this with a "calendar" table, worst case is you could use > generate_series to do it (but it's ugly, and it may not scale well -- > haven't tested it) and left join it to your data table. > > select cal.date, coalesce(foo.x, 0) AS x > fro

Re: [GENERAL] Postgresql.conf

2007-01-23 Thread A. Kretschmer
am Tue, dem 23.01.2007, um 12:11:40 +0100 mailte Laurent Manchon folgendes: > Hi, > > I have a slow response of my PostgreSQL database 7.4 using this query below > on a table with 80 rows: > > select count(*)from tbl; How often do you want to ask the very same question? You have enough answ

[GENERAL] Postgresql.conf

2007-01-23 Thread Laurent Manchon
Hi, I have a slow response of my PostgreSQL database 7.4 using this query below on a table with 80 rows: select count(*)from tbl; PostgreSQL return result in 28 sec every time. although MS-SQL return result in 0.02 sec every time. My server is a DELL PowerEdge 2600 with bi-processor Xeon a

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-23 Thread Csaba Nagy
On Mon, 2007-01-22 at 20:56, Lenorovitz, Joel wrote: [snip] > ERROR: too many trigger records found for relation "item" I've got this error on a development data base where we were continuously creating new child tables referencing the same parent table. The responsible code is in src/backend/com

Re: [GENERAL] array_to_string return is different between Windows and Linux systems

2007-01-23 Thread Magnus Hagander
On Tue, Jan 23, 2007 at 09:23:06AM +0100, Pascal Lequeux wrote: > Hi all, > > The *array_to_string *function used to compare the content of arrays of > doubles doesn't return the same result if the OS is Windows or if it is > a Linux system. > > Here is an example using the same table content:

Re: [GENERAL] Problems compiling from source

2007-01-23 Thread Magnus Hagander
On Mon, Jan 22, 2007 at 05:32:13PM -0600, George Weaver wrote: > Hi all, > > I have installed version 8.2.1 and downloaded the source tree in order to > compile a number of C-functions. > > I have been compiling from source for contrib files and c-functions since > version 7.3 without problem.

[GENERAL] array_to_string return is different between Windows and Linux systems

2007-01-23 Thread Pascal Lequeux
Hi all, The *array_to_string *function used to compare the content of arrays of doubles doesn't return the same result if the OS is Windows or if it is a Linux system. Here is an example using the same table content: Result 1: "0,0.000263,*8e-06*,*8e-06*,0.000146,0.000321" [PostgreSQL 8.0.4

Re: [GENERAL] Password encryption method

2007-01-23 Thread Bertram Scharpf
Hi Bruno, Am Montag, 22. Jan 2007, 23:11:41 -0600 schrieb Bruno Wolff III: > If the web server is running on the same machine as the DB, > then consider using ident authentication and connecting using domain sockets. Ah, a good suggestion. Thanks! I found an exhaustive documentation on

Re: [GENERAL] MSSQL/ASP migration

2007-01-23 Thread Shoaib Mir
In order to move data and tables from MS SQL Server to PostgreSQL, use the MS SQL Server DTS wizard and gave it the ODBC for PostgreSQL as the target database. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/23/07, Robert Fitzpatrick <[EMAIL PROTECTED]> wrote: On Mon, 2007-0