Hi,
We're running PostgreSQL 8.1.3 on an Intel iMac at work and I also
have it running just fine on my new MacBook Pro. No problems.
Compiled as is out of the box using the instructions at http://
keyvaluecoding.com
Thanks,
_
> > Suppose there 3 users red, green, blue. How can the user green know what
> > tables he has created?!
> > From psql command line \dt lists every table in the DB!!!
> >
> > Thanks in advance.
> >
> > Hrishi
> If you mean that the owner of the table(s) is the user "green", then try
> select * fro
If your DB encoding is UTF-8, I don't see why you can't use a TEXT
data type.
Regards,
Gavin
On Mar 2, 2006, at 7:07 PM, Perez wrote:
Any pointers/tricks/gotchas on storing XML into postgresql? Is it any
more complicated than storing the XML into a bytea field? Do I
have to
worry about
On Sat, 4 Mar 2006 19:34:49 -0800
Steve Atkins <[EMAIL PROTECTED]> wrote:
>
> On Mar 4, 2006, at 6:24 PM, Andrew L. Gould wrote:
>
> > I know PostgreSQL works on the PPC chip Macs; but has anyone
> > successfully installed PostgreSQL on one of the new Intel Core Duo
> > Macs?
>
> It's run fin
On Mar 4, 2006, at 6:24 PM, Andrew L. Gould wrote:
I know PostgreSQL works on the PPC chip Macs; but has anyone
successfully installed PostgreSQL on one of the new Intel Core Duo
Macs?
It's run fine on the intel developer macs for quite a while. I've not
actually
built it on the shiny ne
I know PostgreSQL works on the PPC chip Macs; but has anyone
successfully installed PostgreSQL on one of the new Intel Core Duo Macs?
Thanks,
Andrew Gould
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
Adding -general back to the distribution list. Please do a reply-all.
Even if you tell psql what encoding to use, if the database is created with the
wrong encoding it might not be able to differentiate between the two strings.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
On Sat, Mar 04, 2006 at 05:08:27AM -0800, [EMAIL PROTECTED] wrote:
> I have got one table named books with several columns.
> * The first question is :
>
> - All users can find titles, codes and prices of books (which are
> columns of the table books)
>
> So, I would like if a solution existed fo
On Sat, Mar 04, 2006 at 03:13:18AM +, [EMAIL PROTECTED] wrote:
>
>
> What is the query for retrieving a tables and a views definition from the
> system
> tables (in 7.4).
>
> I am trying to find my way in the system tables and I am finding very
> confusing,
> especially way in the way the
Hola , soy estudiante universitario y estoy interesado en
trabajar con PostgresSQL y me gustaría que me ayudaran mandándome información sobre
él
So there is Fedora Core 3 with PostgreSQL 8.1.3 installed from rpms.
The server listens on all interfaces. For testing, I used this
pg_hba.conf (default with added line) and it worked:
local all all trust
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
host all all 10.144.3.0/24 trust
What is the query for retrieving a tables and a views definition from the system
tables (in 7.4).
I am trying to find my way in the system tables and I am finding very confusing,
especially way in the way the tables are linked.
---(end of broadcast)
Hello,
For an exercise at university, I have several SQL queries to find to
manage privileges on a database.
I didn't found all the queries.
So, this is my problem :
I have got one table named books with several columns.
* The first question is :
- All users can find titles, codes and prices of
Hi,
the lsp-fix did the trick. As you supposed it
was a personal firewall (however a great product,
called armor2net personal), which unfortunately was broken
with the winsock lib.
Strange problem with it however, that it hasn't got any
problems with the earlier version of Postgres (last i had to
Hi,
Is it possible using tsearch2 to match a substring of an element of a ts_vec
column?
For example: I have a table with a ts_vec, and I have a field with text, and
if there is a value in the field "I would like to match the beginning of the
words" - and the ts_vec has " 'like':3 'match':5
Is there any way to crypt ODBC settings (user, password)? It seems to
be stored in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI in plain text. I
can use bogus data there and "cover" it with proper login and password
on application side, but... er... MSSQL does not store password in this
way...
It is
Thanks Scott, now I got it! ;)
I found older copies of pg_dump in "/usr/bin" while the newer were in
"/usr/local/pgsql/bin/".
Beginner's mistake... 8-)
Sascha
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your des
For anyone that is interested, my problem was solved on another list.
Turns out the TRUNCATE command that I run at the beginning of the SP
creates and holds an access exclusive lock on the table for the entire
duration of the SP. I changed it to DELETE FROM and my problem was
fixed.
Full discussi
Any pointers/tricks/gotchas on storing XML into postgresql? Is it any
more complicated than storing the XML into a bytea field? Do I have to
worry about character encoding? All my XML is in utf-8.
tia,
arturo
---(end of broadcast)---
TIP 9: In
I would like to have an installation program, which creates psqlODBC
connection, so there will be no need of typing and clicking on two
hundred workstations... There is the driver's msi file which can be
installed very nicely, but what is the best way of creating the
connection itself without much
Here is an example I always used as a start point in this type of project.
http://campbellcentral.org/rick/code/setup.html
Generally, I would store the datafiles on an NTFS partition - it seems
easier to reach NTFS from Linux then vice-versa.
I have seen this done successfully with virtually all
I have notebook which can be booted into Windows XP/NTFS and into Linux.
Notebook is not connected to any network. There are separate IDE partitions
for both OS.
I want same Postgres 8.1 database to be available in both modes.
I think I must put Postgres database cluster into a NTFS partition wh
On 2/23/06, Karl Wright <[EMAIL PROTECTED]> wrote:
> I have a situation where I need postgres to LISTEN and allow BINDs to
> its TCP/IP port (5432) only to connections that originate from
> localhost. I need it to not accept *socket* connections if requests
with new postgresql's (i dont know whic
"Bart Golda" <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> I would like to have an installation program, which creates psqlODBC
> connection, so there will be no need of typing and clicking on two
> hundred workstations... There is the driver's msi file which can be
> installed very nice
On Fri, Mar 03, 2006 at 09:01:53PM -0700, Michael Fuhr wrote:
> Could you explain what you're trying to do without reference to how
> you're trying to do it? It sounds like the goal is to take an
> arbitrary string and find out what rows in what tables contain that
> string. Is that right? If s
-Original Message-
From: [EMAIL PROTECTED] on behalf of Magnus Hagander
Sent: Sat 3/4/2006 9:46 AM
To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Subject: Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3
> But it specifically surprises me that it was necessary for psql
> the lsp-fix did the trick. As you supposed it was a personal
> firewall (however a great product, called armor2net
> personal), which unfortunately was broken with the winsock lib.
Obviously not a gread product, I'd say, if it breaks the winsock stack.
Which the hole purpose of a firewall is t
pgbench comes with PostgreSQL source code distribution and must be
compiled under PostgreSQL source tree.
I'm not familiar with MacOS but I guess there may be pre-compiled
package. Anyone can help him?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> I have just received my new MacBook (1.83Gz. Duo) and wan
28 matches
Mail list logo
