PostgreSQL Database Forum

I'm writing a function in C, and am trying to return a row, containing Numeric and array types. I'm building the row with heap_formtuple. I'm havingtrouble creating the numeric and array Datums. If anyone has some examplecode illustrating this, that'd be great. -Adam

I may have found a bug. I have a table: CREATE TABLE onlpcd_stat ( sel BIGSERIAL PRIMARY KEY, user_id INTEGER NOT NULL REFERENCES onlpcd_user ON DELETE CASCADE, vars TEXT, /* string of Perl var hash */ cre_ts TIMESTAMP DEFAULT NOW()

Hi All, Is it possible to find the size of a pgsql table. TIA -- regards, Deepa K

end end

end end

Hello, Can anybody tell me, whether PostgreSQl is supported on AMD64. If so where can I download from and what is the complexsity in installing them. regards, prahalad

Hi, My problem is rather complex. I will try to explain it clearly (I hope !) Sorry for my poor english. I'm tracking change of state for entities (something than can be monitored.) The set of states are limited (state1 to state5.)

hi, i make programms with c# and i would like to know if there is an alternative to odbc(wich is not really fast) to dialog with postgre. thanks thierry

There is a funciton to convert numbers into string?>? str:=string(3234); ?? _________________________________________________________________ Las mejores tiendas, los precios mas bajos, entregas en todo el mundo, YupiMSN Compras: www.yupimsn.com/compras

Just wondering what the feeling is regarding when the end of beta might be. -- Nigel Andrews ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Scenario: I want to modify the PostgreSQL source code to customize per customer requirements, add new features and then package PostgreSQL with my own developed application. Then I want to sell/lease that sw/hw package to customer. I will only sell/lease software binaries to the customer and not the source code of modified PostgreSQL and my...

Hi, FWIW, I walked into this one when changing an int into a numeric(5,1) : IF ( 0::int ) => interpreted as false IF ( 0.0::numeric(5,1) ) => interpreted as true

Hi All, Is it possible find the size of a pgsql table. TIA -- regards, Deepa K

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...

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,

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?

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

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. ...

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...