[GENERAL] Link tables from different databases

2008-05-17 Thread Reuben D. Budiardja
-- Reuben D. Budiardja -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Client lib v. 7.3 to access 8.0 db server. Compatible ?

2005-02-19 Thread Reuben D. Budiardja
On Saturday 19 February 2005 12:38, Robby Russell wrote: > On Sat, 2005-02-19 at 10:02 -0500, Reuben D. Budiardja wrote: > > Hello, > > I mainly use PHP to access my database. The PHP in the server is compiled > > with postgreSQL client lib v. 7.3. I am planning to upgrade m

[GENERAL] Database Link between 2 PostgreSQL db

2005-03-12 Thread Reuben D. Budiardja
a remote PostgreSQL server from a local PostgreSQL database. Thank you in advance for any respond. RDB -- Reuben D. Budiardja Dept. Physics and Astronomy University of Tennesse, Knoxville, TN -BEGIN GEEK CODE BLOCK- Version: 3.12 GIT/M/MU/P/S d-(++) s: a-- C++(+++) UL P-- L+++>+++

[GENERAL] Help with sorting (ie. ORDER BY expression)

2005-02-05 Thread Reuben D. Budiardja
question_id IN (2,10,3,6,4,5) ORDER BY question_id (2,10,3,6,4,5) Is there any way I can do that, so that the output of the query is question_id, text 2 ... 10 3 6 4 5 Thanks for any help. RDB -- Reuben D. Budiardja Dept. Physics and Astronomy University of Tennesse

[GENERAL] Client lib v. 7.3 to access 8.0 db server. Compatible ?

2005-02-19 Thread Reuben D. Budiardja
PHP, since it's actually ship with the linux distro I'm using (RHEL 3). Thanks in advance for any info. RDB. -- Reuben D. Budiardja Dept. Physics and Astronomy University of Tennesse, Knoxville, TN ---(end of broadcast)--- TIP 9: the pl

[GENERAL] Foreign Key can't refer to one of 2 primary keys

2003-06-21 Thread Reuben D. Budiardja
I don't se any obvious reason why I cannot do that. Any help? Thanks. -- Reuben D. Budiardja ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] Error with word 'desc'

2003-06-24 Thread Reuben D. Budiardja
varying(10)| not null desc | character varying(100) | mod_user | character varying(15)| mod_time | timestamp with time zone | default now() Primary key: or_code_table_pkey Any help is greatly appreciated. Thanks. RDB -- Reuben D. Budiardja Department of Phys

[GENERAL] INSERT WHERE NOT EXISTS

2003-06-25 Thread Reuben D. Budiardja
the docs and googled but haven't found anything. Anyhelp is greatly appreciated. Thanks. RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /"\ ASCII Ribbon Campaign against HTML

Re: [GENERAL] INSERT WHERE NOT EXISTS

2003-06-25 Thread Reuben D. Budiardja
insert into table (field) values (value); > commit; Yes, but I don't see how this is more efficient than what I said previously (??) Thanks though. RDB > On Wed, 25 Jun 2003, Reuben D. Budiardja wrote: > > Hi, > > I am developing application with PHP as the front end, PGSQ

Re: [GENERAL] INSERT WHERE NOT EXISTS

2003-06-25 Thread Reuben D. Budiardja
ning error), so I can check on that and > > do update instead. > > This kind of query should work; just leave out the "FROM dummy_table" bit. > (in Oracle it would be "FROM dual"). Hi, this seems to work. Thanks. Don't know why I didn't just try it. A

[GENERAL] postgresql.org is unreliable

2003-07-01 Thread Reuben D. Budiardja
Hi Does anyone else find the site postgresql.org kinda unreliable? Many times it's stalled for a while. And it's not just today, but very often. It's really frustrating especially when I regularly use it to look up documentation. Is there any mirror to the site ? Thanks. R

Re: [GENERAL] Duplicate key insert question

2003-07-01 Thread Reuben D. Budiardja
On Tuesday 01 July 2003 08:45 pm, Jean-Christian Imbeault wrote: > Reuben D. Budiardja wrote: > > Hi, not sure if this is answering your question, but I just asked similar > > questions here. I asked about using INSERT WHERE NOT EXISTS (which you > > can do in Post

Re: [GENERAL] Duplicate key insert question

2003-07-01 Thread Reuben D. Budiardja
On Tuesday 01 July 2003 09:25 pm, Jean-Christian Imbeault wrote: > Reuben D. Budiardja wrote: > > No, onlu *one* of them will fail, but yes, the other will then generate > > error. So it really is a trade off. Another way would be to lock the > > table, as other ha

Re: [GENERAL] postgresql.org is unreliable

2003-07-01 Thread Reuben D. Budiardja
On Tuesday 01 July 2003 08:47 pm, The Hermit Hacker wrote: > On Tue, 1 Jul 2003, Reuben D. Budiardja wrote: > > On Tuesday 01 July 2003 06:54 pm, The Hermit Hacker wrote: > > > On Tue, 1 Jul 2003, Reuben D. Budiardja wrote: > > > > On Tuesday 01 July 2003 06:

Re: [GENERAL] Duplicate key insert question

2003-07-01 Thread Reuben D. Budiardja
On Tuesday 01 July 2003 11:08 pm, Jean-Christian Imbeault wrote: > Reuben D. Budiardja wrote: > > INSERT INTO mytable > > SELECT 'value1', 'value2' > >WHERE NOT EXISTS > > (SELECT NULL FROM mytable > >

Re: [GENERAL] New Poll @ Codewalkers

2003-07-23 Thread Reuben D. Budiardja
umn's datatypes do not match > > ---(end of broadcast)------- > TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faqs/FAQ.html -- Reuben D. Budiardja Department of Physics and Astronomy

Re: [GENERAL] How to encrypt data in Postgresql

2003-07-25 Thread Reuben D. Budiardja
; > PostgreSQL that can encrypt the data with MD5? > > > > I would like to encrypt the data in PostgreSQL, so other program can > > use the same function. Can anyone give me some hints? What key word > > should I search in the document? > > > > Thansk! -- Reube

Re: [GENERAL] Can I turn the case sensitive off

2003-07-25 Thread Reuben D. Budiardja
d table using pgaccess and type them in UPPER case for both column name and table name Then I could not access from psql. After banging my head to the wall for couple days, I then realize I have to use the double quotes. So somehow pgaccess write the create table statements using doble quotes.

Re: [GENERAL] Fatal error: Call to undefined function: pg_connect()

2003-08-05 Thread Reuben D. Budiardja
On Tuesday 05 August 2003 03:31 am, Jean-Christian Imbeault wrote: > shreedhar wrote: > > Is it necessary to uninstall previous version of PHP in my system. > > No,but a new recompile will probably over-write the version you have now. > > > Which is the better compatible ve