PostgreSQL Database Forum

Hello, Are the indexes inherited during table inheritance ? Thanks ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Hello All I have been following the list in regards to Postgresql 8.0. I am very excited about this release and what it brings to the Postgres World. Our company has been converting from Progress 7.3E Database to Postgres and one of the things that Progress has is roll-forward recovery. I have seen contrib programs that provide that...

Dear Experts, I have a couple of questions about the efficiency of queries involving views. Say I have a large table T, and a view V that just adds some extra columns to T, using for example some date-to-text formatting functions. The functions are defined as immutable. Now I "select * from V where pkey=xxxxx". My hope was that the...

I think I'm going insane. In postgresql.conf I have: tcpip_socket = true In pg_hba.conf I have host all all 0.0.0.0 0.0.0.0 trust

Hi all, I have a problem when inserting into a varchar field via jdbc. Using to bytes makes the varchar fields shorten. Example: with 7.4.5. on Linux create table test(charfield varchar(5)); insert into test(charfield) values('abcde');

Forgive me if this is a basic and trivial (i.e., stupid) question. I haven't been using postgres very long, and I'm not an experienced database system developer. I noticed that there is a very powerful group-based security feature in postgres. Very nice - I like it alot. So one way to implement security constraints is to define appropriate...

What would be the more proper way of storing birthday data? It will be used to send out birthday messages for customers ("Happy 30th birthday, Sam!"). But the date of birth is not necessarily known (in which case, we will only send out "Happy birthday, Sam!"). I prefer using the builtin date type instead of three smallints. But I don't like...

Is there any good way to speed up SQL that uses like and has placeholders? Here's the scoop. I've got a system that uses a lot of pre-generated SQL with placeholders in it. At runtime these SQL statements are fired off (through the C PQexecParams function, if that matters) for execution. No prepares or anything, just bare statements with $1...

I have a table with columns (product_id,related_product_id,related_counter) If product A is related to product B then a record should be created, if the record already exists then the related_counter should be incremented. This is very easy to do with MySQL using INSERT... ON DUPLICATE KEY. Standard or not, it is very usefull.

Hi, What's the best way to obtain the Julian day from a postgresql date? PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) I'm doing some date arithmetic with 1 day intervals and want to, for example, round to the even Julian day. I suppose

Hello list, Is there a way to pass a collection of values (array) to a a function in plpgsql? Thanks in advance -- Sinceramente,

I would like to create a temporary table with a variable name. For example, the name of the table might be based on some form of datetime and a constant text. I have looked through the logs, but have not found any direction on this. Any ideas? ---------------------------(end of broadcast)--------------------------- TIP 7: don't...

I am trying to create a function that creates a user and adds a row to a table. It produces no warnings or errors when I create the function but when I attempt to execute it I get a syntax error. I do not understand why this is happening. Any help would be greatly appreciated. SELECT create_author( 'name', 'username', 'password' );

I'm a complete newbie to postgres so please look the other way if these questions are really stupid. Is it legitimate to have one database per data file? For organizational and backup purposes, I'd like to keep the database files for each of several projects separate. This means, e.g., that postmaster must have multiple instances going...

Been trying to connect to http://gborg.postgresql.org/ website for last 2 days and no luck. Postgresql.org home page stills shows this as the link and can't find any info that the site is down. Cheers Phil

Is there a tool that allows the tables and relationships of an Access database to be moved into postgresql (7.4.5)? Sorry if this has been asked before. There also may be new tools that have recently come out. -- % Randy Yates % "Watching all the days go by... %% Fuquay-Varina, NC % Who are you and who am I?"...

Hello! I am using QNX 6.3 and postgreSQL 7.3.2. I dont know how to set national sorting (polish). I know that i need to set locale but i donno how to do this in qnx. I use: mkdir ppp initdb -E ISO-8859-2 --locale=pl -D ppp then pg_ctl -D ppp start and i get: FATAL: invalid value for option 'LC_MESSAGES': 'pl'

I read that the password hash in pg_shadow is salted with username. Is this still the case? If so, since probably 99% of all PostgreSQL has "postgres" as the superuser name, wouldn't it be better to use standard Unix/Apache MD5 hash instead? -- dave ---------------------------(end of broadcast)---------------------------

On a nightly basis, we shut the database down and do a file system backup. A short chronology of our database problem: 8/21 - count(*) of user tables succeeded (done once a week to get statistics) 8/23 - A specific search on a specific value (one out of over 2 million) caused postmaster to SEGV. I dropped the index in question and...

What is the performance or other benefits of text search on pgSQL vs mySQL on large dbs? thanks for any comments, ..V -- Please post on Rich Internet Applications User Interface (RiA/SoA) <http://www.portalvu.com>

Hello, I have some stuff coming back from the database telling me that columns that I have dropped are being retined inthe table renamed as .........pg.dropped.1........ .........pg.dropped.7........ I know what these columns originally were but I dropped them

On 8 beta1 I get 'SMgrRelation hashtable corrupted' *sometimes* when executing the following, but only when there are other clients connecting to the same database. ALTER TABLE declines ALTER COLUMN comp_name TYPE varchar(128), ALTER COLUMN f_name1 TYPE varchar(48), ALTER COLUMN l_name1 TYPE varchar(48), ALTER COLUMN country TYPE...

Is this pthreads warning of any concern? gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -pthread -pthreads -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -fpic -shared -Wl,-soname,libecpg.so.4 execute.o typename.o descriptor.o data.o error.o prepare.o memory.o connect.o misc.o path.o exec.o...

This is probably a stupid question, but ... I'd like to be able to take an existing query and modify it to return a single row if that's what the base query returns, and 0 rows if the base query returns multiple rows. Similarly, I'd like to also modify it to return multiple rows if that's what the base query returns, and 0 rows if the base...

All, There seems to be a bug in pg_dumpall: For one of my dbs I've done: ALTER DATABASE dbname SET search_path = mw, public; If I do a pg_dumpall I get a line like: