PostgreSQL Database Forum

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

Hi, FWIW, I walked into this one when changing an int into a numeric(5,1) : IF ( 0::int ) => interpreted as false IF ( 0.0::numeric(5,1) ) => interpreted as true

Scenario: I want to modify the PostgreSQL source code to customize per customer requirements, add new features and then package PostgreSQL with my own developed application. Then I want to sell/lease that sw/hw package to customer. I will only sell/lease software binaries to the customer and not the source code of modified PostgreSQL and my...

Just wondering what the feeling is regarding when the end of beta might be. -- Nigel Andrews ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

There is a funciton to convert numbers into string?>? str:=string(3234); ?? _________________________________________________________________ Las mejores tiendas, los precios mas bajos, entregas en todo el mundo, YupiMSN Compras: www.yupimsn.com/compras

end end

end end

Hello, Can anybody tell me, whether PostgreSQl is supported on AMD64. If so where can I download from and what is the complexsity in installing them. regards, prahalad

Hi, My problem is rather complex. I will try to explain it clearly (I hope !) Sorry for my poor english. I'm tracking change of state for entities (something than can be monitored.) The set of states are limited (state1 to state5.)

hi, i make programms with c# and i would like to know if there is an alternative to odbc(wich is not really fast) to dialog with postgre. thanks thierry

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

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

I'm writing a function in C, and am trying to return a row, containing Numeric and array types. I'm building the row with heap_formtuple. I'm havingtrouble creating the numeric and array Datums. If anyone has some examplecode illustrating this, that'd be great. -Adam

I may have found a bug. I have a table: CREATE TABLE onlpcd_stat ( sel BIGSERIAL PRIMARY KEY, user_id INTEGER NOT NULL REFERENCES onlpcd_user ON DELETE CASCADE, vars TEXT, /* string of Perl var hash */ cre_ts TIMESTAMP DEFAULT NOW()

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

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?

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

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

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