PostgreSQL Database Forum

In TransacSQL, we used to have the tabled sorted by marking an index for example by create_date. This way we did not need to do an order by or at least it was faster. Is there a way to force the table to be physicaly stroed sorted by a certain index? tia, ..V

Hiya Everyone, Can anyone explain how postgreSQL reads from a text file into tables already created in PostgreSQL? I am also checking the thread in the Forum just to see if someone has written about it in the past. Thanks.

After being frustrated with the inflexible output of intervals, I've written a pl/pgsql function to do what I want, and hopefully some other people might find it useful. Output is a string that matches the output format of an interval as closely as possible, but rather than counting days as a fixed 24-hours, it recalculates days based on...

I want de unsuscribe from this site .how can I do? Vous manquez d’espace pour stocker vos mails ? Yahoo! Mail vous offre GRATUITEMENT 100 Mo ! Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

I've started using pgpool and while everything appears to be working, I've been getting a lot of the following errors in my logs: ---- ERROR: pid 14761: pool_read: EOF encountered ---- This seems to be simple enough - the client/user probably just canceled the request and isn't anything to be concerned about? I get about a dozen of...

If I have have the table: create table foo ( a int references bar(id), b int references baz(id) ) .... how do I make sure one and only one of the columns a and b are non-null? Is it even reasonable?

I'm trying to stress PostgreSQL 8beta3 on AIX5.2 with TPCH 1 Go I have created and configurated a database on 2 tablespaces : first one for indexes and second one for tables First script for database creation: $ more scrCreateDataBase.sh psql template1<<! create tablespace dataTbl location '/postgres_data/TpchDataTableSpace'; create...

I'm looking for the file postgres.h in my recent install of postgres-7.4.5 on a MacOS 10.3.5 system. I'm attempting to build PyGreSQL-3.5, which appears to require the postgres include dir. My build of postgres-7.4.5 did produce an include dir, /usr/local/pgsql/include;

I thought I had seen something that indicated that v8 was going to provide a means to mirror databases without needing all the triggers etc. I downloaded beta 3 but couldn't see anything that would do this. My goal is to mirror a database from one server to another, hopefully from the logs so that there is nothing added to the database. The...

I must pass NEW row to function count_room(rowtype) as in this code, but pgsql return "_ NEW used in query that is not in a rule". I have a bad syntax or is impossible pass NEW.*? thanks, Ale _ CREATE OR REPLACE FUNCTION public.dr_aggiorna_consistenze() RETURNS trigger AS '

Hello, In mysql, we use "show processlist" to see all current process. Could someone let me know in PostgreSQL, what commands that we can check the current connections and processes please? Thanks a lot, Ly

I have this problem, I wrote a script to insert data into a table, one of the columns is a birthdate now I only have the last two year digits, and this all worked fine. Until I did a portupgrade (i am running on bsd 5.2.1 and 4.8 and postgresql 7.3.6 & 7.3.7 respectively) script worked fine before the upgrade, now however, any year before 70...

So, as far as I know, PostgreSQL does not have any way of verifying the loss of referential integrity. Are there any recommended methods or utilities for checking referential integrity in a PostgreSQL database?

Hello- I am in the process of translating a site using mysql as the backend over to postgres. I have a lot of time data that I would like to display to the user in the form of a schedule. I am using the to_char function to make the times human friendly to_char(class_schedule.endtime, 'HH:MI:SS AM')

I have a database which started on Pg 7.1, moved to 7.2 via pg_dump/restore, and ultimately to Pg 7.4 likewise. While it was in 7.2, I added one user and granted access to various tables. After the 7.4 migration, that user was no longer needed, so was removed via "dropuser" command line tool. Now, when I pg_dump that db using the version...

I'm running PostgreSQL 8.0 beta 1. I'm using the earthdistance to find the distance between two different latitude and logitude locations. Unfortunately, the result seems to be wrong. Here is what I'm doing: select earth_distance(ll_to_earth('122.55688','45.513746'),ll_to_earth('122.396357','47.648845')); The result I get is this:

Hi , I tesetd the lower/upper support and cyrillic and it looks broken. My system: pg 7.4.3 freebsd 5.2.1. I created my database with 'UNICODE'.

subscribe ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Hello, I'm wondering if postgres has a way to determine the last transaction time (and even better, what the transaction was). I've read through the mail list archives and the only thing I've seen is a suggestion to stat the database files. Is there another way to do it using something within postgres (e.g. one of the pg_* tables?) ...

I cant seem to get pg_restore to work for me. here's how im calling it: pg_restore -d <dbname> -C -v -U <user> <src tar file> It keeps on telling me that the database <dbname> does not exist so it cant connect to it. I thought the -C flag creates the database, what am i missing here?

Hi, I've setup a postgres server (7.4) and confirmed that SSL is enabled - I can successfully connect via tcp socket over SSL using the psql client. From PHP4, how can I get the pg_connect function to negotiate an SSL connection? I gather from researching the issue that pg_connect uses the same libraries as psql, so that this should be...

Hi, Is there a way to set locale per query (i use latest JDBC drivers). I am in situation, where we need to make ORDER BY querys over data that is in various langages - English, Russian, Estonian, Latvian. I know that there are issues with indexing that column in such case, but what are my options other then sort results in my program...

please cc me as I am on digetst: -------------------------------- What is the storage format of 'date'? Is it like a timestamp? I want to know in order to choose representations in a table that will receive LOTS of reads with a WHERE clause that chooses dates, and TIMES, past a supplied reference. ---------------------------(end of...

Hi, I'm working on a new product for PostgreSQL (description below) and I'm looking for a few more Mac users who might be interested in beta testing. The first release will be for Mac OS X 10.2 or later. A Windows version will follow, most likely in November. Drop me an email if you can spare a little time to take a look and provide some...

Hi, I'm trying to create a database with 2 tableSpaces one for data table and one other for indexes I have created a schema on my tablespace for datas and a table in this schema, I would like to verify that this table is on the right tablespace. I don't know how to do that. \d <tableName>, \d+ <tableName>, \db+ don't show this...