PostgreSQL Database Forum

Hai.. I introduce myself, my name : Agus, from Indonesia. Im develop application using POwerbuilder 7 and postgresql 7.3. I have serveral error, and cannot solve yet. Anybody help me? This is the error : 1. When I connecct postgresql using powerbuilder , there is message like this ... Catalog tables could not be created and are not...

Is there a way to replicate one-off(a copy of duplicate) of an existing Postgres database. regards, caroline __________________________________ Do you Yahoo!?

I'm still getting lots of SMTP hits from varying servers attempting to deliver mail to my tagged email address, used only for subscribing to this list. The delivery attempts are using the same envelope sender address style as is used by the list itself. But is this real mailing list attempts from a messed up server or network, or is it a...

How may I do a INSERT ON DUPLICATE KEY UPDATE like in mysql: http://dev.mysql.com/doc/mysql/en/INSERT.html ? Eduardo ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

I want to know how functional indexes are used "in the real world". Here are the common uses: * non-unique index on the first parts of a longish text field (SUBSTRING(field)) to save disk space, while still allowing faster searches than a sequential scan. * indexing on LOWER(field)/UPPER(field) to allow case-insensitive searches or...

Hi, Does anybody know how I can get error codes using psql? I know that I could get error codes from server log or using libpq function. I just could not figure out a way to display them in psql. -- Tatsuo Ishii ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Hi, I have read in this list and elsewhere the problem with indexes and big int. Still, I have an index that is used or not, depending of the parameter value used in the query. I am using PostgreSQL 7.4.3 on Linux RH ES3. Here's the table: test=> \d dmaildatum Table "public.dmaildatum" Column | Type | Modifiers...

-- Petre Daniel,System & Network Administrator. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Hi, If I have R(a integer PRIMARY KEY, b text, c text, d integer); and I want to find how many different entries there are, (specified using b and c instead of a), is "select count(distinct b||c) from R" an appropriate query? Also, if I want to find how many of those that have a different "d", can I use "select count(d) from R goup by title...

Hi All, Is it possible to find the size of a pgsql table. TIA -- regards, Deepa K

Dear All, I have a C program using postgresql api (embeded SQL). I plan to distributeit's source under the terms of GNU. I would like to know if there is any restrictions for this issue. Regards, -- Ertan Küçükoðlu ertank@ozlerplastik.com

In using pg_dump to dump an existing postgres database, I get the following: pg_dump: WARNING: out of shared memory pg_dump: attempt to lock table <table name> failed: ERROR: out of shared memory HINT: You may need to increase max_locks_per_transaction. postgresql.conf just has the default of 1000 shared_buffers. The database itself...

Hi everyone. I need to create a C function that returns a row, and the type of this row must be the same of a type that I've created using CREATE TYPE. I've seen the function: TupleDesc TypeGetTupleDesc(Oid typeoid, List *colaliases) but I don't understand two things: 1)I just know the name of the type, not its oid... woud it be ok if I

Trying to create a plperl function to strip non-friendly mainframe characters from a string. However, when I try to add the Trademark symbol (â„¢) as a replace criteria, PG spits back an error: ERROR: Could not convert UTF-8 to ISO8859-1 Any way I get around this? CREATE OR REPLACE FUNCTION public.mainframe_description(varchar) RETURNS...

Is there a way to make Postgresql case-INSENSITIVE? Thanks

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? ...

Hi! I am new with PostgreSQL and I want to know if this database give the possibility to verify automatically, each night, if some records are too old (by example, if session_date is older than a month) and if so delete them. Thanks for your help! Melanie

Priem, Alexander said: > I recreated my entire database (luckily I keep scripts for > table/index/view > creation) and initdb-ed it using --lc-collate=C --encoding=UNICODE. In my > psqlODBC DSN settings I added "set client_encoding='LATIN9';" to the > Connect Settings and that solved all my problems regarding the > special characters. ...

hi, the man page says pg_dump cannot dump "large objects". can some one help me on what does this realy mean? how large is large? if we have some icons can we still use pg_dumpall to backup the db? also large objects do not include large strings, right?

hello, I'm facing an odd problem. I have a query: SELECT "Kürzel", "Autor(en)", "Titel" FROM "tblTitelangaben" WHERE "Titel"||"Kürzel"||"Monographie-Kürzel"||"Autor(en)" ILIKE '%er%'; this works like a charm.

Hello I like to grant some permissions to the user www-data (default user for apache under debian) GRANT SELECT, UPDATE, INSERT, DELETE ON customer TO herbie, www-data; The statements throws the following error: ERROR: parser: parse error at or near "-" at character 64

hello, I installed progresql 7.3.1, windows proof of concept, on a AMD 1.8 OS Windows XP. So it should run without cygwin. When I try to dump/restore a database I always get the message from windowsit can't find cygz.dll. Windows tells me to reinstall progresql. I assume I have to install extra libraries...or is it already a bug in the...

Hey, I've searched for MD5 crypting function in PG, but I did not find it. Anyone knows how to implement this function in PG ? Best wishes, Marek L. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

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...

_________________________________________________________________ High-speed users—be more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster