Re: [GENERAL] Global temporary table - schema

2010/6/24 Ravi Katkar : > Hi List, > > > > When I have created Global temporary table its created under/in PG_temp_1 > schema by default, > > When tried to specify the schema name explicitly its throwing below error > > > > ERROR:  temporary tables cannot specify a schema name > > > > I wanted to c

[GENERAL] Global temporary table - schema

Hi List, When I have created Global temporary table its created under/in PG_temp_1 schema by default, When tried to specify the schema name explicitly its throwing below error ERROR: temporary tables cannot specify a schema name I wanted to create a Global temporary table in public or the sche

[GENERAL] The case of PostgreSQL on NFS Server

Hi This is shikase. I have a question about PostgreSQL on NFS Server as follows. Please let me know advice about that. If I posted the wrong mailing-list, please let me know. I found the manual 17.2.1 Network File System. 17.2.1 Network File System If client and server NFS implementations have

Re: [GENERAL] PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)

Scott Marlowe writes: > On Wed, Jun 23, 2010 at 10:55 PM, Konstantin Izmailov > wrote: >> The company is not willing to upgrade from 7.4 to a later version due to >> risk. > The risk of upgrading is less than the risk of staying on an > unsupported version of pgsql. The company that won't upgr

Re: [GENERAL] PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)

On Thu, Jun 24, 2010 at 12:28 AM, Konstantin Izmailov wrote: > Scott, thank you for the quick answer! > > I think it would work if our software tracks which statements have already > been prepared on the connection. Good chance of it, but honestly, running such an old and now unsupported version

Re: [GENERAL] Fwd: Stalled post to pgsql-es-ayuda

Sebastian Machuca writes: > The directory which contain the PGDATA/data is full, and i move the entire > directory data to another partition, and i link symbolic to PGDATA. > Now, when i try to start the server, keep on "startup process recovering > " > When i try to connect, this is the messa

Re: [GENERAL] PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)

Scott, thank you for the quick answer! I think it would work if our software tracks which statements have already been prepared on the connection. On Wed, Jun 23, 2010 at 8:25 PM, Scott Marlowe wrote: > On Wed, Jun 23, 2010 at 10:55 PM, Konstantin Izmailov > wrote: > > Is there a way to preve

Re: [GENERAL] copy/duplicate database schemas

On 24/06/10 03:21, Jamie Kahgee wrote: > I have an application in a schema and now i need to create other schemas > b/c the app needs to support different languages, is there an easy way > to copy an entire schema to a new one (tables, contents, trigges, > functions, etc..)? Others have replied w

Re: [GENERAL] PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)

On Wed, Jun 23, 2010 at 10:55 PM, Konstantin Izmailov wrote: > Is there a way to prevent transaction abort when preparing command in > version 7.4? > > I googled but haven't been able to find the answer. The issue occurs when > our software trys to prepare a command that is already prepared (by th

[GENERAL] Fwd: Stalled post to pgsql-es-ayuda

Hello everyone. I have a problem First, some basic data: OS: Red Hat Version 8.3 Size 15 GB The directory which contain the PGDATA/data is full, and i move the entire directory data to another partition, and i link symbolic to PGDATA. Now, when i try to start the server, keep on "startup proce

[GENERAL] PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)

Is there a way to prevent transaction abort when preparing command in version 7.4? I googled but haven't been able to find the answer. The issue occurs when our software trys to prepare a command that is already prepared (by the same or different app). PQprepare returns error and aborts current tr

Re: [GENERAL] SQL error: could not connect to database

Hi. At first,I think you lack some settings. (eg. pg_hba.conf,listen_addresses or restarting) But you say "I can log in to postgresql without password prompt using the psql tool". I can image some case,but we have to get some more information. So I'd like you to try the following program.This

[GENERAL] flatten pg_auth_members

Hello, I am trying to make a query which will flatten pg_auth_members into a table with two columns "user" and "group" which will recurse inherited roles so that each login role is associated once with any inherited roles (assuming all associated roles are inherited). This query does not do wh

Re: [GENERAL] No PL/PHP ? Any reason?

On Wed, 2010-06-23 at 17:17 -0400, John DeSoi wrote: > On Jun 22, 2010, at 1:08 AM, Scott Marlowe wrote: > > > I recall talking to the guys at command prompt and apparently > > something in the php runtime makes it unsuitable for pl deployment. > > > Any chance that the Parrot runtime could be u

Re: [GENERAL] No PL/PHP ? Any reason?

On Jun 22, 2010, at 1:08 AM, Scott Marlowe wrote: > I recall talking to the guys at command prompt and apparently > something in the php runtime makes it unsuitable for pl deployment. Any chance that the Parrot runtime could be used for PHP and other languages? I read that some folks are worki

Re: [GENERAL] copy/duplicate database schemas

On Wed, Jun 23, 2010 at 3:21 PM, Jamie Kahgee wrote: > I have an application in a schema and now i need to create other schemas b/c > the app needs to support different languages,  is there an easy way to copy > an entire schema to a new one (tables, contents, trigges, functions, etc..)? > right n

Re: [GENERAL] UPDATE after Cancle

On Wed, 2010-06-23 at 13:05 -0700, David Kerr wrote: > Howdy all - > > I just got this odd behavior in my system. > > This is PG 8.3.10 on RedHat 5.4 > > psql bla > bla=# update blatab set blafield = replace(blafield,'XXX-1','XXX1-') > where created_by = 'blauser'; > > > > > Cancel request

[GENERAL] UPDATE after Cancle

Howdy all - I just got this odd behavior in my system. This is PG 8.3.10 on RedHat 5.4 psql bla bla=# update blatab set blafield = replace(blafield,'XXX-1','XXX1-') where created_by = 'blauser'; Cancel request sent UPDATE 8231584 I checked and the updated did happen. autocommit is on, an

Re: [GENERAL] Problem Using RowType Declaration with Table Domains

On Tue, Jun 22, 2010 at 12:26 AM, Tom Lane wrote: > "George Weaver" writes: >> I have the following (very simplified) scenario: > >> CREATE DOMAIN orderstatus AS text NOT NULL DEFAULT 'Open'; > >> CREATE TABLE orders ( orderno serial >>                                          , status orderstatu

[GENERAL] copy/duplicate database schemas

I have an application in a schema and now i need to create other schemas b/c the app needs to support different languages, is there an easy way to copy an entire schema to a new one (tables, contents, trigges, functions, etc..)? right now i just have - schema what I want is - schema

Re: [GENERAL] No PL/PHP ? Any reason?

On Wed, Jun 23, 2010 at 3:31 PM, Alvaro Herrera wrote: > Excerpts from Devrim GUNDUZ's message of lun jun 21 23:55:41 -0400 2010: > >> IIRC, it does not compile against newer PostgreSQL releases and it is >> not under development right now. > > It compiles with 9.0 just fine (and earlier releases

Re: [GENERAL] No PL/PHP ? Any reason?

Excerpts from Devrim GUNDUZ's message of lun jun 21 23:55:41 -0400 2010: > IIRC, it does not compile against newer PostgreSQL releases and it is > not under development right now. It compiles with 9.0 just fine (and earlier releases too, though I didn't bother to test anything earlier than 8.2)

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

On 06/23/2010 08:22 AM, Grzegorz Jaśkiewicz wrote: the delete will succeed. That's not the point of the exercise tho. The point, is to print name in trigger, rather than null! Sorry about the noise, I completely missed what you where getting at. -- Adrian Klaver adrian.kla...@gmail.com -- Sen

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

Thom Brown writes: > Yes, I'm still not exactly sure why it's seeing uncommitted changes. :/ Because it's all one transaction. A transaction that couldn't see its own changes wouldn't be very useful. I think what the OP is unhappy about is that he imagines that the ON CASCADE DELETE action is p

Re: [GENERAL] what is the meaning of Datum?

Teodor Macicas writes: > Tom Lane wrote: >> C code will work with a value in a "native" representation, and then >> convert to or from Datum in order to pass the value through >> data-type-independent interfaces. > And how this convertions will be made ? > Are there internal functions to do this

Re: [GENERAL] what happens to postmaster?

On Wed, Jun 23, 2010 at 12:42 PM, zach cruise wrote: > using navicat 8's import wizard which does row inserts > (provider=msdaora.1; persist security info=true). more > http://www.navicat.com/manual/online_manual/win_manual/ImportODBC.html > > i know this is not navicat support, but can anyone fro

Re: [GENERAL] what happens to postmaster?

using navicat 8's import wizard which does row inserts (provider=msdaora.1; persist security info=true). more http://www.navicat.com/manual/online_manual/win_manual/ImportODBC.html i know this is not navicat support, but can anyone from navicat support also try answer this question? On Tue, Jun 2

Re: [GENERAL] what is the meaning of Datum?

On Wed, 2010-06-23 at 12:15 -0400, Alvaro Herrera wrote: > > Moreover, is there a documentation (aside the source code) that explains > > and > > links each internal data structure like HeapTuple, HeapTupleHeader, and so > > on? > > The source code comments should be plenty. Have you tried re

Re: [GENERAL] what is the meaning of Datum?

Excerpts from Luca Ferrari's message of mié jun 23 06:09:28 -0400 2010: > Hi all, > ok this is a silly question, but I've got a doubt: what is the exact meaning > of Datum? I see having a look at the macroes (e.g., PG_RETURN_XXX) that a > Datum can be used as a pointer or as a single data, that i

Re: [GENERAL] missing uuid functions in postgresql-contrib RPM for linux?

23.Haz.2010 tarihinde 17:53 saatinde, Andrew Geery > şunları yazdı: FWIW, I don't see the install script in the RHEL5 version RPM either: # rpm -qpl postgresql-contrib-8.4.4-1PGDG.rhel5.i386.rpm | grep -i uid /usr/share/doc/postgresql-contrib-8.4.4/uninstall_uuid-ossp.sql Yeah, it was repor

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

2010/6/23 Grzegorz Jaśkiewicz : > I do understand what you are saying, but still it is highly > unintuitive. Since trigger is BEFORE, developer will expect that data > to be there. > Yes, I'm still not exactly sure why it's seeing uncommitted changes. :/ Thom -- Sent via pgsql-general mailing l

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

I do understand what you are saying, but still it is highly unintuitive. Since trigger is BEFORE, developer will expect that data to be there. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-gener

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

2010/6/23 Grzegorz Jaśkiewicz : > it is confusing to me, because I thought triggers are firring BEFORE > anything goes away. So I assume that all data is still going to be > visible to the trigger, as it is firing BEFORE. The only thing is, it > looks like the FKs are doing the deletion and than th

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

2010/6/23 Grzegorz Jaśkiewicz : > the delete will succeed. > That's not the point of the exercise tho. > > The point, is to print name in trigger, rather than null! > But if it's been deleted from foob already, how can it print it? So if foob has a row with an id of 5, then: DELETE FROM foob WHER

Re: [GENERAL] High Availability with Postgres

On 23/06/10 03:05, John R Pierce wrote: > yeah. generally when money is involved in the transactions, you gotta > stick to the 'no committed data lost ever'. there's plenty of other use > cases for that too. 2PC is sometimes a reasonable alternative to shared-storage failover, though. It can be

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

it is confusing to me, because I thought triggers are firring BEFORE anything goes away. So I assume that all data is still going to be visible to the trigger, as it is firing BEFORE. The only thing is, it looks like the FKs are doing the deletion and than things are handed over to triggers. -- S

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

2010/6/23 Grzegorz Jaśkiewicz : > well, change foob column name to something else, and try yourself. It > still fails. > Wait a minute... it's deleting from foob, which is considered deleted for the remainder of that transaction. This cascades to fooa which sets off the trigger before it does any

Re: [GENERAL] what is the meaning of Datum?

Tom Lane wrote: Luca Ferrari writes: ok this is a silly question, but I've got a doubt: what is the exact meaning of Datum? It's the backend-internal representation of a single value of any SQL data type. The code using the Datum has to know which type it is, since the Datum itself d

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

the delete will succeed. That's not the point of the exercise tho. The point, is to print name in trigger, rather than null! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Facing Problem in Autovacuuming Deamon....

Thank you for your reply Let I will provide you some of the information on your queries... We are using Postgresql 8.4 version... and I will attach my configuration file for Autovacuuming for your reference. Also I will attach my pg_stat_user_tables data on vacuuming and autovacuuming from whi

Re: [GENERAL] Facing Problem in Autovacuuming Deamon....

Hi Joao, Thanks for reply.Let I will tell you the details that you want :- We are using postgresql 8.4 version. And I come to know that on certain table Autovacuuming is not getting started from the pg_stat_user_tables table containts.I will also send the autovacuum_* directives from postgrsql.

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

On Wednesday 23 June 2010 7:57:22 am Grzegorz Jaśkiewicz wrote: > well, change foob column name to something else, and try yourself. It > still fails. As I said in my previous post it did not fail on my instance of 8.3.7. In other words the DELETE succeeded. At this point I do not have an explana

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

well, change foob column name to something else, and try yourself. It still fails. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] missing uuid functions in postgresql-contrib RPM for linux?

FWIW, I don't see the install script in the RHEL5 version RPM either: # rpm -qpl postgresql-contrib-8.4.4-1PGDG.rhel5.i386.rpm | grep -i uid /usr/share/doc/postgresql-contrib-8.4.4/uninstall_uuid-ossp.sql Thanks Andrew 2010/6/23 Devrim GÜNDÜZ : > On Wed, 2010-06-23 at 09:29 -0400, Andrew Geery w

Re: [GENERAL] what is the meaning of Datum?

Luca Ferrari writes: > ok this is a silly question, but I've got a doubt: what is the exact meaning > of Datum? It's the backend-internal representation of a single value of any SQL data type. The code using the Datum has to know which type it is, since the Datum itself doesn't contain that inf

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

On Wednesday 23 June 2010 7:02:59 am Grzegorz Jaśkiewicz wrote: > nope, that's not the thing. This is just specific to my example. But > production code I have, doesn't have such confusing name, and still > fails. > Plus postgresql doesn't rely on names, but on oids rather. For what it worth I tri

Re: [GENERAL] missing uuid functions in postgresql-contrib RPM for linux?

Hi Andrew, You can download one-click installer from http://www.enterprisedb.com/products/pgdownload.do. That does have support for uuid on RHEL4 too. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Wed, Jun 23, 2010 at 6:59 PM,

Re: [GENERAL] best way to check pgdump

On Wednesday 23 June 2010 4:12:40 am Raymond O'Donnell wrote: > On 23/06/2010 04:52, Janet Jacobsen wrote: > > Hi. What is the best way to check a pgdump > > without doing a restore? > > If you used one of the binary formats for pg_dump, you can have > pg_restore list the contents without actually

Re: [GENERAL] missing uuid functions in postgresql-contrib RPM for linux?

On Wed, 2010-06-23 at 09:29 -0400, Andrew Geery wrote: > In the postgresql-contrib-8.4.4-1PGDG.rhel4 RPM (downloaded from > http://www.postgresql.org/ftp/binary/v8.4.4/linux/rpms/redhat/rhel-4-i386/), > there is no installation script or libraries for the uuid_* functions: > > # rpm -qlp postgresq

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

On Wednesday 23 June 2010 5:35:52 am Grzegorz Jaśkiewicz wrote: > consider following example: > > > > CREATE TABLE foob(id serial primary key, name varchar default ''); > CREATE TABLE fooA(id serial primary key, fooB int not null references > fooB(id) on update cascade on delete cascade, name varch

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

not really, as it depends on pretty much both tables. This is where de-normalization would actually makes sens, except for that it wouldn't - because it will badly effect all my other queries (joining on varchar is so slow). I could drop FK, and replace that with my own trigger(s), but that's a lo

Re: [GENERAL] how to create an admin user for restore database.

On Wednesday 23 June 2010 12:45:14 am Guillaume Lelarge wrote: > Le 23/06/2010 05:17, Sam Wun a écrit : > > With user liferayadmin on db liferay, I got the following errors: > > > > 03:14:50,558 WARN [DBUtil:474] ERROR: permission denied for relation > > quartz_locks: insert into QUARTZ_LOCKS valu

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

2010/6/23 Grzegorz Jaśkiewicz : > any ideas than, how can make it actually do what I wanted it to do please ? > Making FK deferrable doesn't help. > > > thanks. > Is it practical to put the trigger on the other table instead? Thom -- Sent via pgsql-general mailing list (pgsql-general@postgresql

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

nope, that's not the thing. This is just specific to my example. But production code I have, doesn't have such confusing name, and still fails. Plus postgresql doesn't rely on names, but on oids rather. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

any ideas than, how can make it actually do what I wanted it to do please ? Making FK deferrable doesn't help. thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

2010/6/23 Grzegorz Jaśkiewicz : > this is 8.3.7, for the record. And no, They won't let me update it to 8.3.11 > :/ > Well, same applies: http://www.postgresql.org/docs/8.3/static/sql-createtrigger.html I've just run the same set of statements you specified against 8.4.1, 8.4.4 and 9.0 beta2 and

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

this is 8.3.7, for the record. And no, They won't let me update it to 8.3.11 :/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] missing uuid functions in postgresql-contrib RPM for linux?

In the postgresql-contrib-8.4.4-1PGDG.rhel4 RPM (downloaded from http://www.postgresql.org/ftp/binary/v8.4.4/linux/rpms/redhat/rhel-4-i386/), there is no installation script or libraries for the uuid_* functions: # rpm -qlp postgresql-contrib-8.4.4-1PGDG.rhel4.i386.rpm | grep -i uid /usr/share/doc

Re: [GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

2010/6/23 Grzegorz Jaśkiewicz : > consider following example: > > > > CREATE TABLE foob(id serial primary key, name varchar default ''); > CREATE TABLE fooA(id serial primary key, fooB int not null references > fooB(id) on update cascade on delete cascade, name varchar default > ''); > > CREATE FUN

[GENERAL] unexpected effect of FOREIGN KEY ON CASCADE DELETE

consider following example: CREATE TABLE foob(id serial primary key, name varchar default ''); CREATE TABLE fooA(id serial primary key, fooB int not null references fooB(id) on update cascade on delete cascade, name varchar default ''); CREATE FUNCTION foobarrA() RETURNS trigger AS $_$ BEGIN

Re: [GENERAL] how to create an admin user for restore database.

On 23/06/2010 12:21, Raymond O'Donnell wrote: > On 23/06/2010 02:50, Sam Wun wrote: > >> When I launched pgadmin in windows and login as user liferayadmin, >> from the tools menu, the restore command is disabled. >> I think the user "liferayadmin" does not have the privilege to restore >> databas

Re: [GENERAL] how to create an admin user for restore database.

On 23/06/2010 02:50, Sam Wun wrote: > When I launched pgadmin in windows and login as user liferayadmin, > from the tools menu, the restore command is disabled. > I think the user "liferayadmin" does not have the privilege to restore > database. Something else worth checking is whether pgAdmin h

Re: [GENERAL] best way to check pgdump

On 23/06/2010 04:52, Janet Jacobsen wrote: > Hi. What is the best way to check a pgdump > without doing a restore? If you used one of the binary formats for pg_dump, you can have pg_restore list the contents without actually restoring the database. If you did a text dump, just look into the file

Re: [GENERAL] No PL/PHP ? Any reason?

On 23/06/10 02:16, Joshua D. Drake wrote: > On Tue, 2010-06-22 at 13:51 +, Greg Sabino Mullane wrote: > >>> Is there any technical obstacle to anyone creating PL/PHP? I am >>> cruious as to why it doesn't alreay exist. >>> >> Obviously we need to improve our documentation. What led y

[GENERAL] what is the meaning of Datum?

Hi all, ok this is a silly question, but I've got a doubt: what is the exact meaning of Datum? I see having a look at the macroes (e.g., PG_RETURN_XXX) that a Datum can be used as a pointer or as a single data, that is it can be a reference or a value. Is this right? So for instance the fact tha

Re: [GENERAL] libpython - cannot open shared object file

Tom Wilcox writes: > Next problem: "$libdir/fuzzystrmatch": No such file or directory. I guess I > need to install the /share stuff separately.. Looks like apt-get install postgresql-contrib-8.4 should do the trick. http://packages.debian.org/lenny-backports/postgresql-contrib-8.4 Regards, --

Re: [GENERAL] libpython - cannot open shared object file

OK! I have successfully got plpythonu installed. The solution was to remove any and all postgresql installation and files except /data. I then ran this from command line: sudo apt-get install postgresql-plpython-8.4 which installed plpython AND postgresql at the same time. Happy days. Next pr

Re: [GENERAL] Single quotes vs. double quotes when setting a pwd and other cmds

On 23 June 2010 10:41, Alexander Farber wrote: > And identifiers means column names (eventually containing whitespace)? > Columns, tables, schemas, views, triggers, indexes etc. See: http://www.postgresql.org/docs/8.4/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS Regards Thom -- Sent

Re: [GENERAL] Single quotes vs. double quotes when setting a pwd and other cmds

In response to Alexander Farber : > And identifiers means column names (eventually containing whitespace)? Right. test=# select 'foo' as "my new column"; my new column --- foo (1 row) Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr:

Re: [GENERAL] Single quotes vs. double quotes when setting a pwd and other cmds

And identifiers means column names (eventually containing whitespace)? Thank you Alex -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] libpython - cannot open shared object file

On Wed, Jun 23, 2010 at 11:20, Dave Page wrote: > On Wed, Jun 23, 2010 at 10:19 AM, Tom Wilcox wrote: >> Hi, >> >> If I use the apt-get facility on Ubuntu is that supposed to get the >> appropriate postgres version for my OS setup (i.e. 64-bit and Python 2.6) ? > > I would assume so. I'm more of

Re: [GENERAL] libpython - cannot open shared object file

On Wed, Jun 23, 2010 at 10:19 AM, Tom Wilcox wrote: > Hi, > > If I use the apt-get facility on Ubuntu is that supposed to get the > appropriate postgres version for my OS setup (i.e. 64-bit and Python 2.6) ? I would assume so. I'm more of a Redhat guy though. -- Dave Page EnterpriseDB UK: htt

Re: [GENERAL] libpython - cannot open shared object file

Hi, If I use the apt-get facility on Ubuntu is that supposed to get the appropriate postgres version for my OS setup (i.e. 64-bit and Python 2.6) ? Because I think I have done that already and it didn't solve my problem, but I will try again now (first uninstalling the current pg version).

Re: [GENERAL] Single quotes vs. double quotes when setting a pwd and other cmds

In response to Alexander Farber : > Hello, > > why aren't double quotes accepted below? > > db1=# alter user user1 password "pass1"; > ERROR: syntax error at or near ""pass1"" > LINE 1: alter user user1 password "pass1"; > ^ > db1=# alter user user1 password 'pas

Re: [GENERAL] Single quotes vs. double quotes when setting a pwd and other cmds

Hello ANSI SQL uses double quotes only for SQL identifiers. For literals are used single quotes. like SELECT col AS "some strange sql column identifier", 'some string value' FROM "some strange sql table identifier" so for case sensitive or strange (is keyword, contains space) sql identifiers us

Re: [GENERAL] Single quotes vs. double quotes when setting a pwd and other cmds

Le 23/06/2010 11:03, Alexander Farber a écrit : > Hello, > > why aren't double quotes accepted below? > > db1=# alter user user1 password "pass1"; > ERROR: syntax error at or near ""pass1"" > LINE 1: alter user user1 password "pass1"; > ^ > db1=# alter user user1

[GENERAL] Single quotes vs. double quotes when setting a pwd and other cmds

Hello, why aren't double quotes accepted below? db1=# alter user user1 password "pass1"; ERROR: syntax error at or near ""pass1"" LINE 1: alter user user1 password "pass1"; ^ db1=# alter user user1 password 'pass1'; ALTER ROLE Is there a thumb rule to know when

Re: [GENERAL] libpython - cannot open shared object file

On Wed, Jun 23, 2010 at 9:52 AM, Tom Wilcox wrote: > Hi, > > I have not used python2.3 on this machine at all (to my knowledge). It is a > fresh install of the latest Ubuntu 64 which comes with Python 2.6 and 3.1. > > The build I want to run is the 64-bit PostgreSQL download for Linux x86-64 > fro

Re: [GENERAL] libpython - cannot open shared object file

Hi, I have not used python2.3 on this machine at all (to my knowledge). It is a fresh install of the latest Ubuntu 64 which comes with Python 2.6 and 3.1. The build I want to run is the 64-bit PostgreSQL download for Linux x86-64 from Entreprise DB (http://www.enterprisedb.com/products/pgdo

Re: [GENERAL] High Availability with Postgres

John R Pierce writes: > yeah. generally when money is involved in the transactions, you gotta stick > to the 'no committed data lost ever'. there's plenty of other use cases for > that too. Well, it's a cost/benefit/risk evaluation you have to make. It'd be bad news that the cost for covering y

Re: [GENERAL] how to create an admin user for restore database.

Le 23/06/2010 05:17, Sam Wun a écrit : > With user liferayadmin on db liferay, I got the following errors: > > 03:14:50,558 WARN [DBUtil:474] ERROR: permission denied for relation > quartz_locks: insert into QUARTZ_LOCKS values('TRIGGER_ACCESS'); > 03:14:50,567 WARN [DBUtil:474] ERROR: permissio

Re: [GENERAL] disable password prompt - command line

On 23/06/10 7:56 AM, Ravi Katkar wrote: Hi List, I need a small help regarding the password options available with PGSQL, I found POSTGRE SQL has *–W* and *–password* options available which is prompting for the password. But I want to take the password thru command line argument and keep th