Description:
PGSQL Relational Database Management System.
|
|
|
Keyword search in spatial database
|
| |
Hi all, i am a master's student. I have to do a keyword search for spatial database. I have the data set of a particular district in India. I have a data model too. Can some one help me through this task. My question is - it is a single word (keyword) search. I have the database schema too. How do i search this keyword through this schema... more »
|
|
Permission, select currval(seq)
|
| |
After an insert statement, I need a the members of a user group to get the recently inserted statement's primary key that was created from a sequence, with the currval() function. For example: select currval('subject_subject_id_se q') The table is "subject", the primary key name is "subject_id" and the sequence is "subject_subject_id_seq".... more »
|
|
Listing multiple joins on one row
|
| |
This is not a Postgres specific question. Given two simple tables tracking the marriages between people: ...The simple query: ...will produce multiple rows per person.name, if that particular person has been married multiple times, such as: ...WHAT I WOULD LIKE TO DO, is to collapse the rows of multiple people into one row and have a query result... more »
|
|
autonomous commit?
|
| |
Can I write a stored procedure which does an automonous commit? I saw something on a website that claimed "you can't get there from here" in postgresSql but then suggested calling an pl/perl routine to do that. Can anyone sort me out on that point? I'm coming from Oracle where autonomous commits have been possible for... more »
|
|
Hash indexes
|
| |
PostgreSQL has hash indexes, very similar to Oracle bitmap indexes. Oracle warns the application designers against using them in the OLTP applications because of the locking. Namely, locking a row would lock all the rows which hash to the same hash value as the original row. My question is whether the same thing applies to the PostgreSQL hash... more »
|
|
How to describe functions.
|
| |
I would like to write a single query listing all of the function argument types. I know that I can write a procedure but I would prefer a single query. The problem is that in pg_proc, the column proargtypes is of the type "oidvector", which is another name for an array oid[]. The types are, of course in pg_type table. The problem here is the array handling.... more »
|
|
Binding....
|
| |
Does anybody have an example with spi_prepare, spi_exec_prepared or spi_query_prepared? I managed to get the basic concepts: create function test_pl(varchar) returns setof varchar as $$ my ($job)=@_; my $qry="select ename from emp where job='".$job."'"; my $sth=spi_query($qry); while (my $row=spi_fetchrow($sth)) {... more »
|
|
setting the search_path
|
| |
Hello, I have several databases. The objects are stored in the public schema of each database. I would like to move them to different schemas in one single database. In the softwares that use these databases, the sql statements don't mention the schemas. I found out that it should be possible to set the search_path variable... more »
|
|
The Encoding problem
|
| |
Hello, today I ran into the "encoding problem". Migrating from Postgres 8 to Postgres 8.3 on a new Debian on another server, psql refused to import my LATIN1 databases, because the server has UTF8 set as locale. As I wanted to migrate to UTF8 with that specific database anyway, I edited my dump and went on with it, of course not after wasting a lot of... more »
|
|
|