Re: [GENERAL] Strange error

Csaba Nagy <[EMAIL PROTECTED]> writes: > ERROR: could not access status of transaction 0 > DETAIL: could not create file "/postgresdata/pg_subtrans/04E7": Die > Datei existiert bereits > The german text means "the file exists already". I think we've finally identified the reason for this: http:

Re: [GENERAL] standard normal cumulative distribution function

On Sat, Jan 21, 2006 at 01:01:28AM +0100, SunWuKung wrote: > This is exactly what I was looking for, could you post that please. The instructions that follow are for building a function written in C on Unix-like systems; if you're on another platform like Windows then I don't know what steps you'l

Re: [GENERAL] How to fetch rows with multiple values

on 1/20/06 9:08 AM, [EMAIL PROTECTED] purportedly said: > No, because I need AND operator between the terms. > > Thanks anyway :) Got it. Being thick. Just so I can save face, it may be more efficient to do: SELECT (min("ID") = avg("ID)) AS result, min("ID") as "ID" FROM customer_mapping WHERE

Re: [GENERAL] standard normal cumulative distribution function

This is exactly what I was looking for, could you post that please. thx B. > On Sat, Jan 21, 2006 at 12:00:49AM +0100, SunWuKung wrote: > > Does somebody have/know of a function for pg returning the standard > > normal cumulative distribution for a Z score? > > Are you looking for something like

Re: [GENERAL] standard normal cumulative distribution function

On Sat, Jan 21, 2006 at 12:00:49AM +0100, SunWuKung wrote: > Does somebody have/know of a function for pg returning the standard > normal cumulative distribution for a Z score? Are you looking for something like this? test=> SELECT z, cdf_ugaussian_p(z) FROM generate_series(-3, 3) AS g(z); z |

Re: [GENERAL] Page-Level Encryption

On Fri, Jan 20, 2006 at 02:06:18PM -0800, Bricklen Anderson wrote: > Jim C. Nasby wrote: > >I would highly recommend taking a look at how Oracle is handling > >encryption in the database in 10.2 (or whatever they're calling it). > >They've done a good job of thinking out how to handle things like >

Re: [GENERAL] Creation of tsearch2 index is very slow

Stephan Vollmer <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> However, I'm not sure that anyone's tried to do any performance >> optimization on the GIST insert code ... there might be some low-hanging >> fruit there. > Unfortunately, I'm not able to investigate it further myself as I'm > quite

Re: [GENERAL] Page-Level Encryption

On 1/20/06, David Blewett <[EMAIL PROTECTED]> wrote: > I'm not sure if this is the right list for this message; if it's not, > let me know and I'll take it up elsewhere. I found this thread today: >

Re: [GENERAL] Page-Level Encryption

[EMAIL PROTECTED] ("Joshua D. Drake") writes: >> IF they've got root, and the unencrypted data or the password / key is >> on the machine or in memory on it, you've lost. It may make it harder >> for them to get it, but they can. > This is true but in answer to your question you can use something

[GENERAL] standard normal cumulative distribution function

Does somebody have/know of a function for pg returning the standard normal cumulative distribution for a Z score? Thanks. Balazs ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Page-Level Encryption

On 1/21/06, Bricklen Anderson <[EMAIL PROTECTED]> wrote: > Jim C. Nasby wrote: > > I would highly recommend taking a look at how Oracle is handling > > encryption in the database in 10.2 (or whatever they're calling it). > > They've done a good job of thinking out how to handle things like > > mana

[GENERAL] Strange errors after some DB problems

Earlier today we experienced some problems with one of our PG installations - running 8.0.3. It started with the DB's write performance being fairly slow (this is how we noticed it), and after some research, I was seeeing severeal of the backend processes growing in their memory usage, to somepla

Re: [GENERAL] Page-Level Encryption

Jim C. Nasby wrote: I would highly recommend taking a look at how Oracle is handling encryption in the database in 10.2 (or whatever they're calling it). They've done a good job of thinking out how to handle things like managing the keys. I know that Oracle magazine did an article on it recently

Re: [GENERAL] Page-Level Encryption

I would highly recommend taking a look at how Oracle is handling encryption in the database in 10.2 (or whatever they're calling it). They've done a good job of thinking out how to handle things like managing the keys. I know that Oracle magazine did an article on it recently; you should be able t

[GENERAL] panic on 7.3

I got this message: 2006-01-20 11:50:51 PANIC: creation of file /var/lib/pgsql/data/ pg_clog/0292 failed: File exists In 7.3. It caused the server to restart. Can anyone tell me what it means? ---(end of broadcast)--- TIP 9: In versions belo

[GENERAL] panic on 7.3

pgsql-general@postgresql.org ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Page-Level Encryption

Doug McNaught wrote: > David Blewett <[EMAIL PROTECTED]> writes: > > > In reading the documentation of Peter Gutmann's Cryptlib, I came > > across this section: > > "The use of crypto devices can also complicate key management, since > > keys generated or loaded into the device usually can't be ex

Re: [GENERAL] Page-Level Encryption

David Blewett <[EMAIL PROTECTED]> writes: > In reading the documentation of Peter Gutmann's Cryptlib, I came > across this section: > "The use of crypto devices can also complicate key management, since > keys generated or loaded into the device usually can't be extracted > again afterwards. This

Re: [GENERAL] Page-Level Encryption

Quoting Scott Marlowe <[EMAIL PROTECTED]>: On Fri, 2006-01-20 at 14:47, David Blewett wrote: Quoting Scott Marlowe <[EMAIL PROTECTED]>: >> Having the table containing the index, or the database object, >> encrypted would protect against system admins, > > IF they've got root, and the unencrypt

Re: [GENERAL] Page-Level Encryption

On Fri, 2006-01-20 at 14:58, David Blewett wrote: > Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>: > > > > >>> This is true but in answer to your question you can use something like > >>> cryptfs. Note that you will loose performance. > >>> > >>> Joshua D. Drake > >> > >> > >> I'm looking for some

Re: [GENERAL] Page-Level Encryption

On Fri, 2006-01-20 at 14:47, David Blewett wrote: > Quoting Scott Marlowe <[EMAIL PROTECTED]>: > > >> Having the table containing the index, or the database object, > >> encrypted would protect against system admins, > > > > IF they've got root, and the unencrypted data or the password / key is >

Re: [GENERAL] Page-Level Encryption

Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>: This is true but in answer to your question you can use something like cryptfs. Note that you will loose performance. Joshua D. Drake I'm looking for something that runs *inside* of Postgres, at a higher level than a loop-back encrypted volum

Re: [GENERAL] Page-Level Encryption

This is true but in answer to your question you can use something like cryptfs. Note that you will loose performance. Joshua D. Drake I'm looking for something that runs *inside* of Postgres, at a higher level than a loop-back encrypted volume. This way, it would only be available when the

Re: [GENERAL] Page-Level Encryption

Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>: IF they've got root, and the unencrypted data or the password / key is on the machine or in memory on it, you've lost. It may make it harder for them to get it, but they can. This is true but in answer to your question you can use something like

Re: [GENERAL] Page-Level Encryption

Quoting Scott Marlowe <[EMAIL PROTECTED]>: Having the table containing the index, or the database object, encrypted would protect against system admins, IF they've got root, and the unencrypted data or the password / key is on the machine or in memory on it, you've lost. It may make it harder

Re: [GENERAL] Page-Level Encryption

IF they've got root, and the unencrypted data or the password / key is on the machine or in memory on it, you've lost. It may make it harder for them to get it, but they can. This is true but in answer to your question you can use something like cryptfs. Note that you will loose performan

Re: [GENERAL] Page-Level Encryption

On Fri, 2006-01-20 at 14:24, David Blewett wrote: > I'm not sure if this is the right list for this message; if it's not, > let me know and I'll take it up elsewhere. I found this thread today: >

[GENERAL] Page-Level Encryption

I'm not sure if this is the right list for this message; if it's not, let me know and I'll take it up elsewhere. I found this thread today: I would be very interested if it's possible to encr

Re: [GENERAL] sequences not restoring properly

I need to amend what I said before; apparently, the 8.1.1 dump is creating correct sequence values (except in one instance), but it's changing the names to "match" the tables and columns they go with. Which is nice, I suppose, except that I use an object-relational mapping API that requires hard

Re: [GENERAL] what am I doing wrong with this query?

Never mind, I figured it out, I had to use ANY instead of IN, works fine now. Thanks, Tony ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that y

Re: [GENERAL] What is the maximum length of an IN(a,b,c....d) list in PostgreSQL

Michael Fuhr <[EMAIL PROTECTED]> writes: > The number of expressions. If you set max_expr_depth to 10 then > ten 1-character values cause an error but nine 1-character > values should be fine (tested on my 7.4.11 system). I think the > same applies to 8.0 and later with max_stack_depth: the l

Re: [GENERAL] sequences not restoring properly

Brian Dimeler wrote: Doing it that way doesn't produce any errors, but it still produces incorrect sequence names and values. Are these sequences that you created by hand and then associated with a column? Versus using serial/bigserial types? Sincerely, Joshua D. Drake Doug McNaught wrote:

Re: [GENERAL] sequences not restoring properly

Brian Dimeler <[EMAIL PROTECTED]> writes: > In the database dump however, this default is omitted (and consequently, when > restoring, the new > server creates an implicit sequence named 'bands_dbbandcode_seq' instead of > the correct > bands_dbcode_seq, and it is never set to the correct value

Re: [GENERAL] sequences not restoring properly

Doing it that way doesn't produce any errors, but it still produces incorrect sequence names and values. Doug McNaught wrote: Brian Dimeler <[EMAIL PROTECTED]> writes: I'm trying to transition a database from one server to another, the old one running Postgres 7.4.1 and the new, 8.1.1. When

Re: [GENERAL] sequences not restoring properly

Brian Dimeler <[EMAIL PROTECTED]> writes: > I'm trying to transition a database from one server to another, the > old one running Postgres 7.4.1 and the new, 8.1.1. When I try to > restore using a pg_dump plaintext sql file from a nightly backup via > the usual > > psql thedb < backup.sql The bes

Re: [GENERAL] What is the maximum length of an IN(a,b,c....d) list in PostgreSQL

On Fri, Jan 20, 2006 at 02:41:04PM +, frank church wrote: > Is the value the actual length of the IN string, or is the maximum of the > comma > separated exressions? The number of expressions. If you set max_expr_depth to 10 then ten 1-character values cause an error but nine 1-character

[GENERAL] sequences not restoring properly

I'm trying to transition a database from one server to another, the old one running Postgres 7.4.1 and the new, 8.1.1. When I try to restore using a pg_dump plaintext sql file from a nightly backup via the usual psql thedb < backup.sql It works for the most part, but encounters several errors

Re: [GENERAL] what am I doing wrong with this query?

Tony Caduto schrieb: > select array_to_string(conkey,',') from pg_constraint where contype = > 'p' and conrelid = 17059 > > returns a value of 1,2,18 for the array to string function, > > when I do this it does not return true: > > select case when 18 in (array_to_string(conkey,',')) then true

Re: [GENERAL] Creation of tsearch2 index is very slow

Martijn van Oosterhout writes: > The cost on inserting would generally go to either penalty, or > picksplit. Certainly if you're inserting lots of values in a short > interval, I can imagine picksplit being nasty, since the algorithms for > a lot of datatypes are not really reknown for their speed

[GENERAL] what am I doing wrong with this query?

select array_to_string(conkey,',') from pg_constraint where contype = 'p' and conrelid = 17059 returns a value of 1,2,18 for the array to string function, when I do this it does not return true: select case when 18 in (array_to_string(conkey,',')) then true else false end from pg_constraint

Re: [GENERAL] Creation of tsearch2 index is very slow

Stephan Vollmer <[EMAIL PROTECTED]> writes: > Unfortunately, I'm not able to investigate it further myself as I'm > quite a Postgres newbie. But I could provide someone else with the > example table. Maybe someone else could find out why it is so slow. I'd be willing to take a look, if you'll send

Re: [GENERAL] Creation of tsearch2 index is very slow

On Fri, Jan 20, 2006 at 10:35:21AM -0500, Tom Lane wrote: > However, I'm not sure that anyone's tried to do any performance > optimization on the GIST insert code ... there might be some low-hanging > fruit there. It'd be interesting to look at a gprof profile of what the > backend is doing during

Re: [GENERAL] Creation of tsearch2 index is very slow

Tom Lane wrote: > Stephan Vollmer <[EMAIL PROTECTED]> writes: >> I noticed that the creation of a GIST index for tsearch2 takes very >> long - about 20 minutes. CPU utilization is 100 %, the resulting >> index file size is ~25 MB. Is this behaviour normal? > > This has been complained of before.

Re: [GENERAL] Initdb panic: invalid record offset at 0/0 creating template1]

DANTE ALEXANDRA <[EMAIL PROTECTED]> writes: > We have generated a new rpm as we haven't found a 8.1.0 rpm for IA-64 on > Red Hat Enterprise Linux 4 on the PostGreSQL web site. We have compiled > PostGreSQL v8.1.0 and generated the rpm with the intel compiler "icc". > In the spec file, we have use

Re: [GENERAL] autovacuum and temporary tables

OK, I have an 8.0.almost 5 installation which did not have any such problems yet. The 8.0.~3 instance will soon be migrated to 8.1.latest, so I will skip the 8.0.5 step, even if it only means install/restart/no dump - after all I had a single crash in a few months of operation. I take it granted t

Re: [GENERAL] How to fetch rows with multiple values

Keary Suska wrote: Data looks something like this: "john" 1 "peter"1 Maybe I'm a little thick this morning but can't you just do: SELECT "ID" from customer_mapping WHERE "Name"='john' OR "Name"='peter' OR "Name"='george' ORDER BY "ID" DESC Not quite. He's after ID that have *both

Re: [GENERAL] autovacuum and temporary tables

Csaba Nagy wrote: It's version 8.0.almost3, meaning that I used the 8.0 stable CVS branch just before 8.0.3 was released. I will upgrade this data base to 8.1.x (the latest released version at the time of upgrade) soon, so if the 8.1 version has the temporary table thing fixed that would be very

Re: [GENERAL] How to fetch rows with multiple values

No, because I need AND operator between the terms. Thanks anyway :)SebastjanOn 1/20/06, Keary Suska < [EMAIL PROTECTED]> wrote:on 1/20/06 6:19 AM, [EMAIL PROTECTED] purportedly said:> I have a table like this:>> CREATE TABLE customer_mapping> (> "Name" varchar(128) NOT NULL,> "ID" int8 NOT NULL >

Re: [GENERAL] Initdb panic: invalid record offset at 0/0 creating

Hello Tom, We have generated a new rpm as we haven't found a 8.1.0 rpm for IA-64 on Red Hat Enterprise Linux 4 on the PostGreSQL web site. We have compiled PostGreSQL v8.1.0 and generated the rpm with the intel compiler "icc". In the spec file, we have used these options for ./configure : ./co

Re: [GENERAL] Create Produre for DROP row

> BEGIN > > DELETE FROM . > > EXCEPTION >WHEN others THEN > ... > END; > > documentation: > http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING > > a list of errors: > http://www.postgresql.org/docs/cur

Re: [GENERAL] Creation of tsearch2 index is very slow

Stephan Vollmer <[EMAIL PROTECTED]> writes: > I noticed that the creation of a GIST index for tsearch2 takes very > long - about 20 minutes. CPU utilization is 100 %, the resulting > index file size is ~25 MB. Is this behaviour normal? This has been complained of before. GIST is always going to b

Re: [GENERAL] How to fetch rows with multiple values

on 1/20/06 6:19 AM, [EMAIL PROTECTED] purportedly said: > I have a table like this: > > CREATE TABLE customer_mapping > ( > "Name" varchar(128) NOT NULL, > "ID" int8 NOT NULL > ) > > Data looks something like this: > > "john" 1 > "peter"1 > "test" 2 > "george" 3 > > What I woul

Re: [GENERAL] autovacuum and temporary tables

Csaba Nagy <[EMAIL PROTECTED]> writes: > I have a postgres 8.0 installation, and I'm running autovacuum against > it. I have noticed that it processes temporary tables too, which is in > itself a bit curious, but the problem is that autovacuum might even > crash if a temporary table is suddenly gon

Re: [GENERAL] autovacuum and temporary tables

It's version 8.0.almost3, meaning that I used the 8.0 stable CVS branch just before 8.0.3 was released. I will upgrade this data base to 8.1.x (the latest released version at the time of upgrade) soon, so if the 8.1 version has the temporary table thing fixed that would be very nice :-) I also hav

Re: [GENERAL] Create User

On Fri, 2006-01-20 at 09:16 +0100, DB Subscriptions wrote: > BEGIN > CREATE USER NEW.userid WITH PASSWORD NEW.pword IN GROUP NEW.groupe; > > RETURN new; > END; You can't use PL/PgSQL variables in DDL commands. Try using EXECUTE: EXECUTE 'CREATE USER ' || NEW.userid || '...'; -Neil

Re: [GENERAL] autovacuum and temporary tables

Exactly which version of 8.0.x? There was a bug fixed around 8.0.5 or so "Prevent core dump in contrib version of autovacuum when a table has been dropped. Per report from daveg (not his patch, though)." The version of autovacuum in 8.1 is a fairly different beast than the contrib version, a

Re: [GENERAL] Initdb panic: invalid record offset at 0/0 creating template1]

DANTE ALEXANDRA <[EMAIL PROTECTED]> writes: > we recompiled and built an RPM on IA64, release of postgresql : 8.1.1, > on RHEL4 update 2, > the installation of the rpm seem to be good, > we install with --nodeps , and we indicate the path for the library's > /opt/intel_cc_80/lib > but when tryin

Re: [GENERAL] mac os x compile failure

Thanks for the help, Tom, and others who made suggestions. I compiled and installed 8.0.6 with no problems on OS X 10.2.8 My little old imac's a happy postgres host now. Neil --- Tom Lane <[EMAIL PROTECTED]> wrote: > Neil Brandt <[EMAIL PROTECTED]> writes: > > fd.c: In function `pg_fsync_write

Re: [GENERAL] Create User

Thanks Pandurangan. The Function could not even be saved or created. The error is not at the insert level but at the creation of the trigger function. Regards. Pandurangan R S wrote: I hope this error arises when you do a insert. Can u post your insert statement that caused this error? On

Re: [GENERAL] Creation of tsearch2 index is very slow

PS: What I forgot to mention was that inserting records into the table is also about 2-3 times slower than before (most likely due to the slow index update operations). I dropped the whole database and restored the dumpfile, but the result it the same. When the index is recreated after COPYing th

[GENERAL] Creation of tsearch2 index is very slow

Hello! I noticed that the creation of a GIST index for tsearch2 takes very long - about 20 minutes. CPU utilization is 100 %, the resulting index file size is ~25 MB. Is this behaviour normal? Full text columns: title author_list tsearch2 word lists: fti_title fti_author_list tsea

Re: [GENERAL] How to convert Big5 to UTF8

On Fri, Jan 20, 2006 at 09:56:40AM +0800, Alex CS Huang wrote: > Hi, All, > I create a database which encoding is UTF8, and create a table test > create table test ( name varchar); > I insert a data '\244\350' encoding is Big5, I wish translate them to > UTF8, so I use > insert into test va

Re: [GENERAL] How to fetch rows with multiple values

Wow, this joined query is super faster then intersect(10x), thanks a lot!!Regarding that I have to make a join for every term, I would think it would be more consuming. Is there any limit of joins or something similar which I should be aware of? SebastjanOn 1/20/06, Michael Glaesemann <[EMAIL PROTE

Re: [GENERAL] How to fetch rows with multiple values

On Jan 20, 2006, at 22:19 , Sebastjan Trepca wrote: What I would like is to write a query where I can specify multiple names and get the IDs which have them. For now it seems the most efficient way is to use INTERSECT statement: SELECT "ID" from customer_mapping WHERE "Name"='john' INTERSEC

[GENERAL] How to fetch rows with multiple values

Hi,I have a table like this:CREATE TABLE customer_mapping(  "Name" varchar(128) NOT NULL,  "ID" int8 NOT NULL) Data looks something like this:"john" 1 "peter"    1"test"  2"george"  3What I would like is to write a query where I can specify multiple names and get the IDs which have them.For

Re: [GENERAL] out parameters and SETOF

On 1/19/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Thu, Jan 19, 2006 at 04:03:41PM -0500, Jaime Casanova wrote: > > there is a way to use OUT parameters in conjunction with SETOF? > > Do you want to return a set of the OUT parameters or a set of > something else? I don't think you can do the

[GENERAL] autovacuum and temporary tables

Hi all, I have a postgres 8.0 installation, and I'm running autovacuum against it. I have noticed that it processes temporary tables too, which is in itself a bit curious, but the problem is that autovacuum might even crash if a temporary table is suddenly gone while it tries to vacuum it... that'

Re: [GENERAL] Change owner of all database objects

> You can find some plpgsql functions here: > > http://pgedit.com/tip/postgresql/access_control_functions John, thank you. I found that acl_admin.grant_on_all() does not grant privileges on schema: it does not execute GRANT ALL ON SCHEMA myschema TO myrole; statements. So I must execute GRAN

[GENERAL] logging connections

Title: logging connections i want to know, how i can log connections to postgres. the sample log file is: LOG:  shutting down LOG:  database system is shut down LOG:  database system was shut down at 2006-01-17 18:18:24 CST LOG:  checkpoint record is at 0/B035D0 LOG:  redo record is at 0/B03

R: [GENERAL] JDBC query creates a suspended Linux process

I discovered myself what was causing this, but still I don't know exactly why it was happening. The table I was talking about has some 30.000 records, not that much, but each insert triggers a pl/pgSQL function that does a few things before actually inserting and it contains a few "raise info" stat

Re: [GENERAL] psql: FATAL: password authentication failed for user "xxxx"

I solved this, but it's still weird. I uninstalled again, this time deleting the windows user account that PostgreSQL created. So when I reinstalled everything was ok. Now I've realised that PostgreSQL is being very stupid about not allowing logins via psql from a windows administrator account. So

Re: [GENERAL] SELECT Rules or stored procedure

On 2006-01-19, "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > On Tue, Jan 17, 2006 at 09:55:42PM -0700, Assad Jarrahian wrote: >> q2) How does one get access to the rows just selected in the CREATE >> RULE computation? > > Via NEW and OLD. Read Chapter 34 of the documentation. He's talking about a SE

Re: [GENERAL] mount -o async - is it safe?

Hi Tom, > > If we turn sync off, surely PostgreSQL keeps the data consistent, ext3 > > journalling keeps the filesystem clean [assuming other mount options > > left at defaults], and then everything should be ok with either a server > > crash, power failure, storage failure, whatever. right? > >

Re: [GENERAL] create plperlu langage fails

yes ! i found my problem i added libperl.so (from perl 5.5.7) in LD_LIBRARY_PATH and now it works thanks Will -Message d'origine- De : Michael Fuhr [mailto:[EMAIL PROTECTED] Envoyé : jeudi 19 janvier 2006 18:30 À : FERREIRA, William (VALTECH) Cc : pgsql-general@postgresql.org Obj

[GENERAL] Initdb panic: invalid record offset at 0/0 creating template1]

Hello, I work with Agnès Bocchino who have posted a message on the NOVICE mailing-list on an initdb error. Maybe we must post this message in the GENERAL mailing-list. I try, hoping someone knows this error. Regards, Alexandra DANTE Message original Sujet: [NOVICE] Initdb p

Re: [GENERAL] Create User

I hope this error arises when you do a insert. Can u post your insert statement that caused this error? On 1/20/06, DB Subscriptions <[EMAIL PROTECTED]> wrote: > Hi, > > I have this table: > > CREATE TABLE users > ( > userid varchar(100) NOT NULL, > nama varchar(50) NOT NULL, > pword varchar

Re: [GENERAL] create plperlu langage fails

i have 2 versions of perl installed : 5.00 and 5.8.7 i added perl 5.8.7 executable in the PATH environnement variable. During postgresql configure, the good version of perl is found. does I need to add in the path some libraries (like libperl.so) or does it find it using the perl executable ? i

[GENERAL] Bizgres 0.8 vs. 8.1.2

Is my impression correct that 8.1.x has almost all features previously only available in Bizgres? Besides the Java Loader.. any arguments to go with the Bizgres distribution instead? -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 3: Hav

[GENERAL] psql: FATAL: password authentication failed for user "xxxx"

Hi. I installed PostgreSQL 8.1.2 on Windows XP Pro. I started psql (via the start menu) and created a user. Then I exited psql using \q. Then I tried to start it again and got: psql: FATAL: password authentication failed for user "postgres" and the command window closed. I don't understand what

[GENERAL] Create User

Hi, I have this table: CREATE TABLE users ( userid varchar(100) NOT NULL, nama varchar(50) NOT NULL, pword varchar(255) NOT NULL, groupe varchar(7) NOT NULL, rolle int2 NOT NULL DEFAULT 2, statux varchar(9) NOT NULL DEFAULT 'Active'::character varying, CONSTRAINT users_pkey PRIMARY KEY (u

Re: [GENERAL] Using rowtype parameter

ANYELEMENT only matches scalar types. I don't think we have any support for accepting an arbitrary row type as a function argument. There's been some speculation about allowing RECORD to do that, but it's not done. OK, that clears it up. RECORD would actually do nicely. Right now I'll be forc