Re: [GENERAL] statement level triggers in PostgreSQL , anybody??

It's true, PostgreSQL can only check a unique contraint at the time the row is inserted and can't defer it to the end of the statement due to the way they are implemented (using the indexes). Sure, there has been talk about it but I don't think anyone has done it yet. The thing is that for the vas

[GENERAL] Turn off "money" formatting?

Is it possible to turn off the "$" and "," that appear in "money" formatted columns so I can dump the table in a numeric format? The man page hints that lc_monetary controls the formatting but I cannot find any clues on what to do... Apparently money cannot be cast to anything. I don't think it

Re: [GENERAL] table content transfer from mysql to postgresql

Tools already exist to convert a MySQL dump to a PostgreSQL format in contrib/mysql. You may wish to do some hand tuning before importing the converted dump into PostgreSQL. Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of brijesh Sent: Friday, June

Re: [GENERAL] table content transfer from mysql to postgresql

[EMAIL PROTECTED] (brijesh) wrote: > Sir, > I am a development engineer in network application > I have a problem regarding upgrading my database > the problem is how do I transfer the contents from one table in a > database from one server to postgresql database table in another > server. > the d

[GENERAL] COPY error handling

Hi, I'm not sure if this is the correct group for this question, but I'll post it hoping that it is. I'm loading several ~15 million row files into a table using the COPY command. Apparently one of the rows, about 6 million in, has an invalid entry. This is causing the COPY command to fail, so m

Re: [GENERAL] statement level triggers in PostgreSQL , anybody??

> This has nothing to do with triggers, it has to do with not being able > to defer UNIQUE constraints. The classic solution is: > > update SET column = -column; > update SET column = -column+1; Thanks for the reply. Is changing query the only way to do this in postgres? I would expect some mor

[GENERAL] table content transfer from mysql to postgresql

Sir, I am a development engineer in network application I have a problem regarding upgrading my database the problem is how do I transfer the contents from one table in a database from one server to postgresql database table in another server. the data contents is in few MB. can you suggest me an e

Re: [GENERAL] JDBC: what exactly does nullsAreSortedHigh() return?

Vikas Rana wrote: Hi all, I am a bit confused about the method java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this return? If this returns true, are nulls considered as the highest value? Or does this mean that nulls comes first when sorted in ascending order (opposite in meani

Re: [GENERAL] JDBC: what exactly does nullsAreSortedHigh() return?

Vikas Rana wrote: > > Hi all, > > I am a bit confused about the method > java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this > return? If this returns true, are nulls considered as the highest > value? Or does this mean that nulls comes first when sorted in > ascending order

[GENERAL] JDBC: what exactly does nullsAreSortedHigh() return?

Hi all, I am a bit confused about the method java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this return? If this returns true, are nulls considered as the highest value? Or does this mean that nulls comes first when sorted in ascending order (opposite in meaning to the first).

Re: [GENERAL] CREATE DATABASE on the heap with PostgreSQL?

Albretch wrote: After RTFM and googling for this piece of info, I think PostgreSQL has no such a feature. Why not? . Isn't RAM cheap enough nowadays? RAM is indeed so cheap that you could design diskless combinations of OS + firewall + web servers entirely running off RAM. Anything needing per

[GENERAL] zope, postgresql and idle connections

hi! i have searched a lot in these pgsql-groups and on the internet, but found no really helpful information for my problem. the famous error >> database "xyz" is being accessed by other users is my problem. i use postgesql 7.3.2 and zope 2.6.1 (python 2.1.3). i want to create and drop databas

[GENERAL] Intalling PHP 4.3.7 with PGSQL support and Heimdal

Trying to portupgrade my PHP 4.3.6 package with PostgreSQL 7.4.2 support and getting this error below. Trying to setup postgresql with Heimdal Kerberos 5 support, believe I have, but not tried anything with it, yet.   /usr/local/lib/libpq.so: undefined reference to `krb5_cc_get_principal'/us

[GENERAL] Changing from money...

>From Day One I have been using "money" in all of my tables, sigh, I guess it is time to change... Any suggestions on what to change to and how to conveniently do the transformation. Anything to watch out for? I have about 6 tables and the largest only has about 3300 rows. Jerry ---

Re: [GENERAL] row access

On Sat, Jun 05, 2004 at 18:50:56 +0200, Bambero <[EMAIL PROTECTED]> wrote: > GRANT for row access ? It looks like you may be expecting individuals to own rows. I didn't read that into your original post. GRANTing appropiate rights could allow a table owner to be able to INSERT, UPDATE and DELETE

Re: [GENERAL] pg_class could not be found

we are running redhat version 7.3.6-1 for EL AS3. most of our db can be analyised by your tool. bot only one is not. if we dump this one, init a db, then import with template1, things are ok and your tool can be used against this new db. any suggestions? please cheng --- Martijn van Oosterho