[GENERAL] CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT again

Hello! According to Tom's message http://archives.postgresql.org/pgsql-general/2005-06/msg00476.php we have the stuff supposed to return number of rows affected by CREATE .. AS SELECT or SELECT ... INTO in 8.1 beta. The patch is at place, though PQcmdTuples returns nothing. It's not a big surpris

[GENERAL] how to list rules?

Dear all, I am new to PostgreSQL. I am experementing with rules. There is a way to create and drop rules but I did not find a way to list all existing rules. How do I view rules that I have? Thanks a lot in advance Oleg ---(end of broadcast)---

Re: [GENERAL] Block Size and various FS settings

After a week of testing i decided to go with JFS as the FS for Postgres. im not an expert benchmarker so i hope i initiated the right parameters in bonnie. Any way here are the results of bonnie++ & pgbench: http://www.canaan.co.il/users/miki/stats/stats.html Cheers Michael Ben-Nes wrot

[GENERAL] Upgrade instructions ->7.4.8/8.0.3 incomplete regarding tsearch2

Hello! I am currently trying to import a 8.0.1 database dump into a 8.0.3 installation. I, too, have at first stumbled over the tsearch2-issue which is explained here: http://www.postgresql.org/docs/8.0/static/release-7-4-8.html (should make a rule to thoroughly read the upgrade notes first :) )

Re: [GENERAL] "Unsubcribe"

# [EMAIL PROTECTED] / 2005-09-13 18:28:07 -0700: > Please...help me.. > How to unsubcribe Look at the headers of any message posted to the list. -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http

[GENERAL] XlogFlus error message

I've a problem with my postgresql database Version : 7.2.4 Os: Mandrake Linux release 8.2 Kernel 2.4.20 I get this king of error ERROR: XLogFlush: request 14D/F77EFE94 is not satisfied --- flushed only to 14D/F75CD1B0 ---(end of broadcast)--- TI

Re: [GENERAL] oracle's first_value function for postgres?

* Tom Lane ([EMAIL PROTECTED]) wrote: > Stephen Frost <[EMAIL PROTECTED]> writes: > > * Ben ([EMAIL PROTECTED]) wrote: > >> Sweet, indeed it is. DISTINCT ON seems to be a postgresism, but I can > >> live with that. > > > Uhhh, I was pretty sure it was standard SQL... > > Nope, definitely a Postgr

Re: [GENERAL] how to list rules?

On Wed, Sep 14, 2005 at 10:05:15AM +0200, Oleg wrote: > I am new to PostgreSQL. I am experementing with rules. There is a way to > create and drop rules but I did not find a way to list all existing > rules. How do I view rules that I have? In psql "\d tablename" shows a table's rules; otherwise

[GENERAL] buffer manager

hi i'm working on typical problem of comparing buffer manager's policies (MRU/LRU/FIFO) and working on postgresql 8-03 . I read old versiona and beta version and found 8-03 uses LRU 2q and the newer beta version is using simple LRU but this time global buffer lock is used removing vacum process

[GENERAL] Backup and Restore mechanism in Postgres

Hi, I have a 4 proc. AMD Opteron machine with 32 GB RAM and ~400GB HDD and a 40GB database. I need to take backup of this database and restore it some other location (say some test environment). I am currently using pg_dump and pg_restore utilities to get this done which takes 4-5 hrs for a du

Re: [GENERAL] index and ilke question

SHOW ALL list all show the value of a run-time parameter. LC_COLLATE String sort order LC_CTYPE Character classification (What is a letter? Its upper-case equivalent?) LC_MESSAGES Language of messages LC_MONETARY Formatting of currency amounts LC_NUMERIC Formatting of

Re: [GENERAL] buffer manager

On Tue, Sep 13, 2005 at 04:38:27AM +, ravi chotalia wrote: > hi > i'm working on typical problem of comparing buffer manager's policies > (MRU/LRU/FIFO) and working on postgresql 8-03 . I read old versiona and > beta version and found 8-03 uses LRU 2q and the newer beta version is using > si

[GENERAL] C-JDBC experiences

To introduce myself, my name is Arjan van Krimpen and I work currently for Stichting Kennisnet in the Netherlands. At the moment we're in the starting phase of a project for which we consider using C-JDBC. The aim of the project is to implement a new central authentication (and in some cas

Re: [GENERAL] buffer manager

"ravi chotalia" <[EMAIL PROTECTED]> writes: > is there any version where simple LRU is used with 8-0-3's vacum > and BufferStrategyCDB stuff. No. There never will be either, because that code is completely gone in CVS tip. [ This seems a tad off-topic for pgsql-general... ]

Re: [GENERAL] XlogFlus error message

"philip johnson" <[EMAIL PROTECTED]> writes: > I've a problem with my postgresql database > Version : 7.2.4 That's an awfully old version, with a lot of known problems. You should at least be running 7.2.8, and preferably thinking about an update to a newer release series. > I get this king of e

Re: [GENERAL] Ranking Results

On Sep 13, 2005, at 3:07 PM, Craig wrote: Hi   I have a query that is grouping by 3 fields and returning a sum of another field. I would also like a further field to be returned that shows a ranking for the records based on the sum field. This should really only be a numbering of the rows returned

Re: [GENERAL] XlogFlus error message

I know. I'm working on an upgrade to postgresql 8.0.3 The big deal is to migrate openfts with tsearch V1 to new version. I've tried to use pg_resetxlog, but not successful. The I've tried to reindex the database. Same problem. Now I came back to a normal state with a backup of the database from t

Re: [GENERAL] Speed problems

On Tue, 2005-09-13 at 21:01, Warren Bell wrote: > >On Tue, 2005-09-13 at 13:20, Warren Bell wrote: > >> I am having problems with performance. I think this is a simple question > and > >> I am in the right place, if not, please redirect me. > >> > >> I have a table with 36 fields that slows down qu

Re: [GENERAL] Block Size and various FS settings

On Wed, 2005-09-14 at 11:25 +0300, Michael Ben-Nes wrote: > After a week of testing i decided to go with JFS as the FS for Postgres. > > im not an expert benchmarker so i hope i initiated the right parameters > in bonnie. > > > Any way here are the results of bonnie++ & pgbench: > > > http://

[GENERAL] ERROR: cursor 'xxx' does not exist

I had a problem with a program that load about 2 MB of information from de DB with a rate of data transfer about 80K. I don´t know why the 'top' of 80K, but is not harware. I still have this problem. Then I set the "Use Declare/Fetch" opcion on the ODBC. This opcion take the information to trans

[GENERAL] TSearch2 snowball version error

    Hi,     I'm trying compile a new brazilian portuguese dictionary to TSearch2 contrib, but found the errors: portuguese_stem.c: In function `r_prelude': portuguese_stem.c:481: error: void value not ignored as it ought to be portuguese_stem.c:487: error: void value not ignored as it ought to be

Re: [GENERAL] Speed problems

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe > Sent: Wednesday, September 14, 2005 8:24 AM > To: Warren Bell > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Speed problems > > > On Tue, 2005-09-13 at 21:01, Warren Bell wrot

Re: [GENERAL] buffer manager

Alvaro Herrera wrote: IIRC Neil Conway posted a patch to make 8.0.2 use LRU instead of ARC, when the whole patent issue arised. http://archives.postgresql.org/pgsql-patches/2005-01/msg00253.php -Neil ---(end of broadcast)--- TIP 9: In versions b

[GENERAL] importing shape files nightmare!

I have two machines, suse and gentoo suse: select version(); PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 20050117 (prerelease) (SUSE Linux) select postgis_full_version(); POSTGIS="1.0.3" PROJ="Rel. 4.4.8, 3 May 2004" USE_STATS DBPROC="0.3.0" RELPROC="0.3.0" gentoo: s

[GENERAL] Howto create a plperlu function as user (not superuser)??

Hi, I have a PostGIS enabled Postgres database. For institutional (un)reasons I'm the database owner in all but reality. I'm writing a plperl function to get the lat & lon coords from a geometry and execute a system call to get the depth (or altitude) at a location from a global datamodel. So

Re: [GENERAL] Replication

On 9/13/05 2:45 PM, "Scott Marlowe" <[EMAIL PROTECTED]> wrote: > On Tue, 2005-09-13 at 10:45, Russ Brown wrote: >> Simon Riggs wrote: >>> Barry, >>> >>> You can use PITR to archive transaction logs to a second server that is >>> kept in standby mode. >>> >>> This will cope with any number of

Re: [GENERAL] how to supress Notice messages or decrease verbosity level

Keve Nagy wrote: > I get NOTICE messages messing up the screen, telling me the obvious > thing that indexes had to be created for the UNIQUE or PRIMARY KEY > constraint. If anybody else is interested, the solution is: SET LOCAL client_min_messages TO 'warning'; This will suppress all NOTICE mess

Re: [GENERAL] Pushing result set to table on different machine?

On Tue, 13 Sep 2005, Jerry LeVan wrote: > Hi, > I recently added a linux/windows laptop to our home network. > > I have started Postgresql (8.0.3) on the laptop and have > "replicated" my main database on the laptop. (pg_dump, > ftp and pg-"undump"). > > I would like to keep them reasonably in s

Re: [GENERAL] Partial dates

On Tue, 13 Sep 2005, Joshua D. Drake wrote: > > > > ERROR: date/time field value out of range: "1997-10-00" > > HINT: Perhaps you need a different "datestyle" setting. > > CONTEXT: COPY Entry, line 1, column EntryDate: "1997-10-00" > > Well the easy solution is to just make the date a text ty

Re: [GENERAL] Partial dates

On Wed, Sep 14, 2005 at 03:49:29PM +1200, Brent Wood wrote: > In case anyone is interested, right now we store year, month & day and > have a timestamp field where the entire field is null if any one part is > unknown. > > Are there any better ways in Postgres? You can create a new type, which i

Re: [GENERAL] Speed problems

On Wednesday 14 September 2005 08:23, Scott Marlowe wrote: > OK. But how many are you updating between regular vacuums? That's the > real issue. If your regular vacuums aren't often enough, postgresql > starts lengthening the tables instead of reusing the space in them that > was freed by the l

Re: [GENERAL] Howto create a plperlu function as user (not superuser)??

Brent Wood <[EMAIL PROTECTED]> writes: > That is not me. Sigh. Is there any way I can develop (with the various > "create or replace function" iterations this wiil probably require) this > plperlu function as a non superuser? If you could, it would be a security hole, which we would fix with utmos

Re: [GENERAL] MS SQL - PostgreSQL

Am Donnerstag, den 15.09.2005, 07:43 +0700 schrieb Irfan Syukur: > Dear Tino, > > In MS SQL, I can execute store procedure that I do not know it's name yet. > > A Simplicity example : >CREATE procedure dbo.sp_run_batch (@as_spname varchar(20)) with > recompile as > >declare @li_rets

Re: [GENERAL] MS SQL - PostgreSQL

Am Donnerstag, den 15.09.2005, 07:43 +0700 schrieb Irfan Syukur: my Postfix reports: <[EMAIL PROTECTED]>: mail for bri.co.id loops back to myself this is weird. Your mail is apparently seriously broken. Please have that fixed. ---(end of broadcast)

Re: [GENERAL] MS SQL - PostgreSQL

AntiSpam UOL schrieb: ANTISPAM UOL » TIRA-TEIMA Olá, Você enviou uma mensagem para [EMAIL PROTECTED] Para que sua mensagem seja encaminhada, por favor, *clique aqui* *snip* Esta confirmação é necessária porque [EMAIL PROTECTED] usa o Antispam UOL,