Re: [GENERAL] Poor Plan selected w/ not provided a date/time but selecting date/time from a table

2007-10-18 Thread Richard Huxton
Ow Mun Heng wrote: On Wed, 2007-10-17 at 20:37 +0100, Richard Huxton wrote: Your query plans don't seem to match your queries. That makes it difficult to provide meaningful advice. Well, then that makes both you and me(both) stumped. because the 2 queries are exactly the same except for the

Re: [GENERAL]

2007-10-18 Thread Richard Huxton
roopal oswal wrote: Hi all, Initially i installed postgresql 8.2.5 for my Dspace software..everything was fine.. but all of sudden yeterday while connecting an error popped out sayin server could'nt listen i have uninstalled it and reinstalled many a times with different ports and diffferent

Re: [GENERAL] Poor Plan selected w/ not provided a date/time but selecting date/time from a table

2007-10-18 Thread Ow Mun Heng
On Thu, 2007-10-18 at 07:28 +0100, Richard Huxton wrote: Ow Mun Heng wrote: On Wed, 2007-10-17 at 20:37 +0100, Richard Huxton wrote: Your query plans don't seem to match your queries. That makes it difficult to provide meaningful advice. Well, then that makes both you and me(both)

Re: [GENERAL] dblink and hostname resolution problem

2007-10-18 Thread postgresql . * . thewild
[EMAIL PROTECTED] a écrit : Hi list! I am using DBLink on a Win32 system running PostgreSQL 8.2 to query a table on another similar system (Win32 / PostgreSQL 8.2). If I query the server with dblink('hostaddr=ip_address ...', ...), it works fine, but if I try to use the hostname instead

Re: [GENERAL] Suggestions for Remote Procedure Calls from PG, please?

2007-10-18 Thread Jorge Godoy
Em Thursday 18 October 2007 01:44:33 Bret Schuhmacher escreveu: Thanks for the reply, Tom. I was thinking I could have my remote process send a message back to PG via XMLBlaster, too. XMLBlaster is a MOM-like message-queuing app that guarantees delivery to subscribers. (www.xmlblaster.org).

Re: [GENERAL] move databases files location

2007-10-18 Thread jehan.procaccia
Richard Huxton wrote: jehan.procaccia wrote: my postgresql installation from redhat package: $ rpm -q postgresql postgresql-7.4.17-1.RHEL4.1 is located in /var partition, unfortunalty it is nearly full $ df -H . Filesystem Size Used Avail Use% Mounted on /dev/sda12

[GENERAL] a failover scenario

2007-10-18 Thread Tomi N/A
I am considering pgsql as the RDBMS in a project with the following constraints: - there's a master and reserve instance of the RDBMS on every remote location - there's a master and reserve instance of the RDBMS on a central location - the connections are DSL connections and therefore unreliable -

Re: [GENERAL] Poor Plan selected w/ not provided a date/time but selecting date/time from a table

2007-10-18 Thread Alvaro Herrera
Ow Mun Heng wrote: On Wed, 2007-10-17 at 22:47 -0300, Alvaro Herrera wrote: Ow Mun Heng wrote: Index Cond: ((audit_key_dtime = $0) AND (audit_key_dtime $1)) Index Cond: ((audit_key_dtime = '2007-08-08 18:00:00'::timestamp without time zone) AND

Re: [GENERAL] a failover scenario

2007-10-18 Thread Bill Moran
In response to Tomi N/A [EMAIL PROTECTED]: I am considering pgsql as the RDBMS in a project with the following constraints: - there's a master and reserve instance of the RDBMS on every remote location - there's a master and reserve instance of the RDBMS on a central location - the

[GENERAL] Crosstab Problems

2007-10-18 Thread Stefan Schwarzer
Hi there, successfully installed the tablefunc package. Now, I would like to transform this kind of result based on a normal SQL: c_name |year|value --- Germany | 2001| 123 Germany | 2002| 125 Germany

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Tom Lane
Stefan Schwarzer [EMAIL PROTECTED] writes: I had a couple of problems getting there. But now that I have the feeling that this is OK, it tells me this: server closed the connection unexpectedly Could you provide a self-contained test case for this? There's not really enough information

[GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
Hi, Several groups I post most of them does not answer. Did noone see my postings ? Please at least give me one answer :-) Thanks, Lothar ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread brian
Lothar Behrens wrote: Hi, Several groups I post most of them does not answer. Did noone see my postings ? Please at least give me one answer :-) Thanks, Lothar ping What was your query? ---(end of broadcast)--- TIP 5: don't forget to

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Stefan Schwarzer
Could you provide a self-contained test case for this? There's not really enough information here for someone else to duplicate the problem. Also, which PG version are you using? Wasn't sure what you ment with a self containted test case. Is it the raw data? Here is a SQL dump for the

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Pavel Stehule
2007/10/18, Lothar Behrens [EMAIL PROTECTED]: Hi, Several groups I post most of them does not answer. Did noone see my postings ? Please at least give me one answer :-) Thanks, Lothar I see your post Pavel ---(end of broadcast)--- TIP 2:

[GENERAL] running postgres

2007-10-18 Thread Ken Johansson
and i though PostgreSQL would be easier to get up and running than SQL server -- Ken

Re: [GENERAL] running postgres

2007-10-18 Thread brian
Ken Johansson wrote: and i though PostgreSQL would be easier to get up and running than SQL server Question? Complaint? Thinking out loud? Lyrics to a song? We're all standing by, Ken! ---(end of broadcast)--- TIP 3: Have you

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Tom Lane
Stefan Schwarzer [EMAIL PROTECTED] writes: Here is a SQL dump for the table. One can just neglect the JOIN with the countries table (which just replaces the country id with the country name): http://geodata.grid.unep.ch/download/sql_agri_area.sql.zip But when re-doing the query now

Re: [GENERAL] running postgres

2007-10-18 Thread Scott Marlowe
On 10/18/07, Ken Johansson [EMAIL PROTECTED] wrote: and i though PostgreSQL would be easier to get up and running than SQL server I sincerely hope you don't consider that the sole criteria for choosing databases. Personally, I found it quite easy. apt-get install postgresqlp8.2

[GENERAL] Problem of installation on Mac

2007-10-18 Thread Lizhe . Xu
Hi, I am a newbie for pgsql and tried to install it on my MacBookPro Intel. I got everything correct until creating the user: postgres and initdb, then the error message showed up for running the db. How to fix the problem? LizheXusComputer:/Users/lizhexu pgsql$ /usr/local/pgsql/bin/postgres

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
On 18 Okt., 17:17, [EMAIL PROTECTED] (brian) wrote: Lothar Behrens wrote: Hi, Several groups I post most of them does not answer. Did noone see my postings ? Please at least give me one answer :-) Thanks, Lothar ping What was your query? I do convert an UML XMI model to a

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Scott Marlowe
On 10/18/07, Stefan Schwarzer [EMAIL PROTECTED] wrote: Could you provide a self-contained test case for this? There's not really enough information here for someone else to duplicate the problem. Also, which PG version are you using? Wasn't sure what you ment with a self containted test

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Farhan Mughal
Gotcha! - Original Message From: Lothar Behrens [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Thursday, 18 October, 2007 7:40:54 PM Subject: [GENERAL] Am I overseen ? Hi, Several groups I post most of them does not answer. Did noone see my postings ? Please at least give

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Scott Marlowe
On 10/18/07, Lothar Behrens [EMAIL PROTECTED] wrote: On 18 Okt., 17:17, [EMAIL PROTECTED] (brian) wrote: Lothar Behrens wrote: Hi, Several groups I post most of them does not answer. Did noone see my postings ? Please at least give me one answer :-) Thanks, Lothar ping

Re : [GENERAL] pg_dump - schema diff compatibility

2007-10-18 Thread Laurent ROCHE
Hi, May be a solution will be to make a diff fo the XML file produced by another tool: DdlUtils (http://db.apache.org/ddlutils/) ! However, DdlUtils won't produce a file with all PG elements (no user types, views, triggers, ...). Have fun, [EMAIL PROTECTED] The Computing Froggy -

Re: [GENERAL] Problem of installation on Mac

2007-10-18 Thread Gavin M. Roy
I just install it as my own user on my laptop... I usually do something like ./configure --prefix=/Users/myaccount/pgsql make make install then cd ~/ pgsql/bin/initdb -D /Users/myaccount/pgsql/data pgsql/bin/pg_ctl _D /Users/myaccount/pgsql/data start and I'm off to the races ;-) Good luck!

[GENERAL] ordering rows

2007-10-18 Thread Bob Pawley
Hi I have a table 'import' which is an amalgam of two other tables 'loops' and 'devices'. The ID column of loops is reflected in the import table. However the order of rows ends up as, a for instance, 6, 8, 7, 4, 5 3, 2, 1. I need to fetch these rows one at a time, in sequence with the loop

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Scott Marlowe
On 10/18/07, Stefan Schwarzer [EMAIL PROTECTED] wrote: But when re-doing the query now without the JOIN, it works (almost): SELECT * FROM crosstab( 'SELECT id_country AS id, year_start AS year, value FROM agri_area

Re: [GENERAL] running postgres

2007-10-18 Thread Ken Johansson
Hello, Sorry everyone for the stupid rant. Wont happen again. And thanks for offer assistance. I seem to have it running and once i have a valid question ill post it. Sorry again.. Ken On 18/10/2007, brian [EMAIL PROTECTED] wrote: Ken Johansson wrote: and i though PostgreSQL would be

Re: [GENERAL] ordering rows

2007-10-18 Thread brian
Bob Pawley wrote: Hi I have a table 'import' which is an amalgam of two other tables 'loops' and 'devices'. The ID column of loops is reflected in the import table. However the order of rows ends up as, a for instance, 6, 8, 7, 4, 5 3, 2, 1. These are the IDs from loops? I need to fetch

Re: [GENERAL] running postgres

2007-10-18 Thread Scott Marlowe
On 10/18/07, Ken Johansson [EMAIL PROTECTED] wrote: Hello, Sorry everyone for the stupid rant. Wont happen again. And thanks for offer assistance. I seem to have it running and once i have a valid question ill post it. Don't worry about it. We've all had to cut our teeth sometime. And

Re: [GENERAL] running postgres

2007-10-18 Thread brian
Ken Johansson wrote: Hello, Sorry everyone for the stupid rant. Wont happen again. And thanks for offer assistance. I seem to have it running and once i have a valid question ill post it. Sorry again.. Ken We'll put it down as thinking out loud then. It happens. ;-) brian

Re: [GENERAL] ordering rows

2007-10-18 Thread Bob Pawley
That's marvelous - thanks. Bob - Original Message - From: brian [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Thursday, October 18, 2007 9:45 AM Subject: Re: [GENERAL] ordering rows Bob Pawley wrote: Hi I have a table 'import' which is an amalgam of two other tables

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
On 18 Okt., 18:22, [EMAIL PROTECTED] (Scott Marlowe) wrote: On 10/18/07, Lothar Behrens [EMAIL PROTECTED] wrote: On 18 Okt., 17:17, [EMAIL PROTECTED] (brian) wrote: Lothar Behrens wrote: Hi, Several groups I post most of them does not answer. Did noone see my postings ?

[GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Laurent ROCHE
Hi, I am quite surprised I could not find a way to automatically reset the value of a sequence for all my tables. Of course, I can write: SELECT setval('serial', max(id)) FROM distributorsBut if I reload data into all my tables, it's a real pain to have to write something like this for every

Re: [GENERAL] Problem of installation on Mac

2007-10-18 Thread Shane Ambler
[EMAIL PROTECTED] wrote: Hi, I am a newbie for pgsql and tried to install it on my MacBookPro Intel. I got everything correct until creating the user: postgres and initdb, then the error message showed up for running the db. How to fix the problem? LizheXusComputer:/Users/lizhexu pgsql$

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread brian
Lothar Behrens wrote: On 18 Okt., 18:22, [EMAIL PROTECTED] (Scott Marlowe) wrote: Normally when you get thundering silence, you've asked a question no one feels real qualified to answer, and rather than answer it halfway, they just leave it for the next guy to get. In my opinion the

Re: [GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Filip Rembiałkowski
2007/10/18, Laurent ROCHE [EMAIL PROTECTED]: Hi, I am quite surprised I could not find a way to automatically reset the value of a sequence for all my tables. Of course, I can write: SELECT setval('serial', max(id)) FROM distributors But if I reload data into all my tables, it's a real

Re: [GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Alan Hodgson
On Thursday 18 October 2007, Laurent ROCHE [EMAIL PROTECTED] wrote: Hi, I am quite surprised I could not find a way to automatically reset the value of a sequence for all my tables. Of course, I can write: SELECT setval('serial', max(id)) FROM distributorsBut if I reload data into all my

[GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Laurent ROCHE
Hi, I have a problem with pg_dump generating a code with no SERIALs id but with SEQUENCEs instead: if I write in a SERIAL I want to see a SERIAL, even when I reload the database. We had this conversation before on this mailing list and I was told that's because SERIAL is just a kind of macro

Re : [GENERAL] Am I overseen ?

2007-10-18 Thread Laurent ROCHE
Hi, You might want to have a look at DdlUtils that does similar things that you want to do: compare databases schemas using XML files and synchronising the schemas. Interesting tool ! ! http://db.apache.org/ddlutils/ Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine

Re: [GENERAL] Problem of installation on Mac

2007-10-18 Thread Lizhe . Xu
Thank you very much Shane. It fixed my problem, at least now :-). I installed the pgsql 8.2.5 from source. The user postgres has a shortname of pgsql. Another question, what's the purpose/advantage to create a user of postgres? May I just create the database under my user account?

Re : [GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Laurent ROCHE
It is not as easy as that : 1/ select table_name from information_schema.tables does not give you the tables list on the current schema but the list of all objects ! But the following will SELECT c.relname FROM pg_namespace AS nc, pg_class AS c WHERE c.relnamespace = nc.oid AND c.relkind IN

Re: [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Andreas Kretschmer
Laurent ROCHE [EMAIL PROTECTED] schrieb: Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not dropped, however when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too ! I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY does not exist ! ! ! Read this message: [EMAIL PROTECTED]

Re: [GENERAL] running postgres

2007-10-18 Thread Richard Huxton
Scott Marlowe wrote: On 10/18/07, Ken Johansson [EMAIL PROTECTED] wrote: and i though PostgreSQL would be easier to get up and running than SQL server I sincerely hope you don't consider that the sole criteria for choosing databases. I don't know - it's put me off MS-SQL in a

Re: Re : [GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
I think this is not the way I should go. My application is a database prototype design tool that also is able to run the design because the designer it self is a design. So I did not only need a DDL to create the target application's database, also I need to feed a model into the system

Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Laurent ROCHE
Yep, of course but what's the situation for people using 8.1 and pg_dump that does not generate code with SERIAL ? Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Andreas Kretschmer [EMAIL PROTECTED] À : pgsql-general@postgresql.org Envoyé le : Jeudi, 18

Re: [GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Martijn van Oosterhout
On Thu, Oct 18, 2007 at 10:06:00AM -0700, Laurent ROCHE wrote: Hi, I am quite surprised I could not find a way to automatically reset the value of a sequence for all my tables. I never bother resetting sequences. It's not like the numbers mean anything... Have a nice day, -- Martijn van

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
On 18 Okt., 19:33, [EMAIL PROTECTED] (brian) wrote: Lothar Behrens wrote: On 18 Okt., 18:22, [EMAIL PROTECTED] (Scott Marlowe) wrote: Normally when you get thundering silence, you've asked a question no one feels real qualified to answer, and rather than answer it halfway, they just leave

Re: Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Alvaro Herrera
Laurent ROCHE wrote: Yep, of course but what's the situation for people using 8.1 and pg_dump that does not generate code with SERIAL ? They grab 8.2's pg_dump and connect with it to their 8.1 server, to generate a dump that does. -- Alvaro Herrera

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Joe Conway
Tom Lane wrote: so it's trying to pstrdup a null result from SPI_getvalue. Obviously it shouldn't crash, but I'm not sure what it *should* do in this case. Joe? The row is pretty useless without a rowid in this context -- it seems like the best thing to do would be to skip those rows

[GENERAL] Abbreviation list

2007-10-18 Thread Steve Crawford
Is there a comprehensive (or semi-comprehensive) on-line list of commonly used PG-related abbreviations used in PostgreSQL documentation, mail-lists, etc.? If there is not, would such a list make a reasonable one-page addition to the PG manual? Things like GUC and DDL for example. Couldn't find

Re: [GENERAL] Abbreviation list

2007-10-18 Thread Alvaro Herrera
Steve Crawford wrote: Is there a comprehensive (or semi-comprehensive) on-line list of commonly used PG-related abbreviations used in PostgreSQL documentation, mail-lists, etc.? If there is not, would such a list make a reasonable one-page addition to the PG manual? I don't think we have one,

Re: Re : [GENERAL] Am I overseen ?

2007-10-18 Thread Tom Lane
Lothar Behrens [EMAIL PROTECTED] writes: When there is a way to optionally add columns to existing tables via SQL I have very less development needs to get this working. Why don't you just issue the ALTER ADD COLUMN and ignore the error if it's duplicate column? Or if you don't like that,

[GENERAL] Did pg_dumpall and imported, NEED TO START OVER

2007-10-18 Thread Ralph Smith
I'm preparing to upgrade and am practicing. I'm using v7.4 I created a blank .7.4 to import a pg_dumpall into. (Also a v8.2 to upgrade to.) The encoding was wrong and I have a lot of: psql:/tmp/cluster_pg_dumpall.txt:4382: ERROR: invalid byte sequence for encoding UTF8: 0x91 HINT:

[GENERAL] autovacuum and locks

2007-10-18 Thread Dietmar Maurer
Hi all, recently our application was locked, and postgres shows several processes in LOCK TABLE waiting state. Even the autovacuum process is stalled. The pg_locks table shows the following: SELECT pg_class.relname AS table, transaction, pid, mode, granted FROM pg_locks, pg_class, pg_database

[GENERAL] PG/Tcl and Expect?

2007-10-18 Thread Bret Schuhmacher
Does the PG/Tcl interface allow expect scripts? I want to create a stored procedure that ssh's to another server and runs a Perl script. Expect could do it, but can I load the expect module from pgtcl? Thanks, Bret

re[GENERAL] lations does not exist

2007-10-18 Thread ctorres
Hi, I doing a simple insert into a table re Perl/DBI INSERT INTO party (party_id, party_type_id, description, status_id) VALUES ($partyId, 'PERSON', 'Initial Import','PARTY_ENABLED') and I'm getting a ERROR: relations party does not exist I get the same error

Re: Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Laurent ROCHE wrote: Yep, of course but what's the situation for people using 8.1 and pg_dump that does not generate code with SERIAL ? They grab 8.2's pg_dump and connect with it to their 8.1 server, to generate a dump that does. Actually, I bet the

Re: [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Erik Jones
On Oct 18, 2007, at 1:02 PM, Andreas Kretschmer wrote: Laurent ROCHE [EMAIL PROTECTED] schrieb: Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not dropped, however when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too ! I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY

Re: [GENERAL] Group By question

2007-10-18 Thread Jeff Lanzarotta
Okay, actually the query is something like: select dept, (col1 + col2) * col3) from table group by dept So, the output would look something like: DeptTotal -- --- 1 26 2 18 3 9 Sam Mason [EMAIL PROTECTED] wrote: On Tue, Oct 16, 2007 at 07:46:34AM -0700,

[GENERAL] Fetch

2007-10-18 Thread Bob Pawley
When I fetch a row it returns a row number. Is there a method under the fetch command of either not returning the row number or of ignoring it after it is returned. begin work; Declare loop_set Cursor for Select one, two from loop_import order by loop_id ; fetch

[GENERAL] pg_dumpall's subseq IMPORT ERRORS

2007-10-18 Thread Ralph Smith
I looked farther up the STDOUT/STDERR of the psql import using the file from a pg_dumpall There are tons of errors there besides encoding. Sample errors: psql:/tmp/cluster_pg_dumpall.txt:10: ERROR: role airburst does not exist SET psql:/tmp/cluster_pg_dumpall.txt:14: ERROR:

Re: re[GENERAL] lations does not exist

2007-10-18 Thread Adrian Klaver
On Tuesday 16 October 2007 12:20 pm, ctorres wrote: Hi, I doing a simple insert into a table re Perl/DBI INSERT INTO party (party_id, party_type_id, description, status_id) VALUES ($partyId, 'PERSON', 'Initial Import','PARTY_ENABLED') and I'm getting a

Re: [GENERAL] a failover scenario

2007-10-18 Thread Tomi N/A
2007/10/18, Bill Moran [EMAIL PROTECTED]: I don't know of any system that will just hand you those capabilities. Every multi-master system I've ever heard of requires high-speed links between the masters, otherwise the synchronization is far too slow to be usable. I supposed so. However, I

Re: [GENERAL] variable in COPY table TO variable

2007-10-18 Thread Rob Shepherd
A case for dynamic SQL!http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQ L-STATEMENTS-EXECUTING-DYN Yours, Laurenz Albe ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings Perfect.

Re: re[GENERAL] lations does not exist

2007-10-18 Thread Alan Hodgson
On Tuesday 16 October 2007, ctorres [EMAIL PROTECTED] wrote: Hi, I doing a simple insert into a table re Perl/DBI INSERT INTO party (party_id, party_type_id, description, status_id) VALUES ($partyId, 'PERSON', 'Initial Import','PARTY_ENABLED') and I'm

Re: [GENERAL] Determining oldest WAL for Archiving PITR Standby - SOLVED

2007-10-18 Thread Brian Wipf
On 17-Oct-07, at 12:01 AM, Brian Wipf wrote: I'm working on a script that takes backups in intervals from our warm PITR stand by server (both servers running PG 8.2.5). The documentation advises running pg_controldata on the standby server to inspect the control file and determine the

Re : Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Laurent ROCHE
Not good because in that case pg_dump will generate code that can not run in 8.1 ... like : ALTER SEQUENCE ... OWNED BY Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Alvaro Herrera [EMAIL PROTECTED] À : Laurent ROCHE [EMAIL PROTECTED] Cc : Andreas

Re : [GENERAL] Abbreviation list

2007-10-18 Thread Laurent ROCHE
Yep, having a list would be good ! To answer your question, DDL is not a PG (here is another one) abbreviation but a database abbreviation. It stands for Data Definition Language ... and basically that means SQL orders to manage objects (CREATE, DROP, ALTER) see Wikipedia for more info. No

Re : Re : [GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Laurent ROCHE
Hi, So nobody can help me to write the SELECT that will return the SEQUENCE names, and their linked columns and their linked tables ? Are the system tables documented somewhere ? Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Laurent ROCHE [EMAIL PROTECTED]

Re: [GENERAL] Determining oldest WAL for Archiving PITR Standby - SOLVED

2007-10-18 Thread Brian Wipf
On 18-Oct-07, at 3:15 PM, Brian Wipf wrote: The offset is the last 6 hex digits of the checkpoint location value. The offset contains leading zeros to make it 6 digits if its actual value is less than 6 digits. Therefore, the digits between the slash and the last 6 digits are the log

Re: Re : [GENERAL] Abbreviation list

2007-10-18 Thread Raymond O'Donnell
On 18/10/2007 22:26, Laurent ROCHE wrote: No idea what GUC is, though ! Grand Unified Contraption? ;-) Ray (who's just been reading Jules Verne). --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL

Re: [GENERAL] XMIN semantic at peril ?

2007-10-18 Thread Karsten Hilbert
On Thu, Oct 11, 2007 at 12:03:47PM -0400, Tom Lane wrote: If in the meantime another writer changed the data we originally read we would detect that by xmin having changed hence no row to be updated. So, yes, there is a *tiny* failure condition: Hmm. I think the failure condition is

Re: Re : Re : [GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Alvaro Herrera
Laurent ROCHE wrote: Hi, So nobody can help me to write the SELECT that will return the SEQUENCE names, and their linked columns and their linked tables ? Are the system tables documented somewhere ? Of course -- in the internals section. You need pg_class where relkind = 's', pg_depend,

Re: Re : Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Douglas McNaught
Laurent ROCHE [EMAIL PROTECTED] writes: Not good because in that case pg_dump will generate code that can not run in 8.1 ... like : ALTER SEQUENCE ... OWNED BY Dumps produced by version X of pg_dump have never been guaranteed to load into earlier versions. -Doug

Re: [GENERAL] Group By question

2007-10-18 Thread brian
Jeff Lanzarotta wrote: Sam Mason [EMAIL PROTECTED] wrote: On Tue, Oct 16, 2007 at 07:46:34AM -0700, Jeff Lanzarotta wrote: Hello, I have a table that looks something like this: SKU Dept Col1 Col2 Col3 --- -- --- --- -- 1112 3

Re: [GENERAL] Abbreviation list

2007-10-18 Thread Harald Armin Massa
I prefer the manual. I would think the list would be pretty long and deal with lots of internals terms. Also the manual has more reference character; as we saw with GUC in this discussion it is still possible to find a CORRECT definition of them. Harald -- GHUM Harald Massa persuadere et

Re: [GENERAL] PG/Tcl and Expect?

2007-10-18 Thread A. Kretschmer
am Tue, dem 16.10.2007, um 21:55:38 -0700 mailte Bret Schuhmacher folgendes: Does the PG/Tcl interface allow expect scripts? I want to create a stored procedure that ssh's to another server and runs a Perl script. Expect could do it, but can I load the expect module from pgtcl? I think,

Re: [GENERAL] Abbreviation list

2007-10-18 Thread Tom Lane
Steve Crawford [EMAIL PROTECTED] writes: My vote is to add Appendix I. Abbreviations. It seems more like FAQ material than something for the manual. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our

Re: Re : [GENERAL] Abbreviation list

2007-10-18 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Steve Crawford wrote: Raymond O'Donnell wrote: On 18/10/2007 22:26, Laurent ROCHE wrote: No idea what GUC is, though ! It's Global User Configuration. But the confusion does point out the need for a reference. I think it is Grand Unified

Re: Re : [GENERAL] Abbreviation list

2007-10-18 Thread Alvaro Herrera
Steve Crawford wrote: Raymond O'Donnell wrote: On 18/10/2007 22:26, Laurent ROCHE wrote: No idea what GUC is, though ! Grand Unified Contraption? ;-) Ray (who's just been reading Jules Verne). It's Global User Configuration. But the confusion does point out the need for a

Re: Re : [GENERAL] Abbreviation list

2007-10-18 Thread Steve Crawford
Raymond O'Donnell wrote: On 18/10/2007 22:26, Laurent ROCHE wrote: No idea what GUC is, though ! Grand Unified Contraption? ;-) Ray (who's just been reading Jules Verne). It's Global User Configuration. But the confusion does point out the need for a reference. -Steve

Re: [GENERAL] Abbreviation list

2007-10-18 Thread Steve Crawford
Alvaro Herrera wrote: Steve Crawford wrote: Is there a comprehensive (or semi-comprehensive) on-line list of commonly used PG-related abbreviations used in PostgreSQL documentation, mail-lists, etc.? If there is not, would such a list make a reasonable one-page addition to the PG manual? I

Re: [GENERAL] running postgres

2007-10-18 Thread Jorge Godoy
Em Thursday 18 October 2007 14:57:27 brian escreveu: Ken Johansson wrote: Hello, Sorry everyone for the stupid rant. Wont happen again. And thanks for offer assistance. I seem to have it running and once i have a valid question ill post it. Sorry again.. Ken We'll put it

Re: [GENERAL] Abbreviation list

2007-10-18 Thread Bruce Momjian
Tom Lane wrote: Steve Crawford [EMAIL PROTECTED] writes: My vote is to add Appendix I. Abbreviations. It seems more like FAQ material than something for the manual. I prefer the manual. I would think the list would be pretty long and deal with lots of internals terms. -- Bruce Momjian

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Jorge Godoy
Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu: Tom Lane wrote: so it's trying to pstrdup a null result from SPI_getvalue. Obviously it shouldn't crash, but I'm not sure what it *should* do in this case. Joe? The row is pretty useless without a rowid in this context -- it

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Tom Lane
Jorge Godoy [EMAIL PROTECTED] writes: Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu: The row is pretty useless without a rowid in this context -- it seems like the best thing to do would be to skip those rows entirely. Of course you could argue I suppose that it ought to throw an

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Joe Conway
Tom Lane wrote: Jorge Godoy [EMAIL PROTECTED] writes: Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu: The row is pretty useless without a rowid in this context -- it seems like the best thing to do would be to skip those rows entirely. Of course you could argue I suppose that it