[GENERAL] Understanding VARHDRSZ

Page 524 of the PostgreSQL 8.1 Manual, PDF Edition, has a code snippit that makes use of the VARHDRSZ macro. I'm trying to understand the purpose of this macro. Here is the code from the manual: #include "postgres.h" ... char buffer[40]; /* our source data */ ... text *destination = (text *) pal

[GENERAL] Table Inheritence...Just Columns?

Does a child table just inherit the columns from a parent table, or are other table objects like column constraints and triggers inherited? Thanks, Scott Huey ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an approp

[GENERAL] Database Design Theory - PostgreSQL Custom Types

Merlin has helped me understand custom data types in PostgreSQL a lot better, but I have some more questions I was hoping the list might be able to help with. I'm trying to come up with some good rules of thumb that can help me determine when it is practical to implement a custom type on PostgreS

[GENERAL] Executing an SQL query from an internal function...

If I am implementing an internal function in PostgreSQL with the C programming language, can I use one of the C API's to execute a query from within the function? Is there another way to execute an SQL query from within an internal function implemented in C? Thanks, Scott Huey -

[GENERAL] Using currval() in an insert statement...

I'm having trouble figuring out how to use the currval() function for sequences in an INSERT statement. I did some searching online, but couldn't find what I was looking for. I have two Schemas in my Database: metadata geometry I have a table named "metadata_geometries" in the metadata schema.

Re: [GENERAL] Beginner's questions about creating a custom data type in PostgreSQL...

ustom data types aren't a good idea in this situation, when are they? I can think of almost no situation when I can't mirror the functionality of a custom data type with a series of related database tables. Thanks Again, Scott Huey On 7/24/06, Merlin Moncure <[EMAIL PROTECTED]> w

[GENERAL] Beginner's questions about creating a custom data type in PostgreSQL...

I've got a few questions about creating custom data types for PostgreSQL. I'm not sure how to phrase the questions without an example, so here goes: I'd like to create a custom data type representing a Medieval Knight. (This isn't what I really want to do, it's just an example.) One of the "pro

[GENERAL] Updates to my PostgreSQL Wiki

I've got some new content on my wiki for PostgreSQL. http://www.bluwiki.org/go/PostgreSQL_Tips_From_The_Sunburned_Surveyor You will find an article on making connections to the PostgreSQL server, and an article on creating automated backups of PostgreSQL databases using a bash shell script. Thes

[GENERAL] Debian Packages For PostgreSQL

It looks like the packages.debian.org site is down. Is there another place where I can download a .deb for the latest stable version of PostgreSQL. (I don't have a direct link to the internet on my Linux box, so I can't use APT.) Thanks, Scott Huey ---(end of broadcast)--

Re: [GENERAL] Wiki Site for the PostgreSQL Newbie

That earlier e-mail won't do anyone much good with out the link to the site. Sorry. That's what happens when I work late in the middle of the week. Link: http://www.bluwiki.org/go/PostgreSQL_Tips_From_The_Sunburned_Surveyor Scott Huey On 1/25/06, Redefined Horizons <[EMAIL PROT

[GENERAL] Wiki Site for the PostgreSQL Newbie

I have started a wiki site for the PostgreSQL newbie. I'm actually a noob myself, but I thought I would take the time to document my mistakes and also provide some tips that I hope will help others. I welcome suggestions and correcions from more experience PostgreSQL and pgAdmin 3 users. I hope th

[GENERAL] Data type that corresponds to bigserial...

I'm a newbie running PostgreSQL 8.1 and pgAdmin 3 (Version 1.2.2) on Debian Sarge. I want to set up a foriegn key in one of my tables. This foreign key will reference the primary key of another table in the database. The referrenced table uses the bigserial datatype to generate its keys. The Postg

[GENERAL] Newbie Questions

I'm running the latest stable version of PostgreSQL on a Debian Linux box running Gnome 2.0. I've just started setting up my first database with PostgreSQL and I've got a few newbie questions:   [1] Is there a way to determine where all the parts of my defualt PostgreSQL installation are located?