Hi,
I know that my question may seem trivial, but unfortunately I haven't found
any understandable info on this topic. It's about length limit of the TEXT
field in PostgreSQL. I've heard that the TEXT fields in psql are limited to
4096 bytes but it's just unbelievable for me. So if I've got text
Bruce Momjian wrote:
>
> > Bruce Momjian writes:
> >
> > > > Break the SQL code that has been implemented for prior versions??
> > > > Bummer ;((.
> > >
> > > Yes, but we don't follow the MySQL behavior, which we copied when we
> > > added LIMIT. Seems we should agree with their implementation.
On 17 Oct 2001, Arcady Genkin wrote:
> Where does Postgres store information about the sequences? I tried
> looking in the tables produced by "\dS", but could find no references
> to the sequences. :(
Oops, I thought you had made a typo, but I made a thinko. Use the -E
option to generate the S
On 17 Oct 2001, Arcady Genkin wrote:
> What I want is an SQL equivallent of "\ds" command, which will return
> a list of all sequences in the current database. I need this for a
> periodically run script so that I could keep an eye on all sequences
> in the database.
\ds *is* the psql command f
[postres@kc131-161 /usr/local/opt/Postgres/data/global]# ls -la
total 170
drwx-- 2 postgres dbadmin 512 Oct 15 18:09 .
drwx-- 5 postgres dbadmin 512 Oct 15 18:00 ..
-rw--- 1 postgres dbadmin8192 Oct 15 18:10 1260
-rw--- 1 postgres dbadmin 0 Oct 15 17:59
> Bruce Momjian writes:
>
> > > Break the SQL code that has been implemented for prior versions??
> > > Bummer ;((.
> >
> > Yes, but we don't follow the MySQL behavior, which we copied when we
> > added LIMIT. Seems we should agree with their implementation.
>
> Isn't it much worse to not foll
I'm having trouble selecting "long" rows out of a database
of email messages using python. I'm working on an IMAP server
in python using Postgres as a backend datastore. All the
code can be seen with a little poking around at
http://zipcode.sourceforge.net but basically I'm just
executi
> Bruce Momjian writes:
>
> > > Break the SQL code that has been implemented for prior versions??
> > > Bummer ;((.
> >
> > Yes, but we don't follow the MySQL behavior, which we copied when we
> > added LIMIT. Seems we should agree with their implementation.
>
> Isn't it much worse to not foll
Use psql -E and it will give you the SQL for the backslash commands..
-Mitch
- Original Message -
From: "Arcady Genkin" <[EMAIL PROTECTED]>
To: "PostgreSQL" <[EMAIL PROTECTED]>
Sent: Wednesday, October 17, 2001 4:35 PM
Subject: [GENERAL] SQL equivallent to "\ds" in psql
> Where does
Ashley @ Turton writes:
> Is it possible in PostgreSQL to construct a blank record without
> specifying a list of fields and values in an INSERT statement (so I
> can perform a collection for UPDATEs to populate the blank record)?
INSERT INTO tablename DEFAULT VALUES;
(The default values are go
Bruce Momjian writes:
> > Break the SQL code that has been implemented for prior versions??
> > Bummer ;((.
>
> Yes, but we don't follow the MySQL behavior, which we copied when we
> added LIMIT. Seems we should agree with their implementation.
Isn't it much worse to not follow PostgreSQL beha
Mihai Gheorghiu writes:
> Therefore, I have to give users permissions to sequences, just to the
> extent that they could add records. What is the minimum set of
> privileges for this?
You need UPDATE privileges to be able to execute nextval() and currval().
I assume this would include setval() a
Lamar Owen <[EMAIL PROTECTED]> writes:
> On Tuesday 16 October 2001 02:39 pm, samsom, debra wrote:
> > I just installed postgresql 7.1.3 on Linux Redhat 7.1. All is well except
> > Postgresql will not start on Boot. I have added the -o '-i' to the
> > postgresql.conf and done the chkconfig --ad
Stephen Robert Norris <[EMAIL PROTECTED]> writes:
> Actually, it's a bug. I spent most of today with a co-worker looking for
> it. There's a Py_DECREF missing in the fetch routine, which makes it
> leak the results of every fetch. Who do I send the (one-line) fix to?
pgsql-patches list.
apparently this is the fix:
psql -d mydb -c "select * from title;" > before
# Save for after cmp test...
cd /usr/local/pgsql # my install root...
vacuumdb mydb# clean up before moving...
cp -pr d
Tom
Thanks for your reply.
I dropped ALL of my views and recreated from a script. This seems to
have worked. I am running my nightly jobs now to see if some how they
are causing the views to break. I will report back later.
Jim
> "Jim Buttafuoco" <[EMAIL PROTECTED]> writes:
> > I am hav
On Tue, Oct 16, 2001 at 01:22:45AM -0700, Randal L. Schwartz wrote:
> > "Gaurav" == Gaurav Priyolkar <[EMAIL PROTECTED]> writes:
>
> Gaurav> Not feasible, because some functions have dynamically created
> Gaurav> tables so I need to re-create table at each invocation.
>
> When I hear that, I
okay.
i followed the instructions very carefully and get the following error when
i try to run pg_upgrade ..
Cannot find database template1 in ./data/base.
Are you running ./pg_upgrade as the postgres superuser?
i am running as superuser and template1 is not there.
Steve
"Steve Brett" <[EMAIL
I added a hash index to a varchar value and when i vacuumed i got the
following error:
Index customer_ha_hash: NUMBER OF INDEX' TUPLES (9176) IS NOT THE SAME AS
HEAP' (9181).
dropping and recreating the index gave me the same error (on this index
only)
dropping the database and reimporting the
Break the SQL code that has been implemented for prior versions??
Bummer ;((.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Sat, 13 Oct 2001 17:26:49 +1300, Andrej Falout <[EMAIL PROTECTED]>
wrote:
>
>Aubit is much more then you asked for, but it will allow you to do this
>really easy, and result is C code. See my sig.
>
Hi Andrej;
Ok, I have downloaded the source tar.gz, I am running RedHat 6.2. What
do I now? Is
Hello,
Can someone tell me how to work with large objects ?
All I want to do is to store an image into my database and retrieve them
back.
What datatype do I have to use?
What is the sql statement to send a image to the database and how can I
retrieve it back.
I'm using php or VB.
Thanks
-
I've been looking for examples of how to access the back end of
PostgreSQL using the C++ library, but all I've found is 'C' examples.
Can someone point point out where I can get living and breathing
examples of C++.
TIA
--
My Computer's Opinion
~~
if( desire == play_games()
I am developing a system to take a generic data structure and store it in a
PostgreSQL database. The data structure contains several entries of the
following:
insert a record into table1
field1 value1
field2 value2
insert a record into table2
field1 value1
field2 value2
Data for different
On Wed, 2001-10-17 at 16:56, Denis Gasparin wrote:
> At 16/10/01 14.00, you wrote:
> >Does the python interface leak memory? We are seeing the process grow
> >with basically every select. Any suggestions on what's going on? There
> >are no cycles, and a trivial program (basically a loop around a s
At 16/10/01 14.00, you wrote:
>Does the python interface leak memory? We are seeing the process grow
>with basically every select. Any suggestions on what's going on? There
>are no cycles, and a trivial program (basically a loop around a select)
>demonstrates the problem.
>
>This is 7.1.2 on RH7.[
26 matches
Mail list logo
