Hi,
Can anyone help me understand why converting the NULL code point ()
from UTF8 to ISO8859_1 is no longer legal in v8.1.4? The conversion
proc
(backend/utils/mb/conversion_procs/utf8_and_iso8859_1/utf8_and_iso8859_1.c)
changed considerably between 8.1.3 and 8.1.4. The utf8_to_iso8859_1
con
Playing with postgresql I have seen that sometime a very long IN (list
of ids) can rise a max_recursion_error (or something like that).
An easy workaround when the list is computer generated and EXISTS is
infeasible (too slow), is breaking the list in log(n) OR parts.
Like in this python snippet:
Sue,you can walk an easier road to get your Excel Table filled with PostgreSQL data:there is an ODBC.Driver for PostgreSQL, you can google it or find it within the standard PostgreSQL for Windows Installer.
After installing the ODBC driver, PostgreSQL is a normal data soure to Excel; you can put yo
> I am relatively new to PostgreSQL, having only been exposed to it with
> a recent DSpace implementation (in the last 8 months or so). I have created
> a new database in PostgreSQL and have written a SQL query against the
> database. The database resides on a Sunfire V440 Solaris 9 machine.
Hi,
I am relatively new to PostgreSQL, having only been exposed to it with a recent DSpace implementation (in the last 8 months or so). I have created a new database in PostgreSQL and have written a SQL query against the database. The database resides on a Sunfire V440 Solaris 9 machin
[EMAIL PROTECTED] writes:
> As I wrote in my initial posting: source and target encoding is UNICODE. I can
> restore mentioned backups without a problem on a Windows host. And every
> backup
> I take is not restore-able on it's original host...
Indeed, 8.0.8 is stricter about encoding than prior
[EMAIL PROTECTED] wrote:
There must be something simple that I am missing, but here is my
problem. I am setting up a standard pg install as a backend to a small
webapp. I want to create a user "webuser" with only enough privileges
to query all of the tables in my database. It has not been work
Quoting Agent M <[EMAIL PROTECTED]>:
> Hi- you have an encoding problem. What is the string encoding of your
> old database? Another option is that your backup became corrupted.
As I wrote in my initial posting: source and target encoding is UNICODE. I can
restore mentioned backups without a probl
Hi all,
I encountered a somewhat big problem in Postgres which is effectively keeping me
from restoring any previous and future database dumps.
We are running FC4 with the latest updates. "SELECT version();" shows
"PostgreSQL 8.0.8 on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (
On Mon, Jul 17, 2006 at 02:25:20AM -0700, polder_udo wrote:
> Hello
>
> i am planning to use postgreSQL in a new project and have some very
> basic questions reguarding installing the product.
> The project will be written in C# and will be running only on windows.
> The software will be installed
On Mon, Jul 17, 2006 at 07:54:08AM -0400, John DeSoi wrote:
> On Jul 17, 2006, at 2:56 AM, Timothy Smith wrote:
> >is it possible to give a non super user the ability to create
> >another user of a different group?
> >i'm looking for a way to assign a special group of admin's just
> >enough rig
On Jul 17, 2006, at 2:56 AM, Timothy Smith wrote:
is it possible to give a non super user the ability to create
another user of a different group?
i'm looking for a way to assign a special group of admin's just
enough rights to create other lowbie users without letting them
bypass all othe
Hello
i am planning to use postgreSQL in a new project and have some very
basic questions reguarding installing the product.
The project will be written in C# and will be running only on windows.
The software will be installed via a standard setup.
1) Is it possible to install postgreSQL in "quit
[EMAIL PROTECTED] wrote:
There must be something simple that I am missing, but here is my
problem. I am setting up a standard pg install as a backend to a small
webapp. I want to create a user "webuser" with only enough privileges
to query all of the tables in my database. It has not been work
On 16 Jul 2006 at 17:12, [EMAIL PROTECTED] wrote:
> There must be something simple that I am missing, but here is my
> problem. I am setting up a standard pg install as a backend to a small
> webapp. I want to create a user "webuser" with only enough privileges
> to query all of the tables in my
Alex,
If you have 2 different sets of data, you might want to replicate both
ways in separate data bases. I mean set up on both machines 2 data
bases, one master and one slave on both machines. Then you can use 2
slony replication sets to replicate in both directions. This way if one
of the server
* Stefan Schwarzer:
> INSERT 0 1
>INSERT 48593 1
The former is printed if the table hasn't got an OID column (new
default), the latter is used when OIDs are available (old default,
nowadays it's CREATE TABLE ... WITH OIDS).
--
Florian Weimer<[EMAIL PROTECTED]>
B
Hi there,
how comes that sometimes, when I use something like this:
psql name_of_my_database < inserts.sql
Postgres displays
INSERT 0 1
INSERT 0 1
INSERT 0 1
but sometimes it counts
INSERT 48593 1
INSERT 48594 1
INSERT 48595 1
???
Altho
Title: RE: [GENERAL] cant connect to the database, even after doing start
this script is taken from the
distribution also
but i think the second check, to do stop -m
immidiate is home grown.
thanks,
regards
Surabhi
From: Scott Marlowe
[mailto:[EMAIL PROTECTED]Sent: Fri 7/14/2006 9:44
is it possible to give a non super user the ability to create another
user of a different group?
i'm looking for a way to assign a special group of admin's just enough
rights to create other lowbie users without letting them bypass all
other access restrictions.
---(end
20 matches
Mail list logo
