PostgreSQL Database Forum

Hi, I have a problem with a PL/PerlU function trying to execute an external perl script. The script is suid to a non-root user and I am executing it in the PL/PerlU function as so : $rc = system "/usr/bin/suidperl", "-T", "/usr/local/bin/script.pl";

This is what I finally ended up with, thanks to those who helped get me here. -- -- PostgreSQL database dump -- pg_dump -d -c -s dbname --

I posted it to the pgsql-hackers list, but I did not seem to get through. Not even sure if this is a bug or a feature :) When I create a temp table and then try to copy some data into the table, if the data is corrupt and the synchronization is lost - the table also seems to get lost. For example create temp table words(aa...

Hi, sorry that this email is a little bit long, but it is actully not :-)) **** I have a database 'unidb' created with -E UNICODE. $ psql -l List of databases Name | Owner | Encoding -----------+---------+----------- unidb | kathy | UNICODE

Hi, A client is using postgresql 7.1.3, and to_date() and to_timestamp() functions fail sometimes,However they never do in postgresql 7.3.2. Are these bugs? Thx _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*.

Anyone out there using beta 2 in production situations? Comments on stability? I am rolling out a project in the next 4 weeks, and really don't want to go though an upgrade soon after its released on an Unsuspecting Client, so I would LIKE to start working with 7.4. -------------------- Andrew Rawnsley President The Ravensfield Digital...

Hi @ all, I'v noticed if you kill -9 the Postmaster Temporary Tables (Shemas) will stay in the DB. Also a VACUUM FULL will not remove them after restart. If the server craches (no power) its the same (I'v noticed it here) Daniel. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore...

do child tables inherit the indexes declared for a parent table? or do i need to redeclare the index on each child table? for example: create table fee ( fie text ); create index fee_index on fee ( fie ); create table foe ( fum text ) inherits foo; create index foe_index on foe ( fie ); -- do i need to do this?

Hi I am Hemasekhar K.P I am trying to replicae pgsql on REDHATLinux 8, but the site http://gborg.postgresql.org/genpage?replication_72install. is giving instructions on REDHATLinux 7, is there any site which gives instructions on how to replicate on REDHATLinux 8, Actually in postgresql.conf which is under...

Hi @ all, I'v noticed if you kill -9 the Postmaster Temporary Tables (Shemas) will stay in the DB also a VACUUM FULL will not remove them after restart. Daniel. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

Using the org.postgresql.Driver JDBC driver is it possible to connect to Postgres using a unix domain socket instead of a TCP socket (so you don't have to start the postmaster with -i)? Using a TCP socket instead of a unix socket seems to slow down requests that return large result sets by a factor of 3 on the same machine. What's the point of...

Hi, I have a problem with a PL/PerlU function trying to execute an external perl script. The script is suid to a non-root user and I am executing it in the PL/PerlU function as so : $rc = system "/usr/bin/suidperl", "-T", "/usr/local/bin/script.pl";

Hello, i have data in form of images which are in GB's, i need to store the extracted data from the images. This will required large fields size. I was thinking of Blob data type as we have in Oracle. Do we have blob data type in postgreSQL, if yes in which version. Thank's Gagan Anand

Say, we have uptimes from several servers: Server up_from up_to ------ ------- ------- s1 0:00 8:00 s1 10:00 20:00 s1 22:00 24:00 (would better be a timestamp with 0:00 and next day) s2 0:00 4:00 s2 6:00 23:00

Hello everybody, Is it possible to design an arbitrary, hierarchical data scheme, that would allow its modification & extension during devel process? In ideal case, it should also support some inheritance. I tried ltree for the hierarchy, and that worx fine. But I ran into problems when traversing across different tables connected by id....

Hi, A client is using postgresql 7.1.3, and to_date() and to_timestamp() functions fail sometimes,However they never do in postgresql 7.3.2. Are these bugs? Thx _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*.

Hello everybody, Is it possible to design an arbitrary, hierarchical data scheme, that would allow its modification & extension during devel process? In ideal case, it should also support some inheritance. I tried ltree for the hierarchy, and that worx fine. But I ran into problems when traversing across different tables connected by id....

Hi, Can somebody tell me why german special characters like 'ü' or 'ä' willbe changed To '?' when retrieving data from postgres with Java (JDBC). When I select the data under Postgres everything is ok. The problem occurs when I select the data with Java. ??? Hope somebody can helps. Thanxx

Hi, I'm not sure it's a bug or it's normal, so i don't send it to pgsq-bugs. Well, i have written pgbench in PRO*C to have a common pgbench.pgc source for Postgres and Oracle. However, there are some differences between the Postgres Pro*c and Oracle Pro*c. So, i use #ifdef ORACLE #else #endif preprocessing instructions to

Hi, I am using a view that has also a LIMII 1000 in it. As it seems when I run a query with a WHERE then the WHERE is only applied to the subset of 1000 records. So although the query my produce 3000 records, I may get only a few hundred back. Is there a way to get change that i.e. that the VIEW places a limit on the final result?

Hi everyone. I need to create a C function that returns a row, and the type of this row must be the same of a type that I've created using CREATE TYPE. I've seen the function: TupleDesc TypeGetTupleDesc(Oid typeoid, List *colaliases) but I don't understand two things: 1)I just know the name of the type, not its oid... woud it be ok if I

I think I understand why this happens. But I find it annoying. I don't see any nice way around it except putting explicit casts everywhere in the code, which bothers me. slo=> select '' order by 1; ERROR: Unable to identify an operator '<' for types '"unknown"' and '"unknown"' You will have to retype this query using an explicit cast ...

How do we get someone from PG to respond to the questions in the ODBC newsgroup? Is the someone we can email directly? Thanks

Hi everyone. I need to create a C function that returns a row, and the type of this row must be the same of a type that I've created using CREATE TYPE. I've seen the function: TupleDesc TypeGetTupleDesc(Oid typeoid, List *colaliases) but I don't understand two things: 1)I just know the name of the type, not its oid... woud it be ok if I

Scenario: I want to modify the PostgreSQL source code to customize per customer requirements, add new features and then package PostgreSQL with my own developed application. Then I want to sell/lease that sw/hw package to customer. I will only sell/lease software binaries to the customer and not the source code of modified PostgreSQL and my...