PostgreSQL Database Forum

I seem to remember reading a post on this, but searching marc does not seem to bring it up immediately. Company BBS is on postgresql, but it's still at 7.1. The guy in charge of it wants some ballpark estimates and warnings about upgrading to 7.4 so he doesn't have to worry about the recent vulnerabilities. War stories? Things to watch...

Hi guys, Is there a way I can separate things in PostgreSQL? Putting tables in a disk partition and indexes in another one????? Regards, MaRcELo PeReiRa PHP/SQL/PostgreSQL

I just did a dump and restore of my database and one of my views did not recreate. The error received was : pg_restore.exe: could not execute query: ERROR: column reference "pricinggroupid" is ambiguous I checked the function in the original database, using PGAdmin, and the system seemed to have slightly changed my query. Part of my...

Hi, In a database I have to create new schemas with exactely the same structure as the default one. Of course, I could reverse a schema with pg_dump, then apply the script to the newly created one. The problem is the base schema sometimes changes so I should generate scripts every time. Also I need to do this from a stored function. My...

On 7.4.6, is there any problem with defining one column of a view to be a string literal? For example ... $ psql -c "create view fooview as select 'bar' as footype" WARNING: column "footype" has type "unknown" DETAIL: Proceeding with relation creation anyway. CREATE VIEW Or is this warning just noise in this case?

How can I calculate the number of second in some interval? Neither the secods part, nor the seconds after midnight... Just the full quantity of the seconds. I haven't find any function. Thanks in advance. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Hello, I think, I found a bug, but maybe it's just my stupidity. Granted: What I did was an error on my part, but I still think, PostgreSQL should not do what it does. I've already created a simple testcase: popscan_light=> create table a (id serial, name varchar(10), primary

Is there a way to define a foreign key for the values of an array? For example, if table T1 is having a colum A which is defined as integer can I define a foreign key in order to force each value to be a pointer (index) to a row in a table T2? If yes, how? Is there any shortcomings to this approach? Thanks, Daniel Savard

Can too many btree indexes cause page level locking? I read this... http://www.postgresql.org/docs/7.4/static/locking-indexes.html

Psycopg and probably PySQL seem to have decided to return a "float" type when libpq returns a string tagged with the "numeric" property. This can cause "pretty" printing problems when generating reports. ( I like all of my decimal points to line up.) For example in my python based browser if I try the command

Hi. i have table like this: create table my_data ( cond_1 int8,cond_2 varchar(),cond_3 .... cond_n whatrver ,data text) This table represents a simple tree structure with known max level (n) . This table is filled with data, but branches have not a same depth.

Hi Forum, Is there a way to change the database access permissions for different IP addresses without having to re-start PostgreSQL? I often want to preclude all IP address but one from accessing the database. Currently, I change the pg_hba.conf file and re-start the database but I would like to be able to do the same thing without having...

Hi all, I am wandering about the pros and cons of creating a separate serial field for a primary key when I already have a single unique field. This existing unique field will have to be a character of fixed length (VARCHAR(12)) because although it's a numeric value there will be leading zeroes. There are a couple more tables with similar...

---------------------------- Original Message ---------------------------- Subject: Abrupt close of pgsql backend From: "Deepa K" <kdeepa@midascomm.com> Date: Mon, October 25, 2004 8:04 pm To: postgresql-general@postgresql.org -------------------------------------------------------------------------- Hi, I am running postgresql...

Hi, is it possible to write a trigger, using pl/pgSQL, that updates tables in a different database than the one the trigger is called from? If it is, what is the syntax for calling the other database? My to databases are on the same server. Regards Jonas:)) ---------------------------(end of broadcast)--------------------------- TIP...

Hello ! To kill a session i used KILL -INT <PID>. This command wasn't successfull. The processus is still here when a 'ps ax'or a 'select * from pg_stat_activity' Is there an other way to kill this process only because a web server 24/7 use postgres and cannot stop postgresql now. Thanks !

hi, I need info on the caracteristics of object relational databases and their advantages as well as disdvantages in comparison to relational databases and OO Databases! Please explain these chacteristics with respect to what Postgresql can and cannot do. Thanks for your assistance.

Hi, the restoration of a dump stops at the line above. The dump was created with pgsql 7.3.2 and I need to pump it into a 7.4.3 one. Should anybody tell me what the problem can be and how I can solve it. (There are double apostophes many times in the string - is it normal??? Besides of the field separator of course...) Many thanks,...

Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --------------------------------------------------------------------- PostgreSQL RPM Set Update 2004-10-26 Version(s): 7.3.8, 7.4.6

Hi folks, 8.0beta3 has pg_autovacuum included, when I want to run this as a Windows service, it says you can use the -I and -R options. When I do that and I specify a password with '-P' (uppercase) then in the registry it's saved as '-p' (lowercase) in the service-commandline (ImagePath). Also it removes the quotes I added and I'm not...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, (S)RPMs for new point releases (per http://archives.postgresql.org/pgsql-announce/2004-10/msg00010.php) have been built for Fedora Core 1&2, Red Hat Linux 9 and Red Hat Enterprise Linux 3.

I'm attempting to debug a script that should perform a simple INSERT of values, but for some reason doesn't. The insert appears to occur without error, printing "INSERT 18015 1 upon completion." Nonetheless, no data values appear to be added to the table when queried in psql. Questions:

I'm trying to properly tag the types of the parameters I'm passing into PQexecParams, as it seems to be the right thing to do, and it's not that big a deal given my existing code base. Unfortunately I'm running into a problem figuring out what I should be using for the tag numbers. I originally thought that the enum in include/ecpgtype.h...

When trying to connect to database via the pgAdmin3 GUI it asks for a password. I use the same passworrd as I did when I connect to the DB via command line but I get Ident error? how do I set, re-set the password so I can use both the commandline and pgAdmin to access edit by DB? Thanks