Joseph Daniel Zukiger wrote:
> It looks like I'm may have to finally subscribe through my isp and
> learn how to configure a newsreader in order to vote in favor, instead
> of posting through google all the time. That should speed my access to
> usenet up quite a bit. Oh, well.
>
> JouDanZuki
Y
Hello. My name is Mike Cox. I am in charge of the changing of these
postgresql lists. I have decided that we are going to drop most of the
lists from the vote. We will only be making 4 lists into real Usenet
newsgroups if we win the election. The rest of the lists are crap and
they take up too much
Anytime data changes in Postgres, the old rows are still on the disk.
This is true regardless if the transaction rolls back.
Read in the docs about vacuuming, which is a process that cleans this
up.
Regards,
d.
--
David Helgason,
Business Development et al.,
Over the Edge I/S (http://otee.dk)
D
"A. Mous" <[EMAIL PROTECTED]> writes:
> Hi,
>
> I've got clients connected to pgsql via ODBC. If they lose their connection
> abruptly, all un-committed transactions are automatically rolled-back (I'm
> assuming) but is there anything left behind that needs to be cleaned up on
> the server side w
From the 7.4 docs:
A column can be referenced in the form
correlation.columnname
correlation is the name of a table (possibly qualified with a schema name), or
an alias for a table defined by means of a FROM clause, or one of the key
words NEW or OLD. (NEW and OLD can only appear in rewrite ru
Hi!
My 8.0beta2 database was initialized with option "-E UNICODE". Psql sets
client encoding to Big5:
database1=# \encoding big5
I get this error when inserting Big5 character 0xf9d8:
WARNING: ignoring unconvertible BIG5 character 0xf9d8
Any idea?
Regards,
CN
---(end
On Tue, Nov 09, 2004 at 02:20:23PM -0500, Alexander Cohen wrote:
>
> When i write code in C to create the functions that define a new data
> type, how can i set a value so that the user sees a null value from
> sql.
What do you mean "sees a null value from sql," and under what
circumstances sho
Hi,
I've got clients connected to pgsql via ODBC. If they lose their connection
abruptly, all un-committed transactions are automatically rolled-back (I'm
assuming) but is there anything left behind that needs to be cleaned up on
the server side with regards to the uncommitted transaction(s)?
Mu
I have some more info on my indexing situation, and a new question.
In my previous email, I told about 2 tables: Notification and Item,
which join on a field called ItemID. The joining query didn't execute
as quickly as I thought it should. I now notice that I have another
table, Folder, which jo
Woodchuck Bill wrote:
> [EMAIL PROTECTED] ("Marc G. Fournier") wrote in
> news:[EMAIL PROTECTED]:
>
>> As a side note ... if/when the CFV is called and those 4 are
>> approved/rejected, that will not change what is available on
>> news.postgresql.org, it will only improve the propogation of those
[EMAIL PROTECTED] wrote:
> The lists are not bogus and your suggestion is not acceptable. Many of
> the list subscribers have no connection to Usenet. They will be mailed
> the ballots, regardless of what you or anyone else say. They are the
> people who will be directly affected by this.
>
You
Brian Mailman wrote:
> [EMAIL PROTECTED] wrote:
>
>> I am affiliated with a network of over 60 PostgreSql users/developers,
>> and I will e-mail each one of those people a ballot...
>
> You should not do that.
>
> Those ballots will be invalidated since only the official ballots that
> are post
Sigh, I can't read what I write...
The correct homepage for PgBrowse is:
http://homepage.mac.com/levanj/TclTk
I guess the correction was probably obvious :)
Jerry
On Nov 9, 2004, at 6:57 PM, [EMAIL PROTECTED] wrote:
The homepage for PgBrowser is:
http://homepage.mac.com/levanj/TckTk
Feedback and en
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Huh? Just checked, the file hasn't been modified since Nov 15th, 2001,
> and the URL looks fine to me:
>
> svr1# grep http README
>http://www.postgreSQL.org
I though we tended to discourage making the 'postgre' and the 'SQL'
distinct.
On Tuesday November 9 2004 4:35, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > I noticed that ipcs on my linux box has a command-line option to list
> > the pid that created the segment. Not sure if such a library exists in
> > usable form, but looking for segments owned by the downed
As a side note ... if/when the CFV is called and those 4 are
approved/rejected, that will not change what is available on
news.postgresql.org, it will only improve the propogation of those 4
specific groups so that more servers around the world carry them ...
On Tue, 9 Nov 2004, Mike Cox wrote:
The Bricolage development team is pleased to announce the release of
Bricolage 1.8.3. This maintenance release addresses quite a large
number of issues in Bricolage 1.8.2. The most important changes
were to
enhance Unicode support in Bricolage. Bricolage now internally
handles
"Ed L." <[EMAIL PROTECTED]> writes:
> I noticed that ipcs on my linux box has a command-line option to list the
> pid that created the segment. Not sure if such a library exists in usable
> form, but looking for segments owned by the downed postmaster's pid would
> seem to be what is needed. J
On Tuesday November 9 2004 1:37, Tom Lane wrote:
> >> The shared memory block would certainly not still exist after a system
> >> reboot, so what we have here is a misleading error message. Looking
> >> at the code, the most plausible explanation appears to be that
> >> shmctl(IPC_STAT) is failing
"Pablo Gosse" <[EMAIL PROTECTED]> writes:
> However, when I connect to this database via a php script, I can enter
> any valid database user, and I can enter anything for the password (or
> leave it blank), and I'm still able to connect.
Sounds like you don't have pg_hba.conf configured to demand
Greg Stark <[EMAIL PROTECTED]> writes:
> Oh I missed the fact that you were talking about after a reboot. So the
> algorithm I described would produce exactly the same sequence of ids after any
> reboot given the same sequence of creation and deletions. Even if there's a
> different sequence as lon
On Tue, 2004-11-09 at 13:21, Marc G. Fournier wrote:
> On Sun, 7 Nov 2004, Greg Sabino Mullane wrote:
> > * We are keeping some very old versions around: 1.08, 1.09, the entire 6
> > series. Is there any reason for this? For that matter, is there any reason
> > to keep around lesser versions in a t
Obviously, there cannot be 21 postgresql groups in the comp.* hierarchy.
Many of the 21 are not used that often, and would not be of much popularity
to those on usenet.
I did a check on news.postgresql.org to see which newsgroups are the most
popular and also the ones which cover the relevant pos
Greg Stark <[EMAIL PROTECTED]> writes:
> At least in 2.6 it seems to avoid reuse of ids by keeping a global counter
> that is incremented every time a segment is created which ranges from 0..128k
> that it multiplies by 32k and adds to the array index (which is reused
> quickly).
>
> So it does
On Tuesday November 9 2004 10:36, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > I know the original statement is printed right after this, but with
> > complex triggers doing lots of write queries, I'm finding it difficult
> > to identify which subsequent query in the trigger is really
Tom Lane <[EMAIL PROTECTED]> writes:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > A power failure led to failed postmaster restart using 7.4.6 (see
> > output below). The short-term fix is usually to delete the pid file
> > and restart.
>
> Thinking some more about this ... does anyone know the al
Will do thanks. I ended up dropping and recreating the index and that
seems to have fixed the problem.
Patrick Hatcher
Tom Lane
<[EMA
Patrick Hatcher <[EMAIL PROTECTED]> writes:
> Doing a Vacuum Analyze on a table and it's been hanging for at least 2
> hours. I could see no other users hitting the table at the time. This is
> the second time this has happened on this particular table and I can't
> seem to pin point the issue
Hi folks. I'm creating a database using the following command:
createdb -U pablo -W pablotest1
I'm prompted to enter the password to create the DB, and after doing so
the db is created successfully.
However, when I connect to this database via a php script, I can enter
any valid database user,
PG: 7.4.5
RH 7.3
Vac_Mem=12mg
Doing a Vacuum Analyze on a table and
it's been hanging for at least 2 hours. I could see no other users
hitting the table at the time. This is the second time this has happened
on this particular table and I can't seem to pin point the issue.
If I kill the PID a
When i write code in C to create the functions that define a new data
type, how can i set a value so that the user sees a null value from
sql.
thanks
Alex
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
PgBrowser is a postgresql database browser written in a more
or less platform independent fashion. I appears to work in
a Mac OSX environment, Linux, and Windows. The program is
written in Tcl/Tk. The program includes LJ Bayuk's Pgintcl
driver that is used if the Pgtcl 1.5 or greater driver cannot
On Sun, 7 Nov 2004, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A bad link in the ftp source directory inspired me to check
the rest of it out:
* Main README file needs updating. The URL is given as:
http:/www.postgreSQL.org
but should be:
http://www.postgresql.org/
Huh
"Ed L." <[EMAIL PROTECTED]> writes:
> I know the original statement is printed right after this, but with complex
> triggers doing lots of write queries, I'm finding it difficult to identify
> which subsequent query in the trigger is really the one immediately
> preceding the deadlock. It would
I want to hide the code itself
Víctor Robador Capel
Análisis de Sistemas y Programación
www.creativosdolmen.com
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Tk421" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 09, 2004 4:11 PM
Subject: Re:
Michael Fuhr wrote:
On Mon, Nov 08, 2004 at 04:15:34PM -0800, Ron St-Pierre wrote:
SELECT INTO exptime current_timestamp + INTERVAL ''intval'';
You're using the literal value 'intval' instead of its value, thus
the syntax error.
Of course, I should have caught that.
You can simplify the
On Tue, 2004-11-09 at 07:00 -0700, Ed L. wrote:
> On Tuesday November 9 2004 2:16, Oliver Elphick wrote:
> > On Mon, 2004-11-08 at 17:47 -0700, Ed L. wrote:
> > > I often wonder why ipcs never seems to show the shared memory
> > > block in question?
> >
> > The permissions of the shared memory bloc
We've actually implemented this kind of thing in a different DBMS. The
physical design consists of a single "organization" table that's something
like:
Org_key (primary key)
Org_type (group, company, etc.)
Org_level (group is 1, company is 2, etc.)
Org_parent_key (foreign key to or
On Tue, Nov 09, 2004 at 01:29:19PM +0100, Tk421 wrote:
> I've made some functions, an i want these functions to be used
> by a specified user, but i don't want this user can see the code
> of the functions.
Are you trying to hide the code itself, or are you just trying to
hide sensitive data embe
On Tuesday November 9 2004 2:16, Oliver Elphick wrote:
> On Mon, 2004-11-08 at 17:47 -0700, Ed L. wrote:
> > I often wonder why ipcs never seems to show the shared memory
> > block in question?
>
> The permissions of the shared memory block and the semaphore arrays are
> 600. ipcs seems not to rep
Am Dienstag, 9. November 2004 13:29 schrieb Tk421:
> I've made some functions, an i want these functions to be used by a
> specified user, but i don't want this user can see the code of the
> functions. Does somebody knows how can i do this?
The only way to do that would be to write the functi
I've made some functions, an i
want these functions to be used by a specified user, but i don't want this user
can see the code of the functions. Does somebody knows how can i do
this?
Sorry about my english, i'm
spanish.
Víctor Robador Capel
Análisis de Sistemas y Programación
On Tue, Nov 09, 2004 at 04:34:16AM +0100, Florian G. Pflug wrote:
> My import sometimes crashed, becausse the meta-information tables are
> changed while importing (e.h, I pass a id to a function, the function
> does some calculations, than tries to select the row with the given id,
> but fails,
> I'd like to know if there is a way to specify different transaction
> isolation levels for different tables in the db.
Simply set up a connection for each transaction isolation level
you need and read the appropriate data from whichever
connection is suitable.
Karsten
--
GPG key ID E4071346 @
On Mon, Nov 08, 2004 at 12:55:06PM -0800, Mike Cox wrote:
> There is also the point of having to post. If I post and I subscribe to the
> digest version or if I post with the option of no emails (since my inbox
> cannot handle the load), how would I respond to a thread I created? Would
> I have t
On Mon, 2004-11-08 at 17:47 -0700, Ed L. wrote:
> I often wonder why ipcs never seems to show the shared memory
> block in question?
The permissions of the shared memory block and the semaphore arrays are
600. ipcs seems not to report objects which you cannot access. Run
ipcs as root and you sh
I need help to connect DBDesigner4 linux in ODBC to postgres.
I'm having a problem connecting to a remote Postgres db using ODBC from
my Debian Linux laptop. I've got ODBC set up (UnixODBC). In DBDesigner
I'm simply trying to set up the connection using the ODBC datasource,
but I keep getting the
47 matches
Mail list logo
