473,320 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

postgresql system column errors


Hello Hiroshi,

When I try to use the column name xmin in one of my tables I get
ERROR: column name "xmin" conflicts with a system column name

You seem to have been affected by these errors in the past too. Had you
found a solution?

Anybody else have any solutions?

Cheers,
ashish

Ashish Mahabal, Caltech Astronomy, Pasadena, CA 91125
http://www.astro.caltech.edu/~aam aa*@astro.caltech.edu

Colorless green ideas sleep furiously.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #1
4 2813
Ashish Mahabal wrote:
Hello Hiroshi,

When I try to use the column name xmin in one of my tables I get
ERROR: column name "xmin" conflicts with a system column name

You seem to have been affected by these errors in the past too. Had you
found a solution?

Anybody else have any solutions?


The only thing you can do is change your column name.

The manual tells you about the system columns here:
http://www.postgresql.org/docs/7.4/s...m-columns.html

--
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 22 '05 #2
Hello

I have got an inhouse application which used to
connect to MySQL using their C API, which is now being
ported to PostGreSQL :)

Is there any reference to PGSQL C API() in one page. I
went thru the docs but they are divided into multiple
HTMLs which is kinda difficult for me to take a
printout.

Any pointers.....???

Also in MySQL, the structure of resultset returned by
MySQL goes thru lot of changes with version so there
is always a possibilty of application crashing if we
refer to wrong index.....does postgresql suffer from
same problem...i have gone thru the api and having a
simple knack of it but not much :)

regards
karam

__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #3
Karam Chand <ka***********@yahoo.com> writes:
Is there any reference to PGSQL C API() in one page.


You probably want to read the libpq chapter.
http://www.postgresql.org/docs/7.4/static/libpq.html
The first three or so sections cover everything you
really need to know about.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 22 '05 #4
On Tue, Feb 17, 2004 at 11:15:13AM -0800, Ashish Mahabal wrote:

Thanx Mark.

Thats what I ended up doing. But it seems silly that the name space for
system columns and user columns are not separate. Its just like saying
that you can not have the same column name in 2 different tables.

Just like I can say table1.myCol and table2.myCol, there should have been
a way to say system.xmin and myTable.xmin, the default being myTable.xmin
when I am doing stuff with myTable. Whereever xmin gets used currently,
the source could explicitely say system.xmin. Anyway. hope that is done in
some future version.
I think you're missing something. Every table has the xmin, xmax, cmin, cmax
and sometimes oid columns. They're not only in the system tables. These
columns are what makes transactions work and they exist for every record.

I hope you're not suggesting a move to myTable.system.xmin ?

Pick a table and do: select xmin,xmax,cmin,cmax from <table>

What you're asking is to have the same column name twice in a single table,
which is obviously silly.
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ If the Catholic church can survive the printing press, science fiction
will certainly weather the advent of bookwarez.
http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFANo7GY5Twig3Ge+YRAtQLAKDJ8HEl3jV7pRv7xWrhKm 0g2Fgk7gCgsK41
7kBPjrUUcFa0OX1GsIxOH/8=
=xI6K
-----END PGP SIGNATURE-----

Nov 22 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: giant food | last post by:
Hi, I'm in the process of converting an Oracle database into postgresql. One thing I've noticed is that postgresql functions keep the entire function body in a string, e.g.: CREATE OR REPLACE...
11
by: Durai | last post by:
Hi All, I tested "concurrent testing" in MySQL. It works fine. But I couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock problem. I used the PHP script to update table( one script...
0
by: Wind Wood | last post by:
Hello £¡ I can dump data from old dababase(Postgresql 6.5.3), but new problem came out when I restore the data to postgresql 7.4. It went out during the COPY command, if I do it in such command...
3
by: Bob.Henkel | last post by:
I write this to tell you why we won't use postgresql even though we wish we could at a large company. Don't get me wrong I love postgresql in many ways and for many reasons , but fact is fact. If...
0
by: Janning Vygen | last post by:
Hi, i have a question about how to handle postgresql constraint errors in the client app. I found some mails in the archive about it, too. But i have still so many questions about how to do it,...
3
by: Robert Abi Saab | last post by:
Hi everyone. I just finished a course on PostgreSQL and I found out that PostgreSQL doesn't provide any object relational features (as claimed in the official documentation), except table...
9
by: Wei Wang | last post by:
hi, I just took over a project done by somebody else of some C extension of Postgresql 7.1.3. And now I have to port it to pl/pgsql. The guy who developed it said he didn't get it running under...
1
by: phil campaigne | last post by:
Tom Lane wrote: > phil campaigne <pcampaigne@charter.net> writes: > > >> when I login to linux and check the env's I see: >>...
2
by: Anthony | last post by:
Our Database is having errors. We are currently using PostgreSQL to store 2.5 Million records per day. The average addition to our primary table is 4.5 Gigs of data. We are doing this on a dual...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.