Magnus Hagander wrote:
Sounds like the WAL log. It's in the pg_xlog directory - verify that
that's where the data is increasing.
The WAL log is global and not per-tablespace, so it doesn't follow your
tablespaces location.
Nope, it's the files in the pg_tblspc directory on my C drive, they ar
Kathy Lo wrote:
On 11/21/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
You probably shouldn't attach any meaning to the numbers from a sequence
- they're just guaranteed to be unique, nothing else.
What you say here contradicts the following.
Actually, the sequence is formed by 4-digit of
Below I've included sample table definitions for a vertically partitioned
disjunctive table hierarchy. I wanted to point out the use of the composite
primary key declaration that is applied to two columns that are clearly not a
candidate key. However, using the badly defined primary key allows
On Nov 22, 2007 1:02 AM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> Paul Lambert wrote:
> > I'd definitely like some PG shirts, polo and tee.
>
> O.k. :) I will arrange for a way to get them online. Let me get through
> thanksgiving.
Just adding one more request for the polo shirt. L or XL if t
On Thu, 2007-11-22 at 15:26 +0900, Paul Lambert wrote:
> I'm running PG 8.3beta3 on a W2K3 server.
>
> I've set up a tablespace on D drive, with PG itself on C drive and
> loaded a bunch of data into a database to test. The directory I've
> created the tablespace in on D drive grows to 116Mb -
Paul Lambert wrote:
Joshua D. Drake wrote:
We do not yet have a "store" although it has been something of
interest in the past. We usually order them in bulk and then request
donations for them at the conferences and shows.
Note :) If you register for East you get a shirt.
What if we regis
Paul Lambert wrote:
I note however, that the pg_database directory on C drive also grows at
the same time to 116MB.
That was meant to say the pg_tblspc directory.
Both directories (my tablespace and pg_tablespace) contain the same set
of files - same names and sizes, eg both contain a file
I'm running PG 8.3beta3 on a W2K3 server.
I've set up a tablespace on D drive, with PG itself on C drive and
loaded a bunch of data into a database to test. The directory I've
created the tablespace in on D drive grows to 116Mb - which would be
about right for the amount of data I've plugged i
Joshua D. Drake wrote:
We do not yet have a "store" although it has been something of interest
in the past. We usually order them in bulk and then request donations
for them at the conferences and shows.
Note :) If you register for East you get a shirt.
What if we register and don't show up
brian wrote:
Joshua D. Drake wrote:
We have considered getting Polos as well as normal shirts. The normal
shirts are your basic 6.1 oz 100% cotton. No iron required, heavy
enough to hide the extra we all get once we get over 30. The main issue
with polo's is that they are expensive (comparativel
Joshua D. Drake wrote:
We have considered getting Polos as well as normal shirts. The normal
shirts are your basic 6.1 oz 100% cotton. No iron required, heavy
enough to hide the extra we all get once we get over 30. The main issue
with polo's is that they are expensive (comparatively) and thus we
Richard Broersma Jr wrote:
--- On Wed, 11/21/07, Stephen Frost <[EMAIL PROTECTED]> wrote:
I've got a real desire for a PG polo. :) One which I could wear to work
(business casual or whatever) would seriously rock.
That's what I like to do. The dress-code in the industry that I work is to wea
--- On Wed, 11/21/07, Stephen Frost <[EMAIL PROTECTED]> wrote:
> I've got a real desire for a PG polo. :) One which I could wear to work
> (business casual or whatever) would seriously rock.
That's what I like to do. The dress-code in the industry that I work is to
wear collared shirts. And hav
* Joshua D. Drake ([EMAIL PROTECTED]) wrote:
> We have considered getting Polos as well as normal shirts. The normal
> shirts are your basic 6.1 oz 100% cotton. No iron required, heavy
> enough to hide the extra we all get once we get over 30. The main issue
> with polo's is that they are expensive
On 11/22/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Nov 21, 2007 11:44 AM, Marco Colombo <[EMAIL PROTECTED]> wrote:
> > Scott Marlowe wrote:
> > > revoke all privs on the sequence to anyone but the user about to reset it
> > > reset it
> > > grant the options back
> >
> > Quoting the OP:
> >
On 11/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
> > Good point. I'm guessing if you need a way to make other users wait,
> > not get an error, you'll need to use a funtion with a security definer
> > that will sleep or something during that period.
>
On 11/21/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Kathy Lo wrote:
> > Hi,
> >
> > I am using Postgresql 8.0.3 in Fedora Core 4.
> >
> > In my database, it contains a sequence. And, I need to alter the range
> > of this sequence and restart it to the start of the new range at
> > 00:00:00 on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 21 Nov 2007 16:47:00 -0800 (PST)
Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> --- On Wed, 11/21/07, Selena Deckelmann <[EMAIL PROTECTED]> wrote:
> > I have been looking into getting some woman-sized
> > PostgreSQL shirts,
> > in addition t
--- On Wed, 11/21/07, Selena Deckelmann <[EMAIL PROTECTED]> wrote:
> I have been looking into getting some woman-sized
> PostgreSQL shirts,
> in addition to the more typical men-sized tshirts. The
Later on, would you consider doing this again for men and women sized polo
shirts?
I've already pur
Tom Hart wrote:
> Hey everybody. I have a field that, in my earlier mySQL days would have
> been an enum('q','y','m','c'), and I'm wondering what's the best way to
> handle this in pgsql.
If it's an option, upgrade to 8.3 and use the new enum support.
--
Peter Eisentraut
http://developer.postgre
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
---
Sushant Sinha wrote:
> I wrote a headline generation function for my app and I have attached
> the patch (against the
Hello,
I have been looking into getting some woman-sized PostgreSQL shirts,
in addition to the more typical men-sized tshirts. The particular
style is American Apparel shirts, style # 2102. They are "normal
looking" t-shirts, just proportioned a bit more correctly for a
woman's body. The shirt say
Hey everybody. I have a field that, in my earlier mySQL days would have
been an enum('q','y','m','c'), and I'm wondering what's the best way to
handle this in pgsql. I've googled enough to find out that pgsql doesn't
have a built in enum type (it's of course possible that what I read was
outdat
On 21/11/2007 22:32, Richard Huxton wrote:
The tricky bit (I'd guess) is to trigger a script when a new user is
created on the Windows side of things. There seem to be people
Yeah... I was thinking in terms of doing it just once, which is what I
do - it's for an educational institution, meani
Kent Tong wrote:
>
> Hi,
>
> Is it possible to log events related to transactions, in particular, about
> blocking? For example:
>
>INFO: transaction 123 is blocked waiting for locked held by transaction
> 456.
8.3 will have a log_lock_waits parameter which will do something like
that.
--
Raymond O'Donnell wrote:
On 21/11/2007 19:44, Marc Munro wrote:
Is there a simple way of coordinating active directory users with
database accounts? I am happy to write tools to deal with the
database end of things, but have no experience with active directory.
Any and
You could use a VBS
Reg Me Please wrote:
Il Wednesday 21 November 2007 20:22:46 Joe Conway ha scritto:
Reg Me Please wrote:
The meaning is that an entity called by the value of "item" has a number
of properties called by "property" with value "prop_value".
So, for a single "item" there can be many different "prope
Il Wednesday 21 November 2007 20:22:46 Joe Conway ha scritto:
> Reg Me Please wrote:
> > The meaning is that an entity called by the value of "item" has a number
> > of properties called by "property" with value "prop_value".
> > So, for a single "item" there can be many different "property" each w
On Wed, Nov 21, 2007 at 12:20:51PM -0800, Garber, Mikhail wrote:
> In the high-availabilty situation with a warm standby, is it possible (or
> planned) to be able to make standby readable?
Yes, but it won't happen for 8.3. It's a feature you can have today with
Slony, by the way.
A
--
Andrew
Garber, Mikhail wrote:
> In the high-availabilty situation with a warm standby, is it possible (or
> planned) to be able to make standby readable?
> This is a new feature in Oracle 11 and it is very important for a project I
> am working on.
yeah there are plans to support this in 8.4 (and some
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 21 Nov 2007 12:20:51 -0800
"Garber, Mikhail" <[EMAIL PROTECTED]> wrote:
> In the high-availabilty situation with a warm standby, is it possible
> (or planned) to be able to make standby readable? This is a new
> feature in Oracle 11 and it is
On 21/11/2007 19:44, Marc Munro wrote:
Is there a simple way of coordinating active directory users with
database accounts? I am happy to write tools to deal with the database
end of things, but have no experience with active directory. Any and
You could use a VBScript script on the domain
In the high-availabilty situation with a warm standby, is it possible (or
planned) to be able to make standby readable?
This is a new feature in Oracle 11 and it is very important for a project I am
working on.
---(end of broadcast)---
TIP 6: expla
Dane Springmeyer wrote:
On Nov 21, 2007, at 1:37 AM, Richard Huxton wrote:
Dane Springmeyer wrote:
These mostly reside in MS access in flat tables and and I am
importing them into postgres.
If you are familiar/comfortable with Access and VB, I'd probably do
the work there.
Unfortunately
I have a client that wants to use active directory for authentication
of connections to a postgres database. They want to be able to
monitor what each user is doing so believe that the best solution is
to have one database account per user. However, they do not want to
have to manage the
On Nov 21, 2007 1:07 PM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > On Nov 21, 2007 12:21 PM, David Fetter <[EMAIL PROTECTED]> wrote:
> >> On Wed, Nov 21, 2007 at 11:10:15AM -0600, Scott Marlowe wrote:
> >>> On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrot
Reg Me Please wrote:
The meaning is that an entity called by the value of "item" has a number
of properties called by "property" with value "prop_value".
So, for a single "item" there can be many different "property" each with its
own value.
A filter is a list of property values needed to qua
Scott Marlowe wrote:
On Nov 21, 2007 12:21 PM, David Fetter <[EMAIL PROTECTED]> wrote:
On Wed, Nov 21, 2007 at 11:10:15AM -0600, Scott Marlowe wrote:
On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
Gauthier, Dave wrote:
APparently, from "man psql", -c can do only one thing
On Nov 21, 2007 12:21 PM, David Fetter <[EMAIL PROTECTED]> wrote:
>
> On Wed, Nov 21, 2007 at 11:10:15AM -0600, Scott Marlowe wrote:
> > On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> > > Gauthier, Dave wrote:
> > > > APparently, from "man psql", -c can do only one thing at a
Thanks Tom and Erik and all the others who helped.
You guys really rock!!!
Sharmila
- Original Message
From: Tom Lane <[EMAIL PROTECTED]>
To: SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]>
Cc: Erik Jones <[EMAIL PROTECTED]>; pgsql-general@postgresql.org
Sent: Wednesday, November 21, 2007 1:14:02
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> Good point. I'm guessing if you need a way to make other users wait,
> not get an error, you'll need to use a funtion with a security definer
> that will sleep or something during that period.
What you'd want is to take out an exclusive lock on the se
Il Wednesday 21 November 2007 16:41:03 Rodrigo De León ha scritto:
> On Nov 21, 2007 9:21 AM, Reg Me Please <[EMAIL PROTECTED]> wrote:
> > Hi all.
> >
> > I've the following concept.
>
>
>
> This smells like EAV.
>
> Please read
>
> http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-ta
On Wed, Nov 21, 2007 at 11:10:15AM -0600, Scott Marlowe wrote:
> On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> > Gauthier, Dave wrote:
> > > APparently, from "man psql", -c can do only one thing at a time. But you
> > > could do this with 2-3 commands (or 1 if you want to
SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> writes:
> 1. How do you find the MAXALIGN of the machine? And what is that used for?
pg_controldata will show "maximum data alignment". A rule of thumb is
that it's 4 on 32-bit machines and 8 on 64-bit machines, but there are
exceptions.
> 2. How does nul
On Nov 21, 2007 11:44 AM, Marco Colombo <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > revoke all privs on the sequence to anyone but the user about to reset it
> > reset it
> > grant the options back
>
> Quoting the OP:
> > That means, when others want to access the sequence between
> > 31-
>>> Calculation
>> >varchar = (overhead) 4 + (actual length of string) 3 = 7 bytes
>> >*for 5 varchar cols =
>> >5*7 = 35 bytes
>> >
>> >numeric (according to manual--- The actual storage requirement is
>> >two bytes for each group of four deci
Scott Marlowe wrote:
On Nov 21, 2007 11:16 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
Scott Marlowe wrote:
On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
Or just put everything in one file and use -f
And from the more than one way to skin a cat department:
cat my.sql
On Nov 21, 2007 11:16 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
>
> Scott Marlowe wrote:
> > On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> >> Gauthier, Dave wrote:
> >>> APparently, from "man psql", -c can do only one thing at a time. But you
> >>> could do this with 2
Erik Jones <[EMAIL PROTECTED]> writes:
> On Nov 21, 2007, at 9:17 AM, SHARMILA JOTHIRAJAH wrote:
>> Calculation
>> varchar = (overhead) 4 + (actual length of string) 3 = 7 bytes
>> *for 5 varchar cols =
>> 5*7 = 35 bytes
>>
>> numeric (according to
Scott Marlowe wrote:
On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
Gauthier, Dave wrote:
APparently, from "man psql", -c can do only one thing at a time. But you could
do this with 2-3 commands (or 1 if you want to wrap the 2 up in a shell script or
something). Here's
On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Gauthier, Dave wrote:
> > APparently, from "man psql", -c can do only one thing at a time. But you
> > could do this with 2-3 commands (or 1 if you want to wrap the 2 up in a
> > shell script or something). Here's an example.
I vacuumed the table before I got this relpages count. When i make
the
change tat you mentioned the total table size as per my calculation is
1373780 and the result thro pg_relation_size is 1548288.
What other overheads are there for the table? Im not sure how to find
the free space? But I didno
Gauthier, Dave wrote:
APparently, from "man psql", -c can do only one thing at a time. But you could
do this with 2-3 commands (or 1 if you want to wrap the 2 up in a shell script or
something). Here's an example...
[snip]
psql --dbname mydb -c "\i create_try.sql;"
psql --dbname mydb -c "se
On Nov 21, 2007, at 9:48 AM, Sergey Konoplev wrote:
Hello,
I have a procedure which takes few arguments. The arguments must
affect expressions set of "order by" clause. For instance in one case
ordering must be performed by 1st, 2nd (desc) and 3rd fields but in
another by 3rd, 1st and 2nd field
APparently, from "man psql", -c can do only one thing at a time. But you could
do this with 2-3 commands (or 1 if you want to wrap the 2 up in a shell script
or something). Here's an example...
The text file that creates the script
create or replace function trythis(varchar) returns varc
On Nov 21, 2007, at 9:17 AM, SHARMILA JOTHIRAJAH wrote:
Hi
Thanks. Ill post it on the mailing list when I get the results. Im
trying to calculate and see how the tablesize works for a simple
table.
I have a table with 10 cols
5 varchars _ it is declared as varchar(40) but contains data of
Pau Marc Munoz Torres <[EMAIL PROTECTED]> schrieb:
> Hi
>
> I've written a sql function in a text file, and now, i would like to upload
> into postgresql an execute, is there any command to do it? as far as I know in
> mysql exist source command, is there something similar in postgresql?
Of cou
Hello,
I have a procedure which takes few arguments. The arguments must
affect expressions set of "order by" clause. For instance in one case
ordering must be performed by 1st, 2nd (desc) and 3rd fields but in
another by 3rd, 1st and 2nd fields.
Is there a way to manage it without using dynamic q
Hi
I've written a sql function in a text file, and now, i would like to upload
into postgresql an execute, is there any command to do it? as far as I know
in mysql exist source command, is there something similar in postgresql?
Thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacio
On Nov 21, 2007 9:21 AM, Reg Me Please <[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I've the following concept.
This smells like EAV.
Please read
http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-table-vs-many.html
and consider reevaluating the schema according to valid relational
de
Hi
Thanks. Ill post it on the mailing list when I get the results.
Im trying to calculate and see how the tablesize works for a simple
table.
I have a table with 10 cols
5 varchars _ it is declared as varchar(40) but contains data of length 3
5 numeric - declared as numeric(22,0) but contains dat
Sascha Bohnenkamp <[EMAIL PROTECTED]> writes:
>> I saw on the todo list that the "with recursive" option for selects
>> (equivalent to oracle's connect by, as far as I know) is on the todo
>> list for postgresql, but apparently not for the upcoming 8.3 release.
> the postgresql derivate enterprised
Hi all.
I've the following concept.
create table t_data
( property text,
item int8,
prop_value text
);
(I've cut some fields away needed only for data history).
The meaning is that an entity called by the value of "item" has a number
of properties called by "property" with value "prop_value"
On Nov 21, 2007 1:39 AM, Kathy Lo <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am using Postgresql 8.0.3 in Fedora Core 4.
>
> In my database, it contains a sequence. And, I need to alter the range
> of this sequence and restart it to the start of the new range at
> 00:00:00 on 1st January on every year.
Hello
theoretically there are only limits on data types 1GB. But really big
fields has negative impact on speed (it depends on RAM). If you have
fields bigger than 10-20M, than is better to use BLOBs.
Regards
Pavel Stehule
On 21/11/2007, Ottavio Campana <[EMAIL PROTECTED]> wrote:
> I want to pas
Bruno Lavoie escribió:
> Hello guys,
>
> Posted this msg on general & hackers list to get most accurate responses as
> possible...
>
> I plan to use PG with an OpenCRX project... but I read that there's some
> probs with PG and strings comparisons Is it true?
> Look at: http://www.opencrx.org
I want to pass some text to a function which is going to store it for
some tsearch queries.
Is there a limit on the length of the text I can pass to a function?
--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.
signature.asc
Description: OpenPGP digital signature
Hi all
I saw on the todo list that the "with recursive" option for selects
(equivalent to oracle's connect by, as far as I know) is on the todo
list for postgresql, but apparently not for the upcoming 8.3 release.
Does anybody know about the status of this feature, e.g. is it something
bound
Hi,
Is it possible to log events related to transactions, in particular, about
blocking? For example:
INFO: transaction 123 is blocked waiting for locked held by transaction
456.
Thanks!
-
--
Kent Tong
Wicket tutorials freely available at http://www.agileskills2.org/EWDW
--
View this m
Hi Tom,
> "Sander Steffann" <[EMAIL PROTECTED]> writes:
> > From: "Harald Fuchs" <[EMAIL PROTECTED]>
> >> Forget inet. Check out http://pgfoundry.org/projects/ip4r/ and be
> happy.
>
> > I would be happy if it would support IPv6 :-) Are there plans to
> > make ip6r or something like that?
>
>
Please don't start a new thread by replying to another question.
If you are going to do that, please don't cross-post it in addition.
This doesn't appear to be anything to do with PHP.
Dane Springmeyer wrote:
Anyone have recommendations on tools/utilities or SQL approaches to
quickly break ap
Bruno Lavoie wrote:
Hello guys,
Posted this msg on general & hackers list to get most accurate responses
as possible...
I plan to use PG with an OpenCRX project... but I read that there's some
probs with PG and strings comparisons Is it true?
Look at: http://www.opencrx.org/opencrx/1.11
Kathy Lo wrote:
Hi,
I am using Postgresql 8.0.3 in Fedora Core 4.
In my database, it contains a sequence. And, I need to alter the range
of this sequence and restart it to the start of the new range at
00:00:00 on 1st January on every year. 5 seconds before and after that
time, I need to preven
Reg Me Please wrote:
Hi all.
What'd be the right place to put a "feature request" for the next releases and
for bugs in the current one?
For bugs, go to: http://www.postgresql.org/
On the right-hand side under "Shortcuts" look for "Report a bug"
Guidelines on how to do so are at:
http://www.p
74 matches
Mail list logo
