PostgreSQL Database Forum

Hello, I'm working on a datatype which I call dnaseq. The basic stuff like input/output functions, comparison operators, etc., work well. I have overloaded the CHARACTER_LENGTH function without problems: CREATE OR REPLACE FUNCTION character_length(dnaseq) RETURNS integer AS 'dnaseq','dnaseq_charlen'

hi, I'm using CVS source built postgres, may be one day later then the main site, but found one problem: I've set PGCLIENTENCODING environment before, for easy of typing, like export PGCLIENTENCODING=GBK in my .profile, but after I upgrade my postgresql to current CVS, I found problem, the database initialized using: initdb...

Hi, i am testing a few queries in my postgresql DB. The first query after reboot is always slower because of an empty OS page/file cache. I want to test my queries without any files in the linux kernel cache, just to know what would be the worst execution time. At the moment i stop postgresql and do something like find / -name foo

Hi guys, I am in troubles with a SERIAL field. I have five tables. A parent table and four child tables. When I do the INSERT in the parent table, I have an ID (generated) by the sequence (SERIAL field), and I have to use this ID to reference all child tables.

I am creating a database which is supposed to contain many data entries (events) that differ only in the date they occur. So let's say event 1 occurs every Monday, Tuesday and Sunday between January 1st and May 30th 2005. How do I store and manage such data in a meaningful way? The simple idea would be to store the event itself in one...

Hi, I know that the disk space of the database server should never run out.... but it can happen. Which is the worst case? May the database be corrupted? Mage -- http://mage.hu

Hi, I'm sure this has been asked before, but my searches haven't come up with an example. I'm writing a generic trigger function called from different tables in plpgsql that needs to get the value of the primary key column from OLD. I can find out the pkey column name by querying the system tables, but the only way I've found of...

Hi all I have to develop an embedded database using memory FLASH and memory RAM Some tables must be saved in RAM and some tables in FLASH ( RAM and FLASH are two different mounted directories in the file system). I saw it's possible to save different databases in different directories with CREATE DATABASE options. It's possible to save...

He wants to be in the big 8. He would like to be under the comp.databases.* domain and will not to move it to something like postgresql.*. So he seems to agree with what was my original intention, which was to make the current groups proper members of the big 8. I also offered to let him take over the process as he understands gatewaying...

When does using schemas make sense? Is it more effective or is it just to make a database more manageable? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bjørn T Johansen

I run these commands automatically every night: vacuumdb -a -z -U postgres reindexdb -a -U postgres Is there a way to temporarily disable all other connections to Postgres until these operations are complete? The operations take a while (about 20 minutes) and connections really pile up, sometimes crashing the server.

Hi, Environment: SunOS 5.7 Generic_106541-29 sun4u sparc SUNW,UltraSPARC-IIi-Engine Postgresql-7.4.6 Build config: --with-java --enable-thread-safety gcc version 3.3.1 less-381 readline-4.3

Hi, In 7.3 I was able to do: ALTER DATABASE babase SET "TimeZone" TO 'Nairobi'; a nice Posix TZ value (FYI UTC+3 w. no daylight savings time). In 7.4 this no longer works. I see some UTC+3 time zones in the 7.4 docs, but how am I to know that they correspond to Kenyan time, especially with respect to daylight savings and other...

A cathartic time, to be sure. However, could we at least limit the scatology to the *body* of the messages? It's very difficult explaining to one's boss as he looks over your shoulder that yes, indeed, this *is* a serious support list. Thanks. Mark Taber State of California Department of Finance Infrastructure & Architecture

Hi all, I was hoping someone might be able to set me straight so that I can get some select performance improvements. The table in question has several thousand rows currently, planning several million, it has a date time stamp column. All selects will be on ranges of the date time column. I created an index on the dt column, ran ANALYSE...

Hi! Is there any Way or have somebody a Function to do something like this copy skurs from 'http://ichart.finance.yahoo.com/table.csv?s=TKAG.DE&d=10&e=15&f=2004&g=d&a=3&b=5&c=1991&ignore=.csv'; Would be great if you could help me! THX Christian Meier

Hi all, I'm using postgresql 7.4.2 and could not create relationships between subclases. I hava a EER model where the superclass Person has subclasses like Customers. When I try to create a relationship between Customers and other relations the database won't let me. Is that correct and if so, when will this be fixed?

Hi, Can anyone suggest any websites that might help with connecting visual studio dot net (I would like to see it running using server explorer if possible) to postgresql. I am planning to write some client applications in VB or C#. Regards, Daron.

Only a simple question I have a table with primarykey(field1,field2,field3) and I want to execure a query like select * from my_table where field1 = some_value

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, I haven't found a way to set the client encoding of a psql connection other then "\encoding" which is arkward for batch processing. As .psqlrc is being ignored during batch processing and the internal encoding is being set *after* "-v", I have to resort to arkward solutions in...

Hi Since sometime yesterday, my postgresql (7.4.5) reports "ERROR: cannot compare arrays of different element types", when I analyze a specific table in my database. Here is the tables definition: Column | Type | Modifiers...

It is now time to cast your vote as to whether you would like these mailing lists to become legal USENET newsgroups. To vote, visit this web page: http://party.to/bardrock Fill out the ballot and email it to the address provided. Thanks.

hello all, i've got a database that takes up 4G of space. when i run a script that deletes all rows and then vacuum, the data directory gets down to around 3-3.5G. what i'd like is to get a blank database structure that really contains no data at all, or any unused space at all. apparently that's not what i'm getting now. is there a way...

Hello all, I have accidently :-) found 'initlocation' and now I like to know, how many secondary database i can create. I like to do that, because I have a Virtual Webserver and for each VirtualHost I have a local $USER. Now I like to create seperatly secondary databases for each $USER/VHost. Thanks

Hello. My name is Mike Cox. I am in charge of the changing of these postgresql lists. I have decided that we are going to drop most of the lists from the vote. We will only be making 4 lists into real Usenet newsgroups if we win the election. The rest of the lists are crap and they take up too much fucking room. Marc was an asshole for...