Re: [HACKERS] Need help debugging why autovacuum seems "stuck" -- until I use superuser to vacuum freeze pg_database

On Sun, May 1, 2016 at 10:39 PM, McCoy, Shawn wrote: > I have been debugging a problem on a 9.3.10 Postgres database cluster with > over 1200 databases. 10 workers, increased maintenance_work_mem, auto > vacuum settings to run more frequently than default. What I will notice is > that autovacuu

Re: [HACKERS] Need help on pgcrypto

On 1/11/16, Michael Paquier wrote: > On Mon, Jan 11, 2016 at 10:03 PM, rajan wrote: >> Trying to find a documentation which will make me understand how to secure >> a >> password column. I want the encryption to be one way and it should not be >> decrypted. >> >> I am able to find discrete docume

Re: [HACKERS] Need help on pgcrypto

On Mon, Jan 11, 2016 at 10:03 PM, rajan wrote: > Trying to find a documentation which will make me understand how to secure a > password column. I want the encryption to be one way and it should not be > decrypted. > > I am able to find discrete documents but nothing of them gets me there. Er, is

[HACKERS] Need help on pgcrypto

Trying to find a documentation which will make me understand how to secure a password column. I want the encryption to be one way and it should not be decrypted. I am able to find discrete documents but nothing of them gets me there. Please help. - -- Thanks, Rajan. -- View this message in

Re: [HACKERS] Need help to begin contribution in PostgreSQL Development - Specifically XML module

Kodamasimham Pridhvi (MT2012066) wrote: > We students of International Institute of Information Technology > Bangalore India, are interested to contribute to  PostgreSQL > development. We identified some modules from ToDo list to which > we want to contribute.We want to begin with an simple modul

[HACKERS] Need help to begin contribution in PostgreSQL Development - Specifically XML module

Dear pgsql-hackers, We students of International Institute of Information Technology Bangalore India, are interested to contribute to PostgreSQL development. We identified some modules from ToDo list to which we want to contribute.We want to begin with an simple module with less dependency lik

Re: [HACKERS] Need help with TRAP: FailedAssertion("!(context != CurrentMemoryContext)"

Stephen Woodbridge writes: > Thank you for your reply. The frustrating thing about this is the same > source works fine in Linux. So here is the pseudo code of my source > removing non pgsql stuff and not expected to be runnable: You can't hold a SPI context open across multiple calls of an SRF

Re: [HACKERS] Need help with TRAP: FailedAssertion("!(context != CurrentMemoryContext)"

OK, it looks like there is a bug related to MinGW builds. If I remove both --enable-cassert --enable-debug from my configure then I get a build that works. Removing just --enable-cassert did not solve the problem. I did not try just removing --enable-debug only. Someone might want to look i

Re: [HACKERS] Need help with TRAP: FailedAssertion("!(context != CurrentMemoryContext)"

On 4/20/2013 5:00 PM, Andres Freund wrote: On 2013-04-20 16:32:36 -0400, Stephen Woodbridge wrote: Hi all, I have been writing pg extensions for a while but I just ran into a problem that has me stumped. I have code for a SRF and it works fine on pg 9.2.2 on linux, but fails with am error in

Re: [HACKERS] Need help with TRAP: FailedAssertion("!(context != CurrentMemoryContext)"

On 2013-04-20 16:32:36 -0400, Stephen Woodbridge wrote: > Hi all, > > I have been writing pg extensions for a while but I just ran into a problem > that has me stumped. > > I have code for a SRF and it works fine on pg 9.2.2 on linux, but fails with > am error in the logfile. > > TRAP: FailedAs

[HACKERS] Need help with TRAP: FailedAssertion("!(context != CurrentMemoryContext)"

Hi all, I have been writing pg extensions for a while but I just ran into a problem that has me stumped. I have code for a SRF and it works fine on pg 9.2.2 on linux, but fails with am error in the logfile. TRAP: FailedAssertion("!(context != CurrentMemoryContext)", File: "mcxt.c", Line:

Re: [HACKERS] Need help understanding pg_locks

Thanks, applied. --- Florian Pflug wrote: > On Jul14, 2011, at 22:18 , Bruce Momjian wrote: > > !OID of the database in which the lock target exists, or > > !zero if the lock is a shared object, or > > !

Re: [HACKERS] Need help understanding pg_locks

Looks good to me. --- Florian Pflug wrote: > On Jul14, 2011, at 22:18 , Bruce Momjian wrote: > > !OID of the database in which the lock target exists, or > > !zero if the lock is a shared object, or > > !

Re: [HACKERS] Need help understanding pg_locks

On Jul14, 2011, at 22:18 , Bruce Momjian wrote: > !OID of the database in which the lock target exists, or > !zero if the lock is a shared object, or > !null if the lock is on a transaction ID For consistency, I think it should say "target" in the second part of the sentenc

Re: [HACKERS] Need help understanding pg_locks

Florian Pflug wrote: > I still believe the chance of confusion to be extremely small, but since > you feel otherwise, what about "Targeted" instead of "Locked". As in > > OID of the relation targeted by the lock, or null if the lock does not > target a relation or part of a relation. > > Pa

Re: [HACKERS] Need help understanding pg_locks

On Jul14, 2011, at 19:06 , Bruce Momjian wrote: > Florian Pflug wrote: >> On Jul13, 2011, at 21:08 , Bruce Momjian wrote: >>> + OID of the relation lock target, or null if the lock is not >>> on a relation or part of a relation >> >> That, however, not so much. "relation lock target" m

Re: [HACKERS] Need help understanding pg_locks

Florian Pflug wrote: > On Jul13, 2011, at 21:08 , Bruce Momjian wrote: > > - OID of the database in which the object exists, or > > - zero if the object is a shared object, or > > - null if the lock object is on a transaction ID > > + OID of the database in which the lock ta

Re: [HACKERS] Need help understanding pg_locks

On Jul13, 2011, at 21:08 , Bruce Momjian wrote: > - OID of the database in which the object exists, or > - zero if the object is a shared object, or > - null if the lock object is on a transaction ID > + OID of the database in which the lock target exists, or > + zero

Re: [HACKERS] Need help understanding pg_locks

Andrew Dunstan wrote: > > > On 07/13/2011 12:31 PM, Tom Lane wrote: > > Bruce Momjian writes: > >> Tom Lane wrote: > >>> I think you misunderstood the suggestion. This is not an improvement, > >>> it's just more confusion. > >> Well, I thought the "lock on" wording helped avoid the confusion bu

Re: [HACKERS] Need help understanding pg_locks

Florian Pflug wrote: > We could also get rid of the noun completely by saying > > (D) > "Locked page number within the relation, or null if it isn't >a tuple or relation page that is locked". > > I personally slightly favor (D). I don't think we can use "Locked" here because the lock mig

Re: [HACKERS] Need help understanding pg_locks

On 07/13/2011 12:31 PM, Tom Lane wrote: Bruce Momjian writes: Tom Lane wrote: I think you misunderstood the suggestion. This is not an improvement, it's just more confusion. Well, I thought the "lock on" wording helped avoid the confusion but obviously I didn't understand more than that.

Re: [HACKERS] Need help understanding pg_locks

Bruce Momjian writes: > Tom Lane wrote: >> I think you misunderstood the suggestion. This is not an improvement, >> it's just more confusion. > Well, I thought the "lock on" wording helped avoid the confusion but > obviously I didn't understand more than that. We did have similar > confusion wh

Re: [HACKERS] Need help understanding pg_locks

Florian Pflug wrote: > On Jul13, 2011, at 17:44 , Tom Lane wrote: > > Bruce Momjian writes: > >> OK, I went with this wording, using "lock object is on" terminology. > >> Applied patch attached --- adjustments welcomed. > > > > I think you misunderstood the suggestion. This is not an improvemen

Re: [HACKERS] Need help understanding pg_locks

On Jul13, 2011, at 17:44 , Tom Lane wrote: > Bruce Momjian writes: >> OK, I went with this wording, using "lock object is on" terminology. >> Applied patch attached --- adjustments welcomed. > > I think you misunderstood the suggestion. This is not an improvement, > it's just more confusion. F

Re: [HACKERS] Need help understanding pg_locks

Tom Lane wrote: > Bruce Momjian writes: > > OK, I went with this wording, using "lock object is on" terminology. > > Applied patch attached --- adjustments welcomed. > > I think you misunderstood the suggestion. This is not an improvement, > it's just more confusion. Well, I thought the "lock

Re: [HACKERS] Need help understanding pg_locks

Bruce Momjian writes: > OK, I went with this wording, using "lock object is on" terminology. > Applied patch attached --- adjustments welcomed. I think you misunderstood the suggestion. This is not an improvement, it's just more confusion. regards, tom lane -- Sent vi

Re: [HACKERS] Need help understanding pg_locks

Florian Pflug wrote: > On Jul11, 2011, at 17:31 , Bruce Momjian wrote: > > Tom Lane wrote: > >> Florian Pflug writes: > >>> On Jul11, 2011, at 17:11 , Tom Lane wrote: > Yeah, I think this patch is going in the wrong direction altogether. > It would be better to modify the description of

Re: [HACKERS] Need help understanding pg_locks

Bruce Momjian wrote: > OK, so as I understand it, in pg_locks: > > Column | Type | Modifiers > +--+--- >locktype | text | >database | oid | >relation | oid | >page

Re: [HACKERS] Need help understanding pg_locks

On Jul11, 2011, at 17:31 , Bruce Momjian wrote: > Tom Lane wrote: >> Florian Pflug writes: >>> On Jul11, 2011, at 17:11 , Tom Lane wrote: Yeah, I think this patch is going in the wrong direction altogether. It would be better to modify the description of virtualtransaction and pid t

Re: [HACKERS] Need help understanding pg_locks

Bruce Momjian writes: > Tom Lane wrote: >> Maybe we could just add a paragraph above the "pg_locks Columns" table >> that says explicitly that virtualtransaction and pid describe the entity >> holding or awaiting the lock, and the others describe the object being >> locked? Any way you slice it,

Re: [HACKERS] Need help understanding pg_locks

Tom Lane wrote: > Florian Pflug writes: > > On Jul11, 2011, at 17:11 , Tom Lane wrote: > >> Yeah, I think this patch is going in the wrong direction altogether. > >> It would be better to modify the description of virtualtransaction > >> and pid to say that those are the "locking" entity. > > > H

Re: [HACKERS] Need help understanding pg_locks

Tom Lane wrote: > Florian Pflug writes: > > On Jul11, 2011, at 05:47 , Bruce Momjian wrote: > >> Thank you. I think my confusion is that virtualtransaction is the lock > >> holder/waiter, and the other two are actual locks. The attached doc > >> patch clarifies that. I had actually realized thi

Re: [HACKERS] Need help understanding pg_locks

Florian Pflug writes: > On Jul11, 2011, at 17:11 , Tom Lane wrote: >> Yeah, I think this patch is going in the wrong direction altogether. >> It would be better to modify the description of virtualtransaction >> and pid to say that those are the "locking" entity. > Hm, we already kinda of say tha

Re: [HACKERS] Need help understanding pg_locks

On Jul11, 2011, at 17:11 , Tom Lane wrote: > Florian Pflug writes: >> On Jul11, 2011, at 05:47 , Bruce Momjian wrote: >>> Thank you. I think my confusion is that virtualtransaction is the lock >>> holder/waiter, and the other two are actual locks. The attached doc >>> patch clarifies that. I ha

Re: [HACKERS] Need help understanding pg_locks

Florian Pflug writes: > On Jul11, 2011, at 05:47 , Bruce Momjian wrote: >> Thank you. I think my confusion is that virtualtransaction is the lock >> holder/waiter, and the other two are actual locks. The attached doc >> patch clarifies that. I had actually realized this a few weeks ago and >> f

Re: [HACKERS] Need help understanding pg_locks

On Jul11, 2011, at 05:47 , Bruce Momjian wrote: > Thank you. I think my confusion is that virtualtransaction is the lock > holder/waiter, and the other two are actual locks. The attached doc > patch clarifies that. I had actually realized this a few weeks ago and > forgot, meaning this is pretty

Re: [HACKERS] Need help understanding pg_locks

Florian Pflug wrote: > On Jul10, 2011, at 06:01 , Bruce Momjian wrote: > > Can someone help me understand pg_locks? There are three fields related > > to virtual and real xids: > > > > virtualtransaction | text | > > transactionid | xid | > > virtualxid | text | > > > >

Re: [HACKERS] Need help understanding pg_locks

On Jul10, 2011, at 06:01 , Bruce Momjian wrote: > Can someone help me understand pg_locks? There are three fields related > to virtual and real xids: > > virtualtransaction | text | > transactionid | xid | > virtualxid | text | > > Our docs say 'virtualtransaction' is:

[HACKERS] Need help understanding pg_locks

Can someone help me understand pg_locks? There are three fields related to virtual and real xids: virtualtransaction | text | transactionid | xid | virtualxid | text | Our docs say 'virtualtransaction' is: Virtual ID of the transaction that is holding or awa

Re: [HACKERS] NEED HELP !

And *int obj_contains(moving_object *a, BOX *b) { if (b->low.x > a->x_low) return 0; if (b->low.y > a->y_low) return 0; if (b->high.x < a->x_high) return 0; if (b->high.y < a->y_high) return 0; return 1; }* this is the procedure obj contains On

Re: [HACKERS] NEED HELP !

I debugged index with gdb and found that it is segmentation fault in my procedure named *gist_mov_consistent* it is only 7 lines. So I think it is worth to publish it to public, * * *Datum gist_mov_consistent(PG_FUNCTION_ARGS)* *{* *GISTENTRY *entry = (GISTENTRY *)PG_GETARG_POINTER(0);* *

Re: [HACKERS] NEED HELP !

On Wed, Jan 13, 2010 at 1:42 PM, Sergej Galkin wrote: > I can not understand why DB is restarting ? It is restarting when SQL begins > use index :((( > Can anybody help me , I would by appretiate every people who downloads my > sources, try to deploy index and maybe solve where is the problem. Yo

Re: [HACKERS] NEED HELP !

I want to add than I have a piece of my code that looks very strange Datum gist_mov_penalty(PG_FUNCTION_ARGS) { GISTENTRY *origentry = (GISTENTRY *) PG_GETARG_POINTER(0); GISTENTRY *newentry = (GISTENTRY *) PG_GETARG_POINTER(1); float * result = (float *) PG_GETARG_POINTER(2); * m

[HACKERS] NEED HELP !

Hello all, I am a student-magister and I'm writting my magister work. I realized gist index TPR tree - it is like a simple R tree but moving :) Everything is compiling ok, I creating table and index, but after whese code - DB is restarting :((( * * *set enable_seqscan = false select * from table_o

[HACKERS] Need help in porting Oracle PL/SQL's OUT paramater based procedures

Hi All, I am involved in porting Spacewalk 's backend DB schema from Oracle to Postgres. We are almost done with table migration, and are now attempting procedure/function porting. A few things have been sorted out (link

Re: [HACKERS] Need help with autovacuuming error.

S. Horio wrote: > We are investigating the following error: > > ERROR: XX000: xlog flush request 1/50B823D8 is not satisfied --- flushed > only to 1/50A711B0 > > OS : Windows XP SP2 > Version : PostgreSQL8.1.4 Please upgrade to a supported version, which for Windows means either 8.2.6 or 8.3.

[HACKERS] Need help with decoding of sql array from WAL files version 7.4.17

I need to restore two records from a lost transaction and I am having only the WAL file, managed by Postgresql 7.4.17. The structure of records is: * Record 1: varchar(400)[] with exact 191 elements, where al least 185 elements are just "*" and at most 6 are string with length>1. Like this {first

[HACKERS] Need help with autovacuuming error.

We are investigating the following error: ERROR: XX000: xlog flush request 1/50B823D8 is not satisfied --- flushed only to 1/50A711B0 OS : Windows XP SP2 Version : PostgreSQL8.1.4 It seems that "postmaster" or "autovacuum" process is executed simultaneously, and it is affecting the WAL r

Re: [HACKERS] Need help with autoconf

On Thu, Jul 12, 2007 at 09:54:28AM -0400, Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: > > Thanks for the pointer. Attached is what I came up with. If someone > > autoconfy can sign off on that it seems correct, I'll apply that. > > Looks reasonable to me. Thanks, applied and bac

Re: [HACKERS] Need help with autoconf

Magnus Hagander <[EMAIL PROTECTED]> writes: > Thanks for the pointer. Attached is what I came up with. If someone > autoconfy can sign off on that it seems correct, I'll apply that. Looks reasonable to me. regards, tom lane ---(end of broadcast)---

Re: [HACKERS] Need help with autoconf

On Wed, Jul 11, 2007 at 01:41:56PM -0400, Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Magnus Hagander <[EMAIL PROTECTED]> writes: > >>> I'm simply using > >>> AC_CHECK_FUNC([krb5_free_unparsed_name]) > >>> which works fine on unix, but breaks on win32. Bec

Re: [HACKERS] Need help with autoconf

Magnus Hagander <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Magnus Hagander <[EMAIL PROTECTED]> writes: >>> I'm simply using >>> AC_CHECK_FUNC([krb5_free_unparsed_name]) >>> which works fine on unix, but breaks on win32. Because autoconf tries the >>> function with no parameters, which doesn't

Re: [HACKERS] Need help with autoconf

Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: >> I'm simply using >> AC_CHECK_FUNC([krb5_free_unparsed_name]) >> which works fine on unix, but breaks on win32. Because autoconf tries the >> function with no parameters, which doesn't work due to win32 decorations. > > Doesn't work w

Re: [HACKERS] Need help with autoconf

Magnus Hagander <[EMAIL PROTECTED]> writes: > I'm simply using > AC_CHECK_FUNC([krb5_free_unparsed_name]) > which works fine on unix, but breaks on win32. Because autoconf tries the > function with no parameters, which doesn't work due to win32 decorations. Doesn't work why? We have dozens of oth

[HACKERS] Need help with autoconf

Hi! I'm trying to write an autoconf macro to figure out if the function krb5_free_unparsed_name exists (because it exists in MIT but not Heimdal), to fix a rather nasty bug in our Kerberos implementation. However, I'm failing :( I'm simply using AC_CHECK_FUNC([krb5_free_unparsed_name]) which wo

Re: [HACKERS] need help in understanding gist function

1. What is the functionality of gistplacetopage() function in gist.c ?Can you please give me detail description of this function. It tries to place index tuple on page. If page hasn't enough space, gistplacetopage splits page on two or more pages. Number of page to be splitted depends, basical

[HACKERS] need help in understanding gist function

I need help in understanding certain things in gist ... 1. What is the functionality of gistplacetopage() function in gist.c ?Can you please give me detail description of this function. 2. I have left and right buffers with values that I have filled. Now, how do I write these changes(buffers) perm

Re: [HACKERS] Need Help In arrays

Hello there isn't other way :-). If you can, use source code from cvs and compile postgresql. http://www.postgresql.org/developer/sourcecode/ or you can use string array, and fictive NULL values. Regards Pavel Stehule Hi, Thanks for replying. I am using the latest code that is 8.1.2. I

Re: [HACKERS] Need Help In arrays

Hi,   Thanks for replying. I am using the latest code that is 8.1.2. I look at the comments of construct_md_array function. On it, it says that NULL values are not supported. Please kindly help me out or tell me some other way.   Thankyou. O

Re: [HACKERS] Need Help In arrays

Salman Razzaq wrote: > I found it difficult to use 'construct_md_array' as i want to > construct an array with NULL elements included in it. How do i do that?. Keep in mind that you can't do that in released versions (8.1 and earlier); it's only possible in the current development bran

[HACKERS] Need Help In arrays

Dear Group Members,  Hi,     I found it difficult to use 'construct_md_array' as  i want  to  construct an  array with NULL elements included in it. How do i do that?.                                    Thankyou.

Re: [HACKERS] Need help in installing postgresql 8.1.2 on Windows

Hopefully your problem is solved by now; but if not, here's the link: do read the README expanded at the end of the file-list: http://www.postgresql.org/ftp/binary/v8.1.2/win32/ I could give you a long lecture on how to look for the things on your own a little bit before pestering these mailing l

[HACKERS] Need help in installing postgresql 8.1.2 on Windows

Sir I am trying to install Globus Toolkit4 on Windows machine. Postgresql8.1.2 is required software for installing GT4. But i cant get installation steps from anywhere.. Please help me and do reply Thanks Sarvjot Yahoo! Photos – Showcase holiday pictures in hardcover Photo Books. You desig

Re: [HACKERS] Need help on SpikeSource Testing Contest

Jim, > Anything more on this? Contest start is in just over 3 weeks... Nope. I've get to get a committer to promise to review submitted tests. That's the main thing I need before we can commit to participation. I'll also be drafting some docs on requirements for regression tests, but that'

Re: [HACKERS] Need help on SpikeSource Testing Contest

Anything more on this? Contest start is in just over 3 weeks... On Thu, Aug 18, 2005 at 11:48:08AM -0700, Josh Berkus wrote: > Folks, > > Those of you who went to OSCON may have heard that SpikeSource is having a > contest to increase testing code coverage of popular OSS projects. The > contes

[HACKERS] Need help on SpikeSource Testing Contest

Folks, Those of you who went to OSCON may have heard that SpikeSource is having a contest to increase testing code coverage of popular OSS projects. The contest involves prizes of up to $2500 for test writers. Given that we have people in the community who have been thinking about testing, an

Re: [HACKERS] need help

For this information, you can go through the code. I would suggest reading through the catalog, heap access methods, storage manager, and executor. Does anyone know of any good high-level docs on this? Nithin Sontineni wrote: Hi, i want to know how create relation works and how the pop

[HACKERS] need help

Hi, i want to know how create relation works and how the populated relation is stored in the form of pages and also when a tuple is inserted how page concept works in postgress. S.Nithin. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the b

Re: [HACKERS] need help

vamsi krishna wrote: hi, i want to know how CREATE table (creating a relation) See DefineRelation() in backend/commands/tablecmds.c, and the routines it calls. also i want to know how postgres parser the input(create table) and how is this connected to the create table source code files

[HACKERS] need help

hi, i want to know how CREATE table (creating a relation) works in Postgres.where can i find this in source code. also i want to know how postgres parser the input(create table) and how is this connected to the create table source code files.

Re: [HACKERS] Need help woth thread support in ecpglib

Hi Michael, I'll have a look at it this afternoon, unless Lee wants first go. Regards, Philip. On Tuesday 12 April 2005 00:28, Michael Meskes wrote: > Hi, > > I recently got the following bug report. It appears to be a bug in > pthread implementation in ecpglib/connect.c where > > pthread_gets

[HACKERS] Need help woth thread support in ecpglib

Hi, I recently got the following bug report. It appears to be a bug in pthread implementation in ecpglib/connect.c where pthread_getspecific(actual_connection_key); doesn't return the value of actual_connection, the variable used for non-threaded mode. Problem is I never really used threading i

Re: [HACKERS] need help on writing an aggregate function

On Tue, Nov 16, 2004 at 03:21:44PM -0600, Bruno Wolff III wrote: > On Tue, Nov 16, 2004 at 12:41:45 -0700, > [EMAIL PROTECTED] wrote: > > hi, > > I was writing my own data type, and, I have to write aggregare > > function like min() and max() for my datatype. I googled for the > > user defined ag

Re: [HACKERS] need help on writing an aggregate function

On Tue, Nov 16, 2004 at 12:41:45 -0700, [EMAIL PROTECTED] wrote: > hi, > I was writing my own data type, and, I have to write aggregare function like > min() and max() for my datatype. I googled for the user defined aggregate > functions, but I could not find any examples for the sfunc and ffunc.

[HACKERS] need help on writing an aggregate function

hi, I was writing my own data type, and, I have to write aggregare function like min() and max() for my datatype. I googled for the user defined aggregate functions, but I could not find any examples for the sfunc and ffunc. Can any of you provide me the source/structure in C or SQL for these two

Re: [HACKERS] Need help.

Thank you very much, for help. The problem was, that the server and client wasn't the same version. "Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Fri, Nov 14, 2003 at 14:04:56 +0200, > Petro Pelekh <[EMAIL PROTECTED]> wrote: > > > > So my database doesn't ha

Re: [HACKERS] Need help.

On Fri, Nov 14, 2003 at 14:04:56 +0200, Petro Pelekh <[EMAIL PROTECTED]> wrote: > > So my database doesn't have pg_namespace system catalog, and doesn't > understand such "pg_catalog.pg_class c", but understand "pg_class c". May be > some of you have such problems with postgres and can help. It

Re: [HACKERS] Need help.

On Fri, Nov 14, 2003 at 02:04:56PM +0200, Petro Pelekh wrote: > I find such strange thing in my postgres server > --- > distance=> \d cities; > ERROR: parser: parse error at or near "." You are using psql from a 7.3 version to talk to an older server. This is not

[HACKERS] Need help.

Good morning, I am new to Postgres, so excuse for such question, but I can't find it in dokumentation. I have table cities. I can insert into it, select from it, but cat run such command distance=> \d cities ERROR: parser: parse error at or near "." distance=> \d cities; ERROR: parser: par

Re: [HACKERS] Need help.

I find such strange thing in my postgres server --- distance=> \d cities; * QUERY ** SELECT c.oid, n.nspname, c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE pg_catalog.pg_table_is_visi

Re: [HACKERS] Need help for our thesis.

On 4 Jul 2003 at 18:56, MIka Santos wrote: > said online registration. He wanted a multidatabase querying. For example, we > knew that the following statements are posible, > select * > from t1, t2., t3; > provided that t1 and t2, t3 are tables from a single database. > Ourthesis is to make the

Re: [HACKERS] Need help for our thesis.

Hello Mika Currently you can use dblink which queries a remote database and returns the data as a table. This works nicely for PostgreSQL. There is also a JDBC version in progress. We have writte an Oracle version of dblink. SELECT * FROM dblink('connectstr', 'SELECT ...') AS some_type; This w

Re: [HACKERS] Need help for our thesis.

As luck would have I've put some thought into this problem before as well. Having reviewed the code quite a bit, and played around with the backend, my intuition tells me that the following would work. Write a custom "cluster-aware" postmaster so it distributes queries to various machines. Of

[HACKERS] Need help for our thesis.

Gud day! We are currently having our thesis for our undergarduate course and this involoves the code of PostgreSQL. Basically, our thesis needs a modification of the existing code of the said database. As of now, our University has an existing online registration system which uses Postgre as their

[HACKERS] Need help in composing PostgreSQL query

Hi Please help me compose the query in PostgreSQL. Using PostgreSQL 7.1.2. Suppose relations A and B have columns: {X1, X2, ..., Xm, Y1, Y2, ..., Yn} and {Y1, Y2, ..., Yn} Attributes Y1, Y2, ..., Yn are common for both relations and have the same type in both. How can I define in PostgreSQL

[HACKERS] Need help with redefining locales

I'm having trouble with like et.al. as there is no single character in et_EE locale (on linux at least) that is bigger than all the others. I would like to modify my locale definition files so that char(255) would always sort after all others but I can't find docs on modifying the locales So

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

> From: Alfred Perlstein <[EMAIL PROTECTED]> > > To: Tom Lane <[EMAIL PROTECTED]> > > Cc: [EMAIL PROTECTED] > > Subject: Re: [HACKERS] Need help with phys backed shm segments >(Postgresql+FreeBSD). > > > > Here's the patch I'm using on FreeBSD

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

Just as interesting On Tue, 5 Dec 2000, Alfred Perlstein wrote: > * Alfred Perlstein <[EMAIL PROTECTED]> [001205 12:30] wrote: > > * Tom Lane <[EMAIL PROTECTED]> [001205 08:37] wrote: > > > BTW, I just remembered that in 7.0.*, the SLocks that are managed by > > > SpinAcquire() all live in their

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

L PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD). > > * Alfred Perlstein <[EMAIL PROTECTED]> [001205 12:30] wrote: > > * Tom Lane <[EMAIL PROTECTED]> [001205 08:37] wrote: > > > BTW,

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

* Alfred Perlstein <[EMAIL PROTECTED]> [001205 12:30] wrote: > * Tom Lane <[EMAIL PROTECTED]> [001205 08:37] wrote: > > BTW, I just remembered that in 7.0.*, the SLocks that are managed by > > SpinAcquire() all live in their own little shm segment. On a machine > > where slock_t is char, it'd lik

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

* Tom Lane <[EMAIL PROTECTED]> [001205 08:37] wrote: > BTW, I just remembered that in 7.0.*, the SLocks that are managed by > SpinAcquire() all live in their own little shm segment. On a machine > where slock_t is char, it'd likely only amount to 128 bytes or so. > Maybe you are seeing some bug i

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

Alfred Perlstein <[EMAIL PROTECTED]> writes: > No I'm not sure actually. :) I'll look into it further, but I > was wondering if there was something I could do to debug the > locks better. I think I'll add some S_MAGIC or something in > the struct to see if the whole thing is getting clobbered or

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

BTW, I just remembered that in 7.0.*, the SLocks that are managed by SpinAcquire() all live in their own little shm segment. On a machine where slock_t is char, it'd likely only amount to 128 bytes or so. Maybe you are seeing some bug in FreeBSD's handling of tiny shm segments?

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

* Tom Lane <[EMAIL PROTECTED]> [001205 07:43] wrote: > Alfred Perlstein <[EMAIL PROTECTED]> writes: > > Here's the log, the number in parens is the address of the lock, > > on tas() the value printed to the right is the value in _ret, > > for the others, it's the value before the lock count is set

Re: [HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

Alfred Perlstein <[EMAIL PROTECTED]> writes: > Here's the log, the number in parens is the address of the lock, > on tas() the value printed to the right is the value in _ret, > for the others, it's the value before the lock count is set. This looks to be the trace of a SpinAcquire() (see src/bac

[HACKERS] Need help with phys backed shm segments (Postgresql+FreeBSD).

On FreeBSD 4.1.1 and above there's a sysctl tunable called kern.ipc.shm_use_phys, when set to 1 it's supposed to make the kernel's handling of shared memory much more effecient at the expense or making the shm segment unpageable. I tried to use this option with 7.0.3 and FreeBSD 4.2 but for some