[GENERAL] problem enabling postgres in php

hello, I am working with Postgresql 8.1.3, Apache 2.0.58 and PHP 5.1.4. on windows 2k. My phpinfo is working fine. But I am not able to enable postgres support. According to phpinfo the configuration file (php.ini) path is "C:\WINNT".  All my extensions are in the  "C:\php\ext"  dir. I modifi

Re: [GENERAL] Junk binary date?

On Tue, Jun 20, 2006 at 09:12:50PM -0700, Kevin Jenkins wrote: > I call PQexecParams with the last parameter as 1 to return binary > data. I then get this data with: > > fileLengthPtr = PQgetvalue(result, rowIndex, fileLengthColumnIndex); > memcpy(&fileLength, fileLengthPtr, sizeof(fileLength));

[GENERAL] Junk binary date?

I call PQexecParams with the last parameter as 1 to return binary data. I then get this data with: fileLengthPtr = PQgetvalue(result, rowIndex, fileLengthColumnIndex); memcpy(&fileLength, fileLengthPtr, sizeof(fileLength)); The value being returned is of type integer. It should have the value

Re: [GENERAL] multiple statement 'instead of' rule

"Merlin Moncure" <[EMAIL PROTECTED]> writes: > create or replace rule insert_fsv as on insert to frequency_service_view > do instead > ( > insert into frequency_operation > select new.table_name, new.frequency, old.code where new.set = > true and old.set = false; > delete from fre

[GENERAL] multiple statement 'instead of' rule

I have a repeatable issue where on an update rule (attached to a view) not all of the statements are firing under certain conditions. There is no error but the rule does not seem to be completely going through the statements. I'm not sure if this is correct behavior reading the documentation but

Re: [GENERAL] Lock contention during inserts

"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > During mass inserts, we have some locking contention in tables referenced by > foreign keys. It´s a 8.0.3 box > and I know that 8.1 solved this but I would like to know if there is an easy > and safe way to only apply this patch to 8.0.3? If it were

[GENERAL] Lock contention during inserts

Hello, During mass inserts, we have some locking contention in tables referenced by foreign keys. It´s a 8.0.3 box and I know that 8.1 solved this but I would like to know if there is an easy and safe way to only apply this patch to 8.0.3? Reimer ---(end of broadcast)---

Re: [GENERAL] simple query terminated by signal 11

""Thomas Chille"" <[EMAIL PROTECTED]> wrote > > I don't know how to post it, because the size is 1,5 MB?! I try to > attch it as gzip. > No ... I mean the "bt" result of the core dump. $gdb -c bt > . > Program terminated with signal 11, Segmentation fault. > #0 0x080753c2 in DataFill () > (

Re: [GENERAL] Adding foreign key constraints without integrity check?

Wes wrote: On 6/20/06 5:07 AM, "Florian G. Pflug" <[EMAIL PROTECTED]> wrote: My suggestion was to create the fk _before_ loading the data, and disable it similarly to what "--disable-triggers" doest. It turned out, however, that a FK always depends on a unique index (be it a primary key, or not

Re: [GENERAL] Help requd in writing functions in C and using in Postgres

On Tue, Jun 20, 2006 at 02:03:06PM -0400, Jasbinder Bali wrote: > Does that mean I can't make a function in C that will have all the database > transactions and then would just be included in the Stored Procedure in > postgres (though i know there is no concept of stored procs in postgres, its > al

Re: [GENERAL] merge result sets

On Die, 2006-06-20 at 15:34 -0500, Bruno Wolff III wrote: > On Tue, Jun 20, 2006 at 12:06:24 +0200, > simon <[EMAIL PROTECTED]> wrote: > > hi all > > > > i'm using postgres 7.3 > > > > my problem is i want to build a helper table: > > > > UPDATE studienmodul_summary > >SET kat

Re: [GENERAL] Dynamic loading of C functions

Was the object compiled on the same architecture as postgres? Sometimes when one is compiled on a 64-bit, the other on 32-bit, or two wildly different versions of gcc, I have seen this cryptic "No such file or directory". Erin On 6/20/06, Jasbinder Bali <[EMAIL PROTECTED]> wrote: chmod 666 fil

Re: [GENERAL] Dynamic loading of C functions

yes, i've named it as .so file. On 6/20/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Jasbinder Bali" <[EMAIL PROTECTED]> writes:>>> /usr/include/pgsql/server/ is exactly the path where test_func object >>> file resides.Hmmm when you say "object file", do you mean it's really named"test_func.o"?If

Re: [GENERAL] Dynamic loading of C functions

"Jasbinder Bali" <[EMAIL PROTECTED]> writes: >>> /usr/include/pgsql/server/ is exactly the path where test_func object >>> file resides. Hmmm when you say "object file", do you mean it's really named "test_func.o"? If so, that's both the wrong name and the wrong type of file. Postgres is lo

Re: [GENERAL] Dynamic loading of C functions

Do you need to specify test_func.so not ...test_func or has that changed? --elein On Tue, Jun 20, 2006 at 05:13:32PM -0400, Jasbinder Bali wrote: > chmod 666 filename is something i've done to give permissions to all.. > still doesn't work. > > > On 6/20/06, Bill Moran <[EMAIL PROTECTED]>

Re: [GENERAL] Dynamic loading of C functions

chmod 666 filename is something i've done to give permissions to all.. still doesn't work.  On 6/20/06, Bill Moran <[EMAIL PROTECTED]> wrote: In response to "Jasbinder Bali" <[EMAIL PROTECTED]>: > I've written a function in C, compiled it and trying to use the same> function in one of my postgres f

Re: [GENERAL] Dynamic loading of C functions

In response to Tom Lane <[EMAIL PROTECTED]>: > Bill Moran <[EMAIL PROTECTED]> writes: > > In response to "Jasbinder Bali" <[EMAIL PROTECTED]>: > >> I get the follwing error > >> ERROR: could not access file "/usr/include/pgsql/server/test_func": No > >> such > >> file or directory > > > Check t

Re: [GENERAL] Dynamic loading of C functions

Bill Moran <[EMAIL PROTECTED]> writes: > In response to "Jasbinder Bali" <[EMAIL PROTECTED]>: >> I get the follwing error >> ERROR: could not access file "/usr/include/pgsql/server/test_func": No such >> file or directory > Check the permissions. Can the Postgres user read the file? The error i

Re: [GENERAL] Dynamic loading of C functions

In response to "Jasbinder Bali" <[EMAIL PROTECTED]>: > I've written a function in C, compiled it and trying to use the same > function in one of my postgres functions like this: > > CREATE FUNCTION add_one(integer) RETURNS integer > AS '/usr/include/pgsql/server/test_func, 'add_one' > L

Re: [GENERAL] help with error message from perl Pg

On Tue, Jun 20, 2006 at 10:43:32 -0400, "A.M." <[EMAIL PROTECTED]> wrote: > > You are using a completely outdated interface to postgres. Looking on > CPAN, Pg.pm was last updated 04 Apr 2000. Which version of postgresql are > you using? It is likely that the old interface blows up when connectin

Re: [GENERAL] Start up question about triggers

I know that this question may be really simple, but I have decided to ask here due to fact that I don't know how to search for this on google or on the docs.   I created a trigger fuction which updates a specific row in some table A. Is it possible to retain the query that was used to t

Re: [GENERAL] merge result sets

On Tue, Jun 20, 2006 at 12:06:24 +0200, simon <[EMAIL PROTECTED]> wrote: > hi all > > i'm using postgres 7.3 > > my problem is i want to build a helper table: > > UPDATE studienmodul_summary >SET kategorie = (SELECT kategorie_bezeichnung > > if the SELECT gives back just one

Re: [GENERAL] Adding foreign key constraints without integrity check?

On Tue, Jun 20, 2006 at 00:49:21 -0400, louis gonzales <[EMAIL PROTECTED]> wrote: > Florian, > I understand where you're coming from. Indexes are always unique and > all RDBMS systems use them to 'uniquely' identify a row from the the > perspective of internal software management. Index != Pr

Re: [GENERAL] Exporting data from view

On Tue, Jun 20, 2006 at 12:44:24PM -0700, Aaron Koning wrote: > copyable, importable... into Excel or another postgres db? Ofcourse. It doesn't have the table definition ofcourse, just the data. The CSV format was added specifically for importing into Excel and similar programs... -- Martijn van

[GENERAL] Dynamic loading of C functions

I've written a function in C, compiled it and trying to use the same function in one of my postgres functions like this:CREATE FUNCTION add_one(integer) RETURNS integer AS '/usr/include/pgsql/server/test_func, 'add_one' LANGUAGE C STRICTtest_func is the name of my object file and add_one i

Re: [GENERAL] Exporting data from view

copyable, importable... into Excel or another postgres db?On 6/20/06, Martijn van Oosterhout wrote:On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote:> CREATE TABLE sometable AS SELECT * FROM someview; > pg_dump -t sometable dbname> DROP TABLE sometable>> Que? Si!Eh?

Re: [GENERAL] Exporting data from view

On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote: > CREATE TABLE sometable AS SELECT * FROM someview; > pg_dump -t sometable dbname > DROP TABLE sometable > > Que? Si! Eh? If you're going to create the table anyway, I'd use psql: psql -c "COPY table TO STDOUT" If you put "CSV" there

Re: [GENERAL] A slow query - Help please?

On 6/19/06, Alban Hertroys <[EMAIL PROTECTED]> wrote: I found a way that works, and is indeed quite a bit faster. It is evenuglier than what you proposed. The problem wasn't the "order by" in thesubquery, but the "order by" combined with the "union": sorry, i always forget about  the fact that unio

Re: [GENERAL] Help requd in writing functions in C and using in Postgres

Does that mean I can't make a function in C that will have all the database transactions and then would just be included in the Stored Procedure in postgres (though i know there is no concept of stored procs in postgres, its all functions that you have in it).   If this is not the case then i thin

Re: [GENERAL] Exporting data from view

CREATE TABLE sometable AS SELECT * FROM someview; pg_dump -t sometable dbname DROP TABLE sometable Que? Si!On 6/20/06, Worky Workerson <[EMAIL PROTECTED]> wrote: On 6/20/06, Aaron Koning <[EMAIL PROTECTED]> wrote:> google pg_dumpReally?  What command do you use?  I've tried the following:pg_du

Re: [GENERAL] Exporting data from view

On 6/20/06, Aaron Koning <[EMAIL PROTECTED]> wrote: google pg_dump Really? What command do you use? I've tried the following: pg_dump -t viewname dbname and I get the view definition, whereas I would like the data. Is there an option to pg_dump that I'm missing? --

Re: [GENERAL] Database Clustering on multiple harddisk

On 6/20/06, arie nugraha <[EMAIL PROTECTED]> wrote: Thanks a Alex,But can tou give a bit explanation about multiple separate tablespaceThis will give you the basic syntax for the commands. http://www.postgresql.org/docs/8.1/static/sql-createtablespace.htmlhttp://www.postgresql.org/docs/8.1/static/s

Re: [GENERAL] [INTERFACES] help with error message from perl Pg

On Tue, June 20, 2006 10:44 am, Tom Lane wrote: > 78 would be ASCII 'N', but that's not really significant AFAICS. The > problem here is that the frontend and backend have lost sync: the server is > expecting to find a message beginning at a place in the frontend data > stream that evidently isn't

Re: [GENERAL] Exporting data from view

google pg_dumpOn 6/20/06, Worky Workerson <[EMAIL PROTECTED]> wrote: I read recently about the efforts underway to COPY from a view,however I was wondering what the current best-practices are for beingable to copy out of a view and import that data into an actual tableelsewhere.  I am currently doi

Re: [GENERAL] Help requd in writing functions in C and using in Postgres

[Please copy the mailing list on replies so others can participate in and learn from the discussion.] On Tue, Jun 20, 2006 at 11:39:03AM -0400, Jasbinder Bali wrote: > Well, as in normal Sql server or oracle Stored procedures, you write a > procedure in the database server and some middle tier wou

[GENERAL] Exporting data from view

I read recently about the efforts underway to COPY from a view, however I was wondering what the current best-practices are for being able to copy out of a view and import that data into an actual table elsewhere. I am currently doing psql -c "SELECT ..." and the using a bit of perl to transform

Re: [GENERAL] join on next row

In article <[EMAIL PROTECTED]>, Sim Zacks <[EMAIL PROTECTED]> writes: > I want my query resultset to be > Employee,EventDate(1),EventTime(1),EventType(1),EventTime(2),EventType(2) > Where Event(2) is the first event of the employee that took place > after the other event. > Example > EventIDE

Re: [GENERAL] question about performance of libpq

I am so sorry. I sent a mail draft.On 6/20/06, Lee Riquelmei <[EMAIL PROTECTED]> wrote: hi,all. A strange question is as follows:I have two PCs:machine A: FreeBSD 5.4 with PostgreSQL 8.1.2machine B: Windows XP with PostgreSQL 8.1.2A and B are with same hardware configuration and in a 100Mbit LAN.

Re: [GENERAL] Help requd in writing functions in C and using in Postgres

On Tue, Jun 20, 2006 at 11:23:33AM -0400, Jasbinder Bali wrote: > Can you help me in writing functions in C and the using in Postgres. > would like to know some pointers and what all needs to be taken into > considerations. Are you writing server-side or client-side code? For server-side see "C-L

Re: [GENERAL] join on next row

On Tue, Jun 20, 2006 at 05:13:50PM +0200, Sim Zacks wrote: > Thank you for responding. > I was thinking along those lines as well, though that would be an > absolute performance killer. I shouldn't be too bad, if you have the appropriate indexes defined. However, it seems to me this is the kind

[GENERAL] question about performance of libpq

hi,all. A strange question is as follows:I have two PCs:machine A: FreeBSD 5.4 with PostgreSQL 8.1.2machine B: Windows XP with PostgreSQL 8.1.2A and B are with same hardware configuration and in a 100Mbit LAN. a large table "lineitem" about 600572 rows exists in both A and B.On machine B, i run psq

[GENERAL] Help requd in writing functions in C and using in Postgres

Hi, Can you help me in writing functions in C and the using in Postgres. would like to know some pointers and what all needs to be taken into considerations. I'm kind of confused how to do it ~Jas

Re: [GENERAL] join on next row

I agree about the performance; but it won't be that bad if PG can unnest these subqueries and convert them into join views!!! In that case, these views would return just one row (LIMIT 1), and that is the best a developer can do to help the optimizer make the decision. If the optimizer knows th

[GENERAL] question about performance of libpq

hi,all. A strange question is as follows:I have two PCs:machine A: FreeBSD 5.4machine B: Windows XP.Both of them

Re: [GENERAL] Interface Guidance and Opinions Needed

Chris, On Jun 20, 2006, at 9:54 AM, Chris Golden wrote: This is my first time posting to this forum and I am very new to PostgreSQL. I am very excited about using it. I have set up a database and just need a point in the right direction on interfacing. I have an orders and messages dat

Re: [GENERAL] help with error message from perl Pg

"A.M." <[EMAIL PROTECTED]> writes: > You are using a completely outdated interface to postgres. Looking on > CPAN, Pg.pm was last updated 04 Apr 2000. Which version of postgresql are > you using? It is likely that the old interface blows up when connecting to > a postgresql from >2000. It shouldn'

Re: [GENERAL] help with error message from perl Pg

Err... On Tue, Jun 20, 2006 at 10:20:19AM -0400, Geoffrey wrote: > Martijn van Oosterhout wrote: > >On Tue, Jun 20, 2006 at 09:33:13AM -0400, Geoffrey wrote: > >>We have an unusual problem with some perl code that is processing data > >>via DBD facility. Basically, the code consists of various s

Re: [GENERAL] Interface Guidance and Opinions Needed

I would like to scan my database for new orders then do an HTTPS post to the provider. I would also like to periodically check for new orders/messages from the provider via an HTTPS post and bring them into my database (a constant exchange of information). I am wondering if something like P

Re: [GENERAL] psql for winxp?

> > Is it possible to have the installer only emplace psql and the > > necessary support libs? > > > I'm not sure offhand. The installer has customization > options, so it may be possible. But if not, it is probably > easy enough just to install it, copy the files that you need, > and then un

Re: [GENERAL] [INTERFACES] help with error message from perl Pg

Geoffrey <[EMAIL PROTECTED]> writes: > ... Any subroutine that does a delete > or update runs fine, but the subsequent routine fails with the following > error: > prgcaphlg: FATAL: invalid frontend message type 78 > server closed the connection unexpectedly > This probably means the serve

Re: [GENERAL] help with error message from perl Pg

On Tue, June 20, 2006 10:20 am, Geoffrey wrote: > > We considered that and have verified that we are not closing it. But, > the question came up, should we be passing it by reference or value? We > are doing the following: > > my $conn = Pg::connectdb ("dbname=$db port=$port"); . > . > my $retVa

Re: [GENERAL] Adding foreign key constraints without integrity

On 6/20/06 5:07 AM, "Florian G. Pflug" <[EMAIL PROTECTED]> wrote: > My suggestion was to create the fk _before_ loading the data, and disable it > similarly to what "--disable-triggers" doest. It turned out, however, that a > FK always depends on a unique index (be it a primary key, or not), which

Re: [GENERAL] help with error message from perl Pg

Martijn van Oosterhout wrote: On Tue, Jun 20, 2006 at 09:33:13AM -0400, Geoffrey wrote: We have an unusual problem with some perl code that is processing data via DBD facility. Basically, the code consists of various subroutines that are identified in a hash. The primary script then reference

Re: [GENERAL] join on next row

Thank you for responding. I was thinking along those lines as well, though that would be an absolute performance killer. Gurjeet Singh wrote: It would have been quite easy if done in Oracle's 'lateral view' feature. But I think it is achievable in standard SQL too; using subqueries in the sele

Re: [GENERAL] DocBook 4.2 detecting at configure time

"Oleg Golovanov" <[EMAIL PROTECTED]> writes: > I have changed configure command. Currently I issue command: > SGML_CATALOG_FILES=/usr/local/share/xml/docbook/4.2/docbook.cat Are you sure that's the place to look? On my machine the appropriate stuff is under .../share/sgml/, not /xml/. > configu

Re: [GENERAL] Interface Guidance and Opinions Needed

Chris Golden wrote:   Hello to all, I use PHP as the web programming layer, it has a great community and support for such things as XML RPC, which may fit the bill.    This is my first time posting to this forum and I am very new to PostgreSQL.  I am very excited

Re: [GENERAL] help with error message from perl Pg

On Tue, Jun 20, 2006 at 09:33:13AM -0400, Geoffrey wrote: > We have an unusual problem with some perl code that is processing data > via DBD facility. Basically, the code consists of various subroutines > that are identified in a hash. The primary script then references the > subroutines throu

[GENERAL] Interface Guidance and Opinions Needed

  Hello to all,   This is my first time posting to this forum and I am very new to PostgreSQL.  I am very excited about using it.  I have set up a database and just need a point in the right direction on interfacing.   I have an orders and messages database.  One of the providers I would

[GENERAL] help with error message from perl Pg

We have an unusual problem with some perl code that is processing data via DBD facility. Basically, the code consists of various subroutines that are identified in a hash. The primary script then references the subroutines through a &$prog(...) syntax. What appears to happen is that all subr

Re: [GENERAL] dynamic sorting...

Yavuz Kavus wrote: this works fine, however the next doesnt(i couldnt compile it ) : CREATE OR REPLACE FUNCTION ftest(_sort_column "varchar", _sort_direction "varchar") RETURNS refcursor AS $BODY$ declare _result_set refcursor; begin open _result_set for select firstname, lastna

Re: [GENERAL] psql for winxp?

Jerry, On Jun 19, 2006, at 10:47 PM, Jerry LeVan wrote: Is it possible to have the installer only emplace psql and the necessary support libs? I'm not sure offhand. The installer has customization options, so it may be possible. But if not, it is probably easy enough just to install it

Re: [GENERAL] simple query terminated by signal 11

Hi Qingqing, thanks for your reply! The postgresql version is 8.0.4 and runs on a debian based linux server with kernel 2.6.11.2. I never dealed with a core dump before. but after setting "ulimit -c 1024" i got it. I don't know how to post it, because the size is 1,5 MB?! I try to attch it a

Re: [GENERAL] join on next row

It would have been quite easy if done in Oracle's 'lateral view' feature. But I think it is achievable in standard SQL too; using subqueries in the select-clause. Try something like this: select Employee, EventDate, EventTime as e1_time, EventType as e1_type, (

Re: [GENERAL] problem connecting to server

Hi,   Thank you, for the link... was helpfull.   Trigve Qingqing Zhou <[EMAIL PROTECTED]> wrote: "Trigve Siver" <[EMAIL PROTECTED]>wrote>> Thank you for reply. No there isn't any panic message. Log contain only> messages I have posted.>Check out this thread (or search "background writer proce

[GENERAL] merge result sets

hi all i'm using postgres 7.3 my problem is i want to build a helper table: UPDATE studienmodul_summary SET kategorie = (SELECT kategorie_bezeichnung if the SELECT gives back just one result row, everthing is easy. my problem is, there is sometimes more than one result row. is

Re: [GENERAL] Adding foreign key constraints without integrity check?

louis gonzales wrote: Florian, I understand where you're coming from. Indexes are always unique and all RDBMS systems use them to 'uniquely' identify a row from the the perspective of internal software management. Surely there are non-unique indices - meaning indices for which there are more

Re: [GENERAL] problem connecting to server

"Trigve Siver" <[EMAIL PROTECTED]> wrote > > Thank you for reply. No there isn't any panic message. Log contain only > messages I have posted. > Check out this thread (or search "background writer process exited" in list): http://archives.postgresql.org/pgsql-general/2006-05/msg01568.php Regard

[GENERAL] best way to get PKey and FKey from inside applications (permission pb)

Hi all, I started using sqlalchemy (python ORM) that works really well but fails detecting Primary and Foreign key other than for owner or superusers. Sqlalchemy queries the information schema with the following query that returns nothing if you are connected as a user with no particular privilege

[GENERAL] Start up question about triggers

Hello all,   I know that this question may be really simple, but I have decided to ask here due to fact that I don't know how to search for this on google or on the docs.   I created a trigger fuction which updates a specific row in some table A. Is it possible to retain the query that was

[GENERAL] DocBook 4.2 detecting at configure time

Hi! I am using FreeBSD 5.4. There are installed: docbook-4.2 V4.2 of the DocBook DTD, designed for technical documentati docbook-sk-4.1.2_3 XML version of the DocBook DTD version controlled for Scrol docbook-xml-4.2_1 XML version of the DocBook DTD docbook-xsl-1.69.1 XSL DocBook st

Re: [GENERAL] Database Clustering on multiple harddisk

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 arie nugraha wrote: > Thanks a Alex, > > But can tou give a bit explanation about multiple separate tablespace > and HBA, > or is there any resources, tutorial on how to use this features on > postgresql An HBA is a physical card. Think of it as an

[GENERAL] dynamic sorting...

hi everybody.i have a sp. i am passing two argument to it.first one : _sort_column --> defines which column will be used in "order by".second : _sort_direction --> define sorting direction(asc or desc). i writing sp as :CREATE OR REPLACE FUNCTION ftest(_sort_column "varchar", _sort_direction "varch