[GENERAL] stored function and grant execute

Hi,I'm developping a web application which use PostgreSQL as database.I'm quite surprise to see that grant execute does not exist for PostgreSQL v7.x, but only in v8.xSo how can i grant such right (execute) to my user in v7.x ? because function were already existing in v7.xthanks a lot,Maileen

Re: [GENERAL] Java Eclipse

I use the QuantumDB plugin.(http://quantum.sourceforge.net/) Provides a basic access to DBs with JDBC. It did not work with older PostgreSQL versions, but seems to work well with 8.1. P. Keith Hutchison wrote: Any views on the best way to access postgresql within java?

Re: [GENERAL] stored function and grant execute

P.M [EMAIL PROTECTED] schrieb: Hi, I'm developping a web application which use PostgreSQL as database. I'm quite surprise to see that grant execute does not exist for PostgreSQL v7.x, but only in v8.x So how can i grant such right (execute) to my user in v7.x ? because function were

[GENERAL] postgres 7 and eastern language

Hi,i would like to know what i have to do to make postgres 7 store some eastern languages with their particular letters. like czech, slovak, and so oni'm sure that some unicode possibilities exist but which ones ?basically, end user will type some text including these special characters and i

[GENERAL] Best open source tool for database design / ERDs?

What open source tool do people here like for creating ER diagrams? ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] stored function and grant execute

On Sun, May 28, 2006 at 02:11:59AM -0700, P.M wrote: I'm developping a web application which use PostgreSQL as database. I'm quite surprise to see that grant execute does not exist for PostgreSQL v7.x, but only in v8.x What version of 7.x are you running? The EXECUTE privilege was added in

Re: [GENERAL] postgres 7 and eastern language

Hi, i would like to know what i have to do to make postgres 7 store some eastern languages with their particular letters. like czech, slovak, and so on i'm sure that some unicode possibilities exist but which ones ? basically, end user will type some text including these special

[GENERAL] db crash after power crash

Hi. Some hours ago there was a power failure with my test machine while active inserting data. After power back the OS done some fsck, clean some files (related to postgres working directory). Then I connect to my DB and see this: billing=# \d ERROR: index pg_attribute_relid_attnum_index is

Re: [GENERAL] db crash after power crash

Anton Maksimenkov [EMAIL PROTECTED] writes: # reindexdb -s -U root -d billing Password: reindexdb: reindexing of system catalogs failed: ERROR: index pg_attribute_relid_attnum_index is not a btree This will not work unless backend is started with -P option. See the REINDEX reference page

[GENERAL] The server's LC_CTYPE locale

Hello Im got the following error when the query string was one of the Hebrew chars: SELECT upper('ש'); ERROR: invalid multibyte character for locale HINT: The server's LC_CTYPE locale is probably incompatible with the database encoding. after few minutes while gathering info i stoped

Re: [GENERAL] db crash after power crash

May I ask - how can I do it...? My ordinary startup command (from rc.local) like this # su -l _postgresql -c nohup /usr/local/bin/pg_ctl start -D /var/postgresql/data -l /var/postgresql/logfile -o '-D /var/postgresql/data' But I tried # su -l _postgresql $ postgres -D /var/postgresql/data/ -P

Re: [GENERAL] Binary Packages

Hi, On Wed, 2006-05-24 at 13:53 -0600, Leonel Nunez wrote: are the packaged rpms with the upgraded drivers ??? Yes and no. I'll give a resping as soon as PyGreSQL guys release a new version. Wait for the announcement in this list. Regards, -- The PostgreSQL Company - Command Prompt, Inc.

Re: [GENERAL] pg_dump on 7.4

We have a running postgresql 7.4 on our server (SuSE Linux 9), and at the moment there is no chance to upgrade. Through an unusual combination of constraints (spanning over schemas) the dump cannot be imported without errors anymore. Try using an 8.0 or 8.1 pg_dump with the 7.4 server.

[GENERAL] DB structure for logically similar objects in different states...

Hi, I was wondering if anyone had any experience with this type of setup and could share what they've learned. Basically we've got several different states that an item can be in. From what I've seen the way many places seem to deal with them is something along the lines of making bool values

Re: [GENERAL] db crash after power crash

Anton Maksimenkov [EMAIL PROTECTED] writes: But I tried # su -l _postgresql $ postgres -D /var/postgresql/data/ -P billing FATAL: catalog is missing 1 attribute(s) for relid 2662 In that case I'm afraid you're stuck: it looks like it's not just the index but the underlying catalog that's

Re: [GENERAL] The server's LC_CTYPE locale

Michael Ben-Nes [EMAIL PROTECTED] writes: Im got the following error when the query string was one of the Hebrew chars: SELECT upper('ש'); ERROR: invalid multibyte character for locale HINT: The server's LC_CTYPE locale is probably incompatible with the database encoding. Hmph. I can't

[GENERAL] Free 1000 Rupee bank note

Hi there, Help me by taking this survey. We can both get 1000 Rupees! Click here: http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0Oi=gmailp=4z=1tc=2 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] upgrade 8.0.4 to 8.1.4 breakage

fedora core 2, upgrade from 8.0.4 - 8.1.4 via RPM I've just upgraded, everything /seemed/ to go swimmingly, but now i cannot connect via PHP. I can connect fine through psql, and all my tables have been restored fine. Using PEAR MDB2 wrappers (MDB2-2.0.3). Has anyone else seen this? Is this