> Hi Jan,
>
> We had something similiar to this in the past. The entire text was broken
> down into lines (80 characters each) and stored as individual rows in a
> table. The problem with this approach was that you can't search for phrases
> that span rows, so I'd like to be able to store the en
unsubscribe
I have created a group in postgres by inserting a group name into
pg_group as suggested in the on-line documentation. I then add a user to
this group using the appropriate create user syntax. Finally, I grant
privileges to the group for a specific table. The system responds
affirmatively up this
> Hi,
> Can somebody give me an example of how to insert a byte array for
> example
> { 12, 24 , 0, 3 , '\' , 40 } into a column declared as type bytea.
> Statements in psql is what I am looking forward to know
Use the string 'abc\003d'. Double-backslashes are optional. Bytea
outputs data
> Afaik, not possible, at least I couldn't get any \0s into bytea column
> from psql nor from perl DBI interface. You need blobs if you want to store
> data which contains embedded nulls. Or so I think.
> -alex
Double-backslashes are the trick.
test=> insert into vv values ('ab\\000d');
INSERT 2
Afaik, not possible, at least I couldn't get any \0s into bytea column
from psql nor from perl DBI interface. You need blobs if you want to store
data which contains embedded nulls. Or so I think.
-alex
On Sun, 19 Mar 2000, Radhesh Mohandas wrote:
> Hi,
> Can somebody give me an example of
I have attempted to configure PostgreSQL as described on the website
to use a different location to no avail. Any hints, suggestions or
instructions
would be appreciated.
RedHat 6.1 and the version of PostgreSQL that came with it.
Michael Black
At 08:43 AM 3/20/00 +0900, Tatsuo Ishii wrote:
>> and
>> will it be possible to set a cut-off period, a la shutdown, after which all
>> backends will be killed, e.g.
>
>Not possible in 7.0. However, it seems to be an interesting idea and I
>would try it after we shipp 7.0. (we are in the beta per
Stan Jacobs wrote:
>
> This isn't quite what I'm looking for, though I can't run a script on
> that machine, so I need to retrieve it with an SQL query. Ie. "SELECT *
> from data_key_table_name_something"... *smile* Judging from the few
> responses so far, it doesn't sound like there's an
On Sun, 19 Mar 2000, martin wrote:
> Hi there, I have been doing some performance testing with ODBC and have
> found that
> ODBC is much slower than using C to call the Psql API
> I don't understand why the results are like this, I thought ODBC would
> slow things down a bit but not my much, all
On Sun, Mar 12, 2000 at 05:57:50PM +0200, Raigo Lukk wrote:
> Hi
>
> > > > alter table tmp add column last text;
>
> I had this same problem, turned out that PostgreSQL don't have
> this feature :-(
>
Upgrade:
ALTER TABLE tablename ADD COLUMN columnname columntype
Has been a feature since
I'm getting the following error when building with current sources
as of 12-Mar-2000:
ERROR: Relation 'pg_user' does not exist
This happens whilst creating a new DB from scratch (initdb-createdb-psql).
Hints greatly appreciated...
Regards,
Ed Loehr
Detailed output for context:
% kil
[Cc'ed to hackers list]
> > In 7.0 there will be a tool called "pg_ctl" that controls
> > starting/restarting/shutting down postmaster. Moreover there will be
> > "smart shutdown" mode in that postmaster waits untill all backends get
> > logged off.
>
> Will postmaster also refuse to take connec
Hi,
I just wanted to pass along the attached C routine for calculating the
"edit" distance between two strings. Some others may find it useful.
(I wrote this code because I needed to do a "fuzzy" join between two
columns with small typographic errors between the corresponding keys.)
Here's som
Why am I the only one whose filters still work for all my lists, with a
*very* simple rule of:
:0:
* ^TO_((pgsql-)?)general@(hub|postgresql).org
$MAILDIR/folders/pg-general
If someone wants to suggest to me what variable to change to set an
'X-Mailing-List' header, or some such, please feel fre
The list owner has approved your request.
Here are the results:
The following was not successfully removed from pgsql-general:
[EMAIL PROTECTED]
No matching addresses.
This isn't quite what I'm looking for, though I can't run a script on
that machine, so I need to retrieve it with an SQL query. Ie. "SELECT *
from data_key_table_name_something"... *smile* Judging from the few
responses so far, it doesn't sound like there's an easy way to do this.
On S
Hi there, I have been doing some performance testing with ODBC and have
found that
ODBC is much slower than using C to call the Psql API
I don't understand why the results are like this, I thought ODBC would
slow things down a bit but not my much, all its doing in sending off SQL
straight the serv
Hi,
Can somebody give me an example of how to insert a byte array for
example
{ 12, 24 , 0, 3 , '\' , 40 } into a column declared as type bytea.
Statements in psql is what I am looking forward to know
Cheers,
Radhesh Mohandas
***
Hello
I have some problem with memory leak using postgres 6.5 (?) on debian linux 2.1.
I have writen following C program:
#include "libpq-fe.h"
#include
#include
PGconn* db;
char d[1001];
char c[5000];
signed long r1,r2,r3,r4,r5;
int i,p,q;
PGresult* dbout;
unsigned long er (unsigned long fr
I'm a Sybase pmgmr by trade. I'm looking into creating an app on
Linux. I don't have the $ for SAE so I'm looking at others. PGSQL has
always been on my short list. Does it have the capability?
Do you know of any sites that are dynamically generating pages from a
PGSQL database?
Can I interf
Hi,
There are some system tables in any pg database which contain information
about table/field names/types and descriptions. use -e with psql command,
and look at the sql code when running /d commands.
regards.
Omid Omoomi
>From: Stan Jacobs <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject
- Original Message -
From: Tatsuo Ishii <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, March 18, 2000 1:12 PM
Subject: Re: [GENERAL] what is the most appropriate way to shutdown the
postmaster?
> In 7.0 ther
On Sat, Mar 18, 2000 at 09:34:37PM -0500, Chris Gokey wrote:
>
> I was hoping that someone could help me optimize this query. This takes
> FOREVER under PostgreSQL.
>
> select distinct data_center, center_long from de_center where de_center.de_id
> in ( SELECT distinct de_parameters.de_id FROM
Hi everyone,
This probably isn't a Postgres-specific question, but I'm hoping that
someone knows the answer to this off the top of their heads... :-)
I'd like to retrieve the table definition via SQL. I'm using ColdFusion
to access a PostgreSQL 6.5.3 database, and I'd like to retrieve the tabl
Dit you do an initdb as postgres?
i.e. you have a: /usr/local/pgsql/data dir?
Cheers Wim.
- Oorspronkelijk bericht -
Van: Greg Brzezinski <[EMAIL PROTECTED]>
Aan: <[EMAIL PROTECTED]>
Verzonden: Saturday, March 18, 2000 4:53 PM
Onderwerp: [GENERAL] Problem with beta2 and shapshot ???
26 matches
Mail list logo
