PostgreSQL Database Forum

Hi, I have a dump with a table with this field: "hdstart" integer which contains integer like 1042758000 1028152800 etc etc How can I convert it to a SQL Server DateTime field? Thank in advance and sorry for my bad english...

Is there an equivalent function for bytea columns that works like lo_import? Alternatively, is there a way to copy from a large object to a bytea column from SQL? Or maybe someone has another way of attacking this problem: I've got some Perl code that does this:

Greetings, Is there any kind of support for XQL in PostgreSQL ? I tried to google to find the answer, but couldn't find anything very useful -- aside from something related to OpenACS... Regards, Frederic ---------------------------(end of broadcast)---------------------------

Happy Thanksgiving to everyone! Sincerely, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com

Hi All; I may be able to do this in Perl, but if there is enough interest in doing something like this in C, maybe I can still help (however, consider your self warned about my skill at coding C). I am looking at the following design. The clustering daemon either need to run on separate computer systems or separate interfaces of the same...

How can I create an index on an array element? I seem to recall having done this in the past but I don't recall how. steve=# \d foo Table "public.foo" Column | Type | Modifiers -----------+--------+----------- textarray | text | steve=# create index foodex on foo (textarray);

Is there something in Postgres that corresponds to the rowid pseudocolumn in Oracle, which represents the unique address of the row of data in the table? If so, how would you access that in a query? -- Barbara E. Lindsey, COG RDC Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162

I noticed this gem for allowing the saving of MS-Project 2000 data into a Postgresql database, http://techdocs.postgresql.org/source.php#fmsproject posted by John P Cavanaugh probably a couple years ago, and was trying to make it work with pg 7.3.4 on RH 7.2. I got the odbc setup right, because I know I can connect to the database...

Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either a MySql shop or a Postgresql shop. It's my opinion that we should be using PG, because of the full ACID support, and the license involved. A...

Thought this might intrest any Postgres Users in the South East England area. The main talk at this meeting is on Postgres Vs MySql. Peter Childs -------- Original Message -------- Subject: Next GLLUG Meeting, 6 December 2003 Date: Wed, 26 Nov 2003 19:09:50 +0000 From: Zachary Struhs <gllugadmin@gllug.org.uk>

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This is a PGP-signed copy of the checksums for PostgreSQL version 7.4. The latest copy of the checksums for this and other versions, as well as information on how to verify the files you download for yourself, can be found at:

We have an interesting case where we want to use Postgres both as a database and a front end to a proprietary database. For the latter, we wrote functions that access the proprietary database. Then we defined views on the proprietary database and wrote rules for insert/update/delete on those views using the functions. The problem is that we...

I was wondering if there is something I can do that would act similar to a index over more than one table. I have about 3 million people in my DB at the moment, they all have roles, and many of them have more than one name. for example, a Judge will only have one name, but a Litigant could have multiple aliases. Things go far to slow when...

Hello list I use postgresql ODBC driver (Version 7.03.02) to access the database (7.3.4) running on RH8, the connection string is: DRIVER={PostgreSQL};DATABASE=dbmund;SERVER=192.168.0.103;PORT=5432; UID=postgres;PWD=foo;A7=50;A8=8192;USEDECLAREFETCH=1 I would like to know if is there a way to tweak the ODBC driver to get more speed for...

Hi, I would like to get the structures of all my tables m4_clients, m4_contacts etc. Help of pg_dump says : -t, --table=TABLE dump this table only (* for all) I have tried a : pg_dump -U postgres -s --table=m4_* my_database

Hello list I have two tables with identical structure, one holds 'correct' data (from an application standpoint) and the other has data 'in error'. Anyway, I need sometimes to query both tables at the same time, so I constructed an elementary view create view v1 as select * from t1 union select * from t2; But I would like to have an...

Hi I am trying to do an insert query but for some reason although there appears to be no exception thrown my data does not get into the database. I will try to explain what I am doing In SQL you can do the following sort of statement INSERT INTO mytable (fname, lname, age) VALUES ('Joe', 'Bloggs', 20); I realise this is not a java...

Hi, I just noticed something bad in our database: webshop=# select oid,* from content_loc where id=20488; oid | id | locale | name ---------+-------+--------+-------------- 9781056 | 20488 | any | Rise Part II 9781058 | 20488 | any | Rise Part II (2 rows)

Hi! If I correctly understand v7.4 manual, value, say, '2003-11-26 12:00' in TIMESTAMP WITHOUT TIMEZONE column should output '2003-11-26 19:00' for "+08:00" timezone. The following test results seem to be somewhat unexpected. Restting OS timezone (/etc/timezone and /etc/localtime in Linux) does not make the results more comfortable.

I'm not looking for an exact answer here, but instead something more "rule of thumb". If I have a table with many fields, and I retrieving small groups of fields during a SELECT, whereby the groups of fields are indexed and/or clustered, will I get a faster select in the left-most fields, or the right-most fields? Or will it not matter? It...

This is what I got installing the RPM for 9.0: file /usr/include/sqltypes.h from install of postgresql-devel-7.4-0.3PGDG conflicts with file from package unixODBC-devel-2.2.3-6 BTW I think that something is wrong with the file size between two distributions:

I'm looking to find out how many rows were effected during an update in a trigger. I ran across this message by jan talking about this feature possibly being added to postgresql 6.5, but I can't find any reference to such a feature in the current documentation. Did this ever make it into postgresql? ...

Is there a faq on this..cause boy it is giving me a headache. System is FreeBSD 4.9 System date returns Tue Nov 25 16:32:36 EST 2003 Postgres Version is 7.3.4 installed from the port collection I've set the datestyle to ISO, european I've set australian_timezones to true I've set TimeZone to local I do a SELECT CURRENT_TIMESTAMP as...

I'm trying some experiments with PostgreSQL 7.3.4 with inheritance. What I read is that if you implement triggers on a parent table, those same triggers won't fire if you add records to a child table. However, I tried it, and they did indeed fire, and worked perfectly. Same sources said that indexes (indices??) wouldn't work right. Is that...

> >Hi, > >I have posted this question yesterday. It doesn't seem to show up for some reason. Here is the problem: > >mm=# delete from signon where user_id='210'; >ERROR: get_typdefault: failed to lookup type 0 > >What is the cause and how to solve it? >