On Nov 15, 2004, at 4:05 PM, Michael Glaesemann wrote:
Just add a nice SERIAL column to the tables you want as foreign keys
(and if you have questions about sequences, check the FAQ).
Erg... SERIALs on the tables as primary keys. Integers on tables
referencing the primary key for foreign keys.
M
On Nov 15, 2004, at 3:52 PM, Jamie Deppeler wrote:
Hi,
I am planning to use OID for referencing as instead PK -->> FK on
this situation would require alot of tables, OID would seen to nice
solution.
My worry with OID's is when i do SQL dump and rebuild the Database
will OID will change makin
Hi,
Im planning on using OID for referencing in certain part of the system
i am building as in this case using normal pk -> fk would be
inefficient as i have to have once table reference multi tables, but i
have concerns that if a Database is exported and reconstructed the
OID's will change ma
Hi,
I am planning to use OID for referencing as instead PK -->> FK on
this situation would require alot of tables, OID would seen to nice
solution.
My worry with OID's is when i do SQL dump and rebuild the Database will
OID will change making referencing certain records impossible.
--
J
On Mon, Nov 15, 2004 at 04:25:59PM +1100, Harvey, Allan AC wrote:
> The table in question has several thousand rows currently,
> planning several million, it has a date time stamp column.
> All selects will be on ranges of the date time column.
>
> I created an index on the dt column, ran ANALYSE
Hi all,
I was hoping someone might be able to set me straight
so that I can get some select performance improvements.
The table in question has several thousand rows currently,
planning several million, it has a date time stamp column.
All selects will be on ranges of the date time column.
I crea
Tom Lane wrote:
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
Since sometime yesterday, my postgresql (7.4.5) reports
"ERROR: cannot compare arrays of different element types",
when I analyze a specific table in my database.
...
GOLink has the basetype int8, which GOLinkList has the basetype int8
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> Since sometime yesterday, my postgresql (7.4.5) reports
> "ERROR: cannot compare arrays of different element types",
> when I analyze a specific table in my database.
> ...
> GOLink has the basetype int8, which GOLinkList has the basetype int8[].
I
Hi
Since sometime yesterday, my postgresql (7.4.5) reports
"ERROR: cannot compare arrays of different element types",
when I analyze a specific table in my database.
Here is the tables definition:
Column | Type | Modifiers
---+-
Am 2004-11-14 20:25:18, schrieb Tino Wildenhain:
> Am Sonntag, den 14.11.2004, 18:10 +0100 schrieb Michelle Konzack:
> > Am 2004-11-13 02:47:04, schrieb BARD ROCK:
> > > It is now time to cast your vote as to whether you would like these
> > > mailing lists to become legal USENET newsgroups.
> >
>
Am Sonntag, den 14.11.2004, 18:10 +0100 schrieb Michelle Konzack:
> Am 2004-11-13 02:47:04, schrieb BARD ROCK:
> > It is now time to cast your vote as to whether you would like these
> > mailing lists to become legal USENET newsgroups.
>
> NO mercie !!!
>
> I get already 2500-8000 SPAMs per day o
Bopolissimus Platypus Jr <[EMAIL PROTECTED]> writes:
> the reason i can't do dump, initdb, restore is: I'm working with postgresql
> 7.1.x
This is your problem right here :-(. You should be making every effort
to get updated sooner, not later. Spending time on workarounds for 7.1
limitations i
Hello Joshua,
Am 2004-11-13 21:40:10, schrieb Joshua D. Drake:
> Dawid Kuroczko wrote:
> >1) One pgsql per user -- in other words each user runs its own copy of
> >pgsql -- waste of memory (each user having its own shared mem, etc),
> >but can enforce quota limits, etc. Hard to keep all those co
Hello Dawid,
Am 2004-11-13 21:42:14, schrieb Dawid Kuroczko:
> Some time ago I talked with a friend working at some ISP, and we were
> talking about PostgreSQL's superiority to hmm, other RDBMSs... ;)
> Blah, blah, blah. The question is - how to give many many users
> access to PostgreSQL...
Am 2004-11-10 07:25:08, schrieb Mike Cox:
> Hello. My name is Mike Cox. I am in charge of the changing of these
Please can you shut-up and fuck yourself ?
> 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 Usen
kick-off this piece of shit
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Am 2004-11-13 02:47:04, schrieb BARD ROCK:
> It is now time to cast your vote as to whether you would like these
> mailing lists to become legal USENET newsgroups.
NO mercie !!!
I get already 2500-8000 SPAMs per day on my E-Mail which I have since
many years and I do not like to change. In more,
ANAL SEX FUCK my WHITE ASSHOLE
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PR
FUCK MY SHITTY ASSHOLE with your COCK
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
SUCK MY SMELLY PENIS and ASSHOLE
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
HISPANIC SPICS go FUCK YOURSELVES
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 6: Have you searched our list archives?
ASIAN GOOKS can SUCK MY COCK
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an ind
FUCK my ANUS with CUM from your COCK
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please se
FUCK MY TIGHT ASSHOLE with your COCK
I want it!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comman
LICK MY FORESKIN CHEESE on the HEAD OF MY COCK!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 9: the planner will ignore your desi
Rebecca whORE is a CUNT SLUT WHORE BITCH
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
SCENT of my PENIS CHEESE gets you HORNY!
Suck away!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 9: the planner will ignore your
SHIT ON MY COCK when I FUCK YOUR ASSHOLE!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, plea
CUM on my ASSHOLE, LIPS, and TEETH
Fire away!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 2: you can get off all lists at once
EAT MY ASSHOLE with your TONGUE!
Clean the crap out of my bung hole!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 7: don't forge
FUCK YOU BITCHES and COCK SUCKING FAGGOTS
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
SUCK MY DICK, BALLS, and ASSHOLE and CUM!!!
These lists belong to me now, motherfuckers!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)--
CUM SWALLOWING FAGGOT COCKSUCKER Marc !
Blow my smelly cock and balls!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
TIP 3: if postin
Black African NIGGERS SUCK COCKS and SWALLOW CUM!!
Vote *YES* *YES* *YES* for Usenet!
Mike Cox
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---(end of broadcast)---
T
On Sun, Nov 14, 2004 at 01:50:10PM +0800, Bopolissimus Platypus Jr wrote:
> hello all,
>
> i've got a database that takes up 4G of space. when i run a script that
> deletes all rows and then vacuum, the data directory gets down to
> around 3-3.5G. what i'd like is to get a blank database struct
At 01:54 AM 11/14/2004, Sim Zacks wrote:
BTW, in Outlook Express if you are posting to the news.postgresql.org server
it will not send a message to news.groups. So this message will not get
there unless someone puts it there.
If 4 are official and 16 are unofficial, why would that bother you?
Becau
At 11:54 AM 11/14/2004, you wrote:
The new proposal should have all of the lists.
This is true. All the mailing lists that gate to USENet should either be
legitimized or removed.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to
Title: Message
Hi,
Can anyone suggest
any websites that might help with
connecting
visual studio dot
net (I
would like to see it running using server
explorer if
possible) to postgresql. I am planning to write some
client applications
in VB or
C#.
Regards,
Daron.
---
Outgoing ma
"Max" wrote:
> >
> > [EMAIL PROTECTED] wrote in
news:[EMAIL PROTECTED]:
> >
> > >>The other issue is that I would like to add the other postgresql
> > >>groups for consideration to be included into the big 8. However
there
> > >>are quite a few of them, and I don't know if all of them deserve
to b
> i've got a database that takes up 4G of space. when i run a script that
> deletes all rows and then vacuum, the data directory gets down to
> around 3-3.5G. what i'd like is to get a blank database structure that
> really contains no data at all, or any unused space at all. apparently
> that'
40 matches
Mail list logo
