On Sep 29, 2010, at 7:56 PM, Tom Lane wrote:
pg_controldata would tell you approximately where the OID counter is.
Just what I needed. Thank you so much Tom.
Dianne
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hello everyone,
We have PostgreSQL 8.1.21 on CentOS 5.5 and some of our older programs still
use OIDs to identify a row. I'm planning on adding a serial column to the
tables and modifying the code to use the serial column instead. But I am
curious to find out how close we are before the OID
First, I want to thank you for your help. You have made great points
and I just want to respond to some of your questions.
My first thought is that if you use a combined info field, you'll
lose the ability to easily do any kind of meaningful data analysis
based on which boxes are checked. If
which webserver does your client want to implement?
Apache, sorry I forgot to mention.
If JSLibrary = Dojo I would look at JSON (JavaScript Object
Notation language)
I would serialize to JSON instead of XML.
http://www.aurore.net/projects/php-json/
A simple json_encode($_POST) might do
Would an EAV model work? I'm thinking something like
form,field,value. For example:
formA,ckbox1,true
formA,input1,initial value
formB,textarea1,enter your long comment here
You could easily extend this to user,form,field,value, or
normalize it as you see fit.
This would work great too. If
Hello,
I have some html forms that I save the settings into the database,
things like which item was selected in the menu and if a checkbox was
checked. The table looks like this:
user_id | report_id | info
Hello list,
I downloaded the 8.0.10 rpms for FC4 yesterday and after installing
it, postgresql won't start. I get the following error: An old
version of the database format was found My previous postgresql
version was 8.0.8 and I read nothing on the release notes about a
this:
pg_dump -Ft -b -v the_db_name the_output_file.tar
pg_restore restores the database. i.e.:
pg_restore -d the_db_name the_output_file.tar
Hope this helps -
Scott
On Nov 10, 2005, at 2:41 PM, Dianne Yumul wrote:
Hello to everybody.
I just have a couple of newbie questions. I'm trying
Thanks for the response.
does the global directory exist on the drive you are syncing from? If
so ...
then it's a problem with your rsync.
check the options you are using with the rsync command.
check the rsync configurations in /etc/rsyncd.conf on the drive.
what user are you running the
Hello to everybody.
I just have a couple of newbie questions. I'm trying to restore our
databases from a file system backup. The backups are done with rsync,
the postgresql service is stopped before backups are done on the
server. The system is Fedora Core 4 with Postgresql 8.0.3.
Now back
May be you want the FM prefix, i.e. to_char(current_timestamp,
'FMMonth'). See the docs for more info:
http://www.postgresql.org/docs/8.0/interactive/functions-
formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLE
On Sep 19, 2005, at 8:20 AM, Alex Turner wrote:
Shiver me timbers, whats up
Hello,
We have Fedora Core 4, but I'm pretty sure it's the same. To start the
service we use
/etc/rc.d/init.d/postgresql start
Now if you want postgresql to start automatically on boot you do:
chkconfig postgresql on
Read the man pages for chkconfig for more details.
Hope this helps.
On
Here:
http://www.postgresql.org/ftp/binary/v8.0.3/linux/rpms/fedora/fedora-core-2/
If you go to www.postgresql.org, under Downloads, you'll find directions and a link to the FTP mirrors.
On Jul 15, 2005, at 7:38 AM, Dinesh Pandey wrote:
x-tad-biggerFrom where can I download?/x-tad-bigger
oh, and for installation instructions, please check out the very fine documentation at:
http://www.postgresql.org/docs/8.0/interactive/index.html
: )
On Jul 15, 2005, at 7:38 AM, Dinesh Pandey wrote:
x-tad-biggerFrom where can I download?/x-tad-bigger
x-tad-bigger /x-tad-bigger
Just an update . . . I tried upgrading kernel to 2.6.11.11 (kernel.org) but was unsuccessful (due to i2c and gcc 4.0 issue). So I settled for the one on the fedora development repository. But that didn't help, upgraded other stuff too like selinux-policy-targeted and initscripts. Beginning to pull
used to
have 8.0.2 installed but I upgraded to 8.0.3, hoping that would fix it
but it didn't.
Thank you.
Dianne
On Jun 6, 2005, at 8:00 PM, Tom Lane wrote:
Dianne Yumul [EMAIL PROTECTED] writes:
We have Fedora Core 4 Test 3 installed on a development box and just
recently installed Postgresql
-D /var/lib/pgsql/data
Many thanks for the help.
Dianne
On Jun 7, 2005, at 9:02 AM, Tom Lane wrote:
Dianne Yumul [EMAIL PROTECTED] writes:
Um, exactly which Postgres RPMs do you have installed?
Thanks for the response. I have the following installed:
postgresql-server-8.0.3-1
postgresql
policy will disallow the
postgres
daemon from writing anywhere under /home.
I really should take the time and learn SELinux but I'm crunched right
now and will disable it for now.
Thank you soo much for the all the help.
Dianne
On Jun 7, 2005, at 10:58 AM, Tom Lane wrote:
Dianne Yumul
Hello list,
We have Fedora Core 4 Test 3 installed on a development box and just
recently installed Postgresql 8.0.3. Sometimes, when starting
postgresql with the /etc/rc.d/init.d/postgresql script, it gives me the
following:
/usr/bin/chcon: can't apply partial context to unlabeled file
Why don't you try yum, it will install the dependencies for you ; )
http://linux.duke.edu/projects/yum/
On Mar 18, 2005, at 11:32 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Edgar Amorim wrote:
I'm a kind new bye with linux related stuffs. I'm
Yup, I didn't see your email off-list till after I re-sent the other
email. But thanks for the info.
On Mar 18, 2005, at 11:56 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Dianne Yumul wrote:
Why don't you try yum, it will install
Sorry, I did not see your email off-list until after I sent the other
one.
On Mar 18, 2005, at 11:56 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Dianne Yumul wrote:
Why don't you try yum, it will install the dependencies for you ; )
http
hi,
I think it works for me. what version of postgres do you have? maybe
you just need to upgrade : )
test=# select cust_id, 'TEST' as test, cust_address from customers;
cust_id | test | cust_address
+--+--
11 | TEST | 200 Maple Lane
23 matches
Mail list logo