PostgreSQL Database Forum

I've got a problem where any group or user permissions to the pg_class table aren't being registered by either psql or the JDBC driver. I issue the following command: GRANT ALL ON TABLE pg_class TO GROUP apps; -OR- GRANT ALL ON TABLE pg_class TO sculptor; Both apps and sculptor are valid user and group names respectively. The command...

Hi! I've downloaded postgreqsql-base-7.2.4.tar.gz but it says in the readme file that "This distribution also contains several language bindings, including C, Perl, Python, and Tcl, as well as a JDBC driver. The ODBC and C++ interfaces have been moved to the PostgreSQL Projects Web Site at http://gborg.postgresql.org for separate...

Hi all- I'm migrating to postgres from the MS SQL Server land, as I can see a great potential with postgres, I was wondering if anyone has experimented or started a project with XML inside user defined functions? I've seen the contrib/xml shipped with the distro, as I see it's usefulness, it's not quite what I had in mind (lacks the...

Hi all, I am trying to do a query that returns all rows that are _not_ part of a join, and so far I cannot seem to find a query that doesn't take 30 minutes or more to run. The basic query is "select * from tableA where tableA_id NOT IN (select tableA_id from tableB)". Is there a more efficient way of doing this?

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, following odity: I have a table "quote". In a stored proc I do a

I have table with column of type "inet". Then I have my own function resolveip(text). It works okay when I store IP addres into column typed as text or varchar. But with type of inet I run into this problem: select host(acc_ip), resolveip(host(acc_ip)) from access_test limit 15 host | resolveip...

I upgraded to 7.4 a few days ago and am getting these errors when importing dumps: "permission denied to set session authority" and "permission denied for schema public". Not all of the dump is imported successfully. Are these errors due to new features in 7.4? Do I need to add more permissions for users? __________________________________...

Hi! I haven't found anything in terms of startup- and check-scripts for pg_autovacuum yet; usually I like to have some sort of mechanism to check if some daemon is running and restart it if it isn't. Of course this sort of script shouldn't be too much of a bother for more experienced users; however you might actually find this small...

I have a table which contains three columns of domain X. If I drop the domain X with cascade, the table remains with no columns. Is this the proper behaviour? It seems to me that any action which results in an invalid object should be

Is there a function or other way to get the user's ip address the moment an insert is performed? Supposed that many people with the same "pg_username" are conected to the database so no username tracking is usefull. Thanks in advance Alexander Antonakakis

I can create a function with a domain and define it to return a domain. The parameter is checked to see if it qualifies in the constraint of the domain, however, the return value is not. Is this a bug? Is the author of the function responsible for re-inforcing the constraint at runtime?

Hi all, a few days ago, I upgraded from PostgreSQL 7.2.1 to 7.4, following the instructions in the INSTALL file, including dump and restore. All this worked fine without any error (message). Since then, I found lots of the following in the postmaster output: 2003-11-29 15:19:54 ERROR: large object 4838779 does not exist 2003-11-29...

In itself, the schema thing in version 7.4 is a good thing, but I'm migrating from a postgres/msacces combination in 7.2 to 7.4, and I'm not to keen on every table in msacces appearing a public_<tablename>. Is there a way to avoid this?

http://hardware.devchannel.org/hardwarechannel/03/10/20/1953249.shtml?tid=20&tid=38&tid=49 -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA I can't make you have an abortion, but you can *make* me pay child support for 18 years? However, if I want the child (and...

I have been trying to execute a shell command from within postgresql My C Function #include <stdlib.h> #include<postgres.h> void shell_exec(text arg) {

Thought others might find this useful (PostgreSQL 7.4+ only) When used, it outputs an array of the inputs, in order. CREATE OR REPLACE FUNCTION aggregate_array(ANYARRAY,ANYELEMENT) RETURNS ANYARRAY AS ' SELECT CASE WHEN $1 IS NULL THEN ARRAY

Hello, Sorry if this post was sent twice. Is it possible to restore a database previously backed-up with "dump", and then recover some of the changes made after the backup, until a specific timestamp, by using some sort of "journal"? Is there such a feature in Postgresql? Thanks ------------------------- Philippe Lang

Hi, I'm not an expert, not by far. I've just installed postgres7.4 and have realized tat the order of rows in queries in different to that in 7.3.4. It seems that previously it was more logic, ordering by the first column, then by the second,... by default. At least this is so in a couple of queries I have. And now I have to explicitly say...

Hi I'm new to this list so say a quick "hello @all!" Ok my question: I did compile the official 7.4 sources for the solaris 8 platform and compilation went right. The problem occured after I started the postmaster process and copied some data into the database using the COPY command:

Hello, Is it possible to restore a database previously backed-up with "dump", and then recover some of the changes made after the backup, until a specific timestamp, by using some sort of "journal"? Is there such a feature in Postgresql? Thanks ------------------------- Philippe Lang Attik System http://www.attiksystem.ch

i am using postgres 7.0.3 and also postgres 7.2.1 I am new towards using blobs,I want to transfers records with blobs from a table to different database(postgres) using perl without extracting the blob to disk(i.e without using lo_export/lo_import). Below is my perl script which is not working can

Hi. Is it posible to rename postgres database ? something like "ALTER DATABASE mydb RENAME TO mydb_old " ? i look to the documentation , but found nothing about. thanx ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

I was wondering if there is something I can do that would act similar to a index over more than one table. I have about 3 million people in my DB at the moment, they all have roles, and many of them have more than one name. for example, a Judge will only have one name, but a Litigant could have multiple aliases. Things go far to slow...

Is it posible to do string concatanation in plpgsql? Somthing like: sec := ''some string here'' . NEW.id; Is there a way to do this? I need te value of that new string for things that come after, and couldn't find much in the PL documentation. --