Druid works ok
http://druid.sourceforge.net/index.html
BTJ
On 28 May 2006 05:19:04 -0700
[EMAIL PROTECTED] wrote:
> What open source tool do people here like for creating ER diagrams?
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked
I use the azzuri eclipse plugin. It's rudimentary, but get's the job
done for smaller (a couple of dozens of tables) models. It has a
commercial version which might be even better.
t.n.a.
On 28 May 2006 05:19:04 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
What open source tool do people
brian ally wrote:
fedora core 2, upgrade from 8.0.4 -> 8.1.4 via RPM
Did you upgrade the php-pgsql library at the same time?
Not 100% sure if you'll need to do that - probably will need to because
the postgres internals will have changed quite a bit between those versions.
--
Postgresql & p
~ahem~
I'd forgotten to adjust pg_hba.conf
All is good. Carry on.
brian
brian ally wrote:
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 b
Eci Souji wrote:
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 m
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
Hi there,
Help me by taking this survey. We can both get 1000 Rupees! Click here:
http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0O&i=gmail&p=4&z=1&tc=2
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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.
"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 th
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 t
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. 7
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.
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
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 get
"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 referenc
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
> 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
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
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
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 w
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
>
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?
--
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
Ri
23 matches
Mail list logo
