PostgreSQL Database Forum

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, I need to synchronize some tables from a database (master) to another one (slave). Both servers are running Debian Woody with PostgreSQL 7.2.1 (postgresql 7.2.1-2woody4). The databases are in unicode and doesn't contain any binary data. The tables have primary/foreign key constraints, sequences and indexes, but no triggers/rules....

Hi ! We are moving to PgSql application, with 'typical' style of work. Thin client, huge database. From database is (also) generated whole website. I will use it for explain my current todo. Right now, I am before solving following problem: Someone starts (let's say) adding 'new product'. It mean, he have to add records to many tables,...

Sorry if this is obvious to you, but it's not obvious to me. In 7.4 this psql -h 127.0.0.1 test and psql -h localhost test will be authenticated as ipv6 addresses. As long as you know, it's OK, but is this intentional?

hi! i am developing with version 7.3.2 under cygwin. my production evironment is 7.3.3 on a suse machine. language settings (lc_...) for the server are on developing and production machine the same, 'C'. now i encoutered the following behaviour. i use a union select to unify a query result with an ' (all)' entry. i used at home a space on...

Hi all, Not sure if this is a question for a php list or this one, but I'll give it a shot and if I am wrong, please do not crucify me. :-) There is a php based sourceforge project called mailwatch. (http://www.sourceforge.net/projects/mailwatch) It logs data from the excellent Mailscanner security product into a mysql database. Now, I...

Hello! I am planning to use unique IDs in the little system I am building. Now being more than a little paranoid (and having no idea about expected loads), I am wary of using int4 as a basis for uids (for the fear of ever running out of them). So the logical choice would be int8, right? Unfortunately quite wrong. Statement of the form:...

This post is as much about getting some questions answered as leaving the following definitions in the archives for the next person. After a quick perview of the web, I came up with the following: tablespaces are a hardware issue, and totally transparent to SQL execution. It is for optimization for IO, recovery, and separating user and...

---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Hi, I am looking for a database engine which: 1) runs under Windows (multiple versions) 2) Can be redistributed without additional fees as part of another product Is postgresql appropriate for this?

Hallo, I tried to compile PGSQL 7.4 and I got error (durring make): ar: command not found What is it? Whe I can found it? I have: $ uname -a SunOS ... 5.8 Generic_108528-03 sun4u sparc SUNW,UltraSPARC-IIi-cEngine

What's the best way to create a connection with dblink with persisted connections with web applications? For example: I want to have a view that links to a table in another pg database so I can mask the connection and make it easier to query. so I would do this ... create view myremote_pg_proc as select *

Dear All, I have some c code that writes results directly to a file as they're produced during a simulation. I want to modify the code to write directly to a postgres database using libpq. I think I could open a connection and insert into the database with a transaction, commiting at the end of the simulation. One problem with this approach...

ok, i'm confused. i have two systems. one is redhat 7.1 (a server in colo, reasonably current), the other is 8.0 (my laptop). the server in colo is running postgresql 7.3.2 along with redhat's updated versions of apache and php for 7.1 (the php version is 4.1.2) on this server, php can access postgres without difficulty. my laptop is...

I'm trying to insert data into an empty table but I keep getting the error: ERROR: could not open relation with OID 42939 I have a couple of constraints on the table but what I'm entering doesn't violate those. Can someone tell me where in the system catalog I can look to find what relation it is talking about? TIA, Duane

I have a field in my pgsql 7.4.2 table that is char(6) type. This holds an ID that contains only numbers, but must be six characters in length. First two chars are the year followed by a sequential number. For instance, a number entered for the time this year would be '040001'. I was trying to setup a check constraint to make sure only number...

I've been programming web applications in PHP/MySQL for a few years. It's worked pretty well, but I've been getting annoyed with the lack of more advanced features lately. After some reading, I've decided to switch to Perl/PostgreSQL. I'll be discarding all database data for other reason anyway, so moving data isn't an issue. I just want to...

These seem to work. I'm posting them now before I'm done with them before I start messing them up with specifics to my database. Any comment is welcome. However, I've no intention of publishing production quality code or documentation, these are my notes and I've used published them here in the event that somebody finds them useful. ...

Hello list, First of all, excuse me if this is not the right site to ask my question. Is there a way in postgresql to loop to all the fields of a given table and compare the OLD and NEW value for each field. I need to make an audit table that must contain only the fields changed after and insert/update. Thanks in advance

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

following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme: "If we are setting a table level lock both the blockId and tupleId (in an item pointer this is called the position) are set to invalid, if it is a page level lock the blockId is valid, while the tupleId is still invalid. Finally if this is a tuple level lock (we...

I need to change a varchar(32) to varchar(1024). It is a primary key that many tables reference. How do I do this without reloading the entire database?

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?

Hi to all i received "message type 0x50 arrived from server while idle" ... RedHat Linux 9, postgres 7.3.4 the program is quite simple, a loop do UPDATE on a random entry on a table. Server is without autocommit. with setittimer and SIGALRM i do an explicit COMMIT every 10 seconds,

I'm running the latest version of PostgreSQL. I backed up one of my databases following the instructions in the postgresql documentation. This means that I did shut down postmaster and I tarred the data directory just like it says to. Now, I'd like to restore the file system. I started by just copying the data directory back, but that...